Excel Case #2 - CSX Corporation Answer Schedule Format Market value of equity (market cap) 10 $ 50.28 billion currency, 2 decimal places Growth rate for equity Market price of stock (per share) 7.67% percentage, 2 decimal places $ 55.01 currency, 2 decimal places Annual dividend Beta of stock Risk free rate Market rate of return DGM cost of equity (stock) CAPM cost of equity (stock) Average cost of equity Market value of debt Average tax rate $ 0.78 currency, 2 decimal places 1.19 number, 2 decimal places 1.80% percentage, 2 decimal places 8.70% percentage, 2 decimal places 9.19%% percentage, 2 decimal places 10.01% 9.60% 10 $ 12.07 billion percentage, 2 decimal places percentage, 2 decimal places currency, 2 decimal places 23.92% percentage, 2 decimal places Pre tax cost of debt (bonds) 3.83% After tax cost of debt (bonds) 2.91% Total market value of equity and debt $ 75.07 billion Weight for equity 0.8064 percentage, 2 decimal places percentage, 2 decimal places currency, 2 decimal places number, 4 decimal places Weight for debt 0.1936 Weighted average cost of capital 8.30% number, 4 decimal places percentage, 2 decimal places Save your file with this name format: CSXexcelcase2_lastnamefirstinitial Example: CSXexcelcase2_smithj Subtotal Extra credit Capital Structure Debt percentage Equity percentage Total points percentage, 2 decimal places percentage, 2 decimal places