I need to know how to arrive at answers c-g. The correct ones are given, I need to know the formulas in Excel. Use the information above.
Market to Book Ratio Debt Ratio Dividend Payout Ratio Marginal Tax Rate Earnings Per Share Expected Net Income
1.00 40.00% 60.00% 40.00% $4.17 $6,000,000,000.00
Bond Coupon Rate Bond Face Value Years Until Maturity Bond Current Price
8.20% $1,000.00 20 $877.48
Current Stock Price Stock Flotation Charge
$28.00 20.00%
a) Before-tax cost of debt
b) After-tax cost of debt
c) Cost of internal equity
d) Cost of external equity
e) WACC using internal equity
f) WACC using external equity
g) Breakpoint for internal equity
9.60% 5.76%
9.60% 5.76% 15.43% 17.79% 11.56% 12.98% $4,000,000