Syntax
=INTRATE(settlement, maturity, investment, redemption, [basis])Arguments
| Argument | Required | Description |
|---|---|---|
settlement | Required | The settlement date |
maturity | Required | The maturity date |
investment | Required | The amount invested |
redemption | Required | The amount received at maturity |
basis | Optional | The day count basis, 0 to 4 |
How to use INTRATE
INTRATE takes 4 required arguments and 1 optional argument. Type =INTRATE( 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.
=INTRATE(DATE(2008,2,15), DATE(2008,5,15), 1000000, 1014420, 2)Result Related financial functions
- DURATIONReturns the Macaulay duration in years of a security that pays periodic interest, for 100 face value.
- EFFECTReturns the effective annual interest rate from a nominal rate and the compounding periods per year.
- FVReturns the future value of an investment with constant payments and a constant rate.
- FVSCHEDULEReturns the future value of a principal after applying a series of interest rates.
- 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.
- MIRRReturns the modified internal rate of return, with separate rates for financing and reinvestment.