企业收入预测压力测试
帮你拆解转化、定价、续约及回款假设,形成下行情景分析、收入变动矩阵与决策触发条件。
完整提示词
I want a deep, evidence-first and revenue-oriented analysis that separates sales activity from real economic outcome and reported revenue from high-quality, collectible and sustainable revenue. Main objective: > Stress-test the revenue forecast by decomposing it into measurable drivers, testing conversion, pricing, retention, pipeline timing, collection and mix assumptions under realistic downside scenarios. This is not: - a vanity sales-dashboard audit - assuming more revenue is automatically better - mixing booked, recognized and collected revenue - pricing recommendation without customer and margin evidence - LTV/CAC analysis without cohorts and definitions - forecasting from pipeline without conversion and aging discipline ## 1. CONTEXT DISCOVERY Establish: - business model and monetization model - revenue recognition and cash collection logic - customer segments, products and channels - sales motion: self-serve, PLG, inside, field, channel or hybrid - contract length, billing frequency and renewal mechanics - gross and contribution margin - sales cycle, conversion, retention and churn - pricing/discount governance - forecast horizon and decision context ## 2. EVIDENCE MODEL A - direct CRM, billing, contract, invoice, payment, cohort or transaction evidence B - complete commercial-to-cash evidence chain and multiple reconciled sources C - strong derived analysis with transparent formula D - credible inference requiring verification E - scenario, hypothesis or hardening recommendation Status: CONFIRMED / SUPPORTED / NOT VERIFIED / CONTESTED / NOT APPLICABLE / SCENARIO ## 3. REVENUE AND METRIC DISCIPLINE For every key metric show: ```text Metric: Business definition: Numerator: Denominator: Cohort/segment: Period: Source: Recognition/cash treatment: Formula: Result: Sensitivity: Known exclusions: ``` Explicitly distinguish lead, opportunity, booking, billings, recognized revenue, ARR/MRR where applicable, gross revenue, net revenue, contribution profit and collected cash. ## 4. FORECAST ARCHITECTURE Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 5. HISTORICAL ACCURACY Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 6. BASE REVENUE Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 7. NEW BUSINESS Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 8. RENEWALS Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 9. EXPANSION Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 10. CONTRACTION Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 11. CHURN Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 12. PIPELINE COVERAGE Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 13. STAGE CONVERSION Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 14. PIPELINE AGING Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 15. SALES CYCLE Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 16. DEAL SIZE Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 17. PRICING ASSUMPTIONS Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 18. DISCOUNT ASSUMPTIONS Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 19. SEASONALITY Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 20. CAPACITY CONSTRAINTS Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 21. CUSTOMER CONCENTRATION Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 22. COLLECTION TIMING Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 23. SCENARIO PROBABILITIES Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 24. FORECAST BIAS Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 25. MANAGEMENT OVERRIDES Analyze this area only when it changes a revenue decision or explains revenue quality. For every material conclusion state metric definition, cohort/segment, baseline, denominator, period, evidence tier, customer behavior, margin/cash effect, alternative explanation and what would falsify it. ## 26. COHORT AND MIX ANALYSIS Do not accept a blended metric when segment, channel, product, geography or cohort mix can change the conclusion. Show newest cohorts separately from lifetime averages and test for Simpson's paradox where relevant. ## 27. FALSE-POSITIVE PROTECTION Do not report a problem merely because conversion is lower, discounts exist, sales cycle is long, customer concentration is high or churn is nonzero. A finding requires a context-appropriate benchmark, a defensible mechanism of harm and an economics consequence. ## 28. SEVERITY P0 - revenue/cash failure that can imminently threaten solvency, compliance or core collection capability P1 - materially wrong revenue thesis, leakage or pricing issue with major value impact P2 - significant conversion, retention, pricing, margin or forecast quality problem P3 - limited commercial/control gap P4 - hardening or monitoring ## 29. FINDING FORMAT ```text ID: Severity: Status: Evidence tier: Revenue stream: Segment/cohort: Observed fact: Metric/definition: Baseline: Expected state: Mechanism: Customer behavior: Revenue effect: Margin effect: Cash effect: Forecast effect: Dependencies: Evidence: Alternative explanation: What would falsify this: Remediation / experiment: Owner: Verification: Decision trigger: ``` ## 30. REQUIRED MATRICES ### Revenue Bridge | Driver | Baseline | Volume effect | Price effect | Mix effect | Retention effect | Net revenue effect | |---|---:|---:|---:|---:|---:|---:| ### Funnel Matrix | Stage | Entry | Exit | Conversion | Median age | Loss reason | Data quality | |---|---:|---:|---:|---:|---|---| ### Pricing Matrix | Segment | Value metric | List price | Realized price | Discount | Margin | Evidence | |---|---|---:|---:|---:|---:|---| ### Cohort Matrix | Cohort | Acquisition source | CAC | Activation | Retention | Revenue | Contribution | |---|---|---:|---:|---:|---:|---:| ## 31. FAILURE CHAINS Model at least 5 concrete chains: ```text condition ↓ commercial trigger ↓ conversion / price / retention / collection failure ↓ revenue and margin effect ↓ cash / forecast / strategic consequence ``` Always test at least one combined scenario: lower conversion + deeper discount + slower collection, or higher churn + higher CAC. ## 32. EXPERIMENT AND SENSITIVITY DESIGN For pricing, conversion or retention claims define a test or sensitivity capable of changing the decision. ```text Hypothesis: Segment: Metric: Baseline: Change tested: Success threshold: Failure threshold: Duration: Bias/confounders: Revenue effect: Margin effect: Decision if passed: Decision if failed: ``` ## 33. ADVERSARIAL SECOND PASS - remove the largest deal/customer and rerun the analysis - inspect newest cohorts - test lower win rate and longer sales cycle - test discount creep - test weaker renewal and expansion - inspect pipeline aging and no-decision - separate pricing effect from mix effect - test slower collection ## 34. FINAL QUALITY GATE Confirm revenue definitions, cohort/segment discipline, gross/net/cash distinctions, margin impact, pricing evidence, conversion denominators, retention definition, forecast assumptions, false-positive protection, combined downside and decision triggers. ## 35. OUTPUT `REVENUE_FORECAST_STRESS_TEST.md` The report begins with Executive summary, Revenue quality, Funnel/pricing snapshot, Top risks, Top leakage points, Findings, Matrices, Failure chains, Experiments and Decision triggers. # FINAL RULE Do not optimize a revenue metric in isolation. The goal is high-quality, collectible and sustainable revenue that creates margin and cash without hidden erosion of future value.
分类与标签
财务理财、收入预测、回款分析、下行情景、预测假设检验