please show the problem on excel.

4 8 B D E F G H 1 ABC Corp. is considering leasing an asset from XYZ Corp. Here are the relevant facts: 2 Asset Cost $1,000,000 3 Depreciation Year 1 20% Year 2 32% 5 Year 3 19.20% 6 Year 4 11.52% 7 Year 5 11.52% Year 6 5.76% 9 Lease Term 6 years 10 Lease Payment $200,000 per year at the start of years 0,1,2,3,4,5 11 Residual Value 0.00% 12 ABC Tax Rate 0% 13 XYC Tax Rate 40% 14 ABC Interest Rate 10% 15 XYC Interest Rate 7% 16 17 Show that it will be advantageous both for ABC to lease the asset and for XYZ to purchase the asset in order to 18 lease it out to ABC. 19 Question 1 Question 2 Ready