Quantitative Growth Model: The Spreadsheet That Runs Your Business

Why it exists

A growth model exists to move beyond vague strategies and answer the question "How does our business grow?" with numbers. It provides a structured, data-driven way to align teams, prioritize work, and forecast the impact of decisions instead of relying on intuition alone.

The mental model

Think of it as a financial model, but for user growth. It's a spreadsheet or application where every key business driver—from ad clicks to user signups to churn rate—is a variable. By changing one input variable, like marketing spend, you can see the ripple effect across the entire system, allowing you to simulate different future scenarios.

How it works

A quantitative model is built using mathematical formulas that represent the relationships between different parts of your business. It starts with inputs (e.g., monthly marketing budget) and applies a series of assumptions based on historical data (e.g., conversion rates, churn rates) to calculate outputs (e.g., new customers, revenue). These models can be linear, like a simple acquisition-to-conversion funnel, or non-linear, incorporating feedback loops where outputs from one cycle (like new users inviting friends) become inputs for the next, creating compounding growth.

When to use it

Use a quantitative model to forecast future growth under different scenarios, which helps in setting realistic goals. It's crucial for prioritizing resources; you can simulate whether investing an extra $10k in acquisition or retention will yield a better return. It also aligns the entire company by creating a single source of truth for how growth happens.

When not to use it

Avoid building a complex quantitative model when you have no historical data or stable conversion rates; start with a simpler, visual model first. Do not treat the model as a rigid prediction of the future. It's a tool for understanding relationships and testing hypotheses, not a crystal ball. Its outputs are only as reliable as the input data and assumptions.

One canonical example

A SaaS company builds a spreadsheet model. One column represents new trial signups, driven by paid ad spend and an assumed cost-per-signup. The next column calculates new paying customers by multiplying signups by the trial-to-paid conversion rate (e.g., 10%). Another column calculates monthly revenue by multiplying total customers by the average revenue per user. Finally, a churn column subtracts lost customers based on a historical churn rate (e.g., 3%). By changing the ad spend or the conversion rate, the team can immediately see the projected impact on end-of-year revenue.