Bample 1. Create an income statement in excel where the sales growth rate and inflation are Independent variables. (Caculate the value for the yellow cells) Assume the following - Products are: Tee shirts 15.00 1900 sold 5.00 700 sold -Yearly Sales growth is 7% -Yearly Inflation is 2.50% - COGS is 40% of sales 2014 2015 2016 2017 2018 Sales COGS: Gross Margin: 2013 $ 32,000.00 $ 12,800.00 $ 19,200.00 1). What is the dollar value of your gross margin projection for 20167 Feed Costs Rent S $ Insurance 2.000.00 500.00 200.00 1.000.00 100.00 450.00 $ $ $ $ Salaries Internet Other fixed costs Sub total of Fixed costs 0.280.00 $ 12,950.00 ifference between variable and fixed costs? Interest $ 12.450.00 4233.0 $ 8,217.00 Net Income Return on sales ROSE 25.73 3. does your ROS ratio show a positive or negative trend in the busine