Thread
:
IRR formula for monthly cash flows
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
Posts: n/a
IRR formula for monthly cash flows
Just IRR will do.
You should realize that you get a monthly rate for monthly cash flows.
--
Kind regards,
Niek Otten
"MB Burgis" <MB
wrote in message ...
| What is the best formula to use when calculating an IRR for monthly cash flows?
|
| XIRR? or ((1+IRR(range,-0.01))^12)-1 ? or can just IRR be used?
|
| Thank you
Reply With Quote