Wauvel
Toolkit

Recurring, capacity, or funnel: which revenue engine are you?

← All posts
By Blake EkelundAugust 24, 2026 · 7 min read

Ask most owners how they forecast revenue and the honest answer is: last year plus a bit. It is not stupid — it is often roughly right — but it is useless the moment you want to changesomething, because a growth percentage has no parts. You cannot pull a lever on 8%.

A revenue model has parts. And here is the useful simplification: almost every business runs on one of three engines. Once you know which one you are, you know exactly which handful of numbers drives your top line — and which ones are worth measuring every month.

Engine one: recurring

You sell access that renews. Software subscriptions, memberships, monthly retainers, subscription boxes, maintenance contracts. Revenue this month is mostly revenue last month, which is the great gift of the model — and the trap, because decline is just as sticky as growth.

Your revenue is a balance, not an event. It moves through four drivers: how many new customers you add, what they pay on average, how many you lose, and how much existing customers expand. Everything else is commentary.

Recurring · the monthly bridge
DriverAmountWhat moves it
Opening MRR$48,000
+ New customers$4,200Sales and marketing
+ Expansion$1,100Upsells, seat growth
− Churn$2,900Retention, onboarding
= Closing MRR$50,400+5.0%
Every month is opening balance plus new, plus expansion, minus churn. If churn exceeds new plus expansion, revenue falls even in a month when sales did well - which is why the bridge matters more than the total.

The number to watch is not MRR. It is churn as a share of opening balance, because that single figure sets the ceiling on how big you can get: at 6% monthly churn, you top out at roughly sixteen times whatever you add each month, no matter how good sales gets.

Engine two: capacity

You sell time or space, and you have a hard ceiling. Salons, restaurants, hotels, clinics, trucking fleets, agencies billing hours. There are only so many chairs, rooms, trucks, or hours in a week, and any one that goes unsold is gone forever.

Revenue is a multiplication: units × sellable slots × utilization × price, plus whatever you sell alongside it. Four chairs, forty slots a week each, 68% filled, $65 a visit. That is your business, and each of those four terms is a different lever with a different cost to pull.

Utilization

68%

of sellable slots filled

Revenue per slot

$65

average ticket

Weekly revenue

$7.1k

4 chairs, 40 slots each

Utilization is almost always the cheapest lever and the last one people look at. Moving 68% to 76% adds 12% to revenue with no new staff, no new space, and no price increase — it is pure yield. Adding a fifth chair adds cost immediately and revenue only if you can fill it.

Engine three: funnel

You buy attention and convert it. Ecommerce, DTC, marketplaces, lead generation, anything where paid acquisition is the primary growth motor. Revenue is the output of a chain, and every stage multiplies: spend → sessions → conversion → orders → average order value, adjusted for returns and repeat purchases.

The dangerous property of a funnel business is that it looks like it scales linearly and does not. Doubling spend rarely doubles orders, because cost per click rises as you push past your best audiences. A model that assumes constant CAC will overstate next year badly.

  • Conversion rate is the highest- leverage term, because it multiplies everything downstream at zero marginal cost.
  • Repeat rateis what decides whether you can outbid competitors — it is the difference between affording one purchase of CAC and three.
  • Returns quietly eat the margin you use to fund acquisition, and almost nobody models them.

What if you are more than one?

Plenty of businesses are. A gym with memberships (recurring) and personal training slots (capacity). An agency on retainers (recurring) plus project work (capacity). A DTC brand with one-time orders (funnel) and a subscribe-and-save tier (recurring).

Model them separately and add them up. Do not average them together — a blended forecast hides the fact that the two halves respond to completely different actions, and it is precisely the mix between them that you most want to see moving.

Why the shape matters more than the forecast

The forecast will be wrong. That is fine and expected. What a driver-based model buys you is not accuracy — it is diagnosis. When revenue comes in 12% light, a growth-percentage model tells you revenue was 12% light. A driver model tells you utilization held but the average ticket fell, or that new customers were on plan and churn spiked.

One of those is a number. The other is a decision.

We built a free Excel model for each engine — recurring, capacity, and funnel — each with industry presets and every result as a live formula off your own inputs.

See what a report like this looks like on your own numbers.

Meet your AI CFO →

Prefer to run the numbers yourself? Try the free Recurring Revenue Model — no signup needed.

Keep reading

ToolkitSeptember 7, 2026 · 8 min read

Building next year's operating plan (start now, not in December)

An annual plan built in the last week of December is a wish list. Built in September, it is a decision you have time to act on. Here's the order to build one in, how long each layer takes, and the difference between a plan and a forecast.

Read it →
ToolkitSeptember 3, 2026 · 7 min read

The 10 KPIs worth watching weekly (and the 40 that aren't)

Most dashboards fail because they show everything, which is the same as showing nothing. Here are the ten numbers that earn a weekly look for a small business, why each one is on the list, and the test for whether a metric deserves your attention at all.

Read it →
ToolkitJuly 7, 2026 · 8 min read

SUMIFS: turn a raw QuickBooks export into a P&L with one formula

Export your general ledger and you get a flat list of every transaction — not a report. SUMIFS is the one formula that rolls that list up into a P&L: revenue by month, opex by category, all of it. Here's exactly how, plus the traps that quietly return a wrong number.

Read it →
ToolkitJuly 3, 2026 · 8 min read

Cleaning messy data in Excel: the six functions that do it

Exported data almost never arrives clean — names in three different cases, addresses jammed in one cell, trailing spaces that quietly break your lookups. Here are the six Excel functions that turn a messy paste into data you can actually total, match, and trust.

Read it →
ToolkitJuly 1, 2026 · 7 min read

XLOOKUP vs VLOOKUP vs INDEX/MATCH: which lookup should you use?

The one-line answer is XLOOKUP — but VLOOKUP and INDEX/MATCH still earn their keep, and INDEX MATCH MATCH does something none of the others can. Here's each one, side by side, with the exact moment you'd reach for it.

Read it →
ToolkitJune 26, 2026 · 9 min read

The case of the missing cash: a CFO's afternoon in Excel

A wholesale distributor turns a profit every month and still can't make its credit line breathe. Here's the afternoon a fractional CFO spent cracking it — and the dozen Excel formulas she reached for, what each one does, and exactly when you'd use it.

Read it →
ToolkitJune 26, 2026 · 9 min read

Financial modeling best practices: building a model that doesn't break

Models almost never fail on the math — they fail on structure, trust, and rot. Here are the practices CFOs use to build a model a banker (or your future self) can actually follow and believe.

Read it →
Finance 101September 5, 2026 · 8 min read

Can you service the loan? DSCR and covenants in plain English

Before a bank lends you anything it computes one ratio, and you can compute it yourself in about five minutes. Here's what DSCR is, what number you need, and what the covenants buried in your loan agreement can actually do to you.

Read it →
Finance 101September 1, 2026 · 7 min read

Payroll as a percentage of revenue: what's normal?

Payroll is the largest cost in most small businesses and the one owners are least sure about. Here's how to measure it so the number means something, what the ranges look like by business type, and the two ratios that matter more than the headline percentage.

Read it →