Reading forecast bias when revenue is close to zero
Avoid relying on percentage error when a small denominator overwhelms the interpretation.
Wall Street Playbook ·
Compare error measures
A new region forecasts $20,000 and realizes $5,000. Absolute error is $15,000 and error as a percent of actual is 300%. A mature region with a $500,000 forecast and $470,000 actuals misses by $30,000, about 6.4%. The mature region has the bigger dollar error and the smaller percentage.
Choose a useful scorecard
Show dollar errors alongside percentage measures and use a consistent aggregation method. Define how zero actual months are treated. Compare forecast errors by stage and receipt timing before making a staffing or budget decision. The metric should identify a practical improvement.
FP&A Interview & Case Workbook
Get the complete guide when you’re ready for more practice.
Sale price $50.15 Original price $59