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
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.
The planner could not start. The forecast below is Refill Round's example.
Without JavaScript the forecast below is for Refill Round's example, and changing an input does not recalculate it.
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.
- Subscription boxes
- Website orders
- Delivery app orders
Month by month
What if? Plausible setbacks, one at a time
| Month | Subscription boxes | Website orders | Delivery app orders | Revenue | Channel fees | After 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 |
| Setback | Year's revenue | Change | Change, % |
|---|---|---|---|
| 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,081 | 0 | 0% |
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
- 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.
- 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.
- 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.
- 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.
- Total revenue and revenue streams, with examples (AO2)
- HL: the benefits and limitations of sales forecasting (AO3)
- Place: the choice of distribution channel changes the revenue kept from each sale
The ideas behind the tool are in the briefing Financial projections: forecasting a business that does not exist yet.
Arjun Agrawal | The Business Brief, https://the-business-brief-dun.vercel.app/entrepreneurship-lab/revenue-planner/. Original teaching material, not an IB publication. The organizations in the teaching cases are fictional unless a case says otherwise.