I'm having trouble completing this pro forma income statement. The assignment says to assume a 10% growth rate in sales and COGS. I'm not sure how to calculate the remaining of 2018. -Aida

g, 7* w7 \"'1" 77d17wer7t'777550rmat Tools Data Window Help 3 [D B to . 7 Home Insert Page Layout Formulas Date Review View Cut rrq .- . . =_ 'ov Prct7eriv I. wv' v as Anal 10 17A77717\\ . 777 :3 6/77 [ e @7177 ' [E [77% 7 4E Copy, 7 _ 77 7 . , . _ 7' Paste gFormat I B I g V BE ' 19%} A ' E7; E7, 5 "7 Merge&Center ' $ v % ) '33 .373, Condmonal Format ' _he:kCell Explanator, 7 7 77. "W ".77.. .4 . 4 .4 , Formatting asTaPle , (DNA , i i777 7i7 Revenue 39,528,000 39,403,000 43,343,300 10% Increase COGS 30,334,000 29,963,000 32,959,300 10% Increase (DmKIO'U'I-b Gross Prot 9,191,000 9,440,000 Gross Margin 23.25% 23.96% 7' 0.00% Gross Prot/Revenue _ SG & A Expense 7,618,000 7,547,000 _ 10 Epreciation Expense 5,761,000 5,850,000 2 11 EBIT 36,909,000_J36,783,000 799.66% 40,723,300 _77 12 [Interest Expense _'80,000 72,000 ' .I 7 13 Taxable Income 455,000 408,000 14 Lraxes :[609000 503,000 _I_ 15 Net Income . 1,375,000 1,854,000 16 bividends :l-499,000 -505,000 ,_ 17 Ere Retained Eams 4,130,000 E99000 18 77 2,72,, 7,7,, 7 I 7 2,2,2, 7 L" 7 , , 7 \\7 19 7' 7 7 777 20 7 7 7 77 1 \\ 22 7 23 .. , _ 2,, .A 2.. ., ,, ,, ' , , 2 24 7 _ 77 7 77 7 7 7 1 7 77 25 '7 7-1 26 7 7 7 7 7 77777 7 77777? 27 ' 1 1 28 7777 ' " ' 1 ; 7 777 717 77777737' 29 7 77 7 ' I" ' , "' \"r " , 30 7 77 . , I " * ' , 33 7 7 7 i 1 " """"'\""' \"\"\" l 1 7 34 7 77 7 7 7 7 ' W " "" " """"""" ' "\"7"\" ., 1 :36 ' " " 1 " '\" 1 ~ 337 77 77777777 7: 777777777"7'\" ' ""7"\" L 1387777777777 77 77 "" "" ' \" ' :39 777 77 777777777 77 7 ' 540 W77 \" ' ' '7 " 7 f' 7' ~ 141 _______ ' V ' 7 1* 11142777777 777 7_ 7\": " 1_ ' * . minim Pminrm: 14:71.57