R analog port of Excel's PMT function

Source: R/excelpmt.R

Originally found as a GIST: https://gist.github.com/raadk/dcd503815bbb271484ff

excelpmt(rate, nper, pv, fv = 0, type = 0)

Arguments

rate

interest rate
nper

number of periods
pv

present value
fv

future value (default is 0)
type

maturity of the payment; 0 = end of period, 1 = beginning; (default is 0)

Examples

excelpmt(rate = .03, nper = 60, pv = 60000)
#> [1] -2167.978