Estimation of asset depreceiation

Question:
A company purchases a truck for $110,000. The truck has an estimated salvage value of $10,000 at the end of the recovery period. Using Microsoft Excel, prepare the depreciation schedule for the truck using the straight line method with a recovery period of five years.
A company purchases a truck for $110,000. The truck has an estimated salvage value of $10,000 at the end of the recovery period. Using Microsoft Excel prepare the depreciation schedule for the truck using the sum of year method with a recovery period of five years.
A company purchases a truck for $110,000. The truck has an estimated salvage value of $10,000 at the end of the recovery period. Using Microsoft Excel prepare the depreciation schedule for the truck using the 200% declining-balance method with a recovery period of five years.
After graphing the results of the three methods, respond to the following questions in a document.
Which method results in more depreciation in each year? Less depreciation each year?
Although we have not covered the details of the accounting/ tax implications of using an accelerated depreciation method, why might you want to use an accelerated depreciation method?
How much was the actual cash amount that was transferred due to depreciation? Think carefully about this question.