need help with question 1 please show on spreadsheet

Instructions: Complete the following problem set. Submit a solution set that includes answers and supporting documentation--spreadsheet or a document showing the calculator inputs/long-hand calculations. 1. Guzman Enterprises hired you to estimate their cost of capital. The company's target capital structure is equally split between debt and common equity, but no preferred equity. Guzman's outstanding bonds are currently selling for $676.86, have original maturity of 20 years, effective maturity of 9 years, par value of S1,000 and an annual coupon of 4% Guzman informs you that they do not intend to issue new shares of common equity, and they have no preferred methods for calculating the cost of retained earnings. However, they do provide you with the following information: The company expects dividend growth of 3.5% forever. The common shares will pay a dividend of $1.90 at year end, and the shares currently trade for $22.35 each. Also, the company's common stock is risky enough that it commands a premium of 1.5% over the company's debt. If the firm faces a flat state-plus-federal tax rate of 25%. what is Guzman's cost of capital