# Document Preview: Sheet3 Sheet2 Sheet1 A B C D E G H Name Section F End of Problem Data Input Sectio

Document Preview:

Sheet3
Sheet2
Sheet1
A
B
C
D
E
G
H
Name
Section
F
End of Problem
Data Input Section:
Estimated residual value
Estimated useful life
Depreciation Expense Per Year
Use the following functions to calculate depreciation
=SLN(cost,salvage,life)
Output Section:
Year ended December 31
Depreciation expense
Accumulated depreciation
Partial Balance Sheet
Machine
December 31
Less accumulated depreciation
A s s e t s =
#1
#2
Cash
Accum. Depr.
Liabilities +
Stockholder’s Equity
Problem 3-59A
Cost of asset, January 1, 2010
Part 1.
Part 2.
Part 3.
Part 4.
Amount
Formula 1
Fomula 2
Title
Formula 3
Formula 4
Formula 5
Formula 6
Charlotte Motorcycle Repair Corporation
Reimers, Financial Accounting 3e

5.00
6.00
7.00
8.00
9.00
10.00
11.00
12.00
13.00
2010.00
2011.00
2012.00
2013.00
14.00
15.00
16.00
17.00
18.00
19.00
20.00
21.00
22.00
23.00
24.00
2010.00
25.00
26.00
27.00
28.00
29.00
30.00
31.00
211.00
2010.00
32.00
33.00
34.00
35.00
36.00
37.00
38.00
39.00
40.00
Sheet3
Sheet2
Sheet1
A
B
C
D
E
G
H
Name
Section
F
End of Problem
Data Input Section:
Estimated residual value
Estimated useful life
Depreciation Expense Per Year
Use the following functions to calculate depreciation
=SLN(cost,salvage,life)
Output Section:
Year ended December 31
Depreciation expense
Accumulated depreciation
Partial Balance Sheet
Machine
December 31
Less accumulated depreciation
A s s e t s =
#1
#2
Cash
Accum. Depr.
Liabilities +
Stockholder’s Equity
Problem 3-59A
Cost of asset, January 1, 2010
Part 1.
Part 2.
Part 3.
Part 4.
Amount
Formula 1
Fomula 2
Title
Formula 3
Formula 4
Formula 5
Formula 6 