Please show all the steps and formulas in excel. Thank you.

Pacific Intermountain Utilities Company has a present capital structure (which the company feels is optimal) of 60 percent long-term debt, 15 percent preferred stock, and 25 percent common equity. For the coming year, the company has determined that its optimal capital budget can be externally financed with $55 million of 11 percent firstThe company's common stock is presently selling at $19 a share, and next year's common dividend, D1, is expected to be $5 a share. The company has 20 million common shares outstanding. Next year's net income available to common stock (including net income from next year's capital budget) is expected to be $115 million. The company's past annual growth rate in dividends and earnings has been 5 percent. However, a 2 percent annual growth in earnings and dividends is expected for the foreseeable future. The company's marginal tax rate is 40 percent. Calculate the company's weighted cost of capital for the coming year. Round your answer to one decimal place