hello, i would like someone to please double check this for me and if you can provide the formulas so i can check it

i also need help with 4 and 5

Five Tear Financial Projection More on back. Year 1 Year 3 30,000.00 $ 31,200.00 $ 32.448.00 33,745.92 $35.09s 2 Year 2 Year 4 Year 5 7 Sales Revenue Cost of goods sold Gross profit 10,500.00 $ 10,920.00 $ 11,356.80 5 11,811.07 5 12,281.51 $ 19,500.00 s 20,280.00 $ 21,091.20 $ 21.934.85 5 22812.24 11 Expenses 12 Commission 13 osk rental 14 Marketing 15 fquipment repar & maint 16 Total Expenses 4,500.00 4680.00 4867.20 50618S 5264.36 250.00 $ 1.500.00 1,42500 $ 1.350.00 $ 1.27500S 120000 s0000 250005 250,00 5 250.00 5 250.00 525.00 6880.00 $7,018.45 $ 7,165.70is 7.322.12 57881 551.25 G07.75 6,750.00 4. Gven the assumptions above, wilthe owner meet her goal of $20,000 Operating Income in Year S? Explain. (Type your answer in the area below your data on the rinancial Projection worksheet) 13 12.750.00 S 13.40000 S 14.072.75S 14.709.15IS 15.490 13 1 Operating ineeme 20 Now use Goal Seek to determine the percentage increase in reveneTout Name" FromoToGo would need to have to achieve an operating income of $20,000 in Year S (Do not change any of the assumptions except for the %revenue ncrease S. 21 22 23 34 &Leave your fe showing these goal seek resuts when you submit for gradng Aho, type your answerto #5 above in the area below your data on the Financial Projection worksheet Use the layout shown below Tele Year S Year o Year a Year 20 Year 1 Salesrevenue Cost of goods sokd Gross profe Finencial Prejetion Assnpon Cover txpemes Cemmis C P Type here to search "Your Name "FroYoToGo is a small business that operates a mall kiosk featuring gourmet frozen yogurt. The owner is interested in projecting sales revenues, cost of goods sold, gross profit, expenses and operating income for a five-year period. She has hired you as a consultant to prepare this projection using MS Excel. Year 1 estimates (based on the previous year numbers) have been provided for you. Projected changes for years 2-5 have also been provided. The owner requires an easy to read worksheet that should allow for quick analysis if projections for certa in numbers change, such as the commission percentage or cost of kiosk rental. Year 1 Information (should be linked to assumptions page): $30,000 peryear 35% of current year Revenue 15% of current year Revenue $250 per month $1500 per year $500 per year Sales Revenue: Cost of Goods Sold: Commission: Kiosk Rental: Marketing: Equipment Repair and Maintenance: Changes for future years: Revenue will increase 4 % per year from the previous year amount Marketing will decrease 5 % per year from the previous year amount Equipment repair and maintenance will increase 5 % peryear from the previous year amount REQUIREMENTS: 1. Open a new work book and save it using the proper naming convention 2. Construct three worksheets within this file. The first worksheet will be your cover worksheet. The second worksheet will be for the assumptions which should be titled and labeled ASSUMPTIONS. The third worksheet will conta in the financial projections based on your paper design. The third worksheet shou ld conta in an appropriate title. All dollars are to "display" to the nearest dollar. All percentages are to "display" to two decimals. Where appropriate, use mixed references unless an absolute reference is necessary. 3. Re-use-ability and user-friendly "assumptions", the financial projection outputs should calculate correctly and present the results in a professional manner. The user shou ld NEVER have to change anything or enter anything in the financial projection sheet no matter the change in assumptions. All output cells in the financial plan output worksheet will contain formulas with NO numbers in the formulas. are the main objectives. If there are any changes in any of the Five Year Financial Projection 5 Year 1 Year 2 Year 3 Year 4 Year 5 7 Sales Revenue 8 Cost of goods sold 9 Gross profit 10 11 Expenses: 12 Commission $ 30,000.00 $31,200.00 $ 32,448.00 $ 33,745.92 $ 35,095.76 10,500.00 $ 10,920.00 $ 11,356.80 $11,811.07 $12,283.51 $ 19,500.00 $ 20,280.00 $ 21,091.20 $ 21,934.85 $ 22,812.24 4,500.00 $ 4,680.00 $ 4,867.20 $ 5,061.89 $5,264.36 250.00 $ 1,500.00 $ 1,425.00 $ 1,350.00 $ 1,275.00 $ 1,200.00 500.00 $ 6,750.00 $ 6,880.00 $7,018.45 $ 7,165.70 $ 7,322.12 250.00 $ 250.00 $ 250.00 $ $ Kiosk rental 250.00 13 14 Marketing Equipment repar & maint. $ 16 Total Expenses $ 525.00 $ 551.25 $ 578.81 $ 607.75 15 17 $ 12,750.00 $ 13,400.00 $ 14,072.75 $ 14,769.15 $15,490.13 18 Operating income 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 4. Giventhe assumptions above, will the owner meet her goal of $20,000 Operating Income in Year 5? Explain. (Type your answer in the area below your data on the Financial Projection worksheet). 5. Now use Goal Seek to determine the percentage increase in revenue "Your Name" FroYoToGo would need to have to achieve an operating income of $20,000 in Year 5. (Do not change any of the assumptions except for the % revenue increase)