npv {grattan}

Financial functions

Description

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

Usage

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.

Author(s)

Enrique Garcia M. [e-mail]

Karsten W. [e-mail]

Examples

npv(0.07, c(1, 2))
irr(x = c(1, -1), start = 0.1)
fv(0.04, 7, 1, pv = 0.0, type = 0)
pv(rate = 0.08, nper = 7, pmt = 1, fv = 0.0, type = 0)
pmt(rate = 0.025, nper = 7, pv = 0, fv = 0.0, type = 0)