please write in excel

Directions for Unit 6 Assignment (Spreadsheet Calculations): Prepare your sales projections for three to five years in Excel. Before submitting your Excel spreadsheet for grading make sure you Check to see that you are not missing any formulas. (These are the calculations that will occur as you change the numbers as outlined below) Format each cell in whole dollars (not necessary to add cents) format all cells properly-S. %, column width, etc. Format page layout as per instructions from previous spreadsheets for orientation, footers, gridlines, etc Format to print - should not be more than two pages, one is more likely Note: The numbers and percentages you use will be from your data gathering for your market area, and assumptions. Growth Rate is the percentage you anticipate (desired or best guess) growing each year, Year 1 Year 2 Year 3 Year 4 Year 5 Multiplier is Multiplier is Multiplier is Multiplier is 1.1 for 10% 1.1 for 10% 1.05 for 5% 1.05 for 5% increase increase increase increase Growth Rate Per Year 10% 10% 1.05 (or 1.05 (or (Desired or best ress 5% incr.) 5% incr.) Population of your Mkt 20000 (City) Target Demographic 35% 70001 Cage, etc) Target Demographic w/ 40%* 25001 median income base Anticipated Mkt Share 15% of the previous category Average It of visits for 4 the year Average price per visits $100 for the year Total Sales for the Year Add'l Sales (pct of total) 10% 5160001 316,8001 Total Sales in Year 1