| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IRR formula for monthly cash flows
Use IRR if your cash flows are regular (ie, every month). Use XIRR if they are
irregular. -- Regards, Fred "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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formula to calculate % gain when adding cash equity to accou | Excel Worksheet Functions | |||
| Need Help With A Formula Please | Excel Worksheet Functions | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
| Using MIRR, if cash flows are monthly, should rate be / 12? | Excel Worksheet Functions | |||
| How do you calculate rate of return on monthly cash flows | Excel Worksheet Functions | |||
Hybrid Mode
