calculate and analyze depreciation under alternative methods

p06-70a.xls

Sheet1

Problem 6-70A					Name
					Section
A	B	C	D	E	F	G	H
5	Data Input Section:		Super Fast Subs Company
6
7	Cost of asset, January 1, 2010						Amount
8	Estimated residual value						Amount
9	Estimated useful life						Amount
10	Year					Miles driven
11	2010					Amount
12	2011					Amount
13	2012					Amount
14	2013					Amount
15	2014					Amount
16	Total miles driven over life of equipment						Formula 1
17	Cost per mile (cost-residual/units)						Formula 2
18	Output Section:
19	Part 1.			Depreciation Expense Per Year
20						Double
21				Straight	Activity	Declining
22		Year		Line	Method	Balance
23		2010		Formula 3	Formula 8	Formula 13
24		2011		Formula 4	Formula 9	Formula 14
25		2012		Formula 5	Formula 10	Formula 15
26		2013		Formula 6	Formula 11	Formula 16
27		2014		Formula 7	Formula 12	Amount
28				$ - 0	$ - 0	$ - 0
29
30	Helpful Hint:
31	Use the following functions to calculate depreciation
32			=SLN(cost,salvage,life)
33			=DDB(cost,salvage,life,period)
34	Part 2.
35	Type answer starting here
36
37
38
39
40
41
42
	End of Problem

&LReimers, Financial Accounting 3e

CyberCoach: Enter the following formula: =(H7-H8)/H16

CyberCoach: Enter the following formula: =G11*$H$17 Then copy down

CyberCoach: You have to enter this amount manually.