
558
~
E-Solve
CHAPTER
16
Depreciation Methods
In all situations, the criterion is to maximize the present worth
of
the total depre-
ciation
PW
D
.
The combination
of
depreciation models that results
in
the largest
present worth is the best switching strategy.
t=1l
PW
D
= L
D(P
/F,i,t)
[16A.5]
/=1
This logic minimizes tax liability
in
the early part
of
an asset's recovery period.
Switching is most advantageous from a rapid write-off model like DDB to the
SL
mode
l.
This switch is predictably advantageous
if
the implied salvage value
computed by Equation [16.10] exceeds the salvage value estimated at purchase
time; that is, switch
if
B V
Il
= 8(1 - d)" > estimated S [ l6A.6]
Since we assume that
S will be zero per rule 3 above, and since
BV
Il
will be greater
than zero,
for a DB model a switch to
SL
is
always advantageous. Depending
upon the values
of
d and n, the switch may be best in the later years
or
last year
of
th
e recovery period, which removes the implied S inherent to the DDB model.
The
procedure to switch from DDB to
SL
depreciation is as follows:
I . For each year t, compute the two depreciation charges.
For
DDB
:
For SL:
DDDB
= d(BV
r
_
1
)
D = BV
r
-
1
SL
n-t+
1
[16A.
7]
[16A.8]
2.
Select the larger depreciation value.
The
depreciation
for
each year is
Dr
=
max[DDDB
' D
sd
[16A.9]
3.
[f
needed, compute the present worth
of
total depreciation, using Equa-
tion [16A.S].
It
is acceptable, though not usually financially advantageous, to state that a
switch
will take place in a particular year, for example, a mandated switch from
DDB to
SL
in
year 7
of
a IO-year recovery period. This approach is usually not
taken, but the switching technique will work correctly for all depreciation model
s.
To use a spreadsheet for switching, first understand the depreciation model
switching rules and practice the switching procedure from declining balance to
straight line.
Once these are understood, the mechanics
of
the switching can be
speeded up by applying the spreadsheet function VDB (variable declining bal-
ance). This
is
a quite powerful function that determines the depreciation for 1 year
or
the total over several years for the DB-to-
SL
switch. The function format is
VDB(B,S,n,starCt,end_t,d,no_switch)
Appendix A explains all the fields in detail, but for simple applications, where the
DDB and
SL
annual Dr values are needed, the following are correct entries:
start_t is the year
(t-l)
end_t is year t
d is optional; 2 for DDB is assumed, the
same
as
in
the
DDB
function