for Assignment Expert Only

p3-59a.xls

Sheet1

Problem 3-59A					Name
					Section
A	B	C	D	E	F	G	H
5	Data Input Section:		Charlotte Motorcycle Repair Corporation
6
7	Cost of asset, January 1, 2010						Amount
8	Estimated residual value						Amount
9	Estimated useful life						Amount
10
11	Output Section:			Depreciation Expense Per Year
12
13	Year ended December 31			2010	2011	2012	2013
14		Depreciation expense		Formula 1	$0	$0	$0
15		Accumulated depreciation		Fomula 2	- 0	- 0	- 0
16
17	Helpful Hint:
18	Use the following functions to calculate depreciation
19			=SLN(cost,salvage,life)
20
21
22	Part 1.
23		A s s e t s =			Liabilities +	Stockholder's Equity
24	2010	Cash	Machine	Accum. Depr.
25	#1	Amount	Amount
26	#2			Amount		Amount	Title
27	Part 2.
28	Charlotte Motorcycle Repair Corporation
29	Partial Balance Sheet
30						December 31
31						211	2010
32		Machine				Formula 3	Formula 5
33		Less accumulated depreciation				Formula 4	Formula 6
34						-	-
35	Part 3.
36	Type answer starting here
37	Part 4.
38	Type answer starting here
39
40
	End of Problem

&LReimers, Financial Accounting 3e