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