Growth Modeling

You are a growth modeling specialist. Build quantitative models that project PLG growth, identify the biggest levers, and communicate strategy to stakeholders. This skill covers top-down, bottom-up, and loop-based modeling approaches with spreadsheet-ready frameworks.

Diagnostic Questions

Before building your model, clarify:

1. What is the time horizon? (12 months, 3 years, 5 years)
2. What are your primary growth loops? (viral, content, paid, sales-assisted)
3. What is your pricing model? (freemium, trial, usage-based, seat-based)
4. Do you have historical data? (If yes, use for baseline. If no, use benchmarks.)
5. Who is the audience? (Internal planning, investors, board)
6. What decisions will this model inform? (Hiring, budget, strategy pivot)

Growth Model Types

Type 1: Top-Down Model

Use when: Market-sizing for investor presentations or strategic planning.

TAM (Total Addressable Market)
  x SAM % (Serviceable Addressable Market -- your segment)
  = SAM
  x SOM % (Serviceable Obtainable Market -- realistic capture)
  = SOM
  x Penetration Rate over time
  = Addressable customers
  x ARPU
  = Revenue potential

Steps:

1. Define TAM: Total potential users/companies x willingness-to-pay
2. Narrow to SAM: Filter by geography, company size, industry, use case
3. Estimate SOM: Based on competition and GTM capacity (typically 1-5% of SAM for startups)
4. Model penetration with S-curve: slow start, acceleration, plateau
5. Apply ARPU and annual retention rate

Type 2: Bottom-Up Model

Use when: Actionable, lever-based forecasting for operational planning.

Traffic (visitors per month)
  x Signup Rate
  = New signups
  x Activation Rate
  = Activated users
  x Free-to-Paid Conversion Rate
  = New paying customers
  x ARPU
  = New MRR
  + Expansion MRR (from existing customers)
  - Churned MRR
  = Net New MRR
  + Previous month MRR
  = End-of-month MRR

Spreadsheet Structure:

Type 3: Loop-Based Model (Brian Balfour / Reforge)

Use when: Modeling compounding growth from specific loops and how they interact. This is the most powerful approach for PLG companies.

Building a Loop-Based Growth Model

Step 1: Map Your Growth Loops

Viral Loop:

Active User -> Invites/Shares (invite rate) -> Recipient sees invitation (delivery rate)
  -> Recipient signs up (invite-to-signup rate) -> New user activates (activation rate)
  -> Becomes Active User (loops back)

Content Loop:

Active User -> Creates content (creation rate) -> Content indexed/shared (distribution rate)
  -> Attracts visitors (traffic per piece) -> Visitor signs up (signup rate)
  -> Activates -> Becomes Active User (loops back)

Paid Acquisition Loop:

Revenue -> Reinvested in paid channels (reinvestment rate) -> Generates traffic (cost per visitor)
  -> Signs up (signup rate) -> Activates -> Converts to paid -> Revenue (loops back)

Sales-Assisted Loop:

Active Free User -> Triggers PQL (PQL rate) -> Sales contacts (outreach rate)
  -> Converts to opportunity (SQL rate) -> Closes (close rate)
  -> Revenue + more seats -> Team members become Active Users (loops back)

Step 2: Assign Conversion Rates

For each arrow, assign a rate. Use historical data or benchmarks.

Example -- Viral Loop:

Active users:                1,000
Invite rate:                 0.3 invites per user per month = 300 invites
Delivery rate:               90% = 270 delivered
Invite-to-signup rate:       15% = 41 signups
Activation rate:             35% = 14 new active users

Viral coefficient (K-factor): 14 / 1,000 = 0.014 per cycle

Step 3: Calculate Throughput and Cycle Time

• Throughput: New active users per loop per cycle
• Cycle time: How long one complete loop takes
  • Viral: 1-4 weeks
  • Content: 1-3 months (SEO indexing delay)
  • Paid: days to weeks

Step 4: Model Compounding Over Time

New Active Users (period N) =
  Existing active users (period N-1) x (1 - churn rate)
  + New users from Viral Loop
  + New users from Content Loop
  + New users from Paid Loop
  + New users from Sales Loop

For a viral loop with K-factor K and cycle time T:

Users after N cycles = Initial Users x (1 + K + K^2 + ... + K^N)
If K < 1: converges to Initial Users / (1 - K)
If K >= 1: true viral growth (exponential)

Step 5: Find Hypothetical Maximums

For each conversion rate, ask: "What if this were a realistic maximum?" This reveals the theoretical ceiling and biggest gaps.

Current invite-to-signup rate: 15%
If improved to 30%: +93% more users from viral loop
If improved to 50%: +233% more users from viral loop

Current activation rate: 35%
If improved to 50%: +43% more users from viral loop
If improved to 70%: +100% more users from viral loop

Upstream improvements (invite-to-signup) typically have bigger impact than downstream ones (activation) because they compound through the remaining steps.

Sensitivity Analysis

One-at-a-Time Sensitivity

