just answer number 5 on excel sheet. show all functions and formuals used. thanks

A truck is purchased for $175,000 and has an estimated salvage value of $15,000 at the end of recovery periods 5 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 9 4) 150% Declining-Balance Method 115) 200% Declining-Balance Using the Midquarter Convention: the Asset is placed in Service During the Third Qurter (MACRS) 70 5) 200% Declining-Balance Using the Midquarter Convention: the Asset is placed in Service During the Third Qurter (MACRS)