Please help demonstrate and solve the problem in Excel with all the formulas. TIA.

Problem: Your boss believes the company's power plant is producing too much air pollution on a typical island. Your boss gives you three choices for dealing with this problem because he/she does not want to deal with it: You can pay a pollution tax (Carbon Offsets) one time of $13,000,000 immediately. You can close the plant and install a power cable from the mainland to the Island. That will cost you $1,000,000 at the end of this year, $3,000,000 at the end of next year and then $750,000 forever for maintenance. You can retrofit the plant with scrubbers to reduce the emissions to make the plant green. That will cost $7.5m at the end of this year and $100,000 for 50-years for maintenance (starting at the end of next year). Assume that the cost of generating power on the mainland is approximately the same as the cost of generating power at the Island's plant. Assume, this comes as a surprise to you and your boss, have not saved any money in reserves, and you need to raise capital. Additional information is that market has a 12 percent market risk premium on the power plant with the risk-free rate being 5 percent with a company tax rate of 35 percent. Current total raised capital at the power plant: > Debt - 7,000 outstanding bonds, at 7.5% coupon and 20 years to maturity. These bonds pay interest semiannually and quoted a price of 108 percent of par. Common Stock -180,000 shares outstanding, selling for $50 per share: Beta 90. > Preferred Stock - 8,000 shares of 5.5 percent preferred stock outstanding, currently selling for $95.00 per share. Step 1: Finding the present value of costs of three options . NPV of option one =- $13,000,000. The number is negative because it is a cost. . NPV of option two = -$1,000,000/(1+WACC)+(-$3,000,000)/(1+WACC)2+(- $750,000)/WACC NPV of option three = -$7,500,000/(1+WACC)+PV of 50 years $100,000 annuity Step 2: Finding WACC to discount all future CFs (or costs) WACC = wd*ra(1-T) + Wps*rps+ ws*rs. Step 3: Calculating and comparing NPVs of three options . NPV of option one = - $13,000,000. The number is negative because it is a cost. . NPV of option two = -$1,000,000/(1+WACC)+(-$3,000,000)/(1+WACC)2+(- $750,000)/WACC NPV of option three = -$7,500,000/(1+ WACC)+PV of 50 years-$100,000 annuity