creat an income statement in an excel where the saless growth rate and the inflation are independent variables caculate the yellow cells assume the fellowing tee $15.00 sold hats $ 5.00 700 sold yearly sales growth is 7% yearly inflation is 2.50% Cogs is 40% of sales 1 1 11 . Sales: COGS: Gross Margin: $ 32,000.00 $ 12,800.00 Fixed Costs Rent Utilities Insurance Salaries Internet Other fixed costs I$ $ $ $ $ 2,000.00 500.00 200.00 3,000.00 100.00 450.00 500.00 Sub total of Fixed Costs EBIT Interest EBT Taxes (34%) Net Income