Functions and CALL Routines |
Category: | Financial |
Syntax | |
Arguments | |
Details | |
Examples |
Syntax |
DEPTAB(p,v,t1,...,tn) |
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.
are numeric, the fractions of depreciation for each time period with t1+t2+...tn 1.
Details |
The DEPTAB function returns the depreciation by using specified tables. The formula is
For a given p, only the arguments 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
The value that is returned is 210.00. The fourth rate, .21, and the fifth rate, .21, can be omitted because they are not needed in the calculation.
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.