View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default 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