View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default IRR / MIRR and Perpetuity

Fred Smith wrote...
Yes, we're saying it won't work for a perpetuity. There has to be a finite
number of cash flows for IRR to calculate the return.

If your cash flow is level forever, the IRR is simply:

=CashFlow/InitialInvestment

....

IRR alone won't work for a perpetual cashflow, but it'd work nicely for
daily b70hxg1