Chapter 9 of 12

Detailed Methodology: Executing the Feasibility Tools

Step-by-step guide to running simulations and audits.

PivotBuddy

Unlock This Playbook

Create a free account to access execution playbooks

9 Comprehensive Playbooks
Access to Free-Tier AI Tools
Save Progress & Bookmarks
Create Free Account
Read Aloud AI
Ready
What You'll Learn By the end of this chapter, you'll have step-by-step methods for revenue modeling, cost forecasting, unit economics calculation, and technical feasibility assessment -- with worked examples and practitioner-tested frameworks you can apply immediately.

Deep Dive: Revenue Model Simulation

The Revenue Simulator is your sandbox for testing how you'll make money -- and what could go wrong before a single dollar changes hands.

Revenue modeling is where founders most frequently fall into the "Excel Fantasy" trap described in Chapter 2. The antidote is driver-based modeling: building your projections from the bottom up, starting with the specific inputs you can measure and control, rather than top-down assumptions about market capture. As David Skok of Matrix Partners has emphasized, the best SaaS financial models are "bottoms-up" -- they start with individual customer acquisition channels and conversion rates, not with total addressable market percentages.

The methodology here draws on the work of Ash Maurya (Running Lean), who advocates for treating financial projections as hypotheses to be tested, not forecasts to be believed. Your revenue model is a living document. It should change every time you get new data from a pricing experiment, a customer interview, or a marketing test. If your model hasn't been updated in the last 30 days, it's already stale.

Inputs and Drivers

Good models need the right inputs. The quality of your projections is entirely determined by the quality of your assumptions. Each input below should have a source -- either a benchmark from your industry, a data point from your validation experiments, or an explicit assumption marked as "to be tested." If you cannot source an input, that's a signal you need to run an experiment before proceeding.

Traffic & Awareness

  • Organic search traffic: Estimate using keyword research tools (Ahrefs, SEMrush). Target keywords with clear purchase intent. Typical organic growth: 10-20% month-over-month in the first year if you're investing in content.
  • Paid ad clicks: Start with a $500-1,000 test budget. Measure cost per click (CPC) and click-through rate (CTR). B2B SaaS CPCs typically range from $2-15 depending on industry competitiveness.
  • Word-of-mouth / referral growth: The most underestimated channel. Benchmark: viral coefficient of 0.1-0.3 for most SaaS products (each user brings 0.1-0.3 new users). Products with inherent virality (collaboration tools, shared documents) can achieve 0.5+.
  • Content and social reach: Blog posts, LinkedIn articles, YouTube videos. Measure impressions, clicks, and email captures. Content typically takes 3-6 months to generate meaningful organic traffic.
  • Partnership and channel traffic: Integrations, marketplace listings, co-marketing. Often overlooked but can provide high-intent traffic at low cost once established.

Conversion Rates

  • Visitor to lead %: Aim for 2-5% for B2B SaaS landing pages. Below 2% suggests messaging or targeting problems. Above 5% suggests strong product-market fit or very well-targeted traffic.
  • Lead to free trial/signup %: Depends heavily on friction. One-click signup: 20-40%. Credit card required: 5-10%. Demo required: 10-20% after the demo.
  • Free to paid conversion %: Industry benchmarks: Freemium models 2-5%, Free trial with CC 40-60%, Free trial without CC 10-25%. Use the Smoke Test tool to validate these rates early.
  • Trial to paid conversion rate: Track by cohort. The conversion rate of your first 100 users is not predictive of your next 1,000 -- early adopters convert at higher rates than later prospects.
  • Expansion conversion rate: What percentage of customers upgrade to a higher tier or add features? Strong products see 10-20% of users upgrading within the first 6 months.

Revenue Drivers

  • Average Revenue Per User (ARPU): Your blended average across all tiers. Calculate separately for each plan, then weight by expected distribution. New products often see 70% on the lowest tier, 25% on mid-tier, and 5% on the highest tier.
  • Average order size / contract value: For transactional or enterprise models. Track median and mean separately -- a few large deals can skew the average significantly.
  • Upsell revenue %: The percentage of customers who purchase add-ons or upgrade. Benchmark: 15-25% of revenue should come from expansion in a healthy SaaS business.
  • Cross-sell rates: Adjacent product purchases. More relevant for multi-product companies, but plan for this in your revenue architecture from day one.
  • Annual contract premium: Most SaaS companies offer 15-20% discount for annual billing, which improves cash flow even at a lower effective monthly rate.

