please use excel to complete.

21. Cost of Capital Hatter, Inc., has equity with a market value of $7.1 million and debt with a market value of $3.2 million. The cost of the debt is 7.5 percent per year. Treasury bills that mature in one year yield 4 percent per year, and the expected return on the market portfolio over the next year is 11 percent. The beta of the company's equity is 1.10. The firm pays no taxes. a. What is the company's debt-equity ratio? b. What is the company's weighted average cost of capital? C. What is the cost of capital for an otherwise identical all-equity firm