Example Using Forecasting Method 4: Specific Percent Increase for Each Month

To calculate sales estimates for January, February and March of 2008, enter these percentage values in the appropriate processing options:

  • January: 10 percent

  • February: 20 percent

  • March: 30 percent

    Month

    2007 Reported

    2008 Estimated

    Forecast Calculation

    JANUARY

    10,000

    11,000

    10,000 × 1.1

    FEBRUARY

    12,500

    15,000

    12,500 × 1.2

    MARCH

    15,000

    19,500

    15,000 × 1.3

Determine the sales estimates for January, February, and March 2008 by multiplying the sales figures for the corresponding months of 2007 with the percentage from the processing options.

Note: For a lease to be comparable, sales for the estimated month in the prior year must exist, that is, at least 13 months of sales data must be available.