CALC.npv(rate, [value1, value2, [....]])

CALC.accrint(issue, interest, settlement, rate, par, freq, [basis])

CALC.accrintm(issue, maturity, rate, par, [basis])

CALC.amordegrc(cost, date_purchased, first_period, salvage, period, rate, [basis])

CALC.amorlinc(cost, date_purchased, first_period, salvage, period, rate, [basis])

CALC.coupdaybs(settlement, maturity, frequency, [basis])

CALC.coupdays(settlement, maturity, frequency, [basis])

CALC.coupdaysnc(settlement, maturity, frequency, [basis])

CALC.coupncd(settlement, maturity, frequency, [basis])

CALC.coupnum(settlement, maturity, frequency, [basis])

CALC.couppcd(settlement, maturity, frequency, [basis])

CALC.cumipmt(rate, nper, pv, start_period, end_period, type)

CALC.cumprinc(rate, nper, pv, start_period, end_period, type)

CALC.db(cost, salvage, life, period, [month])

CALC.ddb(cost, salvage, life, period, [factor])

CALC.disc(settlement, maturity, pr, redemption, [basis])

CALC.duration(settlement, maturity, coupon, yld, frequency, [basis])

CALC.effect(nominal_rate, npery)

CALC.fv(rate, nper, pmt, [pv], [type])

CALC.fvschedule(principal, schedule)

CALC.intrate(settlement, maturity, investment, redemption, [basis])

CALC.ipmt(rate, per, nper, pv, fv, type)

CALC.ispmt(rate, per, nper, pv)

CALC.mduration(settlement, maturity, coupon, yld, frequency, [basis])

CALC.mirr(values, finance_rate, reinvest_rate)

CALC.nominal(effect_rate, npery)

CALC.nper(rate, pmt, pv, fv, type)

CALC.npv(rate, [value1, value2, [....]])

CALC.pmt(rate, nper, pv, fv, type)

CALC.ppmt(rate, per, nper, pv, fv, type)

CALC.price(settlement, maturity, rate, yld, redemption, frequency, [basis])

CALC.pricedisc(settlement, maturity, discount, redemption, [basis])

CALC.pricemat(settlement, maturity, issue, rate, yld, [basis])

CALC.pv(rate, nper, pmt, fv, type)

CALC.received(settlement, maturity, investment, discount, [basis])

CALC.sln(cost, salvage, life)

CALC.syd(cost, salvage, life, per)

CALC.tbilleq(settlement, maturity, discount)

CALC.tbillprice(settlement, maturity, discount)

CALC.tbillyield(settlement, maturity, pr)

CALC.vdb(cost, salvage, life, start_period, end_period, factor, no_switch)

CALC.xnpv(rate, values, dates)

CALC.yielddisc(settlement, maturity, pr, redemption, [basis])

CALC.yieldmat(settlement, maturity, issue, rate, pr, [basis])

Calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values). Rate is the rate of discount over the length of one period. Value1, Value2, etc., are arguments representing the payments and income.

Example

CALC.npv(10, [-10000, 3000, 4200, 6800]);

// returns 1188.44

<< CALC.nper(rate, pmt, pv, fv, type) © 1996-2013 InetSoft Technology Corporation (v11.4) CALC.pmt(rate, nper, pv, fv, type) >>