On January 2, Year 1, Jones Corporation purchased a truck for $39,000. The truck has a 5-year estimated life and a $4,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 5 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.

Straight-line method:

depreciation expense year 1 = ($39,000 - $4,000) / 5 = $7,000depreciation expense year 2 = $7,000depreciation expense year 3 = $7,000depreciation expense year 4 = $7,000depreciation expense year 5 = $7,000

200 declining balance method:

depreciation expense year 1 = 2 x 1/5 x $39,000 = $15,600depreciation expense year 2 = 2 x 1/5 x $23,400 = $9,360depreciation expense year 3 = 2 x 1/5 x $14,040 = $5,616depreciation expense year 4 = 2 x 1/5 x $8,424 = $3,369.60depreciation expense year 5 = $5,054.40 - $4,000 = $1,054.40

Sum-of-years-digits method:

depreciation expense year 1 = 5/15 x $35,000 = $11,666.67depreciation expense year 2 = 4/15 x $35,000 = $9,333.33depreciation expense year 3 = 3/15 x $35,000 = $7,000depreciation expense year 4 = 2/15 x $35,000 = $4,666.67depreciation expense year 5 = 1/15 x $35,000 = $2,333.33