Please show step by step on how to solve in excel

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. Weight of debt Weight of equity Weight of preferred What is the firm's weighted average cost of capital, or WACC? Pretax cost of debt Aftertax cost of debt Cost of equity Cost of preferred WACC