Market-entry demand, customer stock, and seasonal revenue tideCapacity spill is marked in coral when converted demand cannot be activated
Business
Market Entry Forecast Calculator
Build a month-by-month market-entry demand forecast from qualified demand rather than applying one growth percentage to revenue. The model separates demand generation, conversion, activation lag, acquisition capacity, retention, purchase frequency, seasonal demand, and addressable-market saturation to show active customers, orders, revenue, penetration, and the point at which capacity begins suppressing the forecast.
Ending active customers-
Ending market penetration-
Horizon new customers-
Capacity-constrained demand-
Horizon orders-
Horizon revenue-
Peak revenue month-
Forecast condition-
Demand-to-customer estuary
Follow qualified demand through activation lag into retained market share
Qualified demandNew customersActive customer stock
| Month | Qualified demand | Eligible after lag | New customers | Capacity spill | Active customers | Penetration | Orders | Revenue |
|---|
Market-entry forecasting workflow
Forecast demand, customer stock, and orders as separate operating systems
- Define the addressable customer population and the active customers already established in the market.
- Enter qualified demand, its monthly growth rate, and the observed qualified-to-customer conversion rate.
- Delay converted demand by the real activation or onboarding lag and cap monthly activations at operating capacity.
- Roll active customers forward after monthly retention rather than treating every acquired customer as permanent.
- Apply purchase frequency and seasonality to the active stock to forecast orders and revenue.
Forecast notation
Each symbol belongs to demand, activation, retention, or purchasing
Detailed calculation process
Carry each demand cohort through lag, capacity, and retention
Q_m = Q_1 * (1 + g)^(m - 1)Eligible_m = Q_(m - L)New_m = min(Eligible_m * c, K, M - Retained_m) Retained_m = A_(m - 1) * rA_m = Retained_m + New_mPenetration_m = A_m / M Season_m = 1 + s * sin(2π(m - 2) / 12)Orders_m = A_m * (f / 12) * Season_mRevenue_m = Orders_m * P Percentages are divided by 100 before use. Seasonality alters purchasing intensity, not the active customer stock. Capacity spill is recorded instead of silently moving demand into a later month.
Worked default forecast
Why 3,619 acquisitions produce only 2,823 ending active customers
The default starts with 420 active customers, 900 qualified prospects, 5% monthly demand growth, 12% conversion, a two-month activation lag, capacity for 190 activations per month, and 96.5% monthly retention.
Month 1 retained customers = 420 * 0.965 = 405.3Month 1 eligible demand = 0 because L = 2 monthsMonth 1 active customers = 405.3 + 0 = 405.3 Month 3 eligible demand = 900Potential activations = 900 * 0.12 = 108New customers = min(108, 190, available market) = 108 Across 24 months the model activates about 3,619 customers, loses customers through recurring attrition, ends near 2,823 active customers, reaches about 3.32% penetration, and creates roughly $2.12 million of revenue. The customer-stock reconciliation explains why cumulative acquisitions are not the same as ending active customers.
Evidence to replace
Use observed funnel cohorts as the launch matures
- Qualified-demand definition by source
- Conversion by entry cohort and channel
- Signed-to-live onboarding lag
- Monthly gross and logo retention
- Seasonal order index from comparable markets
Forecast limitation
The model does not create demand that capacity rejects
Constrained demand is reported as spill and is not automatically carried forward. The forecast also excludes price response, competitor retaliation, channel inventory, service-capacity churn, cohort-specific retention, and macroeconomic shocks.
Market entry forecast FAQ
Questions about lag, capacity, and saturation
Why can qualified demand rise while active customers flatten?
Retention losses, acquisition capacity, or the addressable-market ceiling can limit customer-stock growth even when prospects continue increasing.
Should backlog be added to the next month?
Only if the operating process preserves and reworks unactivated demand. This model treats capacity spill as lost unless the input forecast is revised.
When should I change the seasonality amplitude?
Replace it with an index estimated from comparable markets or product history; keep it at zero when no defensible seasonal pattern exists.
Practical examples
Market Entry Forecast Calculator in real planning situations
- Forecast a regional launch with a two-month activation lag.
- Test whether acquisition capacity can support the demand plan.
- Separate customer-stock growth from seasonal order volume.
Important note
Before relying on this result
Calculated from the entered values using the displayed accounting method. Reconcile material decisions with source records and applicable accounting policy.
Additional Market Entry Forecast Calculator questions
Why lag new customers behind qualified demand?
Market-entry demand must pass through conversion and onboarding before it becomes an active customer.
Does seasonal demand change customer count?
No. Seasonality changes orders per active customer; customer stock follows acquisition and retention.
What does constrained demand mean?
It is converted demand that exceeds the entered monthly acquisition capacity and therefore does not enter the active base.