Syntax
=MDURATION(settlement, maturity, coupon, yld, frequency, [basis])Arguments
| Argument | Required | Description |
|---|---|---|
settlement | Required | The settlement date |
maturity | Required | The maturity date |
coupon | Required | The annual coupon rate |
yld | Required | The annual yield |
frequency | Required | Coupon payments per year: 1, 2 or 4 |
basis | Optional | The day count basis, 0 to 4 |
How to use MDURATION
MDURATION takes 5 required arguments and 1 optional argument. Type =MDURATION( 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.
=MDURATION(DATE(2008,1,1), DATE(2016,1,1), 0.08, 0.09, 2, 1)Result Related financial functions
- INTRATEReturns the interest rate of a fully invested security.
- 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.
- MIRRReturns the modified internal rate of return, with separate rates for financing and reinvestment.
- 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.