Equity Valuation Framework
by @ndtchan
Provides a decision-grade equity valuation playbook and report standard (multiples, DCF, quality assessment, scenarios, margin of safety); used when users re...
clawhub install equity-valuation-framework📖 About This Skill
name: equity-valuation-framework description: Provides a decision-grade equity valuation playbook and report standard (multiples, DCF, quality assessment, scenarios, margin of safety); used when users request valuation, best-stock comparison, investment thesis explanation, or structured risk review. compatibility: Requires structured market and financial inputs (typically from vnstock workflows); no direct data fetching in this skill. metadata: {"openclaw":{"emoji":"🧮"}}
Equity Valuation Framework
Use this skill as the "rules of the game" for valuation decisions and report standardization.
Scope and role
vnstock-free-expert for company/price/ratio inputs
- nso-macro-monitor, us-macro-news-monitor, vn-market-news-monitor for macro/news contextWhen to trigger
Required input contract
Accept an input bundle with these sections (missing fields allowed, but must be flagged):{
"ticker": "HPG",
"as_of_date": "YYYY-MM-DD",
"currency": "VND",
"financials": {
"income_statement": {},
"balance_sheet": {},
"cash_flow": {},
"ratios": {}
},
"price_history": {
"daily": [],
"returns": {
"1m": null,
"3m": null,
"6m": null,
"12m": null
}
},
"peer_set": ["AAA", "BBB"],
"macro_snapshot": {},
"news_digest": {},
"metadata": {
"source": "kbs|vci",
"data_quality_notes": []
}
}
Execution workflow (ordered)
1. Validate input bundle completeness and freshness. 2. Run the data quality gate and assign initial confidence. 3. Select valuation modules based on available data (Multiples, DCF, sector adaptation).
4. Build bull/base/bear scenarios with explicit assumptions.
5. Triangulate fair value, define safety zone, and list key risks.
6. Apply confidence rubric and disclose gaps that can change conclusions.
7. Return the report using the required section order.Data quality gate (must run first)
1. Check freshness: state report periods and price cutoff date. 2. Check completeness: identify missing key lines (revenue, EBIT, net income, CFO, debt, equity, shares). 3. Check consistency: basic identity checks (assets = liabilities + equity if available). 4. Mark confidence tier:High: complete + recent + internally consistent.Medium: minor gaps, valuation still usable.Low: major gaps; only directional view allowed.Shared confidence rubric (required)
Use this standardized interpretation:High: valuation triangulation is valid (>= 2 robust methods), assumptions are explicit, and key inputs are complete.Medium: only one robust method is usable or moderate gaps require wider valuation ranges.Low: major input gaps/quality issues force directional valuation only (no precise fair-value claim).Always report:
1. Confidence level.
2. Which modules were actually run (Multiples, DCF, sector adaptations).
3. Critical missing inputs that would most likely change fair value.
Valuation modules
Run modules based on available data. Prefer triangulation (2+ methods).1) Relative valuation (Multiples)
Use when at least one of earnings/book/EBITDA is reliable.P/E (earnings-based)
- P/B (capital-intensive, banks/financials)
- EV/EBITDA (operating comparison)
- Optional: EV/Sales, P/CF
2) DCF valuation
Use only when cash-flow visibility is acceptable.3) Sector-specific adaptation
#### Banks / Insurance / FinancialsP/B, ROE, asset quality proxies, capital adequacy proxies, funding cost/NIM proxies.#### Cyclicals (steel, chemicals, commodities, shipping)
Quality and business resilience checklist
Assess each item asStrong / Neutral / Weak with one-line evidence:
Scenario framework (required)
Always provide three scenarios: 1.Bull: better macro + execution upside
2. Base: most likely path under current conditions
3. Bear: macro/industry shock + execution shortfallFor each scenario include:
Margin of safety rule
Fair Value range from module triangulation.Safety Zone below fair value (default 15-30% depending on confidence and cyclicality).Decision policy (how to conclude)
Create an integrated view from:If the user is managing a watchlist/portfolio, end with conditional action framing suitable for portfolio-risk-manager:
Trigger to add risk (what would increase conviction)Trigger to reduce riskInvalidation (what would make the thesis wrong)Horizon (ngắn/trung/dài)Conclusion label:
Attractive (valuation discount + acceptable quality/risk)Watchlist (mixed signals, wait for trigger)Caution (valuation unsupported or risk too high)Required report output template
Return exactly these sections in this order:1. Executive Summary
2. What Data Was Used
3. Core Thesis (Bull / Base / Bear)
4. Valuation Work
5. Business Quality Assessment
6. Risk Register
7. Fair Value and Safety Zone
8. Confidence and Gaps
9. Disclaimer
Formatting standards
Minimal scoring rubric (optional but recommended)
If user asks for ranking within this framework:Valuation 40%Quality 35%Momentum/Revision 15%Risk penalty 10%Calibrate per sector and confidence.