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)
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. |
#> [1] 2.681457#> [1] 8.659104e-09fv(0.04, 7, 1, pv = 0.0, type = 0)#> [1] -7.898294pv(rate = 0.08, nper = 7, pmt = 1, fv = 0.0, type = 0)#> [1] -5.20637pmt(rate = 0.025, nper = 7, pv = 0, fv = 0.0, type = 0)#> [1] 0