PromptBase
Upgrade
Close icon
General
Home
Marketplace
Create
Hire
Login
Chat
Sell
Explore

Prompt Details

Model
(claude-4-6-sonnet)
Token size
1,889
Example input
[MODEL\_ASSUMPTIONS]: 80% YoY revenue growth, 82% gross margin, $5K CAC, $45K LTV, 8% annual churn, net retention 120%, headcount 45→90, marketing $800K/yr [INDUSTRY\_AND\_STAGE]: SaaS / Series A [MODEL\_PURPOSE]: Fundraising pitch
Example output
# FINANCIAL MODEL ASSUMPTION AUDIT ## SaaS | Series A | Purpose: Fundraising Pitch --- ## Phase 1: Assumption Benchmarking | Assumption | Your Value | Industry Range (Series A SaaS) | Benchmark Percentile | Rating | |---|---|---|---|---| | YoY Revenue Growth | 80% | 40–100% (median ~60%) | ~70th | **AGGRESSIVE** | | Gross Margin | 82% | 65–80% (median ~72%) | ~85th | **AGGRESSIVE** | | CAC | $5,000 | $3,000–$15,000 (median ~$7,500) | ~35th | **MARKET** | | LTV | $45,000 | $20,000–$80,000 | ~55th | **MARKET** | | Annual Churn | 8% | 5–15% (median ~10%) | ~40th | **MARKET** | | Net Revenue Retention | 120% | 100–130% (median ~110%) | ~75th | **AGGRESSIVE** | | Headcount Growth (12 mo) | 45→90 (100%) | 40–80% growth typical | ~80th | **AGGRESSIVE** | | Marketing Spend | $800K/yr | {BENCHMARK — verify with industry data for ARR base} | — | **MARKET** (likely) | **Flags on AGGRESSIVE ratings:** - **Revenue Growth (80%):** Achievable but sits above the median for Series A SaaS; typically only sustained by companies with very strong product-led growth or an existing outbound engine — investors will want to see the pipeline coverage ratio to believe it. - **Gross Margin (82%):** Exceeds the 72% SaaS median significantly; at Series A scale, hosting/infrastructure costs and customer success headcount often compress margins below 80% unless the product is highly self-serve. - **NRR (120%):** Top-quartile performance; credible only if expansion revenue mechanics (upsell, seat expansion, usage tiers) are explicitly modeled — investors will probe the *source* of that 20 points of net expansion. - **Headcount Doubling:** 100% headcount growth in 12 months creates significant operational risk — recruiting, onboarding, culture dilution, and management bandwidth are all stretched simultaneously. --- ## Phase 2: Internal Consistency Check **Test 1 — CAC vs. Marketing Spend vs. New Customer Target** 🔴 **CRITICAL** At $800K marketing spend and $5K CAC, the model implies acquiring **160 new customers per year**. Doubling headcount to 90 while adding 160 customers means each customer success or sales rep is responsible for servicing a meaningful book. However, if blended CAC includes sales salaries (as it should — fully-loaded CAC), $800K marketing alone cannot support $5K CAC unless sales compensation is accounted for separately. A fully-loaded CAC for B2B SaaS at Series A typically runs $8,000–$15,000 when sales headcount is included. **The stated $5K CAC appears to be marketing-only, not fully-loaded — this is a common and investor-scrutinized error.** Gap: potentially 60–200% understatement of true CAC. **Test 2 — Churn Rate vs. NRR** 🔴 **CRITICAL** 8% annual gross churn with 120% NRR implies **net expansion of ~28 percentage points** from existing customers (since NRR = 1 − churn + expansion, simplified). That means existing customers are expanding their spend by ~28% annually on average *after* accounting for churned revenue. This is achievable only in usage-based or seat-expansion models with a clearly defined upsell path. If the product is fixed-seat or fixed-tier SaaS, this combination is internally contradictory. The model must explicitly show where the 28 points of expansion comes from — if it can't, NRR should be revised down to 108–112%. **Test 3 — Revenue Growth vs. Sales Headcount Ramp** 🟡 **SIGNIFICANT** 80% YoY growth while doubling headcount sounds aligned, but new sales hires typically take **3–6 months to reach full productivity** in B2B SaaS. If 30–40 of the 45 new hires are in H1, their revenue contribution won't materialize until H2 or beyond — creating a mid-year revenue recognition lag that may cause the model to miss quarterly milestones even if the annual number is eventually hit. The model needs a headcount ramp schedule with productivity curves, not a flat doubling assumption. **Test 4 — LTV/CAC Ratio vs. Gross Margin** 🟡 **SIGNIFICANT** LTV of $45K at 82% gross margin implies ~$36.9K in gross profit per customer. With $5K CAC, the LTV/CAC ratio is 9:1 — excellent on paper, but this depends entirely on the payback period assumption. At $5K CAC and assuming ~$3,750 average ACV (implied by LTV ÷ customer lifetime), payback is ~16 months. That's reasonable, but if CAC is actually $10–12K (fully loaded), payback stretches to 32–38 months — a flag for investors evaluating capital efficiency. **Test 5 — Gross Margin vs. Headcount Doubling** 🟡 **SIGNIFICANT** Maintaining 82% gross margins while doubling headcount is difficult unless all new hires are purely in G&A/Sales/R&D (not COGS). If any new hires sit in customer success, implementation, or DevOps/infrastructure supporting customer workloads, they belong in COGS — and the model likely overstates gross margin by 3–7 percentage points once headcount doubles. Series A SaaS companies that scale CS/implementation headcount typically see gross margins compress to 74–78%. --- ## Phase 3: Sensitivity Map | Assumption | Base Value | −10% Scenario | +10% Scenario | Bottom-Line Impact | Sensitivity Rank | |---|---|---|---|---|---| | Revenue Growth Rate | 80% YoY | 72% YoY | 88% YoY | ±$X on top line; ±**~$400–600K** EBITDA impact depending on fixed cost base | **#1** | | Gross Margin | 82% | 73.8% | 90.2% | Every 1% GM shift ≈ **±$40–80K** at Series A ARR scale; full 10% swing = **±$400–800K** gross profit | **#2** | | Net Revenue Retention | 120% | 108% | 132% | Directly reduces/grows ARR compounding; **±$300–500K** ARR impact over 24 months | **#3** | | CAC (Fully Loaded) | $5,000 | $4,500 | $5,500 | At 160 new customers, ±$80K cash impact; but if true CAC is $10K+, **±$800K+ cash** variance | **#4** | | Headcount Ramp Timing | 100% in 12 mo | Slower ramp (80% growth) | Faster ramp (120% growth) | OpEx variance of **±$500–900K** annually; directly affects runway and burn multiple | **#5** | **Critical narrative:** Revenue growth rate is the dominant swing factor — it affects not just top-line but investor valuation (revenue multiples at Series A are typically 8–15x ARR). A 10-point growth rate miss doesn't just hurt the income statement; it reframes the valuation story entirely. Gross margin is the second most dangerous because investors use it as a proxy for product quality and scalability — a surprise compression signals structural problems, not just a bad quarter. --- ## Phase 4: Stress Test Scenarios ### BASE CASE (Assumptions as stated) - Revenue Growth: 80% YoY - Gross Margin: 82% - NRR: 120% - **Implied Outcomes:** - ARR grows from (assumed) ~$3M to ~$5.4M by end of year - Gross profit: ~$4.4M - Marketing + headcount OpEx: ~$7–9M (estimated for 90-person team + $800K marketing) - **EBITDA: Likely −$3M to −$5M** (typical Series A burn profile) - Runway assumption: 18–24 months post-raise (standard Series A) --- ### DOWNSIDE CASE (Top 3 swing factors shifted −15% simultaneously) - Revenue Growth: 68% YoY (vs. 80%) - Gross Margin: 69.7% (vs. 82%) - NRR: 102% (vs. 120%) - **Implied Outcomes:** - ARR grows to ~$4.6M (vs. $5.4M) — **$800K shortfall** - Gross profit drops to ~$3.2M (vs. $4.4M) — **$1.2M gross profit miss** - NRR near breakeven means no meaningful expansion ARR cushion - EBITDA: **−$4.5M to −$6.5M** — burn accelerates - **Model break point:** If headcount doubles as planned but revenue misses, burn multiple (net new ARR ÷ net burn) deteriorates from ~1.0x to ~1.6x — above the 1.5x threshold many Series B investors use as a red flag - Runway: Reduced by **4–6 months** vs. base case --- ### SEVERE DOWNSIDE (Top 3 swing factors shifted −30% simultaneously) - Revenue Growth: 56% YoY (vs. 80%) - Gross Margin: 57.4% (vs. 82%) - NRR: 84% (vs. 120%) — now net churn, meaning the installed base is *shrinking* - **Implied Outcomes:** - ARR: ~$3.9M — barely above prior year baseline - Gross profit: ~$2.2M — down 50% from base case - EBITDA: **−$6M to −$8M** — cash consumption doubles - **Survival analysis:** At this burn rate, a $6M Series A raise provides only **9–12 months of runway** vs. the 18–24 months planned - NRR below 100% signals product-market fit erosion — the most dangerous signal to Series B investors - **Management mitigations available:** 1. **Hiring freeze** on G&A and non-revenue-generating roles — saves $1.5–2M annually 2. **Cost cuts** on marketing spend (reduce from $800K to $400K, accepting slower growth) — saves $400K but creates a compounding revenue problem 3. **Bridge round** at 6 months if growth metrics don't recover — typically at punitive terms (1.5–2x liquidation preference) 4. **Pivot to land-and-expand** focus — protect NRR by investing in CS over new logo acquisition --- ## Phase 5: Red Flag Report ### 🔴 Red Flag #1 — Gross Margin at 82% - **Current Value:** 82% - **Why Flagged:** Exceeds typical Series A SaaS by 10 percentage points; likely excludes CS and infrastructure costs that belong in COGS - **Defensible Value:** 72–76% - **Model Impact if Adjusted:** Gross profit reduction of ~$240–400K at current ARR scale; more significantly, investors will reprice the company if they believe margins are overstated ### 🔴 Red Flag #2 — CAC at $5,000 (Likely Marketing-Only) - **Current Value:** $5,000 - **Why Flagged:** Almost certainly excludes sales salaries, SE support, and onboarding costs; fully-loaded B2B SaaS CAC at Series A is typically $8,000–$15,000 - **Defensible Value:** $9,000–$12,000 fully loaded - **Model Impact if Adjusted:** LTV/CAC ratio drops from 9:1 to 3.75–5:1 (still good, but changes the efficiency narrative); payback period extends from ~16 months to 28–36 months; cash requirements for growth increase materially ### 🔴 Red Flag #3 — NRR at 120% Without Explicit Expansion Mechanics - **Current Value:** 120% - **Why Flagged:** Mathematically inconsistent with 8% churn unless ~28% gross expansion is explicitly modeled and sourced; no expansion mechanism described - **Defensible Value:** 108–112% unless upsell/expansion revenue is explicitly modeled with a bottom-up driver - **Model Impact if Adjusted:** ARR compound growth slows; the "efficient growth" story weakens; LTV recalculates downward proportionally ### 🟡 Red Flag #4 — Headcount Doubling Without Productivity Ramp - **Current Value:** 45→90 in 12 months - **Why Flagged:** Implies immediate full productivity from all new hires; no ramp curve modeled; creates OpEx-ahead-of-revenue timing mismatch - **Defensible Value:** 45→75 with explicit 3–6 month ramp to full quota/productivity - **Model Impact if Adjusted:** Revenue recognition shifts $200–500K into later quarters; burn in H1 increases; quarterly milestones become harder to hit ### 🟡 Red Flag #5 — Revenue Growth at 80% - **Current Value:** 80% YoY - **Why Flagged:** Top quartile; sustainable only with documented pipeline coverage of 3–4x and a repeatable go-to-market motion - **Defensible Value:** 60–70% without documented pipeline evidence; 80% defensible *only* with trailing data showing acceleration - **Model Impact if Adjusted:** At 65% growth, ARR is ~$800K–$1M lower year-end; valuation impact at 10x ARR multiple is **$8–10M** — material at Series A --- ## Phase 6: Challenge Questions & Coached Answers *(Investor-Style — Fundraising Pitch)* --- **Q1: "Your CAC is $5,000 — how exactly is that calculated? Does it include sales salaries?"** *Coached Answer:* "Our $5,000 reflects direct marketing spend per acquired customer. When we include fully-loaded sales compensation, our blended CAC is [X] — still within [Y] months payback on a $[ACV] ACV, which we believe is capital-efficient for our segment. We track both metrics on our dashboard." *(Adjust X and Y with your real numbers before the meeting.)* *Don't say:* "CAC is $5K, which gives us a 9:1 LTV/CAC" without clarifying the methodology — experienced investors will immediately ask whether it's fully loaded, and hesitation signals the number was cherry-picked. --- **Q2: "120% NRR is impressive. Walk me through exactly where that expansion revenue comes from."** *Coached Answer:* "Expansion comes from [specific mechanic — e.g., seat-based growth, usage tiers, module upsell]. In our current cohort, [X]% of customers have expanded within 12 months, at an average expansion of [Y]%. We model this conservatively using only customers past the 6-month mark." *(If you can't fill in those specifics, revise your NRR assumption before pitching.)* *Don't say:* "We expect customers to grow with us" — vague expansion narratives with no mechanism are one of the most common Series A red flags. --- **Q3: "You're doubling headcount in 12 months. How do you maintain culture and execution quality at that pace?"** *Coached Answer:* "We've mapped our hiring plan to specific revenue milestones, not a calendar date — if we hit [X ARR] by Q2, we accelerate; if not, we modulate the pace. We have a structured onboarding program and have already identified 3 senior hires who will lead each functional team before the broader ramp begins." *Don't say:* "We've done it before" without specifics — investors want to see a process, not a personality claim. --- **Q4: "Your gross margin is 82%. SaaS companies at your stage typically run 70–75%. What's in your COGS?"** *Coached Answer:* "Our COGS includes infrastructure, payment processing, and [specific items]. Customer success and implementation are currently in OpEx because our onboarding is primarily self-serve. As we scale enterprise, we expect gross margins to settle in the 76–79% range as CS headcount migrates into COGS — we've modeled that transition beginning in Year 2." *Don't say:* "82% is our actual margin" without being able to defend the COGS line item by item — investors will reclassify costs themselves and present a lower number back to you. --- **Q5: "What's your pipeline coverage ratio to support 80% growth? What does your funnel look like?"** *Coached Answer:* "We currently have [X]x pipeline coverage against our next 12-month target, with [Y]% of pipeline in late-stage (Procurement/Legal/Final Negotiation). Our average sales cycle is [Z] days, and we've seen consistent win rates of [W]% over the last 3 quarters." *Don't say:* "We have strong pipeline" without a number — pipeline coverage is one of the first data requests investors will make in due diligence, and inability to answer on the spot signals the growth assumption is aspirational. --- **Q6: "If I stress your top 3 assumptions by 20%, you likely run out of money in under 14 months. What's your contingency plan?"** *Coached Answer:* "We've modeled a downside scenario where growth comes in at 60% and margins compress to 74% — in that case, we have [N] months of runway and would implement a hiring pause on non-revenue roles before month [M]. We're raising [X] to give us 24 months at base case, not 18, specifically to create that buffer." *Don't say:* "That scenario won't happen" — investors interpret dismissal of downside scenarios as a lack of financial maturity, not as confidence. --- **Q7: "8% annual churn with 120% NRR — those two numbers are pulling in opposite directions. How do you reconcile them?"** *Coached Answer:* "Gross churn of 8% is concentrated in our SMB segment, where we've made a strategic decision to under-invest in retention in favor of mid-market acquisition. Our expansion comes almost entirely from our mid-market and enterprise cohort, where NRR runs at [X]% — the blended 120% reflects that mix shift strategy, which we can show cohort by cohort." *Don't say:* "Both numbers are correct" without a segmentation explanation — sophisticated investors will do the math on the spot and the combination looks inconsistent without a cohort story. --- **Q8: "What's your burn multiple, and how does it change as you scale?"** *Coached Answer:* "Our current burn multiple is approximately [X] — meaning we're spending $[X] in net burn for every $1 of net new ARR. We expect this to improve to [Y] by month 18 as new hires reach full productivity and marketing efficiency compounds. Best-in-class Series A SaaS runs at 1.0–1.5x; we're targeting [Z]x by Series B." *Don't say:* "We don't track burn multiple" — this metric has become a standard capital efficiency benchmark since 2022 and not knowing it signals financial unsophistication to any experienced investor. --- **Q9: "Why should I believe the 80% growth rate is repeatable and not a one-year spike?"** *Coached Answer:* "We've grown at [X]%, [Y]%, [Z]% in each of the last 3 years — the trend is accelerating, not decelerating. The driver is [specific GTM motion — e.g., outbound team buildout, a partnership channel that went live Q3]. We can show you cohort-level data demonstrating that newer cohorts are converting faster and at higher ACVs than earlier cohorts." *Don't say:* "The market is huge and we're just getting started" — TAM arguments don't validate a specific growth rate; only pipeline data and cohort performance do. --- **Q10: "What happens to your model if a well-funded competitor cuts price by 20% in your core segment?"** *Coached Answer:* "Our churn is primarily driven by [product gaps / company size outgrowing us], not price — in our last 50 churned customers, only [X]% cited price as a factor. Our gross margin gives us room to selectively respond on price in competitive deals without destroying unit economics. We've held our pricing through [specific competitive event] without meaningful impact on win rates." *Don't say:* "We have strong competitive moats" without specifics — every founder claims moats; the investors who have seen 400+ pitches want evidence of price inelasticity, not a category claim. --- *This audit is based on the assumptions provided and general industry benchmarks for Series A SaaS companies. All benchmark ranges should be verified against current market data, including sources such as OpenView's SaaS Benchmarks Report, Bessemer's State of the Cloud, and KeyBanc Capital Markets' SaaS Survey. This analysis does not constitute financial, investment, or legal advice. If this model will be used in regulatory filings, SEC disclosures, or formal valuation engagements, all assumptions must be reviewed by qualified financial professionals.*
🌀 Claude

Financial Model Assumption Auditor

Add to Cart
Instant accessInstant access
Usage rightsCommercial use
Money-back guaranteeMoney‑back
By purchasing this prompt, you agree to our terms of service
CLAUDE-4-6-SONNET
Tested icon
Guide icon
4 examples icon
Free credits icon
Your financial model is only as good as its assumptions. This prompt stress-tests every one of them. ✅ Benchmarks each assumption against industry data — rates as Aggressive, Market, Conservative, or Unrealistic ✅ Cross-checks assumptions against each other for internal consistency (growth rate vs. headcount vs. CAC) ✅ Maps the top 5 swing factors — variables where a 10% shift hits the bottom line hardest ✅ Generates the 10 hardest questions your investors or lenders will ask — with coached resp
...more
Added 3 weeks ago
Report
Browse Marketplace