***********************Need the answer in a formula plese. ****************

FILE Paste Clipboard A1 12 13 14 15 16 17 18 Finding the WACC Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 A A B I u EE A Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Font Styles D E F G H 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 135,000 Bonds outstanding 01/01/00 Settlement date 01/01/15 Maturity date 7.50% Annual coupon rate Coupons per year Bond price of par) 114 1,000 Par value Common stock 8,500,000 Shares outstanding Beta 1.25 Share price 34