View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default IRR / MIRR and Perpetuity

Are you saying it won't work for a perpetuity? If so, how I do I calculate
the IRR for a very long-term investment without creating the individual
cash-flows?

Thanks.

"vezerid" wrote:

The MIRR will not make any projections. Given a finite set of cash
flows it will tell you what the IRR is for the specific set of cash
flows.

Does this help?
Kostis Vezerides


JEFF wrote:
Hello,

I'd like to calculatet the MIRR of an investment, but am a bit confused:

I have the intial outlay in year 0, and the subsequent cashflows for the
next 10 years.... What about the cashflows for the years beyond the 10th?


Thanks