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

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.
πŸŒ€ Claude

Financial Forecast Model 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-5-SONNET
Tested icon
Guide icon
4 examples icon
Free credits icon
πŸ•΅οΈβ€β™‚οΈ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
Report
Browse Marketplace