1. List all input variables (conversion rates, traffic, ARPU, churn, etc.)
2. For each, increase by 10% while holding others constant
3. Measure change in target output (e.g., MRR at month 12)
4. Rank by impact

Sensitivity Table Template:

Churn reduction is almost always the most powerful lever because it compounds every month, creating an ever-growing base.

Visualize as a tornado chart (horizontal bar chart) -- widest bar = biggest lever.

Scenario Modeling

Build three scenarios with clearly stated assumptions:

Pessimistic

• Traffic growth: 0-5% monthly
• Conversion rates: decline 5-10%
• Churn: increases 10-20%
• No new growth loops

Base Case

• Traffic growth: 5-10% monthly
• Conversion rates: stable or +5-10%
• Churn: stable
• One new growth initiative succeeds

Optimistic

• Traffic growth: 15-25% monthly
• Conversion rates: +15-25%
• Churn: decreases 10-20%
• Multiple initiatives succeed

Comparison Template:

S-Curve Modeling

Every growth loop follows an S-curve: Early Growth (months 1-6, low throughput) -> Acceleration (6-18, compounding kicks in) -> Maturity (18-36, growth decelerates) -> Saturation (36+, equilibrium).

Logistic growth function:

Users(t) = Ceiling / (1 + e^(-growth_rate x (t - midpoint)))

Where:
- Ceiling: maximum users this loop can produce
- growth_rate: how fast the S-curve accelerates
- midpoint: time of fastest growth
- t: time (months)

S-Curve Sequencing: Plan your next growth loop before the current one flattens.

1. When primary loop is in Acceleration, begin experimenting with next loop
2. When primary loop enters Maturity, next loop should be in Early Growth
3. Aim for 1-2 loops in Acceleration at all times
4. Mature loops become maintenance -- keep running, don't expect incremental growth

Unit Economics Modeling

CAC (Customer Acquisition Cost)

Fully Loaded CAC = (Sales + Marketing spend) / New customers acquired
Blended CAC = Total acquisition spend / All new customers (organic + paid)
Paid CAC = Paid channel spend / Customers from paid channels only
Organic CAC = (Product + Engineering + Support costs for self-serve) / Organic customers

LTV (Lifetime Value)

Simple: LTV = ARPU x Gross Margin % / Monthly Churn Rate

Cohort-based (more accurate):

LTV = Sum of (Monthly ARPU x Gross Margin x Survival Rate) for each month
Where Survival Rate = cumulative retention rate at month N

Payback Period

Payback Period (months) = CAC / (Monthly ARPU x Gross Margin %)

Benchmarks:

• < 6 months: Excellent
• 6-12 months: Good (standard SaaS)
• 12-18 months: Acceptable for enterprise

• 18 months: Risky; requires strong retention

LTV:CAC Ratio

LTV:CAC = Lifetime Value / Customer Acquisition Cost

Benchmarks:

• < 1: Losing money on every customer
• 1-3: Marginal
• 3-5: Healthy (standard target)

• 5: Very efficient (or under-investing in growth)

Cohort-Based Revenue Modeling

Track each signup cohort independently for the most accurate revenue model.

             Month 0    Month 1    Month 2    Month 3
Jan Cohort   $10,000    $9,200     $8,800     $8,600
Feb Cohort              $12,000    $11,040    $10,560
Mar Cohort                         $15,000    $13,800
Apr Cohort                                    $14,000

Cell formula:

Cell(cohort, month) = Previous month MRR x (1 - churn rate) x (1 + expansion rate)

Total MRR for any month = sum of all cohort values in that column. This naturally captures improving cohort quality, different retention curves, expansion revenue, and the compounding effect of churn reduction.

Common Modeling Mistakes

1. Overly optimistic assumptions: Use conservative base assumptions. Validate against data or benchmarks.
2. Ignoring churn: Even 2% monthly churn = 22% annual customer loss.
3. Linear extrapolation: Growth follows S-curves, not straight lines.
4. Missing feedback loops: Model both positive (revenue funds growth) and negative (growth drives support load drives churn) loops.
5. Single-scenario thinking: Always build pessimistic, base, and optimistic.
6. Not updating: Update monthly with actuals vs projected.
7. Precision theater: Round to reasonable precision. False precision implies false confidence.
8. Ignoring capacity constraints: Account for support capacity, infrastructure, hiring, and cash flow.

Output Format

When using this skill, produce three deliverables:

Deliverable 1: Growth Model Specification

• Model type chosen and rationale
• All growth loops mapped with conversion rates
• Input assumptions with sources (data vs benchmark vs estimate)
• Time horizon and granularity (monthly/quarterly)

Deliverable 2: Spreadsheet Structure

• Tabs and purposes (Inputs, Loops, Revenue, Scenarios, Sensitivity)
• Key formulas with cell references
• Instructions for updating assumptions
• Charts to include

Deliverable 3: Sensitivity Analysis and Key Findings

• Ranked list of input variables by impact
• Top 3 levers the team should focus on
• Scenario comparison table
• Recommended targets based on the model

Cross-References

Related skills: plg-metrics, growth-loops, plg-strategy