Sales Forecasting

How to learn with this guide

1. Read each explanation, then repeat the worked example without looking.
2. Follow the three-step method aloud and answer the check.
3. For feedback and a reworded attempt, return to the interactive lesson.
4. At the end, explain how the idea applies to your own industry.

LESSON 1 OF 4

Start with a driver

Outcome: Calculate revenue from a transparent unit assumption.

Concise briefing

A forecast should show units times net selling price, then separate channels with different price and volume assumptions. Historical performance and signed orders can inform a baseline; a goal alone does not make it likely.

Worked example

A bar line expects 2,000 wholesale units at $8 net and 300 direct units at $16 net. Forecast revenue is $16,000 + $4,800 = $20,800 before returns or discounts.

Repeatable method

1. List units by channel and period.
2. Apply the actual net price assumption.
3. Add channels and label uncertainty.

LESSON 2 OF 4

Forecast a funnel cautiously

Outcome: Use stage evidence without treating every lead as an order.

Concise briefing

For a simple planning estimate, stage-weighted opportunities can help model uncertainty, but probabilities are assumptions and correlated deals can fail together. Track timing, approval, and historical conversion. Keep a separate committed-order line.

Worked example

Ten similar qualified opportunities worth $2,000 each at an evidence-based 25% win assumption produce an expected planning value of $5,000; this is not $5,000 cash or a guarantee.

Repeatable method

1. Define opportunity stage and amount.
2. Use historical conversion where available.
3. Keep expected value separate from booked sales.

LESSON 3 OF 4

Separate sales and collection dates

Outcome: Move expected cash into the period it is collected.

Concise briefing

A purchase order, invoice, and bank receipt can occur in different periods. A cash forecast should use expected collection dates and account for credit terms, deductions, and late payments. Do not add the same sale twice.

Worked example

A retailer receives goods in January and is invoiced $20,000 on 60-day terms. The revenue and receivable may be recorded earlier, but the cash plan uses the expected receipt date, subject to payment behavior.

Repeatable method

1. Record shipment and invoice dates.
2. Apply contractual and observed payment timing.
3. Place expected cash in the likely collection week.

LESSON 4 OF 4

Build a downside scenario

Outcome: Change one driver and quantify the consequence.

Concise briefing

A base forecast needs a downside. Reduce volume, delay a customer, or raise cost, then compare gross contribution and cash low points. The scenario is a decision tool, not a prediction of certainty.

Worked example

Base forecast is 2,000 wholesale units at $8. A 25% volume shortfall means 1,500 units and $12,000 wholesale revenue, $4,000 less than base before any cost changes.

Repeatable method

1. Choose a plausible driver shock.
2. Recalculate units, revenue, contribution and cash timing.
3. Set a trigger for action if actuals deviate.

Final review

Close your notes and answer these in the interactive course. Revisit any missed lesson before attempting the reworded check.

1. Which is strongest evidence for next month's volume baseline?
2. Does a $5k stage-weighted pipeline equal $5k cash?
3. Why create a downside case?

Use it in your setting

Replace one fictional example with facts from your field. Name the decision, evidence needed, and the first assumption to verify.

All examples are educational. This printout does not create a verified grade, enrollment, or credential.

Sources and further reading

Original Aim High Hero explanations and fictional exercises. External sources do not endorse this course.

• U.S. Small Business Administration — Plan your business
• SCORE — Business education
• SBA — Manage your business