Please do this on Excel and put the exact formulas.

ABC Corporation has $500 mil worth of bonds outstanding at par value with a 7.5% coupon rate paid semiannually. These bonds have 19 years to maturity. The current price on these bonds is $952.30 and they were issued with the par value of $1000. The corporate tax rate is 20%.

The company also has 5 mil shares of common stock that currently sell for $30 per share. The risk-free rate is 4%, and the expected return on the market is 10%. The firms beta is 1.1. The firm paid $2.15 per share in dividend recently. Eight years' ago the firm paid $1.40 in dividend. The same growth would be maintained in the long run.

What is the firm's weighted average cost of capital (WACC), if the firm calculates the cost of equity by taking average between the results from the DGM and SML models?