Need assistance with an Excel project, I got up to Question 12 and I am stuck.

Cost of Capital- Cost of Debt Report

The firm decides to raise $30 million by selling equity and debt. The investment bankers hired by your firm contact potential investors and come back with the following numbers:

Debt that pays $1 million coupons a year and $18 million maturity value after 10 years will sell for $20 million.

Equity that pays expected dividends of $1.2 million starting next year and growing at a rate of 3 percent per year thereafter sells for $10 million.

Question 12: Calculate the cost of debt, equity, and the WACC.

Be sure to show your calculations in Excel and provide a narrative analysis that summarize the results of your analysis and make recommendations for the benefit of company.