I am working on this Excel problem. I am needing some help figuring out the formulas for the blue cells. Please help me with the formulas for the bleu squares. Thank you!

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). BOD Corp Capital Structures Current ed Assets Debt Equity Debt/Equity Ratio Share Price Shares Outstanding Interest rate $8,000,000 $8,000,000 $4,000,000 $4,000,000 $8,000,000 $20 400,000 10% $20 10% Current Capital Structure: No Debt EBIT Interest Net Income Recession $500,000 0 Expected $1,000,000 0 Expansion $1,500,000 0 ROE EPS sed Capital Structure: Debt $4 million Recession Expected Expansion EBIT Interest Net Income $500,000 $1,000,000 $1,500,000 ROE EPS BreakEven EBIT