the second picture are the answer for reference. Can this be all done in excel please?

25 > 11- A company is considering buying a new piece of machinery. A 10% interest rate will be used 44 in the computations. Two models of the machine are available. A Machine I Machine II Initial cost $80,000 $100,000 End-of-useful-life salvage value, S 20,000 25,000 Annual operating cost 18,000 15,000 first 10 years 20,000 thereafter Useful life, in years 20 MACRS class 7 yr 7 yr (a) Determine which machine should be purchased, based on equivalent uniform annual cost. (b) What is the capitalized cost of Machine I? (c) Machine I is purchased and a fund is set up to replace Machine I at the end of 20 years. Compute the required uniform annual deposit. (d) Machine I will produce an annual saving of material of $28,000. What is the rate of return if Machine I is installed? (e) What will be the book value of Machine I after 2 years, based on 60% bonus depreciation with the balance using MACRS? (f) What will be the book value of Machine II after 3 years, based on straight-line depreciation? (g) What would be the MACRS depreciation in the third year for Machine II? 1-44 a) M/C2 $27,380, b) $270,500, c) $1050, d) 11.4%, e) $19,590, f) $91,000, g) $17,490 1-46 MV2-BV, 1c) $40.800. 2c) MV-BV=$60,000 25 > 11- A company is considering buying a new piece of machinery. A 10% interest rate will be used 44 in the computations. Two models of the machine are available. A Machine I Machine II Initial cost $80,000 $100,000 End-of-useful-life salvage value, S 20,000 25,000 Annual operating cost 18,000 15,000 first 10 years 20,000 thereafter Useful life, in years 20 MACRS class 7 yr 7 yr (a) Determine which machine should be purchased, based on equivalent uniform annual cost. (b) What is the capitalized cost of Machine I? (c) Machine I is purchased and a fund is set up to replace Machine I at the end of 20 years. Compute the required uniform annual deposit. (d) Machine I will produce an annual saving of material of $28,000. What is the rate of return if Machine I is installed? (e) What will be the book value of Machine I after 2 years, based on 60% bonus depreciation with the balance using MACRS? (f) What will be the book value of Machine II after 3 years, based on straight-line depreciation? (g) What would be the MACRS depreciation in the third year for Machine II? 1-44 a) M/C2 $27,380, b) $270,500, c) $1050, d) 11.4%, e) $19,590, f) $91,000, g) $17,490 1-46 MV2-BV, 1c) $40.800. 2c) MV-BV=$60,000