Skip to contents

Calculates compounded interest rate

Source: R/RATE.R
RATE.Rd

Based on loan term, instalment, and the loan amount, this function calculates the associated compound interest rate. This function is designed to be equivalent to the Excel function RATE. It calculates a fixed interest rate.

Usage

RATE(nper, pmt, pv, fv = 0)

Arguments

nper

Number of periods

pmt

Instalment per period (should be negative)

pv

Present value i.e. loan advance (should be positive)

fv

Future value i.e. redemption amount

Value

rate The corresponding compound interest rate required to arrive at an FV of 0

See also

PMT PV

Other finance: APR(), PMT(), PV()

Examples

RATE(12,-500,3000) # 0.126947 Taken from excel
#> [1] 0.1269469

df<-data.frame(nper=c(12,12),pmt=c(-500,-400),pv=c(3000,3000))
RATE(df$nper,df$pmt,df$pv)  # c(0.126947,0.080927) Taken from excel
#> [1] 0.12694689 0.08092716