Excel Function : RATE
Category
Financial
Description
Returns the interest rate per period of an annuity
Microsoft Excel Reference Page
https://support.office.com/en-us/article/RATE-function-9f665657-4a7e-4bb7-a030-83fc59e748ce
Syntax and Description of the RATE Excel Function
The RATE function in Microsoft Excel is used to calculate the interest rate per period of an investment. The function takes the following arguments: RATE(nper, pmt, pv, [fv], [type], [guess]) where: nper: the number of periods of the investment pmt: the payment made each period pv: the present value of the investment fv: the future value of the investment type: the type of the investment, 0 for a regular investment, 1 for an investment with payments at the beginning of each period guess: an estimate of the interest rate per period
About RATE Excel Function
The RATE function is used to calculate the periodic interest rate required to pay off a loan or to earn a certain amount of interest on an investment. The syntax for the RATE function is as follows: RATE(nper, pmt, pv, [fv], [type], [guess]) where: nper: The number of periods over which the loan or investment is paid or held. pmt: The periodic payment amount. pv: The present value of the loan or investment. fv: The future value of the loan or investment. type: The number 0 or 1 to indicate when payments are due. guess: An