Retention & Churn

  • Monthly logo churn rate: The percentage of customers who cancel. SMB SaaS: 3-7% monthly. Enterprise SaaS: 0.5-2% monthly. Consumer subscriptions: 5-10% monthly. Even small improvements here have massive LTV impact.
  • Revenue churn rate: Often different from logo churn if larger customers churn at different rates than smaller ones. Track both.
  • Win-back rate: Percentage of churned customers who return. Typically 5-15% with a strong win-back campaign. Factor this into your retention model.
  • Net revenue retention (NRR): Revenue from existing cohort after churn, downgrades, and expansion. Target: >100% (meaning expansion exceeds churn). Elite SaaS: 120-140%.
  • Cohort degradation curve: How revenue changes over time within a cohort. Plot monthly revenue for each signup cohort to see whether customers become more or less valuable over time.

Building the Revenue Funnel Model

The most reliable revenue model is a funnel model that traces the journey from first touch to paying customer. Here's the methodology, step by step:

The Revenue Funnel Formula

Monthly Revenue = Traffic x Conversion Rate x ARPU x (1 - Churn)^months

But this simplified formula hides complexity. In practice, you need to model each acquisition channel separately, because they have different traffic volumes, conversion rates, and customer quality. A customer acquired through organic search often has lower churn than one acquired through paid ads, because they found you through genuine need rather than an advertisement's persuasion.

Hybrid Revenue Modeling

If you charge subscriptions plus usage (the "hybrid" model discussed in Chapter 3), you need to track both components separately. This is increasingly important as more SaaS companies add usage-based pricing layers. The challenge is that usage revenue is inherently less predictable than subscription revenue, which makes forecasting harder -- but the upside is that usage revenue scales with customer success, creating natural alignment.

Recurring Revenue (Predictable)

Paying Users x Monthly Price = Subscription MRR

This is your baseline. It covers your fixed costs and provides revenue predictability. Model this with conservative growth assumptions -- new customers minus churned customers each month.

Usage Revenue (Variable)

Active Users x Avg Usage x Price per Unit = Usage MRR

This is your upside. Model three scenarios for average usage: light (25th percentile), median, and heavy (75th percentile). Use the median for your base case. Track real usage data from your prototype or beta to calibrate these estimates.

What-If Analysis: Stress-Testing Your Revenue Model

A revenue model is only as useful as the scenarios you run against it. The goal isn't to predict the future -- it's to understand which variables your business is most sensitive to. Run these specific scenarios and document the results:

Scenario What Changes What to Look For
Price Elasticity Raise prices 20%, reduce by 20% How much can conversion drop before revenue is flat? If a 20% price increase only reduces conversions by 10%, raising prices is obviously the right call.
Churn Sensitivity Churn rises from 3% to 5% monthly What happens to cumulative revenue and cash flow over 24 months? This scenario tests whether your model survives a product-market fit wobble.
CAC Escalation Ad costs double (or triple) Can you still acquire customers profitably? If paid channels become unprofitable, do you have organic or referral channels to fall back on?
Delayed Revenue First revenue arrives 3 months late Does your runway survive the delay? Many startups underestimate the time from "product ready" to "first paying customer."
Competitor Response A competitor cuts prices 30% Does your model work at a 30% lower price point? If not, your competitive moat may not be deep enough.

Use the Financial Model tool to run these scenarios automatically. The tool includes built-in sensitivity analysis that shows you which variables have the largest impact on your bottom line.

Deep Dive: Cost Structure Forecasting

AI Cost Modeling Methodology

For AI-native products, cost modeling requires a fundamentally different approach than traditional SaaS. Your cost of goods sold (COGS) is not just hosting and bandwidth -- it includes inference costs that can vary 100x depending on query complexity. Here's the step-by-step methodology for accurately forecasting AI costs:

Cost Per AI Interaction Formula

Cost = (Input Tokens x Input Price) + (Output Tokens x Output Price) + (Embedding Retrieval Cost) + (Post-Processing Cost)

Each component needs separate tracking and optimization:

Input Token Optimization

Your system prompt is the biggest controllable cost driver. A 2,000-token system prompt adds $0.006-0.03 per request at standard model pricing. At 10,000 requests per day, that's $60-300/day just for the system prompt. Techniques to reduce this:

  • Prompt compression: Rewrite your system prompt to be concise without losing instructions. Often you can cut 30-50% without quality degradation.
  • Prompt caching: Use providers that support prompt caching (Anthropic, OpenAI) to reduce repeated system prompt costs by up to 90%.
  • Dynamic prompts: Only include the instructions relevant to the current interaction, rather than loading every possible instruction every time.

