fill in the blank A-K

Finish the pro forma income statement for a newly create coffee shop. In 2017, the coffee shop had $250,000 in sales with an expected increase (randomly determined) up to the range 12.5%-13.5% in 2018. Their usual product mix consists of coffee, food, and general goods (cups, mugs, etc.). The Expenses are also provided below. Rent and utilities are fixed at $20,000 per year. In order to increase sales, the Advertising expense is projected to increase based on the following formula: 10% + 0.1%*(number of years away from the base year)1/2 Taxes are only paid when Earnings Before Taxes is greater than $41,000 Complete the income statement for 2018 by selecting the correct formula(s) for the corresponding letter (A-K) listed in the graphic below: 2 Pre Forma Autos INCOME STATEMENT 2017 2011 B 4 Sales Growth 5 6 Item 7 Coffee 8 Food General Good 10 General Goods Product cat 55.0 25. ON 200 250 50.000 250.000 2 500 162500 Cost of Good and c D E OPERATING EXPENSES Salary 75.000 F G 12 Salary & Benefits 13 Advert 14 Sen. Gen. A 15 M 16 Tax Rate 17 Base Year 3.0 Aden 2017 12.000 7.500 1270 Toler IS 19 20 21 22 K . B. =RANDO"(0.125-0.135)+0.139 C. EFB-F9 =IF (A19-41000 (A19'$C$16),0) D =EB'B4EB E. =F58"$B$8 =(F5*C7)+(F6'C8)(F7C9) F =F10-F18 G =SUM(F13F17) -RANDO"(0.135-0.125)+0.125 H E14 -IF(F10-F18-F20, F19,0) -F19-F20 J.-F58'SCS12 -F58"$B$12 K IF(F1941000 (F19'58516).0)