Hello

My problem is that im given
period 1 -12120
period 2 3000
period 3 8000
period 4 11000

now im supposed to get the XIRR, but i dont know what to put in "dates" and
"Guess"

thank you for your help

you need dates for each period so it can calculate rate of return, were these
monthly or annual reports etc. Guess is your estimate of return, if blank it
uses the default of 0.1 or 10%.

"Daniela Gutierrez" wrote:

Hello

My problem is that im given
period 1 -12120
period 2 3000
period 3 8000
period 4 11000

now im supposed to get the XIRR, but i dont know what to put in "dates" and
"Guess"

thank you for your help

Daniela, xiir is a formula for calculating the internal rate of return
for nonperiodical payments. If your paymnets are periodical, including
the first one, otherwise, u must enter the payment days for all your
cash flow

Oscar


--
omoratto
------------------------------------------------------------------------
omoratto's Profile: http://www.excelforum.com/member.php...o&userid=35343
View this thread: http://www.excelforum.com/showthread...hreadid=549560

Daniela Gutierrez wrote:
My problem is that im given
period 1 -12120
period 2 3000
period 3 8000
period 4 11000
now im supposed to get the XIRR, but i dont know what to put in "dates" and
"Guess"

Why are you "supposed to" use XIRR? If your cash flows occur with
regular frequency (e.g. monthly), simply use IRR. No dates are
required. On the other hand, if you "must" use XIRR -- for example, to
demonstrate the very small difference between its result and IRR's --
you "must" make up fictitious dates on a parallel column, e.g.
3/1/2006, 4/1/2006, etc. But beware of the latter: choosing
fictitious dates will alter the XIRR result.

As for a "guess" parameter, I found that none is needed for those
particular cash flows.