| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Threaded Mode
