Economics Homework Help
DeVry University Week 3 Budgeting and Forecasting Excel Worksheet
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 (Links to an external site.))
Table 1 (Moderate)
- 1% for 2nd year
- 3% for 3rd to 5th year
- 8% for 6th to 10th year
Table 2 (Aggressive)
- 3% for 2nd year
- 6% for 3rd to 5th year
- 9% for 6th to 10th year
Table 3 (Conservative)
- -2% for 2nd year
- 1% for 3rd to 5th year
- 2% for 6th to 10th year
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Year 6 |
Year 7 |
Year 8 |
Year 9 |
Year 10 |
|
Number of units |
||||||||||
Unit dollar |
||||||||||
Sales |