please show in excel how to calculate common equity and debt for the highlighted cells using excel formulas

BOD CORPORATION Common Equity, Preferred Equity and Debt Balances 2010 500,000 2011 Common Equity 2012 600,000 2013 650,000 2014 2015 525,000 Preferred Equity 50,000 55,000 60,000 60,000 70,000 70,000 Debt 600,000 650,000 700,000 750,000 Total Firm Value 1,150,000 1,230,000 1,310,000 1,410,000 1,355,000 1,345,000 Corp. Tax Rate 35% 30% 30% 40% 35% 35% Debt to Equity Ratio 1,63 1.10 BOD CORPORATION Common Equity. Preferred Equity and Debt Expected Returns 2010 2011 2012 2013 2014 2015 Common Equity Expected Return