Creating Financial Models
Chen-zexi/open-ptc-agent
This skill provides an advanced financial modeling suite with DCF analysis, sensitivity testing, Monte Carlo simulations, and scenario planning for investment decisions
构建DCF现金流折现模型和三表财务模型（利润表、资产负债表、现金流量表联动）. An agent skill from rongxinzy/RongxinAI.
Install Dcf Model Builder
$ npx skills add rongxinzy/RongxinAI --skill dcf-model-builder -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install rongxinzy/RongxinAI dcf-model-builder --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/rongxinzy/RongxinAI.git skills-src && mkdir -p .claude/skills && cp -r skills-src/SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builder .claude/skills/dcf-model-builder && 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 "dcf-model-builder" agent skill from https://github.com/rongxinzy/RongxinAI/tree/main/SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builder into .claude/skills/dcf-model-builder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "dcf-model-builder", 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/rongxinzy/RongxinAI/tree/main/SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builderType 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 rongxinzy/RongxinAI --skill dcf-model-builder -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install rongxinzy/RongxinAI dcf-model-builder --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/rongxinzy/RongxinAI.git skills-src && mkdir -p .agents/skills && cp -r skills-src/SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builder .agents/skills/dcf-model-builder && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "dcf-model-builder" agent skill from https://github.com/rongxinzy/RongxinAI/tree/main/SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builder into .agents/skills/dcf-model-builder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "dcf-model-builder", 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 rongxinzy/RongxinAI --skill dcf-model-builder -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install rongxinzy/RongxinAI dcf-model-builder --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/rongxinzy/RongxinAI.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builder .cursor/skills/dcf-model-builder && 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 "dcf-model-builder" agent skill from https://github.com/rongxinzy/RongxinAI/tree/main/SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builder into .cursor/skills/dcf-model-builder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "dcf-model-builder", 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/rongxinzy/RongxinAI.git --path SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builder--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 rongxinzy/RongxinAI --skill dcf-model-builder -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install rongxinzy/RongxinAI dcf-model-builder --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/rongxinzy/RongxinAI.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builder .gemini/skills/dcf-model-builder && 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 "dcf-model-builder" agent skill from https://github.com/rongxinzy/RongxinAI/tree/main/SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builder into .gemini/skills/dcf-model-builder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "dcf-model-builder", 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 rongxinzy/RongxinAI dcf-model-builderInstalls 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 rongxinzy/RongxinAI --skill dcf-model-builder -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/rongxinzy/RongxinAI.git skills-src && mkdir -p .github/skills && cp -r skills-src/SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builder .github/skills/dcf-model-builder && 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 "dcf-model-builder" agent skill from https://github.com/rongxinzy/RongxinAI/tree/main/SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builder into .github/skills/dcf-model-builder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "dcf-model-builder", 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 rongxinzy/RongxinAI --skill dcf-model-builder -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install rongxinzy/RongxinAI dcf-model-builder --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/rongxinzy/RongxinAI.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builder .opencode/skills/dcf-model-builder && 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 "dcf-model-builder" agent skill from https://github.com/rongxinzy/RongxinAI/tree/main/SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builder into .opencode/skills/dcf-model-builder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "dcf-model-builder", 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.
Facts
- Skill name
dcf-model-builder- GitHub stars
- 154
- Used in
- 1 other repo
- Token cost
- ~735 tokens
- SKILL.md length
- 187 words
- Files
- 1
- Skills in repo
- 94
- Repo updated
- First seen
- Licence
- AGPL-3.0
At a glance
构建DCF现金流折现模型和三表财务模型（利润表、资产负债表、现金流量表联动）. An agent skill from rongxinzy/RongxinAI.
- Works in 7 steps: ：业务理解与收入驱动 → ：利润表建模 → ：资产负债表建模 → …
- Tasks that involve Financial modeling
- SKILL.md covers 功能说明, 工作流, 输出格式 and 注意事项
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Dcf Model Builder is an agent skill from rongxinzy/RongxinAI. 构建DCF现金流折现模型和三表财务模型（利润表、资产负债表、现金流量表联动）。 触发词：DCF、现金流折现、财务建模、三表模型、估值模型、WACC、自由现金流、financial model、valuation model
Its SKILL.md is about 740 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
It sits in Business, Finance & HR, covering Financial modeling. The repository describes itself as: An all-in-one local AI Agent workspace with a fully self-developed stack. The licence is AGPL-3.0.
When your agent uses it
- Tasks that involve Financial modeling
Example prompts
- “/dcf-model-builder”
Workflow steps
7 steps, taken from the step headings in SKILL.md.
What it can do on your machine
Read from SKILL.md and the folder at commit aa2b27b. It shows what the files ask for, not the result of running them.
Tool permissions
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.
Runs code
No scripts in the folder and no shell commands in SKILL.md.
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Dcf Model Builder loads about 735 tokens when it runs. Until then it costs about 32 tokens; SKILL.md has 187 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.
Safety
Auto-check passed
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.
SKILL.md
The full file from rongxinzy/RongxinAI at commit aa2b27b, republished under its AGPL-3.0 licence (© rongxinzy). 187 words, ~735 tokens.
Download SKILL.mdSave it as
.claude/skills/dcf-model-builder/SKILL.md (or your agent's skills folder).- name
- dcf-model-builder
- description
- 构建DCF现金流折现模型和三表财务模型（利润表、资产负债表、现金流量表联动）。 触发词：DCF、现金流折现、财务建模、三表模型、估值模型、WACC、自由现金流、financial model、valuation model
DCF 模型与财务建模
功能说明
构建从收入驱动到估值输出的完整财务模型，包括：
- 三表联动模型：利润表 → 资产负债表 → 现金流量表的完整闭环
- DCF 估值：基于自由现金流折现推导内在价值
- 敏感性分析：关键假设变动对估值的影响
工作流
Phase 1：业务理解与收入驱动
- 拆解业务结构和收入驱动因子：
- 按产品线/区域/客户类型分拆收入
- 识别量/价驱动因子（如用户数 × ARPU、门店数 × 坪效）
- 建立收入预测框架（3-5 年预测期）
- 确定增长假设的依据和来源
Phase 2：利润表建模
- 收入预测（基于 Phase 1 驱动因子）
- 成本结构分析：
- 固定 vs 可变成本
- 规模效应和经营杠杆
- 各项费用率假设：
- COGS / 毛利率
- 销售费用率、管理费用率、研发费用率
- 营业利润 → 税前利润 → 净利润
- 折旧/摊销/股权激励等非现金项
Phase 3：资产负债表建模
- 营运资金预测：
- 应收账款周转天数
- 存货周转天数
- 应付账款周转天数
- 资本支出（Capex）预测
- 固定资产和无形资产
- 债务结构和偿还计划
- 股东权益变动
Phase 4：现金流量表建模
- 经营活动现金流（间接法）：
- 净利润 + 折旧摊销 + 营运资金变动
- 投资活动现金流：
- Capex + 收购/处置
- 筹资活动现金流：
- 借款/还款 + 股息 + 回购/增发
- 自由现金流推导：
- FCFF = EBIT × (1-T) + D&A - Capex - ΔWC
- FCFE = FCFF - 利息 × (1-T) + 净借款
Phase 5：WACC 计算
- 权益成本（Ke）：
- 无风险利率（10Y 国债）
- 市场风险溢价（ERP）
- Beta（行业/个股）
- 规模溢价（如适用）
- 债务成本（Kd）：
- 借款利率或债券收益率
- 税盾效应
- 资本结构：
- 目标/当前 D/E 比率
- WACC = Ke × E/(D+E) + Kd × (1-T) × D/(D+E)
Phase 6：DCF 估值
- 预测期自由现金流折现
- 终值（Terminal Value）计算：
- 永续增长法：TV = FCF_n × (1+g) / (WACC - g)
- 退出倍数法：TV = EBITDA_n × Exit Multiple
- 企业价值 = PV(FCF) + PV(TV)
- 股权价值 = EV - 净债务 - 少数股东权益 + 联营投资
- 每股价值 = 股权价值 / 稀释后股份数
Phase 7：敏感性分析
- 双变量敏感性表：
- WACC vs 永续增长率
- 收入增速 vs 利润率
- 情景分析：牛市/基本/熊市
- 终值占比检查（>75% 需警示）
输出格式
模型假设表
假设项 | 来源/依据 | 预测值
---------------|---------------|------
收入增速 Y1-Y3 | [依据] | XX%
长期利润率 | [依据] | XX%
Capex/Revenue | [依据] | XX%
WACC | 计算得出 | XX%
永续增长率 | [依据] | XX%DCF 估值总结
| 熊市 | 基本 | 牛市
-------------------|---------|---------|--------
WACC | X.X% | X.X% | X.X%
永续增长率 | X.X% | X.X% | X.X%
预测期FCF现值 | ¥XXX | ¥XXX | ¥XXX
终值现值 | ¥XXX | ¥XXX | ¥XXX
企业价值 | ¥XXX | ¥XXX | ¥XXX
(-) 净债务 | ¥XXX | ¥XXX | ¥XXX
股权价值 | ¥XXX | ¥XXX | ¥XXX
每股价值 | ¥XX | ¥XX | ¥XX
当前股价 | ¥XX | |
隐含上行/下行 | XX% | XX% | XX%
终值占比 | XX% | XX% | XX%敏感性矩阵
| WACC
永续增长率 | 8.0% | 8.5% | 9.0% | 9.5% | 10.0%
-----------|-------|-------|-------|-------|------
1.0% | ¥XX | ¥XX | ¥XX | ¥XX | ¥XX
1.5% | ¥XX | ¥XX | ¥XX | ¥XX | ¥XX
2.0% | ¥XX | [基本] | ¥XX | ¥XX | ¥XX
2.5% | ¥XX | ¥XX | ¥XX | ¥XX | ¥XX
3.0% | ¥XX | ¥XX | ¥XX | ¥XX | ¥XX注意事项
- 三表必须联动闭合（资产 = 负债 + 权益，现金变动一致）
- 终值假设对结果影响巨大，永续增长率通常不超过 GDP 增速
- WACC 各组成部分须有明确来源和论证
- 区分 FCFF（企业自由现金流）和 FCFE（股权自由现金流）的适用场景
- 周期性行业注意使用中周期正常化盈利
- 高增长公司可适当延长预测期（但需论证）
- 所有假设标注来源，区分事实数据与分析师判断
© rongxinzy, AGPL-3.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
Just SKILL.md in SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builder of rongxinzy/RongxinAI.
Open the folder on GitHubat commit aa2b27b
Used in 1 other repository
We found 1 copy of this SKILL.md (exact, near-identical or edited) in other folders, from 1 other GitHub owner. This page covers the copy in rongxinzy/RongxinAI, which our catalogue first saw on October 7, 2026.
Compare with similar skills
Dcf Model Builder 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 |
|---|---|---|---|---|---|---|
| Dcf Model Builder this skillrongxinzy/RongxinAI | 154 | 1 repos | ~735 | Automated safety check: Pass | AGPL-3.0 | |
| Creating Financial ModelsChen-zexi/open-ptc-agent | 729 | 3 repos | ~1.3k | Automated safety check: Pass | MIT | |
| Equity ResearchrollingSirius/equity-research-skill | 453 | — | ~1.5k | Automated safety check: Pass | MIT | |
| Startup Financial Modelingnicepkg/auto-company | 194 | 11 repos | ~2.8k | Automated safety check: Pass | None | |
| Stock Value AnalyzerFunnyKun/stock-value-analyzer | 140 | — | ~3.3k | Automated safety check: Pass | None | |
| Dcf Valuationedinetdb/dexter-jp | 311 | — | ~1.1k | Automated safety check: Pass | MIT |
Similar skills
Equity Research
rollingSirius/equity-research-skill
撰写机构级个股投资研究报告（二级市场深度研究）。Use whenever the user wants to research, analyze, or value a specific publicly-traded stock — e.g.
Startup Financial Modeling
nicepkg/auto-company
This skill should be used when the user asks to "create financial projections", "build a financial model", "forecast revenue", "calculate burn rate", "estimate runway", "model cash flow", or…
Stock Value Analyzer
FunnyKun/stock-value-analyzer
基于邱国鹭《投资中最简单的事》方法论的股票价值分析器（v2.0 双层架构）。通过"三好原则"（好行业、好公司、好价格）系统评估一只股票是否值得投资。v2.0 在原定性框架之上注入一套可量化、可复现的硬模型层——反向 DCF 反解市场隐含增速、情景概率加权估值、EPV 盈利能力价值、分行业估值路由、杜邦三/五因子分解、ROIC vs WACC、Piotroski F-Score、Beneish…
Dcf Valuation
edinetdb/dexter-jp
Performs discounted cash flow (DCF) valuation analysis to estimate intrinsic value per share for Japanese listed companies.
Company Valuation
himself65/finance-skills
Estimate a public company's intrinsic value with DCF, relative (peer multiple), and sum-of-the-parts (SOTP) methods, then blend them into an implied share price with upside/downside vs the market…
More from rongxinzy/RongxinAI
All 94 skills in this repoSaaS Metrics Coach
rongxinzy/RongxinAI
SaaS financial health advisor. An agent skill from rongxinzy/RongxinAI.
Churn Prevention
rongxinzy/RongxinAI
Reduce voluntary and involuntary churn through cancel flow design, save offers, exit surveys, and dunning sequences.
Presentation Studio
rongxinzy/RongxinAI
The only skill for creating a new PowerPoint deck. An agent skill from rongxinzy/RongxinAI.
Zhiyuan Expert Manager
rongxinzy/RongxinAI
ZhiYuan Agent expert package lifecycle manager for the pi engine.
Ziwei Doushu
rongxinzy/RongxinAI
Professional Ziwei Doushu consultation skill with an offline calculation engine.
Lark Mail
rongxinzy/RongxinAI
飞书邮箱：Use when user mentions 起草邮件、写邮件、草稿、发送/回复/转发邮件、查阅邮件、看邮件、搜索邮件、邮件文件夹、邮件标签、邮件联系人、监听新邮件、邮件收信规则等；use for mail/email intent only.
Related
Categories
Questions about Dcf Model Builder
What does Dcf Model Builder do?
构建DCF现金流折现模型和三表财务模型（利润表、资产负债表、现金流量表联动）. An agent skill from rongxinzy/RongxinAI. Dcf Model Builder is an agent skill from rongxinzy/RongxinAI.
When should I use Dcf Model Builder?
Dcf Model Builder fits situations like: tasks that involve Financial modeling.
How do I install Dcf Model Builder in Claude Code?
Run `npx skills add rongxinzy/RongxinAI --skill dcf-model-builder -a claude-code`. Or copy the skill folder (SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builder in rongxinzy/RongxinAI) into .claude/skills/dcf-model-builder in your project. Claude Code loads it when a task matches its description.
How do I install Dcf Model Builder in Codex?
Run `npx skills add rongxinzy/RongxinAI --skill dcf-model-builder -a codex`. Or copy the skill folder (SKILLs/zhiyuan-expert-manager/presets/equity-research/skills/dcf-model-builder in rongxinzy/RongxinAI) into .agents/skills/dcf-model-builder in your project. Codex loads it when a task matches its description.
Can I use Dcf Model Builder in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add rongxinzy/RongxinAI --skill dcf-model-builder -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/dcf-model-builder, .gemini/skills/dcf-model-builder, .github/skills/dcf-model-builder and .opencode/skills/dcf-model-builder in your project.
What does Dcf Model Builder need to run?
SKILL.md names no scripts, command-line tools or credentials: Dcf Model Builder is instructions for the agent only.
Does Dcf Model Builder access the network?
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.
Is Dcf Model Builder safe to install?
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.
What licence does Dcf Model Builder use?
Dcf Model Builder is published under the AGPL-3.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Dcf Model Builder use?
About 735 tokens (SKILL.md is roughly 2.9k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Dcf Model Builder?
Skills that share tags, products or a category with Dcf Model Builder: Creating Financial Models (Chen-zexi/open-ptc-agent, 729 stars), Equity Research (rollingSirius/equity-research-skill, 453 stars), Startup Financial Modeling (nicepkg/auto-company, 194 stars) and Stock Value Analyzer (FunnyKun/stock-value-analyzer, 140 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Dcf Model Builder?
rongxinzy (a GitHub organization) maintains it in rongxinzy/RongxinAI, which has 154 GitHub stars. The repository holds 94 skills in this directory. The repository was last updated on October 9, 2026.
Source: rongxinzy/RongxinAI on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.