A B C D E G CHAPTER 13 - EXCEL EXERCISE Using the information provided below fill out the tables for each of the capital structures. This should be done using formulas (which may just be equations). 6 BOD Corp Capital Structures Current Proposed Assets $8,000,000 $8,000,000 Debt $4,000,000 10 Equity $8,000,000 $4,000,000 11 Debt/Equity Ratio 0 12 Share Price $20 $20 13 Shares Outstanding 400,000 14 Interest rate 10% 10% 15 16 17 Current Capital Structure: No Debt 18 Recession Expected Expansion 19 EBIT $500,000 $1,000,000 $1,500,000 20 Interest 0 0 0 21 Net Income 22 23 ROE 24 EPS 25 26 27 Proposed Capital Structure: Debt = $4 million 28 Recession Expected Expansion 29 EBIT $500,000 $1,000,000 $1,500,000 30 Interest 31 Net Income 32 33 ROE 34 EPS 35 36 37 BreakEven EBIT 38 39 40 41 42 43 44