Functions and CALL Routines |
Returns the accumulated depreciation from specified tables.
DACCTAB(p,v,t1, . . . ,tn)
|
-
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 with t1+t2+...tn
1.
The DACCTAB function returns the accumulated
depreciation by using user-specified tables. The formula for this function
is
![[equation]](images/deqn73.gif)
For a given p, only the arguments
need to be specified with k=ceil(p)
.
An asset has a depreciable initial value of $1000 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 accumulated depreciation throughout the third year
can be expressed as
y3=dacctab(3,1000,.15,.22,.21,.21,.21);
The value that is returned is 580.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.