Develop three (3) ten-year (REVENUE) projects

Colors "of Width: Automatic V Gridlines Headings A Fonts Margins Orientation Size Print Breaks Background Print 4 | Height Automatic View View Scale: Print Print Bring Send Effects . Selection Align Group Rotate Area . Titles 100% Forward . Backward - Pane homes Page Setup Scale to Fit Sheet Options Arrange X fx A B C D E G H K M N EXAMPLE: USE TEMPLATE TO CREATE SALES BUDGET WITH VARIATION OPTIONS: DO NOT ENTER ANY DATA IN THE GREYED OUT CELLS Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Number of units 1200 1212 1236 1256 1279 1302 1328 1354 1385 1417 Unit dollar 190.00 190.60 190.00 190.00 190.00 190.00 190.00 190.00 190.00 190.00 Sales ENTER DESIRED GROWTH (26 1.0% 2.0% 1.6% 1.8% 1.8% 2.0% 2.0% 2.3% 2.3% Develop three (3) ten-year (REVENUE) projections USING YOUR COURSE PROJECT SALES PROJECTIONS assuming estimated growth scenarios as shown below Directions BLE 1 (MODERATE) 1. Enter Year 1 Units (Estimate) a. 1% for 2" year 2. Enter Year 1 Unit Price (Estimate) b. 3% for 3" to 5" year 3. Enter Desired Annual Growth in Percentage c: 8% for 6* to 10" your 4. Enter Deired Growth Percentage in Unit Dollars TABLE 2 (AGGRESSIVE) a. 3% for 2" year b. 61% for 3" to 5 year c. 9% for &" to 10" year TABLE 3 (CONSERVATIVE) a. -29% for 2 year 27 b. 1% for 3% to 5 year 23 c. 2% for 6 to 10 year 24 25 26