Three-Statement Model Builder
ginlix-ai/LangAlpha
Builds or repairs an integrated income statement, balance sheet and cash flow model in Excel with live formulas, supporting schedules, scenarios and a Checks sheet.
Walks through company valuation with DCF, dividend discount and sum-of-the-parts models, relative multiples, sensitivity tables and a valuation-trap checklist.
$ npx skills add HKUDS/Vibe-Trading --skill valuation-model -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install HKUDS/Vibe-Trading valuation-model --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/HKUDS/Vibe-Trading.git skills-src && mkdir -p .claude/skills && cp -r skills-src/agent/src/skills/valuation-model .claude/skills/valuation-model && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "valuation-model" agent skill from https://github.com/HKUDS/Vibe-Trading/tree/main/agent/src/skills/valuation-model into .claude/skills/valuation-model/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "valuation-model", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/HKUDS/Vibe-Trading/tree/main/agent/src/skills/valuation-modelType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add HKUDS/Vibe-Trading --skill valuation-model -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install HKUDS/Vibe-Trading valuation-model --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/HKUDS/Vibe-Trading.git skills-src && mkdir -p .agents/skills && cp -r skills-src/agent/src/skills/valuation-model .agents/skills/valuation-model && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "valuation-model" agent skill from https://github.com/HKUDS/Vibe-Trading/tree/main/agent/src/skills/valuation-model into .agents/skills/valuation-model/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "valuation-model", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add HKUDS/Vibe-Trading --skill valuation-model -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install HKUDS/Vibe-Trading valuation-model --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/HKUDS/Vibe-Trading.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/agent/src/skills/valuation-model .cursor/skills/valuation-model && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "valuation-model" agent skill from https://github.com/HKUDS/Vibe-Trading/tree/main/agent/src/skills/valuation-model into .cursor/skills/valuation-model/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "valuation-model", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/HKUDS/Vibe-Trading.git --path agent/src/skills/valuation-model--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add HKUDS/Vibe-Trading --skill valuation-model -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install HKUDS/Vibe-Trading valuation-model --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/HKUDS/Vibe-Trading.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/agent/src/skills/valuation-model .gemini/skills/valuation-model && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "valuation-model" agent skill from https://github.com/HKUDS/Vibe-Trading/tree/main/agent/src/skills/valuation-model into .gemini/skills/valuation-model/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "valuation-model", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install HKUDS/Vibe-Trading valuation-modelInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add HKUDS/Vibe-Trading --skill valuation-model -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/HKUDS/Vibe-Trading.git skills-src && mkdir -p .github/skills && cp -r skills-src/agent/src/skills/valuation-model .github/skills/valuation-model && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "valuation-model" agent skill from https://github.com/HKUDS/Vibe-Trading/tree/main/agent/src/skills/valuation-model into .github/skills/valuation-model/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "valuation-model", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add HKUDS/Vibe-Trading --skill valuation-model -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install HKUDS/Vibe-Trading valuation-model --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/HKUDS/Vibe-Trading.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/agent/src/skills/valuation-model .opencode/skills/valuation-model && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "valuation-model" agent skill from https://github.com/HKUDS/Vibe-Trading/tree/main/agent/src/skills/valuation-model into .opencode/skills/valuation-model/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "valuation-model", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
valuation-modelWalks through company valuation with DCF, dividend discount and sum-of-the-parts models, relative multiples, sensitivity tables and a valuation-trap checklist.
A valuation framework covering absolute methods (discounted cash flow, the dividend discount model and sum of the parts) and relative methods based on PE, PB and EV-EBITDA. The DCF section gives the formulas for enterprise, equity and per-share value, then walks through forecasting free cash flow, calculating WACC, estimating terminal value and building a sensitivity table of value per share against WACC and growth.
It includes reference WACC and beta ranges by industry for China A-shares, a two-stage dividend model with a checklist of when a company's payouts make it suitable, and the sum-of-the-parts method for diversified groups. The description also promises PE-band, PB-ROE and trap-detection material, but the excerpt is cut off before those sections.
6 steps, taken from the step headings in SKILL.md.
Read from SKILL.md and the folder at commit 14cabaf. It shows what the files ask for, not the result of running them.
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
No scripts in the folder and no shell commands in SKILL.md (its code samples are markdown).
From the folder's file list and the shell code blocks in SKILL.md.
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Company Valuation Methods loads about 2.2k tokens when it runs. Until then it costs about 47 tokens; SKILL.md has 509 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
The full file from HKUDS/Vibe-Trading at commit 14cabaf, republished under its MIT licence (© HKUDS). 509 words, ~2,249 tokens.
.claude/skills/valuation-model/SKILL.md (or your agent's skills folder).Systematic corporate valuation framework covering absolute valuation (DCF / DDM / SOTP) and relative valuation (PE / PB / EV-EBITDA), including sensitivity-analysis methods and a checklist for identifying valuation traps.
Core formulas:
Enterprise value = Σ FCF_t / (1+WACC)^t + TV / (1+WACC)^n
Equity value = enterprise value - net debt
Per-share value = equity value / total shares outstandingDetailed steps:
FCFF = EBIT × (1-tax rate) + depreciation & amortization - capex - increase in working capital
Simplified version:
FCFF ≈ operating cash flow - capex| Year | Revenue (100m RMB) | EBIT (100m RMB) | FCFF (100m RMB) | Growth |
|---|---|---|---|---|
| 2026E | 120 | 24 | 18 | +15% |
| 2027E | 138 | 28 | 21 | +15% |
| 2028E | 155 | 31 | 24 | +12% |
| 2029E | 170 | 34 | 26 | +10% |
| 2030E | 182 | 36 | 28 | +7% |
WACC = E/(D+E) × Ke + D/(D+E) × Kd × (1-T)
Ke (cost of equity) = Rf + β × (Rm - Rf)
- Rf: 10-year government bond yield (about 2.5% for China A-shares)
- β: industry average or company beta (1.0-1.5)
- Rm-Rf: equity risk premium (about 5-7% for China A-shares)
Kd: cost of debt (loan rate, about 4-5%)
T: income tax rate (25%)Reference WACC ranges for China A-shares:
| Industry | WACC Range | Reference β |
|---|---|---|
| Consumer | 8-10% | 0.8-1.0 |
| Technology | 10-13% | 1.2-1.5 |
| Financials | 7-9% | 1.0-1.2 |
| Cyclicals | 9-12% | 1.0-1.4 |
| Utilities | 6-8% | 0.5-0.8 |
Perpetual-growth method: TV = FCF_n × (1+g) / (WACC - g)
- g: perpetual growth rate (usually 2-3%, should not exceed GDP growth)
Exit-multiple method: TV = EBITDA_n × EV/EBITDA multiple
- Reference the industry average or historical median### DCF Sensitivity Analysis (per-share value, RMB)
| WACC \ g | 2.0% | 2.5% | 3.0% |
|----------|------|------|------|
| 9.0% | 32.5 | 35.8 | 40.2 |
| 9.5% | 28.3 | 30.8 | 34.0 |
| 10.0% | 24.8 | 26.7 | 29.1 |
| 10.5% | 22.0 | 23.5 | 25.3 |
| 11.0% | 19.6 | 20.8 | 22.2 |Applicable to: high-dividend stocks (banks, utilities, mature consumer companies).
Two-stage DDM:
P = Σ D_t / (1+Ke)^t + D_n × (1+g) / [(Ke-g) × (1+Ke)^n]
Gordon model (single stage):
P = D_1 / (Ke - g)Applicability checklist:
Applicable to: diversified conglomerates.
Group value = Σ valuation of each business segment + net cash - holding-company discount
Example (a group company):
| Segment | Revenue (100m RMB) | Valuation Method | Valuation (100m RMB) |
|------|---------|---------|---------|
| Baijiu | 80 | 30x PE | 600 |
| Real estate | 50 | 0.6x PB | 120 |
| Financials | 30 | 1.0x PB | 200 |
| Total | | | 920 |
| Holding-company discount | | -15% | -138 |
| Group valuation | | | 782 |Historical PE percentile analysis:
- Take the past 5 years of PE_TTM time series
- Compute the 10% / 25% / 50% / 75% / 90% percentiles
- Judge overvaluation / undervaluation from the current PE percentile
| Percentile | PE | Implied Price | Interpretation |
|------|-----|---------|------|
| 90% | 35x | 52.5 | Severely overvalued |
| 75% | 28x | 42.0 | Rich |
| 50% | 22x | 33.0 | Fair |
| 25% | 16x | 24.0 | Cheap |
| 10% | 12x | 18.0 | Severely undervalued |
| Current | 18x | 27.0 | Cheap (30th percentile) |Theoretical relationship: PB = (ROE - g) / (Ke - g)
Practical use: plot companies in the industry on a PB vs ROE scatter chart
| Quadrant | PB | ROE | Interpretation |
|------|-----|-----|------|
| Lower right | Low PB | High ROE | Undervalued (best buy zone) |
| Upper right | High PB | High ROE | Fair (quality premium) |
| Lower left | Low PB | Low ROE | Value trap or distressed turnaround |
| Upper left | High PB | Low ROE | Overvalued (avoid) |EV = market cap + net debt (interest-bearing debt - cash)
EBITDA = operating profit + depreciation + amortization
Advantages:
- Removes capital-structure differences (vs PE)
- Removes depreciation-policy differences
- Suitable for asset-heavy industries (telecom / energy / infrastructure)
Reference EV/EBITDA ranges by China A-share industry:
| Industry | Median | Undervalued | Overvalued |
|------|--------|------|------|
| Consumer | 15-20x | <12x | >25x |
| Technology | 12-18x | <10x | >22x |
| Energy | 6-10x | <5x | >12x |
| Utilities | 8-12x | <6x | >15x || # | Trap | Detection Method | Typical Example |
|---|---|---|---|
| 1 | Low-PE cyclical at the peak | PE is lowest when earnings are highest and about to fall | Coal at 5x PE in 2021 was the top |
| 2 | High-PE growth can be justified | PEG < 1 means the growth rate supports the valuation | 30x PE + 40% growth = PEG 0.75 |
| 3 | Low-PB value destruction | Sustained ROE < Ke means shareholder value is being destroyed | Long-term loss-making asset-heavy company |
| 4 | Goodwill bomb | Goodwill / net assets >30% implies impairment risk | Underperforming acquisition after paying a high premium |
| 5 | Accounts-receivable trap | Rising receivables / revenue ratio = poor revenue quality | Government receivables + high customer concentration |
| 6 | Capitalization trap | Capitalizing R&D / interest flatters profit | PE doubles after true expensing |
| 7 | One-off gains | Large gap between recurring net profit and reported net profit | Asset sales / government subsidies boost earnings |
| 8 | Share dilution | Stock options / convertible bonds reduce EPS | PE should be based on diluted EPS |
| 9 | Related-party transactions | Buy cheap from related parties / sell high to them | Profit shifted outside the listed entity |
| 10 | FX swings | High overseas-revenue share means large currency sensitivity | RMB appreciation erodes exporter profits |
What type of company is it?
├── Mature and stable (consumer / utilities / banks)
│ ├── High dividend -> DDM
│ └── Low dividend -> DCF + PE Band
├── High growth (tech / pharma / new energy)
│ └── DCF (high-growth phase) + PEG + PS
├── Cyclical (coal / steel / nonferrous)
│ └── PB + EV/EBITDA (avoid PE)
├── Diversified conglomerate
│ └── SOTP
└── Loss-making company
└── PS (price-to-sales) + EV/SalesUse at least 2 valuation methods and take the middle value:
1. DCF -> intrinsic value
2. Comparable PE -> market pricing
3. If the difference >30% -> check whether assumptions are reasonable## Valuation Analysis: [Company Name / Code]
### Valuation Summary
| Method | Per-Share Value | Weight | Notes |
|------|---------|------|------|
| DCF | ¥32.5 | 50% | WACC=10%, g=2.5% |
| Comparable PE | ¥28.0 | 30% | Industry average 22x, EPS=1.27 |
| PB-ROE | ¥30.0 | 20% | Fair PB=2.5x |
| **Composite Target Price** | **¥30.8** | | Current price 25.0, upside +23% |
### Sensitivity Analysis
[WACC vs growth-rate matrix]
### Valuation-Trap Check
- [x] Is PE a falsely low cyclical peak? -> No
- [x] Goodwill / net asset ratio -> 12%, safe
- [x] Receivables / revenue trend -> Stable, not deteriorating
- [ ] Gap in recurring net profit -> 15% difference, subsidy dependence worth attention
### Investment Rating: Buy
Target price ¥30.8, current price ¥25.0, upside 23%onchain-analysis)© HKUDS, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Just SKILL.md in agent/src/skills/valuation-model of HKUDS/Vibe-Trading.
Open the folder on GitHubat commit 14cabaf
Company Valuation Methods next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Company Valuation Methods this skillHKUDS/Vibe-Trading | 35k | — | ~2.2k | Automated safety check: Pass | MIT | |
| Three-Statement Model Builderginlix-ai/LangAlpha | 1.8k | — | ~5.4k | Automated safety check: Pass | Apache-2.0 | |
| Money Financeiamzifei/show-me-the-money | 1k | — | ~2.2k | Automated safety check: Pass | Custom licence | |
| Financial Model Checkerginlix-ai/LangAlpha | 1.8k | — | ~4.2k | Automated safety check: Pass | Apache-2.0 | |
| DCF Model Builderginlix-ai/LangAlpha | 1.8k | — | ~7.7k | Automated safety check: Pass | Apache-2.0 | |
| Longbridge Fundamentalshelsome/folio | 269 | 1 repos | ~1.8k | Automated safety check: Pass | MIT |
ginlix-ai/LangAlpha
Builds or repairs an integrated income statement, balance sheet and cash flow model in Excel with live formulas, supporting schedules, scenarios and a Checks sheet.
iamzifei/show-me-the-money
Financial tracking, revenue analytics, expense management, and pricing optimization.
ginlix-ai/LangAlpha
Audits an existing Excel financial model without editing it, checking structure, formulas, integrity identities and source tie-out, and ends in a prioritized issue log.
ginlix-ai/LangAlpha
Builds a live Excel DCF valuation workbook with free cash flow projections, WACC, terminal value, three scenarios, sensitivity grids and a reverse DCF.
helsome/folio
Financial statements, business segments, dividends, valuation multiples (PE/PB/PS), industry comparison, operating data, corporate actions, company and executive profiles, cross-stock comparison…
alirezarezvani/claude-skills
Runs financial ratio analysis, DCF valuation, budget variance reports and rolling forecasts from statement data using four bundled Python scripts.
HKUDS/Vibe-Trading
Index of Eastmoney's free, no-token market data interfaces for China A-shares and Hong Kong stocks: fund flows, dragon-tiger lists, margin trading, reports and news.
HKUDS/Vibe-Trading
Retrieves public OKX cryptocurrency market data such as spot prices, candlesticks, funding rates and open interest through the OKX V5 REST API, with no authentication.
HKUDS/Vibe-Trading
Fetches U.S. SEC EDGAR data: resolves tickers to CIK numbers, lists recent 10-K, 10-Q and 8-K filings with document URLs, and pulls XBRL financial series.
HKUDS/Vibe-Trading
Predicts whether a mainland China A-share company risks an ST or *ST warning after its next annual report, using financial thresholds and Sina penalty records.
HKUDS/Vibe-Trading
Breaks a structural trend such as AI infrastructure into its physical supply chain and ranks lesser-known listed companies sitting on each bottleneck.
HKUDS/Vibe-Trading
Plans and drafts an eight-part, roughly 120k-word investigative series on one company, built around a strict fact-check pass rather than fast drafting.
Categories
Walks through company valuation with DCF, dividend discount and sum-of-the-parts models, relative multiples, sensitivity tables and a valuation-trap checklist. A valuation framework covering absolute methods (discounted cash flow, the dividend discount model and sum of the parts) and relative methods based on PE, PB and EV-EBITDA. The DCF section gives the formulas for enterprise, equity and per-share value, then walks through forecasting free cash flow, calculating WACC, estimating terminal value and building a sensitivity table of value per share against WACC and growth.
Company Valuation Methods fits situations like: estimating a company's intrinsic value with a discounted cash flow model; valuing a dividend-paying stock such as a bank or a utility; valuing a diversified conglomerate segment by segment; testing how sensitive a valuation is to WACC and terminal growth.
Run `npx skills add HKUDS/Vibe-Trading --skill valuation-model -a claude-code`. Or copy the skill folder (agent/src/skills/valuation-model in HKUDS/Vibe-Trading) into .claude/skills/valuation-model in your project. Claude Code loads it when a task matches its description.
Run `npx skills add HKUDS/Vibe-Trading --skill valuation-model -a codex`. Or copy the skill folder (agent/src/skills/valuation-model in HKUDS/Vibe-Trading) into .agents/skills/valuation-model in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add HKUDS/Vibe-Trading --skill valuation-model -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/valuation-model, .gemini/skills/valuation-model, .github/skills/valuation-model and .opencode/skills/valuation-model in your project.
SKILL.md names no scripts, command-line tools or credentials: Company Valuation Methods is instructions for the agent only.
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
Company Valuation Methods is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
About 2.2k tokens (SKILL.md is roughly 9k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
Skills that share tags, products or a category with Company Valuation Methods: Three-Statement Model Builder (ginlix-ai/LangAlpha, 1.8k stars), Money Finance (iamzifei/show-me-the-money, 1k stars), Financial Model Checker (ginlix-ai/LangAlpha, 1.8k stars) and DCF Model Builder (ginlix-ai/LangAlpha, 1.8k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
HKUDS (a GitHub organization) maintains it in HKUDS/Vibe-Trading, which has 34,949 GitHub stars. The repository holds 89 skills in this directory. The repository was last updated on October 8, 2026.
Source: HKUDS/Vibe-Trading on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.