Microsoft Office Tutorials and References
In Depth Information
MIRR
Figure 6.22
The MDURATION
function returns the
modified duration of
a security with a par
value assumed of
$100.
A
The result of cell
referencing
MIR MIRR returns a modified internal rate of return for several periodic cash flows.
=MIRR(values,finance_rate,reinvest_rate)
Consider the following example in Figure 6.23. You purchased a restaurant with an initial
borrowing of $230,000 at 8.1%; your returns for the following five years were respectively $35,000,
$36,000, $57,000, $76,000, and $87,000. You reinvest the profits over the five years, earning an
annual return of 12.8%. Your modified rate of return after 5 years is 8.98%. (The difference between
this function and IRR is mainly that MIRR takes into account finance and reinvestment interest.)
The array of numbers or reference to cells represented by payments
(negative values), and income (positive values).
VALUES
The interest rate paid on the money used in the cash flows.
FINANCE_RATE
The interest rate received on the cash flows as they are reinvested.
REINVEST_RATE
MIRR can be calculated as:
Search JabSto ::




Custom Search