* PLEASE PROVIDE EXCEL FORMULA RO SOLVE THESE PROBLEMS AS WELL THANKS

Nova Corporation is interested in measuring the cost of each specific type of capital as well as the weighted average cost of capital. Historically, the firm has raised capital in the following manner:

Source of capital: Weight

Long-term Debt 35%

Preferred Stock 12 %

Common Stock Equity 53%

The tax rate of the firm is currently 21%. The needed financial information and data are as follows

Debt: Nova can raise debt by selling $1,000-par-value, 6.5% coupon interest rate, 10-year bonds on which annual interest payments will be made. To sell the issue, an average discount of $20 per bond needs to be given. There is also an associated flotation cost of 2% of par value.

Preferred stock: Preferred stock can be sold under the following terms: The security has a par value of $100 per share, the annual dividend rate is 6% of the par value, and the flotation cost is expected to be $4 per share. The preferred stock is expected to sell for $102 before cost considerations.

Common stock: The current price of Novas common stock is $35 per share. The cash dividend is expected to be $3.25 per share next year. The firms dividends have grown at an annual rate of 5%, and it is expected that the dividend will continue at this rate for the foreseeable future. The flotation costs are expected to be approximately $2 per share. Nova can sell new common stock under these terms.

Retained earnings: The firm expects to have available $100,000 of retained earnings in the coming year. Once these retained earnings are exhausted, the firm will use new common stock as the form of common stock equity financing. (Note: When measuring this cost, the firm does not concern itself with the tax bracket or brokerage fees of owners.

a)Calculate the after-tax cost of debt.

Per value	$1000
Coupon Rate	6.50%
Maturity (yrs)	10
Discount	$20
Flotation cost	2%
Tax Rate	21%
Annual Coupon Rate
Net proceeds
Before tax cost of Debt
After tax cost of Debt

b) Calculate the cost of preferred stock

Par Value	$100
Annual Dividend Rate	6%
Floation Cost	$4
Sales Price before cost consideration	$102
Annual Dividend Payment
Net proceeds
Cost of preferred stock

c) calculate the cost of retained earnings

Current Price	$35
Expect Cash dividend	$3.25
Constant growth rate	5%
Flotation cost	$2
Cost of retained earning

d) Calculate the cost of new common stock

Cost of new common stock $ ( )

e)Calculate the firms weighted average cost of capital using retained earnings and the capital structure weights shown in the table above.

WACC using retained earnings ( )

f) Calculate the firms weighted average cost of capital using new common stock and the capital structure weights shown in the table above

WACC using new common stock ( )