现金流折现估值模型审查
帮你梳理现金流、折现率与终值假设,形成含敏感性分析和证据缺口的估值审查报告。
完整提示词
I want a deep, evidence-first and investment-grade analysis that separates accounting performance, cash generation, enterprise value, equity value and the assumptions carrying most of the value. Main objective: > Audit a DCF model by testing cash-flow construction, forecast drivers, reinvestment, discount rate, terminal value, consistency and sensitivity before treating the output as decision-useful valuation evidence. This is not: - a single valuation multiple without context - a DCF that simply extrapolates management forecast - mixing enterprise value and equity value - ignoring debt-like and cash-like items - treating management assumptions as confirmed facts - due diligence without red-flag prioritization and decision impact ## 1. CONTEXT DISCOVERY Establish: - purpose of analysis and transaction/investment type - valuation date and currency - ownership/capital structure - historical financial periods - management forecast and forecast horizon - earnings and cash-flow normalizations - net debt, debt-like and cash-like items - working-capital and capex requirements - critical commercial and operating assumptions - decision context, required return and downside tolerance ## 2. EVIDENCE MODEL A - audited financials, bank/cash evidence, contracts, transaction data, tax filings or direct customer/operating evidence B - reconciled financial-commercial evidence chain from multiple high-quality sources C - strong derived analysis with transparent model and assumptions D - credible inference requiring verification E - scenario, sensitivity or hardening recommendation Status: CONFIRMED / SUPPORTED / NOT VERIFIED / CONTESTED / NOT APPLICABLE / SCENARIO ## 3. VALUATION AND NORMALIZATION DISCIPLINE For every important financial metric show: ```text Metric: Definition: Period: Source: Reported value: Adjustment: Normalized value: Reason for adjustment: Recurring/non-recurring: Cash impact: Valuation impact: Evidence: ``` Explicitly separate revenue, EBITDA, EBIT, net income, operating cash flow, FCFF/FCFE, enterprise value and equity value. ## 4. REVENUE FORECAST Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 5. MARGIN FORECAST Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 6. TAXES Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 7. DEPRECIATION Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 8. CAPEX Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 9. WORKING CAPITAL Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 10. FCFF Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 11. FCFE Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 12. FORECAST HORIZON Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 13. WACC Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 14. COST OF EQUITY Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 15. COST OF DEBT Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 16. CAPITAL STRUCTURE Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 17. BETA Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 18. RISK-FREE RATE Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 19. EQUITY RISK PREMIUM Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 20. TERMINAL GROWTH Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 21. EXIT MULTIPLE Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 22. MID-YEAR CONVENTION Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 23. TERMINAL VALUE SHARE Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 24. DISCOUNTING Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 25. SENSITIVITY GRID Analyze this area only when it changes a valuation or investment decision. For every material conclusion state metric definition, period, source, normalization adjustment, evidence tier, base/upside/downside impact, alternative explanation and what would falsify it. ## 26. VALUATION TRIANGULATION When relevant use at least two independent valuation methods and explain why they differ. Do not treat DCF, public comps and precedent transactions as independent if they rely on the same assumptions. ## 27. FALSE-POSITIVE PROTECTION Do not report a red flag merely because a company has a high multiple, negative working capital, customer concentration or a large terminal value. Require a context-appropriate mechanism and evidence that the characteristic changes risk or value. ## 28. SEVERITY P0 - finding capable of invalidating the transaction, indicating fraud/misstatement or threatening solvency/ownership validity P1 - material valuation or diligence issue that significantly changes price, structure or investment thesis P2 - significant downside, normalization or execution risk P3 - limited evidence gap or model weakness P4 - sensitivity, hardening or additional diligence ## 29. FINDING FORMAT ```text ID: Severity: Status: Evidence tier: Valuation/DD domain: Observed fact: Metric/definition: Reported value: Normalized value: Assumption: Mechanism: Base-case impact: Downside impact: Upside impact: EV impact: Equity-value impact: Cash impact: Dependencies: Evidence: Alternative explanation: What would falsify this: Remediation / diligence request: Deal / investment implication: Owner: Verification: Decision trigger: ``` ## 30. REQUIRED MATRICES ### Valuation Bridge | Method | Key metric | Base | Low | High | EV | Equity value | Confidence | |---|---|---:|---:|---:|---:|---:|---| ### Normalization Matrix | Item | Reported | Adjustment | Normalized | Recurring? | Cash effect | Evidence | |---|---:|---:|---:|---|---:|---| ### Assumption Matrix | Assumption | Base | Downside | Upside | Evidence | Value sensitivity | |---|---:|---:|---:|---|---:| ### Red-Flag Matrix | Finding | Severity | Evidence | Value impact | Deal impact | Required action | |---|---|---|---:|---|---| ## 31. FAILURE AND DOWNSIDE CHAINS Model at least 5 concrete downside chains: ```text assumption ↓ adverse trigger ↓ operating / commercial / financial deterioration ↓ cash-flow effect ↓ valuation / return consequence ``` At least one scenario must combine two or more negative drivers. ## 32. SENSITIVITY AND SCENARIO TESTS Test when relevant: - revenue growth -10% / -20% - margin -300 / -500 bps - WACC +100 / +200 bps - terminal growth -100 bps - higher capex and working-capital requirements - loss of the largest customer - weaker pricing/retention assumptions - lower exit multiple ## 33. ADVERSARIAL SECOND PASS - recalculate without management add-backs - test downside without terminal multiple expansion - remove the largest customer or best segment - test higher reinvestment needs - recheck working-capital normalization - inspect debt-like and off-balance-sheet obligations - look for circular assumptions - check whether method selection is choosing the conclusion rather than testing it ## 34. FINAL QUALITY GATE Confirm valuation date, EV/equity bridge, normalized earnings/cash, net debt/debt-like items, forecast drivers, valuation methods, sensitivities, downside, red flags, evidence gaps and decision triggers. ## 35. OUTPUT `DCF_VALUATION_AUDIT.md` The report begins with Executive summary, Valuation range, Key assumptions, Quality of earnings/cash, Red flags, Method triangulation, Findings, Matrices, Downside scenarios, Deal/investment implications and Decision triggers. # FINAL RULE Valuation is not one number. A good result shows what is evidenced, what is normalized, which assumptions carry value, how much value changes when they are wrong and which finding changes the investment decision itself.
分类与标签
财务理财、企业估值、现金流折现、敏感性分析、投资尽调