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

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

Returns the depreciation of an asset for a specified period using the fixed-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. Month is the number of months in the first year. If Month is omitted, it is assumed to be 12.

Example

CALC.db(1000000, 100000, 6, 1, 7);

// returns 186083.33

(Depreciation of an asset valued at $1,000,000 (worth 100,000 after 6 years with) after the first year with only 7 months calculated)

<< CALC.cumprinc(rate, nper, pv, start_period, end_period, type) © 1996-2013 InetSoft Technology Corporation (v11.4) CALC.ddb(cost, salvage, life, period, [factor]) >>