Please complete in excel showing formula

1. (10 points) The company used the allowable Section 179 deduction during the first year. The company has decided to sell the asset during year 5, what is the depreciation allowance for year 1 cost of asset amount invested + installation costs 450,000+ 150,000 600,000 depreciation rate 7 year for macrs years 1 2. 3 4 5 6 7 2. (10 points) The company obtained a loan at 10% to be paid only the interest for 5 years, and then the principal at the end of year 5. Fill the following ATCF table for year 1, including Section 179. PPMT DWO Section 179 TI T ATCF BV EOY 1 BT&CF 750.000 IPMT 600.000 (15 points) Assume that the company did use section 179, did use the credit as stated in problem 2, and sold the asset during year 5 for $250,000. Fill the ATCF table bellow for year 5. BT&LCF Salvage PPMT IPMT DWO Section 1791 TI ATCF BV EOY 5 1. (10 points) The company used the allowable Section 179 deduction during the first year. The company has decided to sell the asset during year 5, what is the depreciation allowance for year 1 cost of asset amount invested + installation costs 450,000+ 150,000 600,000 depreciation rate 7 year for macrs years 1 2. 3 4 5 6 7 2. (10 points) The company obtained a loan at 10% to be paid only the interest for 5 years, and then the principal at the end of year 5. Fill the following ATCF table for year 1, including Section 179. PPMT DWO Section 179 TI T ATCF BV EOY 1 BT&CF 750.000 IPMT 600.000 (15 points) Assume that the company did use section 179, did use the credit as stated in problem 2, and sold the asset during year 5 for $250,000. Fill the ATCF table bellow for year 5. BT&LCF Salvage PPMT IPMT DWO Section 1791 TI ATCF BV EOY 5