Sales Projection Formula: Model Assumptions and Check a Target

Write the base and assumption together

Fictional service line: the supplied completed-quarter sales base is $125,000. Model the next quarter under three assumptions: a 4% decline, no change and 8% growth. Use the same sales definition and quarter length in all three cases. There is no evidence here that any scenario is more likely.

Forecasting: Principles and Practice explains that usable methods depend on available data. A supplied growth assumption can illustrate a scenario, but the arithmetic alone does not validate the assumption.

Calculate three one-quarter scenarios

Check the rate hidden inside a target

Suppose the exercise adds a target of $150,000 for the next quarter. The implied change is ($150,000 ÷ $125,000) − 1 = 0.20, or 20%. That is larger than the supplied 8% growth case. It does not prove the target is achievable or impossible; it reveals the assumption the target would require relative to this base.

A useful calculation note says “20% growth would be needed to reach the target from this base.” Writing “we forecast 20% because that is the target” would confuse a desired result with an evidence-based expectation.

Distinguish repeated growth from a single increase

If the supplied scenario is 8% each quarter for two quarters, the second projected quarter is $125,000 × 1.08² = $145,800. Adding 16% to the original base gives $145,000, which is $800 lower because it omits compounding on the first increase.

Do not apply two quarters of growth to a one-quarter question. Likewise, an annual assumption cannot be inserted as a monthly rate without defining how it should be converted. Keep period labels on the base, rate and projected amount.

Hand over the scenario with its limits

Completed note: “Using the supplied $125,000 quarterly base, an assumed 8% next-quarter increase gives $135,000. A $150,000 target implies 20% instead. The exercise contains no seasonality, pipeline or customer-retention evidence, so the rates have not been validated.”

Practice task: change only the growth assumption to 12%. The next-quarter projection becomes $140,000. Leave the original base unchanged so the effect of the new assumption is visible.