| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I calculate IRR using monthly cash flows, not annual?
As I understand it, Excel assumes that for purposes of calculating IRR, each
consecutive value is an annual value. If I have a short lived project, say 16 months, Excel assumes that the cash flow in the 16th cell is the 16th year, thus the IRR is dramatically understated. How do you adjust for this effect in Excel? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate total interest earned on a loan and monthly payment | Excel Worksheet Functions | |||
| Using MIRR, if cash flows are monthly, should rate be / 12? | Excel Worksheet Functions | |||
| IRR calc Monthly vs Annual | Excel Worksheet Functions | |||
| How do I forecast monthly and annual totals from previous year's . | Excel Worksheet Functions | |||
| How do you calculate rate of return on monthly cash flows | Excel Worksheet Functions | |||
Threaded Mode
