please solve with excel

M N 0 1 KORUMALI GRNM Dikkatli olun! internet kaynakl dosyalar virs ierebilir. Dzenlemeniz gerekmiyorsa, Korumal Grnmde kalmanz daha gvenli olur. Dzenlemeyi Etkinletir A1 Xv fx Suppose XYZ Corporation operates (i) in a perfect capital market (i) faces 40% namely 0.4 corporate income tax and (ii) has current asset value of $1000. A A B D D E F G HT KI L Suppose XYZ Corporation operates (i) in a perfect capital market (ii) faces 40% namely 0.4 corporate income tax and (iii) has current asset value of $1000. 2 Management expects operating profit (i.e., earnings before interest and taxes) of $200 in the coming year. 3 a Calculate total expected income available to the suppliers of capital for the following three capital structures: 5 Capital Structure 1: 100% equity 7 Capital Structure 2: 70% equity, 30% debt with an annual interest of 10% 8 Capital Structure 2: 30% equity, 70% debt with an annual interest of 10%. 15 pts 9 9 10 11 b) Assuming 10% interest applies to any amount of debt, what is the optimal (namely the one that maximizes total expected income to suppliers of capital) 12 capital structure for this company? What is the resulting maximum expected income? 15 pts 13 Hint: fill the following table 14 15 Capital Structure 1 in S Capital Structure 2 in $ Capital Structure 3 in $ Optimal Structure 16 Debt Operating 17 Earnings Interest 18 Expense Taxable 19 Income 20 Taxes Earnings 21 after taxes Total Income to Suppliers of Capital 22 23 24 25 26 27 28 29 Q1 Q2 QZ Q3 Q4