**PLEASE SHOW EXCEL EQUATIONS FOR ANSWERS**

Given the following information from Kiing Power Co., find the reqested answers.

Debt: 40,000 bonds outstanding currently trading at $949.87 per bond. The bonds have a 6.0% coupon rate. Coupon payments are made semi-annually. The bond has 18 years remaining to maturity

Preferred Stock: 100,000 shares that are currently trading for $96.71 per share. The preferred stock is paying an annual dividend of $4.75 per share.

Common Stock: 1,000,000 shares outstanding with current market price of $74.17 per share. The firm is expected to announce a $4.60 per share for next year, the growth is 3.15%. The market risk premium is 7.00% and the risk free rate is 1.25%. The firm beta is 1.10.

Assume a 34% tax rate.

Find the following:

	%
Before-tax Cost of Debt
After-tax Cost of Debt
Cost of Preferred Stock
Cost of Equity - CAPM
Cost of Equity - Dividend Growth Model
Cost of Equity - Average
WACC
	Capital Structure - %
% - Debt
% - Preferred
% - Equity
	Current Market Value - $
Debt
Preferred
Equity
TOTAL