RAG Cost Optimization

Retrieval-Augmented Generation adds embedding costs and vector database charges. The methodology for optimizing:

  • Chunk size tuning: Smaller chunks (200-500 tokens) give more precise retrieval but require more chunks per query. Larger chunks (500-1,500 tokens) reduce retrieval costs but may inject irrelevant context. Test both and measure quality vs. cost.
  • Retrieval limits: Retrieving 10 chunks when 3 would suffice wastes tokens and money. Measure the marginal quality improvement of each additional chunk.
  • Tiered storage: Keep frequently accessed content in hot storage, archive older content to cold storage. Most vector databases charge based on active data volume.

Practitioner tip: Log every AI interaction's token count and cost during your prototype phase. After 1,000 interactions, you'll have real data to build your cost model on -- far more reliable than estimates. Use the MVP Cost Forecaster tool to input these real numbers and project costs at scale.

The Step-Function Cost Methodology

As discussed in Chapter 4, costs don't scale linearly -- they jump at thresholds. The methodology for identifying and planning for these jumps:

  1. Map your capacity thresholds. For each operational area (engineering, support, infrastructure, compliance), identify the customer count at which you'll need to step up. Example: "At 200 active customers, we need a second support person."
  2. Calculate the cost of each step. Each threshold has a fixed cost increase. A new hire adds $120K-200K in fully loaded annual cost. A database upgrade might add $500-2,000/month. SOC2 certification is $20K-50K one-time plus $10K-25K annual renewal.
  3. Plot the step function. Create a chart showing total monthly costs at 0, 100, 250, 500, 1,000, and 5,000 customers. This reveals the "danger zones" where a small increase in customers triggers a large increase in costs.
  4. Build triggers into your model. Your financial projection should automatically increase costs when customer count crosses each threshold. This prevents the "everything is fine until it suddenly isn't" problem.

Deep Dive: Unit Economics Methodology

Customer Acquisition Cost: The Paid CAC Method

The most reliable CAC methodology uses Paid CAC -- the cost of customers acquired through paid channels only. Here's why and how:

Blended CAC (total marketing spend / total new customers) is misleading because it includes organic and referral customers who cost nearly nothing to acquire. When you want to model growth, you need to know the cost of the marginal customer -- the next one you'll acquire by spending more money. That's your paid CAC.

CAC Component What to Include Common Mistake
Direct Spend Ad spend, content creation costs, event sponsorships Only counting ad spend and forgetting content, design, and event costs
People Costs Sales team salaries, marketing team salaries, founder time on sales Excluding founder time ("I don't pay myself"). Your time has opportunity cost.
Tool Costs CRM (HubSpot), email (Mailchimp), analytics, A/B testing tools Forgetting the $500-2,000/month in marketing SaaS subscriptions
Overhead Allocation Portion of office/remote costs, management time Treating marketing as having zero overhead

Customer Lifetime Value: The Cohort Method

The most accurate LTV calculation uses cohort analysis -- tracking actual revenue from groups of customers who signed up in the same month. Here's the methodology:

  1. Define your cohorts. Group customers by signup month (e.g., "January 2026 cohort," "February 2026 cohort").
  2. Track monthly revenue per cohort. For each cohort, measure total revenue in month 1, month 2, month 3, etc. This gives you a retention curve showing how revenue decays over time.
  3. Calculate cumulative revenue per customer. Divide total cohort revenue at each month by the number of customers in the original cohort. This shows you how much revenue a typical customer generates over time.
  4. Apply a time cap. Cap your LTV calculation at 36 months for early-stage projections. Beyond 36 months, too many variables change (pricing, product, market) to make reliable predictions.
  5. Subtract COGS. Remember: LTV is gross profit, not revenue. Subtract your per-customer cost of goods sold from the cohort revenue to get true LTV.
The Cohort Insight

If your cohorts show improving retention over time (newer cohorts retain better than older ones), that's strong evidence of product improvement and increasing product-market fit. If cohorts are degrading (newer cohorts retain worse), you may be exhausting your early adopter pool and reaching customers who are a weaker fit. Use the CAC/LTV Model tool to track and visualize your cohort data.

Deep Dive: Technical Feasibility Assessment

The Technical Smoke Test Battery

