name: Revenue Modeler
slug: revenue-modeler
description: Build revenue projection models with driver-based forecasting, scenario analysis, and pricing optimization
category: finance
complexity: complex
version: "1.0.0"
author: "ID8Labs"
triggers:
- "revenue model"
- "revenue projection"
- "sales forecast"
- "pricing model"
- "revenue growth"
- "MRR forecast"
tags:
- revenue-modeling
- forecasting
- pricing
- saas-metrics
- growth-planning

Revenue Modeler

Expert revenue forecasting agent that builds driver-based revenue models, projects growth scenarios, optimizes pricing strategies, and forecasts subscription metrics. Specializes in SaaS revenue modeling, marketplace economics, and multi-stream revenue forecasting.

This skill applies rigorous revenue modeling methodologies to create defensible projections, stress-test assumptions, and support strategic planning. Perfect for fundraising projections, board reporting, budgeting, and pricing decisions.

Core Workflows

Workflow 1: SaaS Revenue Model

Objective: Build comprehensive SaaS/subscription revenue model

Steps:
1. Current State Analysis
- Current MRR/ARR
- Customer count by segment
- ARPU by segment
- Growth trends (MoM, YoY)
- Cohort retention data

1. Revenue Driver Identification

2. Customer Acquisition:

   • New customer growth rate
   • Lead generation capacity
   • Conversion rates by channel
   • Sales capacity and productivity
   • CAC and payback period

3. Customer Retention:

   • Gross churn rate (customer count)
   • Net revenue retention (NRR)
   • Churn by segment/cohort
   • Contraction rate

4. Expansion:

   • Upsell rate
   • Cross-sell rate
   • Seat expansion
   • Tier upgrades

5. Model Architecture
   ```
   Beginning MRR

6. New MRR (new customers × ARPU)
7. Expansion MRR (existing customer upgrades)
8. Contraction MRR (downgrades)
9. Churned MRR (lost customers)
   = Ending MRR

ARR = MRR × 12
```

1. Cohort-Based Modeling
2. Track each cohort separately
3. Apply cohort-specific retention curves
4. Model degradation over time

5. Account for seasonality

6. Scenario Development

7. Base Case:

   • Current trend continuation
   • Realistic growth assumptions

8. Upside Case:

   • Improved conversion
   • Lower churn
   • Higher expansion

9. Downside Case:

   • Slower acquisition
   • Higher churn
   • Economic headwinds

10. Key Metrics Output

11. MRR/ARR projections by month
12. Customer count projections
13. Net Revenue Retention
14. LTV/CAC ratio evolution
15. Payback period
16. Gross margin projections

Deliverable: Monthly MRR model with 12-36 month projections

Workflow 2: Marketplace Revenue Model

Objective: Build revenue model for marketplace businesses

Steps:
1. Marketplace Metrics Setup
- Supply Side:
- Active sellers/providers
- Listings per seller
- Average order value
- Supply growth rate

• Demand Side:

  • Active buyers
  • Transactions per buyer
  • Buyer frequency
  • Demand growth rate

• Marketplace Metrics:

  • Gross Merchandise Value (GMV)
  • Take rate percentage
  • Net revenue = GMV × Take rate

• GMV Driver Model
  ```
  GMV = Active Buyers × Transactions/Buyer × Average Order Value

OR

GMV = Active Sellers × Listings/Seller × Sell-Through Rate × Price
```

1. Take Rate Analysis
2. Current take rate
3. Take rate by category
4. Take rate optimization potential
5. Competitive benchmarking

6. Additional revenue streams (ads, premium, fulfillment)

7. Liquidity Modeling

8. Match rate projections
9. Supply/demand balance
10. Geographic coverage

11. Category depth

12. Revenue Streams

13. Transaction fees (primary)
14. Subscription fees (seller SaaS)
15. Advertising revenue
16. Fulfillment/logistics fees
17. Premium placement fees
18. Data/analytics fees

Deliverable: Marketplace revenue model with GMV and take rate projections

Workflow 3: Usage-Based Revenue Model

Objective: Model revenue for consumption-based pricing

Steps:
1. Usage Metrics Identification
- Primary usage unit (API calls, storage, compute hours)
- Average usage per customer
- Usage distribution (heavy vs. light users)
- Seasonal patterns

1. Pricing Structure
2. Per-unit pricing tiers
3. Volume discounts
4. Minimum commitments
5. Overage pricing

6. Platform fees

7. Customer Segmentation

8. Segment by usage level
9. Different growth rates by segment
10. Segment-specific retention

11. Enterprise vs. SMB patterns

12. Model Components
    ```
    Revenue = Σ (Customers per segment × Usage per customer × Price per unit)

Account for:
- Customer growth
- Usage growth per customer
- Price changes
- Volume discount impact
```

1. Predictability Enhancement
2. Committed vs. overage revenue
3. Minimum revenue guarantees
4. Prepaid usage credits

5. Annual contract values

6. Scenario Modeling

7. Usage growth scenarios
8. Customer mix changes
9. Pricing optimization
10. Enterprise contract impact

Deliverable: Usage-based revenue model with consumption projections

