please show work through excel

5 A tractor is purchased for $175,000 and has an estimated salvage value of $20,000 at the end of recovery periods. Prepare a depreciation schedule for a truck (6 years) 6 1) Straight-line Method 7 2) Sum-of-Years method 8 3) 200% Declining Balance Method 94) 150% Declining-Balance Method 10 11 S) 200% Declining-Balance Using the Midquarter Convention: the Asset is placed in Service During the Third Qurter (MACRS) 12 13. All the dollar value should be presented with two decimal places 14 15 16 1) Straight-Line Method Deprecitaiton - Excel Function Use Dale A tractor is purchased for $175,000 and has an estimated salvage value of $20,000 at the end of recovery periods. Prepare a depreciation schedule for a truck. (6 years) 1) Straight-line Method 2 Sum-of-Yews method 3) 2009 Declining-Balance Method 4) 150. Declining Balance Method 5200% Declining Balance Using the Midporter Convention the Asset is Placed in Service During the Third Qurter (MACRS) All the dollar value should be presented with two decimal places 1) Straight-Line Method 2) Sem-of-Years method 3) 2009. Declining-Balance Method 4) 150% Dining-Balance Method 5) 200% Declining Balance Using the Midquarter Cevent the Asset is placed in Service During the Third Qurter (MACRS)