PLEASE USE EXCEL AND EXPLAIN EVERYTHING WITH DETAIL INCLUDING ALL FORMULAS.

6. Determining the optimal capital structure Aa Aa Understanding the optimal capital structure Review this situation: Transworld Consortium Corp. is trying to identify its optimal capital structure. Transworld Consortium Corp. has gathered the following financial information to help with the analysis Debt Ratio Equity Ratio EPS DPS Stock Price 30% 40% 50% 60% 70% 70% 60% 50% 40% 30% 1.25 0.55 36.25 1.40 0.60 37.75 1.60 0.65 39.50 1.85 0.75 1.75 0.70 38.25 38.75 Which capital structure shown in the preceding table is Transworld Consortium Corp.'s optimal capital structure? O Debt ratio-30%; equity ratio-70% Debt ratio-60%; equity ratio-40% O Debt ratio-50%; equity ratio-50% Debt ratio-40%; equity ratio-60% O Debt ratio-70%; equity ratio-30% Consider this case: Globo-Chem Co. currently has a capital structure consisting of 30% debt and 70% equity. However, Globo-Chem Co.'s CFO has suggested that the firm increase its debt ratio to 50%. The current risk-free rate is 2.5%, the market risk premium is 7.5%, and Globo-Chem Co.'s beta is 1.25 If the firm's tax rate is 35%, what will be the beta of an all-equity firm if its operations were exactly the same? Now consider the case of another company