Claude Business advanced

Financial Model Assumptions Builder

Added Apr 1, 2026

You are a financial analyst who builds models for [INDUSTRY] companies. Help me build the assumptions section of a 3-year financial model for [COMPANY_NAME], a [BUSINESS_DESCRIPTION]. Revenue model: [REVENUE_MODEL]. Current metrics: [CURRENT_METRICS]. For each assumption, provide: the assumption name, the base case value, a conservative scenario value, an aggressive scenario value, the rationale for each, and which industry benchmarks or data sources support it. Cover these categories: Revenue Drivers (pricing, volume, growth rate, churn), Cost Structure (COGS, headcount plan, marketing spend as % of revenue), Operating Expenses (rent, SaaS tools, professional services), and Capital Requirements (equipment, R&D capitalization). Format as a structured table with scenario columns.

Try in Claude

About This Prompt

The assumptions page is the most scrutinized part of any financial model because every projection flows from it. This prompt generates a comprehensive assumptions framework with three-scenario analysis that shows investors or stakeholders you have considered multiple outcomes. Industry benchmark references add credibility to your projections and help identify where your assumptions deviate from norms. The structured table format makes it easy to transfer directly into Excel or Google Sheets. Essential for fundraising models, business plan financials, or annual budgeting exercises.

Variables to Customize


[INDUSTRY]

Your industry vertical

Example: B2B SaaS


[COMPANY_NAME]

Your company name

Example: DataSync Pro


[BUSINESS_DESCRIPTION]

What the business does

Example: cloud data integration platform for mid-market companies


[REVENUE_MODEL]

How you make money

Example: monthly subscription with 3 tiers ($99, $299, $799/month) plus implementation fees


[CURRENT_METRICS]

Your current financial metrics

Example: $180K ARR, 45 customers, 3.2% monthly churn, $4,200 average ACV, 18-month average customer lifetime

Tips for Best Results

Validate all benchmark references with current industry reports
Add seasonality assumptions if your business has seasonal patterns
Request sensitivity analysis formulas as a follow-up for your spreadsheet

Example Output

## Revenue Drivers
| Assumption | Conservative | Base Case | Aggressive | Rationale |
|-----------|-------------|-----------|------------|----------|
| Monthly customer growth rate | 8% | 12% | 18% | Base: Median B2B SaaS growth at $180K ARR (OpenView SaaS Benchmarks 2025). Conservative: Assumes current sales capacity only. Aggressive: Assumes new sales hire in Q2. |
| Monthly gross churn | 4.0% | 3.2% | 2.5% | Base: Current trailing 6-month average. Industry median for mid-market SaaS: 3-5% (Bessemer Cloud Index). |

financial-modeling assumptions scenario-analysis forecasting startup-finance