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. 1% for 2nd year
  2. 3% for 3rd to 5th year
  3. 8% for 6th to 10th year

Table 2 (Aggressive)

  1. 3% for 2nd year
  2. 6% for 3rd to 5th year
  3. 9% for 6th to 10th year

Table 3 (Conservative)

  1. -2% for 2nd year
  2. 1% for 3rd to 5th year
  3. 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

PreviousNext