Back to Forecasting Guide

Revenue Modeling

Learn how to project revenue accurately for different business models and revenue streams.

The Foundation: Unit Economics

The best way to forecast revenue is from the bottom up, starting with unit economics. This means understanding:

What is a "unit" in your business?

A customer, a product, a transaction, a project, etc.

How many units will you have?

Based on customer acquisition, market size, or capacity

What does each unit generate?

Average revenue per unit over its lifetime

SaaS & Subscription Models

For recurring revenue businesses, focus on these key drivers:

Revenue Formula:

MRR = (New Customers × Avg Price) + Expansion - Churn

New Customer Acquisition

  • • Marketing qualified leads (MQLs)
  • • Conversion rate to paid
  • • Sales cycle length
  • • Acquisition channels

Average Revenue Per User

  • • Pricing tiers
  • • Mix of plans
  • • Usage-based fees
  • • Add-ons and upsells

Expansion Revenue

  • • Upsells to higher tiers
  • • Cross-sells of other products
  • • Volume expansion
  • • Feature add-ons

Churn Rate

  • • Monthly/annual churn %
  • • By customer segment
  • • Reasons for churn
  • • Retention initiatives

Example: SaaS Business

Starting Customers:100
New Customers/Month:20
Monthly Churn Rate:5%
Avg Price:$99/month
Month 1 MRR:100 × $99 = $9,900
Month 2 MRR:(100 - 5 + 20) × $99 = $11,385
Month 3 MRR:(115 - 6 + 20) × $99 = $12,771
Annual Revenue:~$167,000

E-commerce & Retail

For product-based businesses, think about transaction frequency and basket size:

Revenue Formula:

Revenue = Customers × Purchase Frequency × Average Order Value

Key Drivers:

Traffic
  • • Website visitors
  • • Store foot traffic
  • • Marketing channels
Conversion Rate
  • • % visitors who buy
  • • By product category
  • • By traffic source
Repeat Rate
  • • Purchase frequency
  • • Customer lifetime
  • • Loyalty programs

Seasonal Considerations:

Most retail businesses have seasonality. Model monthly variations based on:

  • • Holiday shopping peaks (Q4 typically highest)
  • • Industry-specific patterns (back to school, summer, etc.)
  • • Weather impacts for certain products

Service-Based Businesses

For agencies, consultancies, and professional services:

Revenue Formula:

Revenue = Billable Hours × Hourly Rate × Utilization Rate

Capacity-Based Model:

  • 1.Calculate total available hours (team size × working hours)
  • 2.Apply utilization rate (typically 60-80% for agencies)
  • 3.Multiply by blended hourly rate
  • 4.Factor in ramp time for new hires

Project-Based Alternative:

  • • Average project value
  • • Number of projects per month
  • • Project length and pipeline
  • • Win rate on proposals

Marketplace & Platform Models

For two-sided marketplaces connecting buyers and sellers:

Revenue Formula:

Revenue = GMV (Transaction Volume) × Take Rate

Key Components:

Gross Merchandise Value (GMV)

Total value of transactions on your platform

= Active buyers × Purchase frequency × Average transaction size

Take Rate

Percentage you keep from each transaction

Varies widely: 3-5% (payments) to 20-30% (premium marketplaces)

Network Effects:

Marketplaces get more valuable as they grow. Model this with:

  • • Supply growth (sellers/service providers)
  • • Demand growth (buyers/users)
  • • Liquidity (match rate between supply and demand)
  • • Repeat transaction rate

Common Mistakes in Revenue Forecasting

Hockey Stick Projections

Sudden exponential growth without explanation. Be realistic about growth rates and show how you'll achieve them.

Ignoring Customer Acquisition Cost

Revenue growth costs money. Factor in marketing and sales expenses needed to hit your targets.

No Churn or Seasonality

All businesses lose customers and most have seasonal patterns. Ignoring this makes forecasts unrealistic.

Too Many Revenue Streams at Once

Focus on your core revenue model first. Adding multiple untested streams makes the forecast less credible.

Pro Tip: Cohort Analysis

For subscription and repeat-purchase businesses, build cohorts to understand customer behavior:

  • • Group customers by acquisition month
  • • Track retention and revenue over time
  • • Calculate lifetime value (LTV) by cohort
  • • Identify trends in cohort performance

This gives you a realistic view of how customer value evolves and helps you forecast future cohorts more accurately.

Model Your Revenue with Confidence

Formulate helps you build bottom-up revenue models for any business type

Start Free Trial