Syntax
=MIRR(values, finance_rate, reinvest_rate)Arguments
| Argument | Required | Description |
|---|---|---|
values | Required | The cash flows, at regular periods |
finance_rate | Required | The interest rate paid on money used |
reinvest_rate | Required | The interest rate earned on reinvested money |
How to use MIRR
MIRR takes 3 required arguments. Type =MIRR( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=MIRR({-120000, 39000, 30000, 21000, 37000, 46000}, 0.1, 0.12)Result =MIRR({-120000, 39000, 30000, 21000, 37000, 46000}, 0.1, 0.14)Result Related financial functions
- IPMTReturns the interest part of one payment of a loan or investment.
- IRRReturns the internal rate of return of cash flows at regular periods.
- ISPMTReturns the interest paid in one period of a loan with equal principal repayments.
- MDURATIONReturns the modified duration in years of a security that pays periodic interest, for 100 face value.
- NOMINALReturns the nominal annual interest rate from an effective rate and the compounding periods per year.
- NPERReturns the number of payment periods needed for a loan or investment.
- NPVReturns the net present value of future cash flows (at the end of each period) at a discount rate.
- ODDFPRICEReturns the price per 100 face value of a security with an odd (short or long) first period.
- ODDFYIELDReturns the yield of a security with an odd (short or long) first period.