What excel formula is used to calculate 2012 Expenses?

EAGLE OUTFITTERS PROJECTED INCOME STAT 8 Sates 10 'Gross Margin 13 'EBIT }hterest (12%) 'EBT 16 Tax (43%) w Net Income 26 :cash 28 ' inventory Fued Assets hota 2011 950. ooo '40,000 110,000 9.642 ag,358 20 794 ASSETS 2011 1000% 560% 440% 208% 232% 39% D t Vidcnds 2012 S275.ooo' 148.500 126.500 126.500 50 430 54.0% 20.8% 12.0% 43.0%, 250% Inrome Statement 2 The s 46%. 3) Deenoqeof the qrnes bst year. The 25%. use to to n z) Aounts Rerevabk' s 3.6. The 6 S) The Alp 6 150 dm. EAGLE OUTFITTERS PROJECTED BAMNCE SHEET L'ABUTIES & EQUITY $20,000' 24750.00 Accounts payable 10.0002 76.389 36 Debt 90000} 250 Conunon Stock 150.0001 171.875 374.7262 1.6 Retained Earnings $60, 000' S330 000 61,027 374,726 EAGLE OUTFITTERS PROJECTED INCOME STAT 8 Sates 10 'Gross Margin 13 'EBIT }hterest (12%) 'EBT 16 Tax (43%) w Net Income 26 :cash 28 ' inventory Fued Assets hota 2011 950. ooo '40,000 110,000 9.642 ag,358 20 794 ASSETS 2011 1000% 560% 440% 208% 232% 39% D t Vidcnds 2012 S275.ooo' 148.500 126.500 126.500 50 430 54.0% 20.8% 12.0% 43.0%, 250% Inrome Statement 2 The s 46%. 3) Deenoqeof the qrnes bst year. The 25%. use to to n z) Aounts Rerevabk' s 3.6. The 6 S) The Alp 6 150 dm. EAGLE OUTFITTERS PROJECTED BAMNCE SHEET L'ABUTIES & EQUITY $20,000' 24750.00 Accounts payable 10.0002 76.389 36 Debt 90000} 250 Conunon Stock 150.0001 171.875 374.7262 1.6 Retained Earnings $60, 000' S330 000 61,027 374,726