Workflow 4: Multi-Product Revenue Model

Objective: Model revenue across multiple products and revenue streams

Steps:
1. Product Portfolio Mapping
- Product 1: Type, pricing, target market
- Product 2: Type, pricing, target market
- Product 3: Type, pricing, target market
- Cross-sell relationships

1. Individual Product Models
2. Build sub-model for each product

3. Apply appropriate methodology:

   • Subscription → SaaS model
   • Transaction → Marketplace model
   • Usage → Consumption model
   • One-time → Pipeline model

4. Cross-Sell Modeling

5. Attach rate assumptions
6. Timing of cross-sell
7. Bundle discount impact

8. Cannibalization effects

9. Revenue Mix Analysis

10. Current revenue mix
11. Target revenue mix
12. Mix shift assumptions

13. Profitability by product

14. Consolidation

15. Sum of product revenues
16. Eliminate double-counting
17. Bundle revenue allocation

18. Total company revenue

19. Scenario Development

20. Product-specific scenarios
21. Portfolio-level scenarios
22. New product launch impact
23. Sunset product impact

Deliverable: Consolidated multi-product revenue model

Workflow 5: Pricing Optimization Model

Objective: Analyze and optimize pricing strategy

Steps:
1. Current Pricing Analysis
- Current price points
- Discount frequency and depth
- ARPU analysis
- Price sensitivity observed

1. Competitive Benchmarking
2. Competitor pricing
3. Feature comparison
4. Value-based positioning

5. Market standard pricing

6. Value-Based Pricing Analysis

7. Customer value delivered
8. ROI for customer
9. Willingness to pay research

10. Price anchoring opportunities

11. Price Elasticity Modeling

12. Historical price change impact
13. Segment-specific elasticity
14. Volume vs. price trade-off

15. Revenue optimization point

16. Pricing Scenarios

17. Price increase impact:

    • Revenue gain from price
    • Volume loss from churn
    • Net revenue impact

18. Price decrease impact:

    • Revenue loss from price
    • Volume gain from conversion
    • Net revenue impact

19. Pricing Structure Options

20. Per-seat vs. per-company
21. Usage-based vs. flat
22. Tiered pricing design
23. Freemium conversion

24. Annual discount strategy

25. Implementation Plan

26. Grandfathering strategy
27. Rollout timeline
28. Customer communication
29. Monitoring metrics

Deliverable: Pricing analysis with optimization recommendations

Quick Reference

SaaS Metrics Reference

Core Metrics

MRR Movement Types

SaaS Benchmarks

Revenue Model Template

# Revenue Model: [Company Name]

**Model Period:** [Start] - [End]
**Last Updated:** [Date]

## Model Inputs

### Customer Assumptions
| Metric | Current | Growth Rate |
|--------|---------|-------------|
| Starting Customers | | |
| New Customers/Month | | |
| Churn Rate (Monthly) | | |
| Net Revenue Retention | | |

### Pricing Assumptions
| Segment | ARPU | % of New |
|---------|------|----------|
| Starter | | |
| Professional | | |
| Enterprise | | |
| Weighted Avg | | |

## Revenue Projections

### Monthly MRR Waterfall
| Month | Start MRR | New | Expansion | Contraction | Churn | End MRR |
|-------|-----------|-----|-----------|-------------|-------|---------|
| M1 | | | | | | |
| M2 | | | | | | |
| ... | | | | | | |
| M12 | | | | | | |

### Annual Summary
| Metric | Year 1 | Year 2 | Year 3 |
|--------|--------|--------|--------|
| ARR | | | |
| YoY Growth | | | |
| Customers | | | |
| ARPU | | | |
| NRR | | | |

## Scenario Comparison
| Scenario | Year 1 ARR | Year 2 ARR | Year 3 ARR |
|----------|------------|------------|------------|
| Base | | | |
| Upside | | | |
| Downside | | | |

## Key Assumptions & Risks
1. [Assumption 1] - [Risk if wrong]
2. [Assumption 2] - [Risk if wrong]

Best Practices

Model Building

• Start with driver-based approach
• Document all assumptions
• Make assumptions adjustable
• Build scenario capability
• Test edge cases

Assumption Setting

• Ground in historical data
• Benchmark to industry
• Be realistic, not optimistic
• Explain reasoning
• Sensitivity test key drivers

Presentation

• Executive summary first
• Visualize key trends
• Show assumption sensitivity
• Include scenario comparison
• Highlight risks

Integration with Other Skills

• Use with budget-planner: Link revenue to expense budget
• Use with cash-flow-forecaster: Convert revenue to cash
• Use with unit-economics-calculator: Validate profitability
• Use with financial-analyst: Historical performance analysis
• Use with investment-analyzer: Support fundraising projections

Common Pitfalls to Avoid

• Hockey stick projections: Ground in reality
• Ignoring churn: Even small churn compounds
• Overestimating new customers: Harder than it looks
• Ignoring seasonality: Build in monthly patterns
• Linear assumptions: Growth often S-curve
• Ignoring capacity constraints: Sales, product, support
• Static pricing: Build in price evolution
• No segmentation: Different customers behave differently