Please solve in Excel and show the formulas

09.03-PR009 Hyundai USA has numerous robotic welders as well as robotic checkers with vision. One underbody robotic welder costing $1,200,000 (7-year property class) was installed and is increas- ing productivity by 2.5% in one area. The result is a savings of $500,000 per year. Deductible expenses other than depreciation and interest associated with the installed robotic welder are only $120,000, Hyundai borrowed $550,000 at 11% for 5 years. They plan to keep the welder for 8 years. Hyundai's income tax rate is 25% and their MARR is 9% after taxes. Determine the PW, FW, AW, IRR, and ERR for the investment if: a. The loan is paid back using Plan 1. c. The loan is paid back using Plan 3. b. The loan is paid back using Plan 2. d. The loan is paid back using Plan 4 0902 PP010 09.03-PR009 Hyundai USA has numerous robotic welders as well as robotic checkers with vision. One underbody robotic welder costing $1,200,000 (7-year property class) was installed and is increas- ing productivity by 2.5% in one area. The result is a savings of $500,000 per year. Deductible expenses other than depreciation and interest associated with the installed robotic welder are only $120,000, Hyundai borrowed $550,000 at 11% for 5 years. They plan to keep the welder for 8 years. Hyundai's income tax rate is 25% and their MARR is 9% after taxes. Determine the PW, FW, AW, IRR, and ERR for the investment if: a. The loan is paid back using Plan 1. c. The loan is paid back using Plan 3. b. The loan is paid back using Plan 2. d. The loan is paid back using Plan 4 0902 PP010