View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mdyer Mdyer is offline
external usenet poster
 
Posts: 1
Default IRR monthly flows with multiple answers

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?