Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm running a 24 month (period) cash flow scenario with multiple positive and
negative cash flows. When I run a straight IRR analysis for the 24 periods, I'm getting a 3% IRR. I know this is not correct. Alternatively, if I add the cash flow for the first 12 months and use that as period 1 and the total of months 13-24 as the 2nd period, my IRR = 85%. I believe this is closer to the correct return, but why the huge difference? What am I not doing correctly? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rolling Monthly Amounts to Annual Monthly Amounts | Excel Discussion (Misc queries) | |||
How do I change the IRR formula for MONTHLY periodic payments? | Excel Worksheet Functions | |||
MATCH w/ multiple answers? | Excel Worksheet Functions | |||
IF function for multiple answers? | Excel Worksheet Functions | |||
How to look up a value in list & return multiple answers | Excel Discussion (Misc queries) |