
/
16
.9 An asset with an unadjusted basis
of
$50,000 was depreciated over n
tax
=
10
years for tax depreciation purposes and
over n
book
= 5 years for book depreciation
purposes. The annual depreciation was
lin
using the relevant life value. Use
Excel to plot on one graph the annual book
value for both methods
of
depreciation.
Straight Line Depreciation
16.10 Home Health Care, Inc. (HHCI) pur-
chased a new sonargram imaging unit for
$300,000 and had it mounted on a truck
body for an additional
$100,000, includ-
ing the truck chassis. The unit-truck sys-
tem will be depreciated as one asset. The
functional life is 8 years, and salvage is
estimated at
10%
of
the purchase price
of
the imaging unit. (a) Use classical
straight line depreciation and hand calcu-
lations to determine the salvage value,
annual depreciation, and book value after
4 years.
(b)
Develop the cell reference
worksheet
in
Excel to obtain the answers
in
part (a) for the original data. (c) Use
your Excel worksheet to determine the
answers, if the sonargram unit cost goes
up to
$350,000 and the expected life is
decreased to 5 years.
16.
I I Air handling equipment that costs
$12,000 has a life
of
8 years with a $2000
salvage value. (a) Calculate the straight
line depreciation amount for each year.
(b) Determine the book value after 3 years.
(c) What
is
the rate
of
depreciation?
16.12 As asset has an unadjusted basis
of
$200,000, a salvage value
of
$10,000,
and a recovery period
of
7 years. Write a
single-cell Excel function to display the
book value after 5 years
of
straight line
depreciation.
16.
13
Simpson and Jones Pharmaceuticals pur-
chased a prescription drug tablet-forming
machine
in
2004 for $750,000. They had
PROBLEMS 5
51
planned to use the machine for
10
years,
but due to rapid obsolescence it should
be retired after 4 years. Develop the
spreadsheet for depreciation and book
value amounts necessary to answer the
following.
(a) What is the amount
of
capital in-
vestment remaining when the asset
is retired due to obsolescence?
(b)
If
the asset is sold at the end
of
4 years for $75,000, what
is
the
amount
of
capital investment lost
based on straight line depreciation?
(c)
If
the new technology machine has
an estimated cost
of
$300,000, how
many more years should the com-
pany retain and depreciate the cur-
rently owned machine to make its
book value and the first cost
of
the
new machine equal?
16.14 A special-purpose computer workstation
has
B = $50,000 with a 4-year recovery
period. Tabulate and plot the values for
SL
depreciation, accumulated deprecia-
tion, and book value for each year if
(a) there is no salvage value and
(b)
S =
$16,000. (c) Use a spreadsheet to solve
this problem.
16.
15
A company owns the same asset in a U.S.
plant and in a EU plant. It has B =
$2,000,000 with a salvage value
of
20%
of
B.
For tax depreciation purposes, the
United States allows a straight line write-
off over 5 years, while the
EU
allows
write-off over 8 years. The general man-
agers
of
the two plants want to know the
difference
in
(a) the depreciation amount
for year 5 and
(b) the book value after
5 years.
Use Excel and write cell equations
in only two cells to answer these questions.
Declining Balance Depreciation
16.16 For the declining balance method
of
depre-
ciation, explain the differences between