Before committing to a full build, run these concrete technical tests. Each test is designed to surface a specific category of risk. The methodology draws on the "Spike" concept from Agile development -- short, time-boxed investigations designed to reduce uncertainty about technical feasibility.

Test What to Check How to Run It Red Flag
API Dependency Test Can your critical dependencies handle your projected load? Send 100 concurrent requests to each critical API. Measure response times and error rates. Rate limits that can't be raised, >2s response times, >1% error rates
AI Quality Test Does the AI produce acceptable output quality? Create 50 representative test cases. Run them through your prompt chain. Have domain experts rate quality on a 1-5 scale. Average quality below 3.5/5, or any critical failures (harmful/incorrect outputs)
Latency Test Does the end-to-end interaction take an acceptable amount of time? Measure p50 and p95 latency for a complete user interaction (including retrieval, inference, and post-processing). p50 > 5 seconds or p95 > 15 seconds for user-facing interactions
Cost Per Query Test What does each AI interaction actually cost? Log token counts and compute costs for 1,000 representative interactions. Calculate average, median, and p95 costs. Cost per interaction that exceeds revenue per interaction at your target price point
Data Pipeline Test Can you process and embed data at the required scale? Process 10x your expected monthly data volume. Measure time, cost, and error rates. Processing time that creates unacceptable delays, or costs that blow your budget

The "Bus Factor" Audit

The "bus factor" measures how many people would need to be hit by a bus before a project is in serious trouble. For most startups, the answer is "one" -- and that's a critical risk. Here's how to systematically assess and mitigate this:

Bus Factor = 1 (Critical Risk)

  • Only one person understands the AI prompt engineering
  • Only one person has access to production infrastructure
  • Only one person manages the key customer relationship
  • Only one person knows how the billing system works

If any of these are true, you have an existential risk that must be addressed before scaling.

Mitigation Steps

  • Document all system architecture and deployment procedures
  • Ensure at least 2 people have access to every critical system
  • Write runbooks for common operational tasks
  • Conduct regular knowledge-sharing sessions
  • Use infrastructure-as-code so environments can be recreated

Cross-training costs time now but prevents catastrophe later.

Technology Stack Decision Framework

At the feasibility stage, your technology choices should be driven by three principles, ranked in order of priority:

  1. Speed to market: Choose technologies your team already knows. A mediocre technology used expertly beats a perfect technology used poorly. The time to learn a new framework is not the feasibility stage.
  2. Operational cost: Prefer managed services (AWS RDS over self-managed PostgreSQL, Vercel over self-managed Kubernetes) during the early stages. The premium you pay for managed services is cheap insurance against operational complexity. Use the MVP Cost Forecaster to compare managed vs. self-managed costs.
  3. Future flexibility: Avoid lock-in where possible, but don't over-engineer. You can migrate databases later if needed. You can switch cloud providers later if needed. Don't let fear of lock-in slow you down today.

What You Walk Away With

  • Revenue Simulation Methodology: Driver-based modeling with sensitivity analysis and scenario testing. You know which variables to track and how to stress-test your projections.
  • Cost Forecasting Framework: AI-specific cost stack with step-function modeling and optimization strategies. You can predict when costs will jump and plan for it.
  • Unit Economics Engine: Cohort-based LTV and Paid CAC methodologies with worked examples. You know the difference between blended and paid CAC and why it matters.
  • Technical Smoke Tests: A concrete battery of tests to validate feasibility before committing to a full build. You know which tests to run, how to interpret the results, and what constitutes a red flag.
  • Risk Reduction Playbook: Bus factor audit, technology stack decision framework, and operational readiness checklist. You've identified and begun mitigating the biggest execution risks.
Apply These Methodologies

LeanPivot's AI-powered feasibility tools implement all these methodologies with guided workflows and industry benchmarks built in.

Save Your Progress

Create a free account to save your reading progress, bookmark chapters, and unlock Playbooks 04-08 (MVP, Launch, Growth & Funding).

Ready to Prove Your Business Model?

LeanPivot.ai provides 80+ AI-powered tools to validate feasibility and build your startup.

Start Free Today

Related Guides

Lean Startup Guide

Master the build-measure-learn loop and the foundations of validated learning to build products people actually want.

From Layoff to Launch

A step-by-step guide to turning industry expertise into a thriving professional practice after a layoff.

Fintech Playbook

Master regulatory moats, ledger architecture, and BaaS partnerships to build successful fintech products.