Blog · Forecast and pipeline · Sales teams
Market analysis and sales forecasting connects supplied demand estimates with attainable company sales. Build a regional assumption table, compare it with actual sales, and identify which inputs explain the gap.
Market analysis and sales forecasting turns supplied demand and market-share assumptions into a company revenue estimate. Define the reachable buyers, the period in which they might buy, and the share your company could attain. Then compare the result with regional sales history and actual outcomes.
Start with a market research table and your own sales export. The research table needs geography, customer segment, eligible account count, buying-period assumption, source date, and an owner. The sales export needs the same geography and segment definitions, transaction dates, and net sales in USD.
The Small Business Administration's market research guide identifies demand, market size, location, saturation, and pricing as research questions. Those questions help define the inputs; they do not supply a company-specific sales forecast.
Check what every source actually measures. Census County Business Patterns reports establishment counts, employment, and payroll for establishments with paid employees. An establishment count is not a count of buying customers or a measure of their planned purchases. A company with several locations can otherwise enter the forecast more than once.
Use market potential versus sales potential for the distinction between the wider opportunity and your attainable portion. This calculation begins after the market definition and evidence have been supplied.
A US maintenance-equipment supplier forecasts one quarter of new-account sales. Each eligible account can buy one initial package during the quarter. Existing-customer renewals and repeat purchases are outside this example, so they must not enter its comparison actuals.
Quarterly sales forecast = Eligible accounts × Quarterly buying fraction × Attainable share of buyers × Average package value
The buying fraction means the portion expected to purchase during this quarter. Attainable share means the portion of those purchasing accounts the company expects to win. Keeping these separate prevents an annual demand estimate from silently becoming a quarterly forecast.
| Region | Eligible accounts | Quarterly buying fraction | Attainable share | Package value (USD) | Forecast sales (USD) |
|---|---|---|---|---|---|
| West | 2,000 | 10% | 20% | 12,500 | 500,000 |
| South | 3,000 | 8% | 25% | 10,000 | 600,000 |
| Midwest | 1,000 | 12% | 25% | 15,000 | 450,000 |
| Total | 6,000 | 1,550,000 |
Place the table in A1:F4. In Excel, enter this formula in F2 and copy down:
=B2*C2*D2*E2
West has 200 expected buying accounts: 2,000 × 10%. Winning 20% means 40 sales; 40 × $12,500 gives $500,000. South has 240 buying accounts and 60 wins; Midwest has 120 buying accounts and 30 wins. These are scenario expectations, not promised orders.
Independently check the total:
=SUMPRODUCT(B2:B4,C2:C4,D2:D4,E2:E4)
Microsoft documents SUMPRODUCT as summing the products of corresponding ranges. It returns $1,550,000 here, matching the sum of F2:F4. Do not multiply total accounts by simple average percentages or average prices; the regional combinations matter.
Match the forecast to the same quarter, geography, and new-account scope in the company history. The prior-year amounts below are supplied sales actuals, not estimates derived from the market table.
| Region | Comparable prior sales (USD) | Forecast sales (USD) | Increase (USD) | Increase (%) |
|---|---|---|---|---|
| West | 450,000 | 500,000 | 50,000 | 11.1% |
| South | 550,000 | 600,000 | 50,000 | 9.1% |
| Midwest | 390,000 | 450,000 | 60,000 | 15.4% |
| Total | 1,390,000 | 1,550,000 | 160,000 | 11.5% |
For this table in A1:E4, use:
=C2-B2
=IF(B2=0,"Review zero base",C2/B2-1)
Percentages are rounded to one decimal place. Calculate total growth from total forecast divided by total prior sales, minus one. The total is not an average of regional growth rates.
The Midwest assumption needs evidence for the largest percentage increase. Ask whether the account pool expanded, more buyers are expected this quarter, prices changed, or sales capacity improved. Use market trend analysis to review demand evidence rather than treating a positive market narrative as a numeric assumption.
Test one input at a time. Reducing South's attainable share from 25% to 20% changes its forecast to 3,000 × 8% × 20% × $10,000 = $480,000. The company total becomes $1,430,000, a $120,000 reduction. The remaining assumptions stay fixed, so the change has a clear explanation.
Suppose the quarter closes with these matching sales actuals:
| Region | Frozen forecast (USD) | Actual sales (USD) | Actual minus forecast (USD) |
|---|---|---|---|
| West | 500,000 | 520,000 | 20,000 |
| South | 600,000 | 540,000 | -60,000 |
| Midwest | 450,000 | 420,000 | -30,000 |
| Total | 1,550,000 | 1,480,000 | -70,000 |
The regional differences sum to the company miss. Revenue alone cannot identify whether buying activity, share, or price caused it. Add observed customer wins and realized package values before assigning an explanation. Keep the frozen assumptions in sales forecasting reports, and use the sales forecast template when connecting this market view to a wider company forecast.
Covirage is not affiliated with Microsoft.
Upload your market-assumption workbook and matching sales history; Covirage maps the columns, and its tools compute and check the comparisons while the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, and bring a sample of your own data. See sales forecast analysis for the supporting review workflow.
No. Market size describes a defined pool of potential demand. A company sales forecast estimates the portion it expects to capture in a specific period. Geography, buying timing, reachable customers, competition, and delivery capacity all affect the connection between those figures.
Start with evidence from comparable regions, customer segments, win rates, and available sales capacity. Document which buyers are in the denominator. Treat a higher share as an assumption requiring support rather than increasing it until the forecast reaches a management target.
Historical sales provide a reasonableness check, especially when the period and customer definition match. They cannot independently prove the market estimate. Investigate whether a forecast implies changed pricing, a larger buying pool, or a higher attainable share, and retain the evidence behind each change.