11-15 WACC, please show formula on Excel

shares du share, and the bonds are selling IUI TUU for debt in the computation of OMG's WACC? (LG11-4) 11.13 Weight of Preferred Stock FarCry Industries, a maker of telecommunicati equipment, has 2 million shares of common stock outstanding, 1 million shares of preferred stock outstanding, and 10,000 bonds. If the common shares sell for 527 per share the preferred shares sell for $14.50 per share, and the bonds sell for 98 percent of par, what weight should you use for preferred stock in the compu- tation of FarCry's WACC? (LG11-4) 11-14 Weight of Preferred Stock OMG Inc. has 4 million shares of common stock out- standing, 3 million shares of preferred stock outstanding, and 5,000 bonds. If the common shares sell for $17 per share, the preferred shares sell for $16 per share. and the bonds sell for 108 percent of par, what weight should you use for preferred stock in the computation of OMG's WACC? (LG11-4) INTERMEDIATE PROBLEMS 11-15 WACC Suppose that TapDance, Inc.'s, capital structure features 65 percent equity. 35 percent debt, and that its before-tax cost of debt is 8 percent, while its cost of equity is 13 percent. If the appropriate weighted average tax rate is 34 percent, what will be TapDance's WACC? (LG11-2) 11-16 WACC Suppose that JB Cos, has a capital structure of 78 percent equity, 22 percent debt, and that its before-tax cost of debt is 11 percent while its cost of equity is 15 percent. If the appropriate weighted average tax rate is 25 percent, what will be JB's WACC? (LG11-2) 11-17 WACC Suppose that B2B Ine hon of 27 narcent equity