Financial functions from Excel. These functions are equivalent to the Excel functions of the same name (in uppercase).

npv(rate, values)

irr(x, start = 0.1)

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

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

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

Arguments

rate

Discount or interest rate.

values

Income stream.

x

Cash flow.

start

Initial guess to start the iterative process.

nper

Number of periods

pmt

Payments.

pv

Present value.

type

Factor.

fv

Future value.

Examples

npv(0.07, c(1, 2))
#> [1] 2.681457
irr(x = c(1, -1), start = 0.1)
#> [1] 8.659104e-09
fv(0.04, 7, 1, pv = 0.0, type = 0)
#> [1] -7.898294
pv(rate = 0.08, nper = 7, pmt = 1, fv = 0.0, type = 0)
#> [1] -5.20637
pmt(rate = 0.025, nper = 7, pv = 0, fv = 0.0, type = 0)
#> [1] 0