Your power plant on Gilligan's Island is producing too much air pollution. The professor gives you three choices for dealing with this problem:

1. You can pay a pollution tax (Carbon Offsets) onetime of $13,000,000 immediately.
2. 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.
3. 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.

Assume that the cost of generating power on the mainland is approximately the same as the cost of generating power at your Gilligan's Island plant. Assume, this comes as a surprise to you and you 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: (This will help you calculate the WACC)

• Debt - $7,000 outstanding bonds, at 7.5% coupon and 20 years to maturity. These bonds pay interest semiannually and quoted price of 108 percent of par.
• Common Stock -180,000 shares outstanding, selling for $50 per share: Beta .90 CAPM is .118 or 11.8%

Preferred Stock - 8,000 shares of 5.5 percent preferred stock outstanding, currently selling for $95.00 per share

Could you please provide solution in excel just to compare data. I have developed the case, but I am not sure if the answer is correct.

I got a WACC of 10.38% and for option three a total NPV of $-7,661,246.82 with three being the best option. I have attached a copy of the excel sheet I am currently using. Any help would be appreciated! Thank you.

Number Value Common 180000 Stock Debt 7000 Preferred 8000 Stock Total Weig Total Value ht 50 $ 9,000,000.00 ### 1080 $ 7,560,000.00 ### 95 $ 760,000.00 4.39% ### Cost of Debt 6.76% Cost of Preferred Stock, under the assumption that there is a PAR value of $100 is calculate Preferred dividend/ price of preferred stock 5.79% WACC Weight Cost of Debt Tax shield Weight Average Cost Common St 51.96% 15.80% 0 8.21% Debt 43.65% 6.76% 35% 1.92% Preferred S 4.39% 5.79% 0 0.25% WACC 10.38% Paying a pollution tax (Carbon Offsets) onetime of $13,000,000 immediately which has a NPV of -$13,000,000 Closing the plant and installing a power cable from the mainland to the Island. Year 0 1 2 3 to Cash Flow 0 ### ### $(750,000.00) Retrofitting the plant with scrubbers to reduce emissions and make the plant green Interest Year Cash Flow Discounted Cash Flow 10.38% 0 $ $ 1 ### $ (6,794,709.19) 2 $(100,000.00) $ (82,076.57) 3 $(100,000.00) $ (74,358.19) 4 $(100,000.00) $ (67,365.64) 5 $(100,000.00) $ (61,030.66) 6 $(100,000.00) $ (55,291.41) 7 $(100,000.00) $ (50,091.87) 8 $(100,000.00) $ (45,381.29) 9 $(100,000.00) $ (41,113.69) 10 $(100,000.00) $ (37,247.41) 11 $(100,000.00) $ (33,744.71) 12 $(100,000.00) $ (30,571.40) 13 $(100,000.00) $ (27,696.50) 14 $(100,000.00) $ (25,091.96) 15 $(100,000.00) $ (22,732.34) 16 $(100,000.00) $ (20,594.62) 17 $(100,000.00) $ (18,657.93) 18 $(100,000.00) $ (16,903.36) 19 $(100,000.00) $ (15,313.79) 20 $(100,000.00) $ (13,873.70) 21 $(100,000.00) $ (12,569.03) 22 $(100,000.00) $ (11,387.06) 23 $(100,000.00) $ (10,316.23) 24 $(100,000.00) $ (9,346.10) 25 $(100,000.00) $ (8,467.21) 26 $(100,000.00) $ (7,670.96) 27 $(100,000.00) $ (6,949.59) 28 $(100,000.00) $ (6,296.06) 29 $(100,000.00) $ (5,703.99) 30 $(100,000.00) $ (5,167.59) 31 $(100,000.00) $ (4,681.64) 32 $(100,000.00) $ (4,241.38) 33 $(100,000.00) $ (3,842.53) 34 $(100,000.00) $ (3,481.18) 35 $(100,000.00) $ (3,153.82) 36 $(100,000.00) $ (2,857.24) 37 $(100,000.00) $ (2,588.54) 38 $(100,000.00) $ (2,345.12) 39 $(100,000.00) $ (2,124.59) 40 $(100,000.00) $ (1,924.79) 41 $(100,000.00) $ (1,743.79) 42 $(100,000.00) $ (1,579.81) 43 44 45 46 47 48 49 50 51 $(100,000.00) $(100,000.00) $(100,000.00) $(100,000.00) $(100,000.00) $(100,000.00) $(100,000.00) $(100,000.00) $(100,000.00) $ (1,431.24) $ (1,296.65) $ (1,174.71) $ (1,064.25) $ (964.17) $ (873.50) $ (791.35) $ (716.94) $ (649.52) $ (7,661,246.82) f $100 is calculated by Average Cost lant green