CALC.ddb(cost, salvage, life, period, [factor])
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.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])
Returns the depreciation of an asset for a specified period using the double-declining balance method. Cost is the initial cost of the asset. Salvage is the value at the end of the depreciation (sometimes called the salvage value of the asset). Life is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset). Period is the period for which you want to calculate the depreciation. Period must use the same units as life. Factor is the rate at which the balance declines. If Factor is omitted, it is assumed to be 2 (the double-declining balance method). See db() for sample script.
| << CALC.db(cost, salvage, life, period, [month]) | © 1996-2013 InetSoft Technology Corporation (v11.4) | CALC.disc(settlement, maturity, pr, redemption, [basis]) >> |