Please, solve it with the formula in Excel. Thank you

3 The ACME Toy Company has the following information. Computer the cost of capital for each. a. It has $1,000 par value bond with a 9% annual coupon rate and a 20 year maturity. The investors require a 11% rate of return. Compute the market value of the bonds and the after-tax cost if the tax rate is 21% and you can buy the bond for $1,100 3 b. ACME's common stock paid a $1.40 dividend last year. In addition, their dividends are growing at 6% per year. The price of this stock is currently $100.00. Compute the cost of this capital. 1 c. ACME's preferred stock is payinng a 8% dividend on a $100 par value. The market price of shares is currently 2 $90.00/share. Compute the cost of this capital. 4 d. Using the information above and the balance sheet info below, compute the WACC. Liabilities and Equity Accounts Payable Long Term Debt Preferred Stcok Common Stock 00 ONM $ $ $ $ $ 45,000 1,000,000 500,000 2,000,000 3,545,000