JS.7.2 Financial Functions

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])

The CALC object provides the financial functions listed below.

<< CALC.yearfrac(date1, date2, [basis]) © 1996-2013 InetSoft Technology Corporation (v11.5) CALC.accrint(issue, interest, settlement, rate, par, freq, [basis]) >>