PLEASE SHOW IN EXCEL!! THANK YOU PLEASE SHOW FORMULAS

5. Capital Structure and Growth Edwards Construction currently has debt outstanding with a market value of $87,000 and a cost of 11 percent. The company has EBIT of $9,570 that is expected to continue in perpetuity. Assume there are no taxes. a. What is the value of the company's equity? What is the debt-to-value ratio? b. What are the equity value and debt-to-value ratio if the company's growth rate is 3 percent? c. What are the equity value and debt-to-value ratio if the company's growth rate is 7 percent? Chapter 17 Question 5 Input Area: $ Amount of debt Debt interest rate EBIT b. Growth rate C. Growth rate $ 87,000 11% 9,570 3% 7% Output Area: a. Interest payment Earnings available to shareholders Value of equity DN ratio b. Earnings next year V2 Value of equity DN ratio c. Earnings next year VL Value of equity DN ratio