Please provide both answers in excel

1)

Bolster Foods' (BF) balance sheet shows a total of $25 million long-term debt with a coupon rate of 8.50%. The yield to maturity on this debt is 8.00%, and the debt has a total current market value of $27 million. The balance sheet also shows that the company has 10 million shares of stock, and the stock has a book value per share of $5.00. The current stock price is $20.00 per share, and stockholders' required rate of return, r_s, is 12.25%. The company recently decided that its target capital structure should have 35% debt, with the balance being common equity. The tax rate is 40%. Calculate WACCs based on book, market, and target capital structures. What is the sum of these three WACCs?

2)

To help finance a major expansion, Castro Chemical Company sold a noncallable bond several years ago that now has 20 years to maturity. This bond has a 10.25% annual coupon, paid semiannually, sells at a price of $1,100, and has a par value of $1,000. If the firm's tax rate is 40%, what is the component cost of debt for use in the WACC calculation?