Calculate and analyze depreciation under alternative methods.

p06-72a.xls

Sheet1

Problem 6-72A					Name
					Section
A	B	C	D	E	F	G	H
5	Data Input Section:		Schillig & Gray Industries
6
7	Cost of asset, January 1, 2011						Amount
8	Estimated salvage value						Amount
9	Estimated useful life						Amount
10	Year					Units produced
11	2011					Amount
12	2012					Amount
13	2013					Amount
14	2014					Amount
15	Total units produced over life of machine						Formula 1
16	Cost per unit (cost-residual/units)						Formula 2
17	Output Section:
18	Parts 1,2			Depreciation Expense Per Year
19						Double
20				Straight	Activity	Declining
21			Year	Line	Method	Balance
22		1	2011	Formula 3	Formula 7	Formula 11
23		2	2012	Formula 4	Formula 8	Formula 12
24		3	2013	Formula 5	Formula 9	Formula 13
25		4	2014	Formula 6	Formula 10	Formula 14
26				$ - 0	$ - 0	$ - 0
27
28	Helpful Hint:
29	Use the following functions to calculate depreciation
30			=SLN(cost,salvage,life)
31			=DDB(cost,salvage,life,period)
32
33	Part 3.			Book Value of the Asset
34		End of Year		Straight Line	Activity Method	Double Declining Balance
35		2011		Formula 15	Formula 16	Formula 17
36		2012		- 0	- 0	- 0
37		2013		- 0	- 0	- 0
38		2014		- 0	- 0	- 0
39
	End of Problem

&LReimers, Financial Accounting 3e