Entrepreneurship and Innovation LabTool 04 of 06

Where will the money come from, month by month?

A revenue model says what customers pay for, how and how often. Turn it into a twelve-month forecast stream by stream: products sold by the unit through your own shop or someone else's platform, and subscriptions that build up as customers join and wear away as they leave. Then see which assumption the year depends on most.

Back to 3.3 Costs and revenues Also for 4.3 Sales forecasting (HL) and 4.5 The seven Ps of the marketing mix

Tool
Revenue model planner
IB status
IB content and enrichment; draws on 3.3, 4.3 (HL), 4.5
Example
Refill Round, fictional; figures simulated
Saved
On this device only

Section 01: Revenue model planner

IB content and enrichment Source: Enrichment Source: Simulated data

The example. Refill Round, the fictional subscription refill service, has three revenue streams: the subscription box at $24 a month; one-off refill orders through its own website at about $9; and one-off orders through a local delivery app at $11, of which the app keeps 20%. All figures are simulated.

Without JavaScript the forecast below is for Refill Round's example, and changing an input does not recalculate it.

Revenue streams, up to 4

  1. Stream 1: Subscription boxes
  2. Stream 2: Website orders
  3. Stream 3: Delivery app orders

The forecast

Revenue in the year
$106,081
Month 1
$2,510
Month 12
$15,4116.1 times month 1
After channel fees
$104,413fees $1,668
Subscribers in month 12
529232 cancelled during the year

Reading. The forecast year brings in $106,081, from $2,510 in month 1 to $15,411 in month 12 (6.1 times as much). Largest stream: Subscription boxes, with 77% of the year's revenue. Channel fees take $1,668, leaving $104,413. 529 subscribers are paying in month 12, after 232 cancellations over the year.

Implication. Of the four setbacks tested, starting sales 20% lower costs the year the most: $21,552, or 20% of the forecast. Each setback is a plausible bad case, not a prediction. Test the assumption behind the costliest one with real customers before committing money to it.

Your streams are kept on this device only.

Revenue each month, stacked by streamRevenue grows from $2,510 in month 1 to $15,411 in month 12, $106,081 in the year. Share of the year's revenue: Subscription boxes (solid navy) 77%, Website orders (blue with diagonal lines) 15%, Delivery app orders (gold with horizontal lines) 8%.$0$5,000$10,000$15,000$20,0001$2,51023456789101112$15,411MonthRevenue, $
  • Subscription boxes
  • Website orders
  • Delivery app orders
Revenue each month, stacked by stream; each stream has its own colour and pattern. The figures are in the table below.

Month by month

What if? Plausible setbacks, one at a time

MonthSubscription boxesWebsite ordersDelivery app ordersRevenueChannel feesAfter fees
1$1,08045 subscribers$990110 units$44040 units$2,510−$88$2,422
2$2,13689 subscribers$1,044116 units$47343 units$3,653−$95$3,558
3$3,192133 subscribers$1,089121 units$51747 units$4,798−$103$4,695
4$4,224176 subscribers$1,143127 units$55050 units$5,917−$110$5,807
5$5,256219 subscribers$1,206134 units$59454 units$7,056−$119$6,937
6$6,264261 subscribers$1,260140 units$64959 units$8,173−$130$8,043
7$7,296304 subscribers$1,323147 units$69363 units$9,312−$139$9,173
8$8,352348 subscribers$1,395155 units$75969 units$10,506−$152$10,354
9$9,408392 subscribers$1,467163 units$81474 units$11,689−$163$11,526
10$10,488437 subscribers$1,539171 units$88080 units$12,907−$176$12,731
11$11,592483 subscribers$1,611179 units$94686 units$14,149−$189$13,960
12$12,696529 subscribers$1,692188 units$1,02393 units$15,411−$205$15,206
Year$81,98477%$15,75915%$8,3388%$106,081−$1,668$104,413
The year's revenue if one assumption turns out worse, the others unchanged
SetbackYear's revenueChangeChange, %
Prices 10% lower$95,473−$10,608−10.0%
Starting sales 20% lower$84,529−$21,552−20.3%
Monthly growth halved$92,478−$13,603−12.8%
Churn doubled$89,473−$16,608−15.7%
The forecast as entered$106,08100%

The setbacks are different sizes on purpose: each is a plausible bad case for that assumption, not a common percentage.

Section 02: How to use it, and what to watch for

Steps

  1. Add up to four revenue streams. Choose units for products or orders sold one at a time, and subscription for customers who pay every month.
  2. For a unit stream, enter the price, the units sold in month 1, the monthly growth in units and any share of the price a channel keeps.
  3. For a subscription, enter the monthly price, any subscribers you already have, the new subscribers in month 1, the monthly growth in new subscribers and the share of subscribers who leave each month.
  4. Read the forecast, then the table of setbacks, which makes each assumption worse on its own and shows what the year loses.

Section 03: What the terms mean here

Revenue stream

A distinct source of revenue, such as one product, one service or one channel. Total revenue is the sum of the streams (3.3).

Subscription

An agreement under which a customer pays regularly, usually monthly, until they cancel.

Churn

The share of subscribers who cancel in a month. Each month, churn removes subscribers and new ones join.

Channel fee

The share of each sale kept by an intermediary that sells for you, such as a marketplace or a delivery app.

Monthly growth rate

The percentage by which units, or new subscribers, rise each month. 5% a month compounds to about 71% more after 11 months.

Section 04: Where it sits in the IB course

Total revenue and revenue streams are IB content (3.3, AO2), and at HL so are the benefits and limitations of sales forecasting (4.3, AO3). Subscriptions, churn and channel fees are enrichment: standard start-up terms the guide does not use. The guide's own forecasting methods are on the HL sales forecasting page.

The ideas behind the tool are in the briefing Financial projections: forecasting a business that does not exist yet.