HELP PLEASE

Starstruck Company would like to determine its optimal capital structure. Several of its managers believe that the best method is to rely on the estimated earnings per share (EPS) of the firm because they feel that profits and stock price are closely related. The financial managers have suggested another method that uses estimated required returns to estimate the share value of the firm. The following financial data are available. Capital structure debt ratio Estimated EPS Estimated required return 0% 10 20 30 40 50 60 $1.75 1.90 2.25 2.55 3.18 3.06 3.10 11.40% 11.80 12.50 13.25 18.00 19.00 25.00TO DO Based on the given financial data, create a spreadsheet to calculate the estimated share values associated with the seven alternative capital structures. Refer to Table 13.15. b. Use Excel to graph the relationship between capital structure and the estimated EPS of the firm. What is the optimal debt ratio? Refer to Figure 13.7. c. Use Excel to graph the relationship between capital structure and the estimated share value of the firm. What is the optimal debt ratio? Refer to Figure 13.7. d. Do both methods lead to the same optimal capital structure? Which method do you favor? Explain. e. What is the major difference between the EPS and share value methods? Starstruck Company would like to determine its optimal capital structure. Several of its managers believe that the best method is to rely on the estimated earnings per share (EPS) of the firm because they feel that profits and stock price are closely related. The financial managers have suggested another method that uses estimated required returns to estimate the share value of the firm. The following financial data are available. Capital structure debt ratio Estimated EPS Estimated required return 0% 10 20 30 40 50 60 $1.75 1.90 2.25 2.55 3.18 3.06 3.10 11.40% 11.80 12.50 13.25 18.00 19.00 25.00TO DO Based on the given financial data, create a spreadsheet to calculate the estimated share values associated with the seven alternative capital structures. Refer to Table 13.15. b. Use Excel to graph the relationship between capital structure and the estimated EPS of the firm. What is the optimal debt ratio? Refer to Figure 13.7. c. Use Excel to graph the relationship between capital structure and the estimated share value of the firm. What is the optimal debt ratio? Refer to Figure 13.7. d. Do both methods lead to the same optimal capital structure? Which method do you favor? Explain. e. What is the major difference between the EPS and share value methods