DEPTAB

DEPTAB

Returns the depreciation from specified tables

Category: Financial

Syntax
Arguments
Details
Examples

Syntax

DEPTAB(p,v,t1, . . . ,tn)

Arguments

p: is numeric, the period for which the calculation is to be done. For noninteger p arguments, the depreciation is prorated between the two consecutive time periods that precede and follow the fractional period.
v: is numeric, the depreciable initial value of the asset.
t1,t2, . . . ,tn: are numeric, the fractions of depreciation for each time period.

Details

The DEPTAB function returns the depreciation by using specified tables. The formula is given below:

[IMAGE]

For a given p, only the arguments [IMAGE] need to be specified with k=ceil(p).

Examples

An asset has a depreciable initial value of $1,000 and a five-year lifetime. Using a table of the annual depreciation rates of .15, .22, .21, .21, and .21 during the first, second, third, fourth, and fifth years, respectively, the depreciation in the third year can be expressed as

   y3=deptab(3,1000,.15,.22,.21,.21,.21);

The value returned is 210.00.

Chapter Contents
Previous
Next
Top of Page