SaaS operating model
Sales capacity, ARR roll-forward, billings, unit economics. Build a subscription business from sales capacity to ARR to a quarterly P&L, reconcile cash to revenue through deferred revenue, and read the unit economics an investor will ask for.
By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.
On this subject: saas operating model.Updated 30 September 2026
Who builds it, and for whatThe operating plan a software company runs on and the model a growth investor, a software equity analyst or a corporate development team rebuilds to test it: whether the sales force can close the ARR the plan needs, what retention does to the base, when the cash arrives against the revenue, and whether a customer pays back what it cost to win. The corporate three-statement frame does not carry over, and the model is built from the objects that do.
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Assumptions | ||||||||||||||
| 2 | Blue cells only. $ millions; quarters Y1Q1 to Y3Q4. The company is invented. | ||||||||||||||
| 4 | Quarter | Unit | Y1Q1 | Y1Q2 | Y1Q3 | Y1Q4 | Y2Q1 | Y2Q2 | Y2Q3 | Y2Q4 | Y3Q1 | Y3Q2 | Y3Q3 | Y3Q4 | |
| 5 | Opening position | ||||||||||||||
| 6 | Annual recurring revenue at the start | $m | 24.0 | ||||||||||||
| 7 | Customers at the start | # | 300 | ||||||||||||
| 8 | Deferred revenue at the start | $m | 9.0 | ||||||||||||
| 9 | Productive account executives at the start | # | 8 | ||||||||||||
| 11 | Sales capacity | ||||||||||||||
| 12 | Account executives hired in the quarter | # | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 5 | 6 | |
| 13 | Quarters to ramp (a new hire is productive from the quarter after) | # | 2 | ||||||||||||
| 14 | Productivity while ramping, share of full | % | 50.0% | ||||||||||||
| 15 | Annual new-ARR quota per productive rep | $m | 1.2 | ||||||||||||
| 16 | Quota attainment | % | 80.0% | ||||||||||||
| 17 | Rep attrition per quarter, share of productive reps | % | 5.0% | ||||||||||||
| 18 | Average new contract value (annual) | $m | 0.06 | ||||||||||||
| 20 | Retention and expansion | ||||||||||||||
| 21 | Gross ARR churn per quarter, share of opening ARR | % | 3.0% | ||||||||||||
| 22 | Expansion per quarter, share of opening ARR | % | 4.5% | ||||||||||||
| 23 | Customer (logo) churn per quarter | % | 2.5% | ||||||||||||
| 25 | Billing and costs | ||||||||||||||
| 26 | Share of new and renewed contracts billed annually in advance | % | 70.0% | ||||||||||||
| 27 | Cost of revenue, % of revenue (hosting, support, success) | % | 22.0% | ||||||||||||
| 28 | Fully loaded cost per account executive, per quarter | $m | 0.08 | ||||||||||||
| 29 | Marketing and sales support, % of new ARR booked | % | 35.0% | ||||||||||||
| 30 | Research and development, % of revenue | % | 28.0% | ||||||||||||
| 31 | General and administrative, % of revenue | % | 14.0% | ||||||||||||
| 32 | Lifetime value horizon: quarters of margin counted | # | 20 |
Click any cell. The inspector names the line, the schedule it belongs to and what kind of cell it is; blue on cream is an input, black a calculation, green a value from another sheet. Scroll sideways to see every year.
Download
SaaS operating model: the workbook
Native Excel, formulas live, no macros, no external links. Inspect it above first; the file is the same model with the formulas in it.
A free account chooses one worked model to keep, and downloads every starter workbook. L3VLUP Pro ($25/month) opens the whole library. Signing in takes one email and no password.
What the base case says
- Closing ARR, end of Year 3
- $90.9m
- ARR growth, Year 3 on Year 2
- 61.5%
- Net revenue retention, last four quarters
- 107.3%
- CAC payback (months), last quarter
- 11.13
- LTV to CAC, last quarter
- 5.4x
- Operating margin, last quarter
- 5.8%
- Rule of 40, last quarter
- 67.3%
Read from the workbook as served, every input at its default. Periods: Y1Q1, Y1Q2, Y1Q3, Y1Q4, Y2Q1, Y2Q2, Y2Q3, Y2Q4, Y3Q1, Y3Q2, Y3Q3, Y3Q4. The figures are invented and move with whatever you type in.
What this model is
A subscription business over three years by quarter, built from its own objects: a sales force whose capacity sets new ARR, an ARR roll-forward with expansion and churn, billings ahead of revenue through deferred revenue, and a P&L whose sales and marketing line is the team and the spend that fed it.
Unit economics read from the same lines: customer acquisition cost, payback in months of gross margin, lifetime value against CAC, net and gross revenue retention, the magic number and the burn multiple.
Every quarter closes to the next quarter’s opening, deferred revenue reconciles cash to revenue, and the checks hold the retention identities.
Seats: Product and technology, Venture capital, Equity research and hedge funds.
How the schedules connect
Every row in the workbook is tagged with the schedule it belongs to; the inspector above shows the tag when you click a row. These are the schedules this model is made of and where each one lives.
Sales capacity
Reps, ramp, quota: the new ARR a team can close
Assumptions, rows 12–18 · Sales Capacity, rows 6–11 · Sales Capacity, rows 14–18
ARR roll-forward
Opening, new, expansion, churn, closing
Assumptions, rows 6–9 · Assumptions, rows 21–23 · ARR Build, rows 6–14 · ARR Build, rows 17–21
Bookings, billings and deferred revenue
Cash before revenue, and the balance in between
Assumptions, rows 26–32 · Bookings & Billings, row 6 · Bookings & Billings, rows 9–13 · Bookings & Billings, rows 16–21
SaaS profit and loss
Gross margin, sales and marketing, R&D, G&A, cash
P&L, rows 6–16 · P&L, rows 19–21
Unit economics
CAC, payback, LTV, retention, magic number, burn multiple
Unit Economics, rows 6–12 · Unit Economics, rows 15–19
What you should be able to explain
- Why ARR is a stock moved by flows, and why growth is a sales capacity before it is a rate.
- How ramp, attrition and attainment turn a hiring plan into the new ARR it can actually produce.
- Why billings run ahead of revenue, what deferred revenue is, and why a SaaS company can burn less cash than its P&L suggests.
- How CAC, payback, lifetime value, net and gross retention and the magic number are read from the same lines rather than asserted.
- What the rule of 40 and the burn multiple summarise, and what they hide.
What a reviewer looks for
- Revenue grown at a rate with no sales capacity behind it.
- Churn and expansion applied to closing ARR, or expansion netted into churn so gross retention disappears.
- Revenue recognised when billed, which overstates the quarter a big annual contract lands.
- A lifetime value computed as margin over churn with a 1% churn rate, which produces a customer that lives a hundred years.
- Unit economics typed in from a board deck rather than read from the model.
Conventions this workbook uses
Stated on the cover sheet too. A model is only as trustworthy as the decisions it tells you it made.
- Quarterly periods, because sales capacity, hiring and retention are managed by the quarter and a year hides the ramp.
- New ARR is what the sales force can close: productive reps at a quarterly quota times attainment, ramping reps at half productivity, hires productive from the third quarter after they join, and attrition on the productive base. It is a capacity, not a growth rate.
- ARR is a stock moved by new, expansion and churn on the opening balance. Revenue is the average ARR through the quarter earned over four quarters.
- Billings are the share of new, expansion and renewing contracts billed annually in advance plus the rest of the book billed quarterly; deferred revenue is billings not yet earned, and the operating cash line is profit plus its build.
- Lifetime value counts gross margin per customer over the shorter of a fixed horizon and the average life implied by logo churn, so a low churn rate cannot produce an infinite customer.
Build it yourself
The starter workbook
The ARR Build sheet has been cleared: the roll-forward from opening ARR through new, expansion and churn to closing, the growth lines and the customer count. Build it from the Sales Capacity sheet and the retention assumptions so that revenue, billings, the P&L and the unit economics come back to life. The Checks sheet tells you when ARR rolls in every quarter.
Blanks: ARR roll-forward. Free with any account. Compare with the worked model when you are done: download above.
The path around this model
Understand it, drill it, read the build, then apply it to a real company.
Build · Lab · ~12 min
Unit Economics
Build an LTV:CAC you could defend under questioning, and answer payback as its own question.
Build · Lab · ~12 min
Product Metrics Tree
Name the right north star for a product shape, and the guardrail your change would break.
Read · Guide · 11 min
SaaS Operating Models: ARR, Sales Capacity, Billings and the Metrics That Follow
Read · Guide · 13 min
How to Build a Three-Statement Model That Actually Balances
Apply · Skill
Model Audit
Find the errors in a financial model before someone senior does.
Apply · Skill
Company Profile
Build a banker-grade one-pager on any company, fast.
Vocabulary: ARR (Annual Recurring Revenue), Net Revenue Retention (NRR), CAC Payback, LTV to CAC, Deferred Revenue, Magic Number.
Questions about this model
Why is new ARR driven by sales capacity and not by a growth target?
Because the target is not what happens; the team is. Productive reps at a quarterly quota times attainment, ramping reps at half productivity and attrition on the base give the new ARR the company can close, and a plan that needs more has to hire earlier or sell more per rep. Building it this way turns a growth rate into a hiring plan someone can be held to.
What is the difference between bookings, billings and revenue?
Bookings are the value of contracts signed. Billings are the invoices raised, which for the share of contracts billed annually in advance arrive up to a year before the service. Revenue is the service delivered, earned evenly through the term. The gap between billings and revenue sits on the balance sheet as deferred revenue, and its build is why a growing SaaS company’s cash can be better than its profit.
How is lifetime value computed here?
Gross margin per customer per quarter, counted over the shorter of a fixed horizon and the average customer life implied by logo churn. The horizon is the guard: dividing margin by a very low churn rate produces a customer that lives for decades, and no investor believes that number.
What does the magic number tell you that CAC payback does not?
Payback is per customer; the magic number is for the whole go-to-market engine: net new ARR in the quarter over the sales and marketing spent the quarter before. Above about 0.75 the engine is efficient enough to feed; below about 0.5 the company should fix sales before it hires more. They usually agree, and when they do not the difference is retention.
What does it cost?
Nothing to inspect: the whole workbook is on this page. A free account chooses one worked model to keep, and downloads every starter workbook. L3VLUP Pro ($25/month) downloads the whole library and opens every model’s formulas in the inspector.