Need the excel formulas for this. Thanks!

A B 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 2 4 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 8 10 114 1,000 Common stock Shares outstanding Beta Share price 8,500,000 1.25 34 16 17