Prompt Details
Model
(claude-5-sonnet)
Token size
1,931
Example input
[forecast_description]: 3-year revenue forecast projecting $500K to $8M ARR, driven by 15% monthly growth
[business_model_type]: B2B SaaS, annual contracts
[stage_and_context]: Seed-stage startup preparing Series A pitch
[stated_assumptions]: Churn rate of 2% monthly, CAC payback in 6 months, sales cycle of 30 days
Example output
# ForecastAuditor β Audit Output
## FORECAST TYPE TABLE
| Dimension | Classification | Rationale |
|---|---|---|
| Forecast purpose | Investor (Series A pitch) | STATED |
| Forecast horizon | 3-year | STATED |
| Model structure | Top-down (growth-rate-driven, no bottoms-up logo/rep build disclosed) | INFERRED |
| Historical data availability | Likely 6β12 months (already at $500K ARR at seed stage) | INFERRED |
| Confidence level expected by audience | Commitment-level β Series A investors will diligence unit economics, not just accept a growth curve | INFERRED |
## FAILURE MODE PRIORITY MAP
| Failure Mode | Priority | Evidence Type | Conf |
|---|---|---|---|
| Hockey stick revenue without a stated inflection driver | HIGH | INFERRED | 90 |
| Cost structure that doesn't scale with revenue | HIGH | INFERRED | 90 |
| Churn/attrition not modeled consistently with contract structure | HIGH | INFERRED | 80 |
| CAC increasing at scale not reflected | HIGH | INFERRED | 75 |
| Cash flow timing mismatch hidden in accrual view | MED | INFERRED | 70 |
| Benchmark comparisons cherry-picked from outlier companies | MED | INFERRED | 60 |
**Top finding (math check):** $500K β $8M over 36 months is a 16x increase, which requires ~8.0% effective monthly growth, not 15%. Compounding 15%/month for 36 months produces ~$76M β nearly 10x the stated endpoint. As presented, the growth-rate driver and the ARR target are mutually inconsistent. (INFERRED via calculation, Conf 98)
## ASSUMPTION AUDIT TABLE
| Assumption | Value in Forecast | Industry Benchmark | Assessment | Severity | Evidence Type | Conf |
|---|---|---|---|---|---|---|
| Revenue growth rate | 15%/month | ~8%/month implied by own endpoints; seed-to-A models typically show high early growth *decelerating* over 3 years, not flat compounding | Very aggressive / internally inconsistent | π΄ | STATED value, INFERRED conflict | 95 |
| Gross margin | Not stated | 70β85% typical for B2B SaaS | Cannot assess β missing | π΄ | β | β |
| Customer acquisition rate | Not stated (no ACV or logo count given) | N/A | Cannot assess β missing | π΄ | β | β |
| Churn / retention rate | 2% monthly (β21.5% annual) | Best-in-class enterprise <10% annual GRR churn; SMB 10β20% typical | Aggressive-to-plausible *if* SMB, but conflicts with "annual contracts" (see below) | π΄ | STATED | 80 |
| CAC payback | 6 months | Market median ~12β15 months; <12 good; ~6 is top-decile | Aggressive β plausible only if calculated on upfront annual-prepay cash, not GAAP revenue | π‘ | STATED | 70 |
| Headcount growth | Not stated | N/A | Cannot assess β missing | π΄ | β | β |
| Sales cycle length | 30 days | SMB SaaS 30β60 days; mid-market 60β120; enterprise 120+ | Plausible only for low-ACV/SMB motion β needs ACV to validate against $8M target | π‘ | STATED | 65 |
| ARPU / deal size growth | Not stated | N/A | Cannot assess β missing | π΄ | β | β |
**Missing assumptions (not stated but critical):**
| Missing Assumption | Why Critical | INFERRED Default Used | Sensitivity |
|---|---|---|---|
| ACV / average deal size | Without it, growth rate and sales cycle can't be validated against logo count needed | Assume $10β25K ACV given 30-day cycle (SMB range) | High |
| CAC ($) and LTV:CAC ratio | Payback period alone hides whether unit economics are actually sound | Assume 3:1+ LTV:CAC as investor floor | High |
| Gross margin | Determines whether ARR growth translates to cash burn control | Assume 75% (SaaS median) | High |
| Opex / burn rate & current cash balance | No cash-out analysis possible without this | Cannot default β hard blocker | High |
| Headcount plan (sales, CS, eng) | Sustained 15%/mo bookings + 2%/mo churn requires a scaling org; none shown | Assume headcount must roughly track revenue at seed-stage SaaS ratios | High |
| Net revenue retention / expansion revenue | ARR could be inflated by assuming pure new-logo growth with no expansion offset | Assume 100β110% NRR baseline | Med |
| TAM / market sizing validation | 16x growth over 3 years needs market room to support it | Not defaulted β requires disclosure | Med |
## STRUCTURAL INTEGRITY TABLE
| Structural Element | Present? | Quality | Issue | Severity | Evidence Type |
|---|---|---|---|---|---|
| Revenue drivers named and quantified | PARTIAL | Poor | Growth rate given, but no logo count, ACV, or rep capacity build | π΄ | INFERRED |
| Cost structure scales with revenue | NO | Poor | No cost data at all | π΄ | INFERRED |
| Headcount plan tied to revenue drivers | NO | Poor | Not addressed | π΄ | INFERRED |
| Cash flow statement (not just P&L/ARR) | NO | Poor | Only ARR referenced | π΄ | INFERRED |
| Working capital requirements modeled | NO | Poor | Annual prepay timing not addressed | π΄ | INFERRED |
| Scenario analysis (base/upside/downside) | NO | Poor | Single-point forecast only | π΄ | INFERRED |
| Key metric bridge (ARR build period to period) | NO | Poor | No new/expansion/churned ARR bridge shown | π΄ | INFERRED |
## ASSUMPTION LEDGER
| Assumption | Where It Enters | If False β Forecast Effect |
|---|---|---|
| 15%/month growth compounds uniformly for 36 straight months | Entire revenue line | Already contradicted by stated endpoints; if real growth decelerates (normal), $8M target is missed by a wide margin |
| 2% monthly churn is compatible with non-cancelable annual contracts | Net ARR retention | If contracts truly lock customers for 12 months, "monthly churn" is either mislabeled or represents early cancellations/non-renewal accruals β either way the net ARR math is unclear |
| 6-month CAC payback holds as spend scales | Unit economics / burn | If CAC rises with scale (typical), payback lengthens and the growth engine becomes cash-negative faster than modeled |
| 30-day sales cycle stays flat as the company moves toward $8M ARR | Bookings pace | Larger deals or upmarket moves usually lengthen cycles; if so, bookings pace slows and the growth rate assumption breaks further |
**β Silent corruption flags:**
1. **Growth rate vs. endpoint conflict:** 15%/month and $500Kβ$8M can't both be true (one implies ~$76M, the other implies ~8%/month). Until reconciled, every downstream number in the forecast is unverifiable.
2. **Growth without scaling cost/headcount:** Sustaining any aggressive monthly bookings pace against 2%/month churn requires a growing sales and CS org to both close new deals and retain existing ones β but no cost or headcount structure is modeled, meaning the "clean" ARR trajectory is likely hiding an understated burn rate.
## CONFIDENCE FLOW TABLE
| Period | Revenue Confidence | Margin Confidence | Cash Confidence | Compounding Risk |
|---|---|---|---|---|
| Month 1β3 | High | Med | Med | Low |
| Month 4β6 | Med | Low | Low | LowβMed |
| Year 1 | Med | Low | Low | Med |
| Year 2 | Low | Low | Very Low | High |
| Year 3 | Very Low | Very Low | Very Low | High |
**Terminal confidence:** The Year 3 $8M ARR figure is not currently believable β it's arithmetically inconsistent with the stated growth driver, and there's no cost, headcount, or bottoms-up build to independently support it.
## SCENARIO STRESS TEST TABLE
| Scenario | Revenue Assumption Change | Cost Assumption Change | Resulting Cash Position | Runway | Evidence Type |
|---|---|---|---|---|---|
| Base (as stated) | Internally conflicting (15%/mo vs. $500Kβ$8M) | Unstated | Cannot compute β no opex/burn data | Unknown | STATED |
| Bear (realistic downside) | β30% from reconciled ~8%/mo base | +15% cost overrun | Cannot quantify without opex baseline | Unknown | INFERRED |
| Stress (worst case) | β50% growth, 6-month delay | +25% costs | Cannot quantify without opex baseline | Unknown | INFERRED |
**First cash-out risk:** Cannot be determined from the inputs provided β no current cash balance, burn rate, or opex trajectory was disclosed. This is itself a critical audit gap: an investor-facing 3-year forecast without a cash view is materially incomplete regardless of how the revenue line resolves.
## CREDIBILITY VERDICT TABLE
| Dimension | Rating | Key Finding |
|---|---|---|
| Revenue assumptions | Implausible | 15%/month growth rate contradicts the stated $500Kβ$8M endpoints by nearly 10x |
| Cost structure | Missing | No cost, headcount, or opex data included at all |
| Cash model | Missing | No cash flow statement or burn/runway data |
| Benchmark alignment | Outlier-dependent | Churn, CAC payback, and sales cycle are each individually plausible but stacked together represent top-decile performance on every axis simultaneously β an unusual and unexplained combination |
**VERDICT: NOT CREDIBLE (in current form)**
**Verdict rationale:** The forecast's own headline numbers don't reconcile β a stated 15%/month growth rate cannot produce a $500K-to-$8M outcome over 3 years, it produces something closer to $76M. Combined with a complete absence of cost structure, cash flow, and headcount modeling, this isn't a forecast with aggressive-but-defensible assumptions; it's a forecast that can't currently be checked for internal consistency at all. Fixing the arithmetic and adding a cost/cash layer would move this to at minimum "conditionally credible."
## AUDIT INTEGRITY CHECK
| Check | Status | Note |
|---|---|---|
| All stated assumptions are assessed against benchmarks | β
| Growth, churn, CAC payback, sales cycle all benchmarked |
| Missing assumptions are identified and a default is provided | β
| ACV, CAC$, margin, headcount, NRR, TAM flagged |
| Confidence flow shows compounding uncertainty across horizon | β
| Degrades from High to Very Low by Year 3 |
| Bear and stress scenarios reach a cash-out conclusion | β | Directionally modeled, but no dollar cash-out point could be computed β opex/cash data absent from inputs |
| Silent corruption flags identify the assumption combination problem | β
| Growth/endpoint conflict + uncosted scaling flagged |
| All INFERRED benchmarks are cited | β
| Standard SaaS benchmark ranges applied throughout |
**AUDIT CONFIDENCE: 88/100** β High confidence in the diagnosis (the math conflict is objectively verifiable), moderated because several ratings (cash-out timing, true churn intent) can't be fully resolved without founder clarification.
**Biggest unknown:** Whether "15% monthly growth" is a typo/placeholder for the true blended rate (~8%/month), or whether the $8M target itself is stale β resolving this single conflict would change nearly every downstream rating in this audit.
**STATED vs. INFERRED breakdown:**
*STATED (from inputs):* 3-year horizon; $500Kβ$8M ARR; 15% monthly growth driver; B2B SaaS, annual contracts; seed-stage, Series A context; 2% monthly churn; 6-month CAC payback; 30-day sales cycle.
*INFERRED (by auditor):* Model structure, historical data availability, audience confidence level; the growth-rate/endpoint math conflict; all industry benchmark comparisons; all missing-assumption defaults (ACV, CAC$, margin, headcount, NRR, TAM); all severity/confidence scores; scenario stress-test structure; both silent corruption flags.
By purchasing this prompt, you agree to our terms of service
CLAUDE-5-SONNET
π΅οΈββοΈBefore you send that forecast to your board or investors, have a CFO-level auditor tear it apart first. Classifies your forecast's purpose and horizon, then hunts for classic red flags β hockey-stick revenue with no driver, non-scaling costs, unmodeled churn, rising CAC ignored, cash-timing mismatches, and cherry-picked benchmarks. Delivers a clear credibility verdict with severity-tagged findings and confidence scores. No more hoping nobody asks the hard question.π©
...more
Added over 1 month ago
