# Business Finance (I need only explanation of the calculation as required as I already have Excel)

Anonymous

Question description

I just need explanation in an easy format for each calculation as I am uploading the Excel Work. Just complete the highlighted portion below.

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) onetime 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.

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 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 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.

Please answer in essay format and provide your Excel document showing all your calculation in appendixes choose the best option for Island. Support your answer with your calculations. Also, to calculations use specified resources, other appropriate scholarly resources, including older articles.Length: However long you need to answer the question (Paragraph per option is normal).

Your paper should demonstrate thoughtful consideration of the ideas and concepts presented in the course and provide new thoughts and insights relating directly to this topic. Your response should reflect scholarly writing and current APA standards. Be sure to adhere to University's Academic Integrity Policy.

• The introduction should state the answer and establish the topic and a clear thesis statement.
• The conclusion summarizes the main points and leaves the reader with a strong comprehension of the paper’s significance and the author’s understanding of the correct financial decision.
• All research is correctly credited, using correct APA format.
• Grammatically correct - No spelling, grammar, or mechanics errors

(Top Tutor) Studypool Tutor
School: Purdue University
Studypool has helped 1,244,100 students
flag Report DMCA

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors