Please show work in excel spreadsheet.

Thank you! MNO's capital structure includes bonds, preferred stock, and common stock. The target capital structure calls for 42 percent common stock, 14 percent preferred stock, and the remainder as bonds. The company's bonds have a yield to maturity of 6.2 percent. The company's preferred stock, which sells for $93.29 per share, pays an annual dividend of $4.88. The market risk premium for the average common stock is 13.7 percent and the risk-free rate is 2.9 percent. MNO stock has a beta of 2. If MNO's marginal tax rate is 40 percent, then what is MNO's weighted average cost of capital?