While working on your calculations,

i) Round the number in percentage upto the second decimal place (e.g., 2.3567..% 2.36%)

ii) Round the dollar values upto the second decimal place if they are not whole numbers.

On January 2, Year 1, Jones Corporation purchased a truck for $45,000. The truck has a 4-year estimated life and a $5,000 estimated salvage value. Jones expects to drive the truck 100,000 miles during its useful life. Prepare the depreciation schedule for Year 1 through Year 4 using each of the following depreciation methods; Straight-line method, 200 declining balance method, and Sum-of-years-digits method. You have to construct the depreciation schedules to answer this question. Make sure that all of your calculations should be done on the excel formula bar to show how you obtained your answers.

1) S-Lmethod
	Depreciation Basis	Depreciation Exp.
Year 1
Year 2
Year 3
Year 4
2) 200 declining balance method		S-L rate=?	200 DB rate=?
		200 DB rate
	Beg NBV		Depreciation Exp.	End NBV
Year 1	$45,000
Year 2
Year 3
Year 4
3) Sum-of-years-digits method
	Depreciation Basis	Remaining Years to	Sum-of-Years-Digits	Depreciation Exp.
		the end of the usefule life
Year 1
Year 2
Year 3
Year 4