Syntax
=RATE(nper, pmt, pv, [fv], [type], [guess])Arguments
| Argument | Required | Description |
|---|---|---|
nper | Required | The number of payment periods |
pmt | Required | The payment made each period |
pv | Required | The present value |
fv | Optional | The value wanted after the last payment (0 when left out) |
type | Optional | 0 for payments at the end of each period, 1 at the start |
guess | Optional | A first guess for the rate (10% when left out) |
How to use RATE
RATE takes 3 required arguments and 3 optional arguments. Type =RATE( 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.
=RATE(4*12, -200, 8000)Result =RATE(4*12, -200, 8000)*12Result Related financial functions
- PRICEReturns the price per 100 face value of a security that pays periodic interest.
- PRICEDISCReturns the price per 100 face value of a discounted security.
- PRICEMATReturns the price per 100 face value of a security that pays interest at maturity.
- PVReturns the present value of a series of equal future payments.
- RECEIVEDReturns the amount received at maturity for a fully invested security.
- RRIReturns the equal interest rate per period that grows a present value into a future value.
- SLNReturns the straight line depreciation of an asset for one period.
- SYDReturns the sum of years' digits depreciation of an asset for a period.
- TBILLEQReturns the bond equivalent yield of a Treasury bill.