Requirements: Develop three (3) ten-year (REVENUE) projections USING YOUR COURSE PROJECT SALES PROJECTIONS assuming estimated growth scenarios as shown below: (USE WEEK 3 ASSIGNMENT FILES OR THE WORKING SPREADSHEET) TABLE 1 (MODERATE) a. 1% for 2nd year b. 3% for 3rd to 5th year c. 8% for 6th to 10th year TABLE 2 (AGGRESSIVE) a. 3% for 2nd year b. 6% for 3rd to 5th year c. 9% for 6th to 10th year TABLE 3 (CONSERVATIVE) a. -2% for 2nd year b 1% for 3rd to 5th year c. 2% for 6th to 10th year Year Year 1 Year 2 Year 3 Year 4 6 Year 6 Year 7 Year 8 Year 9 Year 10 Number of units Unit dollar Sales Sales Year 1 759 297.00 Year 2 1,237,554.00 Year 3 2,903879.00 Year 4 Years 3,845,780.60 / 4,920.806 M EXAMPLE: USE TEMPLATE TO CREATE SALES BUDGET WITH VARIATION OPTIONS: DO NOT ENTER ANY DATA IN THE GREYED OUT CELLS Yeart Year 2 Your Year Years Years Year Year Number of units 1200 1212 1236 1256 1279 1302 1328 1354 Unit dollar 190.00 190.00 190.00 190.00 190.00 190.00 190,00 190.00 Sales an ENIR DESIRED GROWTH 1.0% 2.ON 1.8% 1.8% 2.0% 2.ON 2.3 2.3% 16% 4 5 16 77 Directions 1. Enter Year 1 Units (Estimate) Enter Year 1 Unit Price (Estimate) Enter Desired Anal Growth in Percentage Inter Deiced Growth Percentage in Dollars She 2.1 Sales Forecast - Year 1 759,297.00 Sales Year 2 1,237,554.00 Year 3 2.903879.00 Year 4 3,845,780.60 Year 5 4,920.806 Requirements: Develop three (3) ten-year (REVENUE) projections USING YOUR COURSE PROJECT SALES PROJECTIONS assuming estimated growth scenarios as shown below: (USE WEEK 3 ASSIGNMENT FILES OR THE WORKING SPREADSHEET) TABLE 1 (MODERATE) a. 1% for 2nd year b. 3% for 3rd to 5th year c. 8% for 6th to 10th year TABLE 2 (AGGRESSIVE) a. 3% for 2nd year b. 6% for 3rd to 5th year c. 9% for 6th to 10th year TABLE 3 (CONSERVATIVE) a. -2% for 2nd year b 1% for 3rd to 5th year c. 2% for 6th to 10th year Year Year 1 Year 2 Year 3 Year 4 6 Year 6 Year 7 Year 8 Year 9 Year 10 Number of units Unit dollar Sales Sales Year 1 759 297.00 Year 2 1,237,554.00 Year 3 2,903879.00 Year 4 Years 3,845,780.60 / 4,920.806 M EXAMPLE: USE TEMPLATE TO CREATE SALES BUDGET WITH VARIATION OPTIONS: DO NOT ENTER ANY DATA IN THE GREYED OUT CELLS Yeart Year 2 Your Year Years Years Year Year Number of units 1200 1212 1236 1256 1279 1302 1328 1354 Unit dollar 190.00 190.00 190.00 190.00 190.00 190.00 190,00 190.00 Sales an ENIR DESIRED GROWTH 1.0% 2.ON 1.8% 1.8% 2.0% 2.ON 2.3 2.3% 16% 4 5 16 77 Directions 1. Enter Year 1 Units (Estimate) Enter Year 1 Unit Price (Estimate) Enter Desired Anal Growth in Percentage Inter Deiced Growth Percentage in Dollars She 2.1 Sales Forecast - Year 1 759,297.00 Sales Year 2 1,237,554.00 Year 3 2.903879.00 Year 4 3,845,780.60 Year 5 4,920.806