Please help with Excel You need to complete this problem in a spreadsheet and sh

Question

Please help with Excel

You need to complete this problem in a spreadsheet and show all your work. Create an excel file that shows your calculations. Clearly indicate your final answer(s). Name the file with the following convention: Lastname-Problem#.xlsx. For instance. Roark-Problem2.xlsx. Several years ago the Haverford Company sold a $1,000 par value bond that now has 25 years to maturity and an 8.00% annual coupon that is paid quarterly. The bond currently sells for $900.90. and the company's tax rate is 40%. What is the component cost of debt for use in the WACC calculation? Haverford uses debt, common equity and preferred stock in their capital structure. Using the following information AND the cost of debt calculated in part (a) above, determine the WACC for the company: Preferred Dividend is $2.50 per share Price of Preferred is $22.72 Weight of Debt is 40% and Weight of Equity is 45% Haverford estimates the cost of equity based on their debt yield plus a risk premium of 5.5%

Explanation / Answer

Solution.

A .

Cost of debt = 8% x ( 1 - 0.40 )

= 4.80%

B.

Cost of debt = 4.80%

Cost of prefrrred stock = $2.50 / $22.72 = 11%

Cost of Equity =( $80 / $900.90 ) + 5.5% = 14.38%

WACC = 10%

Capital Cost Weight WACC prefrrred stock 11% 0.15                        0.02 Debt 4.80% 0.40                        0.02 Equity 14.38% 0.45                        0.06 Total                        0.10

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.