>> IRR function

[Jonathan Parminter]

Hi, any ideas to resolve this one

A B
1 Amount IRR calc
2 $(33,756)
3 $19,578 -42%
4 $(19,074) #NUM!

in cell B4 is: =IRR(A2:A4)

I have tried using the optional guess argument. But
haven't figured out how to make a valid guess.

Any ideas or suggestions appreciated

Thanks
Jonathan

 

[Michael R Middleton]

Jonathan -

IRR is the discount rate such that a sequence of cash flows has a net
present value equal to zero.

For your data, and for the timing implied by your Excel formula =IRR(A2:A4),
the cash flow at t=1 is $(33,756), at t=2 it's $19,578, and at t=2 it's
$(19,074). There is no finite discount rate that will give a net present
value of zero (at t=0).

- Mike

www.mikemiddleton.com

++++++++++++++++++++++++

 

[Jonathan Parminter]

Thanks Mike...

Regards
Jonathan

-----Original Message-----
Jonathan -

IRR is the discount rate such that a sequence of cash flows has a net
present value equal to zero.

For your data, and for the timing implied by your Excel formula =IRR(A2:A4),
the cash flow at t=1 is $(33,756), at t=2 it's $19,578, and at t=2 it's
$(19,074). There is no finite discount rate that will give a net present
value of zero (at t=0).

- Mike

www.mikemiddleton.com

++++++++++++++++++++++++

"Jonathan Parminter"


.