all answers must be inputed as a formula

1. Calculate the market value capital structure and WACC. x All answers must be entered as a formula. Click OK to begin. OK D E Titan Mining Corporation has 8.5 million shares of common stock outstanding, 250,000 shares of 5 percent preferred stock outstanding, and 135,000 7.5 percent semiannual bonds outstanding, par value $1,000 each. The common stock currently sells for $34 per share and has a beta of 1.25, the preferred stock currently sells for $91 per share, and the bonds have 15 years to maturity and sell for 114 percent of par. The market risk premium is 7.5 percent, T-bills are yielding 4 percent, and Titan Mining's tax rate is 35 percent. Debt Bonds outstanding Settlement date Maturity date Annual coupon rate Coupons per year Bond price (% of par) Par value ($) 135,000 01/01/00 01/01/15 7.50% 2 114 1,000 $ $ Common stock Shares outstanding Beta Share price 8,500,000 1.25 34 $ Preferred stock outstanding Shares outstanding 250.000 Common stock Shares outstanding Beta Share price 8,500,000 1.25 34 $ Preferred stock outstanding Shares outstanding Coupon rate Share price Par value ($) 250,000 5.00% 91 100 $ Market Market risk premium Risk-free rate Tax rate 7.50% 4.00% 35% Complete the following analysis. Do not hard code values in your calculations. 0 1 32 33 34 35 36 What is the firm's market value capital structure? Market value of debt Market value of equity 32 33 What is the firm's market value capital structure? 34 35 36 37 Market value of debt Market value of equity Market value of preferred Market value of firm 38 39 40 41 Weight of debt Weight of equity Weight of preferred 42 43 44 45 46 What is the firm's weighted average cost of capital, or WACC? 47 48 Pretax cost of debt Aftertax cost of debt Cost of equity 49 50 51 Cost of preferred 52 53 WACC 54 55