Please show all your work:)

Late submission is no longer accepted for this homework. Question 1: (20 points) Year Sales Vanguard Solar Systems is building a new manufacturing facility to be used for the production of solar panels. Vanguard uses MACRS depreciation on its assets. Suppose the equipment belongs to MACRS's 3-year property class. The equipment used in this manufacturing facility costs $3.55M, although the company also had to spend $450,000 on the installation costs. O&M costs are expected to be $1.3M the first year, increasing 2% annually. In computing the tax deductions, consider a combined rate of 35% for the tax. $2,100,000 3,200,000 3.800,000 4,500,000 5,300,000 5 Compute the after-tax rate of return. Use Microsoft Excel to solve this problem and attach your file to your homework submission. Otherwise, you must show all your work in your homework submission. In any case, use IRR function to compute the rate of return; you do not need to perform interpolation