please DO NOT answer using excel, use hand written formuals instead and show all work. thank you!

Problem 7(15 points) An asset has a first cost of $45,000, a recovery period of 8 years, and a $3,000 salvage value. An engineer wants to compare the PW of depreciation at i = 10% per year for DDB-to-SL switching with MACRS for n= 7 years to determine which is the preferred method. MACRS D ($) (a) Continue the calculation to fill all blanks in the table below. Method Switching D ($) Year S DDB L BV($) Pick d (%) 45,000 1 11,250 5,625 11,250 33,750 14.29 8,438 4,821 8,438 25,312 BV($) 45,000 38,569 6,431 8 3,000 (b) Indicate the year that DDB is switched to SL and the depreciation at that year. (c) Calculate the PW of depreciation for both methods and determine which is the preferred method. Problem 7(15 points) An asset has a first cost of $45,000, a recovery period of 8 years, and a $3,000 salvage value. An engineer wants to compare the PW of depreciation at i = 10% per year for DDB-to-SL switching with MACRS for n= 7 years to determine which is the preferred method. MACRS D ($) (a) Continue the calculation to fill all blanks in the table below. Method Switching D ($) Year S DDB L BV($) Pick d (%) 45,000 1 11,250 5,625 11,250 33,750 14.29 8,438 4,821 8,438 25,312 BV($) 45,000 38,569 6,431 8 3,000 (b) Indicate the year that DDB is switched to SL and the depreciation at that year. (c) Calculate the PW of depreciation for both methods and determine which is the preferred method