G
Guest
I am running a 5yr IRR on monthly rests and the derived IRR is giving me a NUM result. This is occuring when the monthly IRR number is low (but above zero). Can anyone provide any assistance with this please?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Norman Harker
Hi Col!
#NUM! usually happens when there is no sign change in the range
containing the cash flows.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
is low (but above zero). Can anyone provide any assistance with this
please?
#NUM! usually happens when there is no sign change in the range
containing the cash flows.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
giving me a NUM result. This is occuring when the monthly IRR numberCol said:I am running a 5yr IRR on monthly rests and the derived IRR is
is low (but above zero). Can anyone provide any assistance with this
please?
G
Guest
Thanks Normnan- I appreciate your time to respond
I have the sign change in OK. I am running the Monthly and Annual IRRs as two models to compare results. The monthly is working fine until my monthly C/F numbers get too low which then gives a NUM result . The Annual rest IRR however is still throwing of a big number. ie Cost -$16,000 and 5 yr annual c/f of $5,400pa produces an IRR of 20.4%pa and if on monthly c/f ($450) the IRR is 1.91% per mth or roughly 23% annually BU
If the annual C/F is reduced to $5,300pa, the IRR becomes 19.6%pa and the monthly c/f ($442) produces an IRR of NUM
Co
Sydney
I have the sign change in OK. I am running the Monthly and Annual IRRs as two models to compare results. The monthly is working fine until my monthly C/F numbers get too low which then gives a NUM result . The Annual rest IRR however is still throwing of a big number. ie Cost -$16,000 and 5 yr annual c/f of $5,400pa produces an IRR of 20.4%pa and if on monthly c/f ($450) the IRR is 1.91% per mth or roughly 23% annually BU
If the annual C/F is reduced to $5,300pa, the IRR becomes 19.6%pa and the monthly c/f ($442) produces an IRR of NUM
Co
Sydney
G
Guest
Solved my own problem. The Excel IRR guesses 0.1 (10%) in the absence of any other entry. Because the monthly IRR was a lot less than that, it was giving a NUM IRR result. By inserting 0.01 (1%) as the guess , the IRR calc was able to be done. Sorry for being so slow.
N
Norman Harker
Hi Col!
Use -0.9 as your guess rate in future. You'll find that it almost
invariably hits a solution.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
than that, it was giving a NUM IRR result. By inserting 0.01 (1%) as
the guess , the IRR calc was able to be done. Sorry for being so slow.
Use -0.9 as your guess rate in future. You'll find that it almost
invariably hits a solution.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
absence of any other entry. Because the monthly IRR was a lot lessCol said:Solved my own problem. The Excel IRR guesses 0.1 (10%) in the
than that, it was giving a NUM IRR result. By inserting 0.01 (1%) as
the guess , the IRR calc was able to be done. Sorry for being so slow.
G
Guest
Thanks again Norm.