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

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