Finding the WACC-Excel HOME | INSERT PAGE LAYOUT FORMULAS DATA REVIEW VEw Sign In B I U A Alignment Number Conditional Format as CellCells Editing -Formatting TableStyles Font Styles E F 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 (S) 135,000 01/01/00 01/01/15 114 1,000 Common stock Shares outstanding Beta 8,500,000 1.25 Share price Preferred stock outstandina .Sheet1