|
|
|
% Safe Rate for Modified Internal Rate of Return: |
|
|
% Reinvest Rate for Modified Internal Rate of Return: |
|
|
|
|
|
|
|
|
Initial Investment |
|
|
Cash
Flow, End of Year 1 |
|
|
Cash
Flow, End of Year 2 |
|
|
Cash
Flow, End of Year 3 |
|
|
Cash
Flow, End of Year 4 |
|
|
Cash
Flow, End of Year 5 |
|
|
Cash
Flow, End of Year 6 |
|
|
Cash
Flow, End of Year 7 |
|
|
Cash
Flow, End of Year 8 |
|
|
Cash
Flow, End of Year 9 |
|
|
Cash
Flow, End of Year 10 |
|
|
|
|
|
Modifiied Internal Rate of Return |
|
|
Automatic Recalculation
|
 |
Modified Internal Rate of Return (MIRR)
The MIRR calculation takes any negative cash flows, zeroes them out and discounts them at the safe rate back to day one of the investment period. You can consider the safe rate to be the interest rate at which you can put money aside, in a secure and reasonably liquid form, so that it will grow to meet the amount needed to cover the negative cash flows.
MIRR takes positive cash flows and compounds them forward to the sale year, using the reinvestment rate (also known as the risk rate). The reinvestment rate is the rate at which you believe you could reinvest your positive cash flows.
<< Book Home Page
<< Main Forms Page
<< To RealData Website
|
These resources are provided free of charge, "as is" and without warranty of any kind, either expressed or implied, by RealData, Inc. to readers of "What Every Real Estate Investor Needs to Know About Cash Flow ... And 36 Other Key Financial Measures." You may not reproduce or distribute these materials without the permission of RealData, Inc. Technical support is not available for the free materials provided here. © 2003 RealData, Inc. |
|