Subscription forecastBusiness

Forecast for a subscription box or membership business

Usually ready in 15 minutesRevisions includedQuality check
Packages
Payment protectionDetails
  • Revisions within the package are free.
  • If you do not respond within 3 days of delivery, the work is accepted automatically.

The money is reserved when you pay and released only once you accept the work.

Forecast for a subscription box or membership business

Example result

Example for the Standard package

12-month forecast: a coffee subscription box

Key assumptions

AssumptionValueSource
New subscribers per month180Last 6 months' average
Monthly cancellations7.5%Payment platform data
Skipped boxes6% a monthNot billed
Cost per box$17.30Coffee $9.40, packaging $1.60, shipping $5.20, fees $1.10
Cost to win one subscriber$38Ad account
Fixed costs$4,500 a monthPart-time staff, software, storage

Subscriber economics

  • Contribution per box: $32 − $17.30 = $14.70
  • Average stay: 1 ÷ 7.5% = 13.3 months
  • Lifetime value: 13.3 × $14.70 = $196, or 5.2 times the $38 it costs to win a subscriber

Forecast (excerpt)

MonthSubscribersBoxes shippedRevenue, $Profit, $
11,2441,16937,4085,844
31,4111,32642,4328,152
61,6171,52048,64011,004
91,7801,67353,53613,253
121,9101,79557,44015,047

Profit = boxes × $14.70 − ads $6,840 − fixed costs $4,500.

What moves the result most

Cancellations. At 7.5% the base levels off at about 2,400 subscribers; at 10% only at 1,800. Cutting cancellations to 6% raises the average stay to 16.7 months and lifetime value to $245.

Client: Brewbox, a monthly box with 2 bags of specialty coffee for $32; 1,150 subscribers today Task: a 12-month forecast with subscriber economics; $39 package

The client and all details are made up.

About this service

We forecast a subscription box or membership from its subscriber base: new sign-ups, monthly cancellations, skips and pauses, plan mix and how long the average member stays. For boxes we add product, packing and shipping cost per box, and for memberships the cost of content, events or perks, so you see lifetime value against what you pay to win each subscriber.

What is included

  • What you getForecast tables for your subscription: active subscribers by month, churn and pauses, revenue by plan, cost per box or member, lifetime value, acquisition cost and cash flow, with assumptions listed. Tables come as text on the order page and as an Excel (.xlsx) file; this is a planning estimate, not financial, tax or investment advice.
  • Subscriber flowNew, cancelled, paused and active
  • Cost per box or memberProduct, packing, shipping or perks
  • Lifetime valueProfit over a typical stay
  • Prepaid plansQuarterly and annual cash timing
  • Acquisition paybackMonths to earn back a new subscriber

How it works

  1. 1
    BriefYou share plans, costs and churn
  2. 2
    CalculationWe work out subscribers, LTV and cash
  3. 3
    DeliveryYou get tables, an Excel file and a summary

What we need from you

What the box or membership includes, plans and prices (monthly, quarterly, annual), current or expected subscribers, churn, cost per box or per member, shipping, acquisition cost and other monthly costs.

We will ask you:

  • Is it a physical box or a membership?
  • What are your plans and prices?
  • How many subscribers do you have or expect, and how many cancel?
  • What does one box or member cost you?

Compare packages

PackagesBasic$19Standard$39Premium$79
What is includedSubscriber economics12-month forecast3-year plan, 3 scenarios
Deadline1 day2 days4 days
Revisions123
Periodper unit and per month12 months3 years
Scenarios113
Cash flow tableNoYesYes
Tables in Excel (.xlsx)YesYesYes
Order BasicOrder StandardOrder Premium

Payment protection

You pay when you order, but the money is released only for accepted work.

  • Fixed priceThe package price does not change after you pay.
  • The money is reservedWhen you pay, the amount is only reserved. It is released to the service once you accept the work.
  • Checked before deliveryEvery result goes through a quality check before it reaches you, and you see it on the order page before accepting it.
  • Free revisionsAsk for changes within your brief as many times as the package allows.
  • Acceptance after 3 daysIf within 3 days of delivery you neither accept the work nor ask for changes, it is accepted automatically. If you write in the order chat after delivery, the order waits; once we answer, we may start the 3 days again and will say so in the chat.
  • Redo or a full refundIf the result does not match your brief and the revisions did not fix it, or the work takes more than twice its deadline, write in the order chat: we will redo the work or refund the payment in full.
How it works →

Questions and answers

How do you handle skips and pauses?

We treat paused subscribers as not paying that month but not lost, using the rate you give us.

Can you show the effect of a gift subscription season?

Yes. Gift subscriptions usually spike before holidays and end without renewal, and we show that separately.

Will the forecast tell me the right price?

It shows the margin and payback at the prices you test. Premium scenarios can compare price points.

Did not find your answer?

Packages