原文核对：2026-10-13 · 中文正文 · 英文提示词与演示
场景定位
上传历史财务、估值假设和建模说明，创建可在 ChatGPT 中检查修订的 DCF 工作簿。
- 难度
- 中级
- 时间跨度
- 30 分钟
适合用于
- 依据历史财务和假设建模的分析师。
- 希望直接审阅迭代工作簿的财务团队。
- 从源文件准备估值模型的团队。
相关工具
根据上传输入、公式和假设创建可编辑工作簿。
起步提示词
英文原文 · 可复制后按实际材料修改
Use $spreadsheets to build a DCF workbook for the company in the attached source files.
Include explicit operating drivers for revenue growth, margins, capex, and working capital. Calculate unlevered free cash flow, WACC, terminal value, and enterprise value. If capital structure and diluted share count are provided, bridge to implied equity value and implied equity value per share.
Use any assumptions included in the source files. If an assumption is missing, add a clearly labeled placeholder in the assumptions tab instead of hiding it in a formula. If full balance sheet or cash-flow statement inputs are missing, create the operating forecast needed for unlevered free cash flow and flag the missing statement inputs.
Generate the result as an editable .xlsx workbook.简介
ChatGPT 可以创建可实际运行、检查和修订的 DCF 工作簿。
可综合历史财务、估值假设和建模笔记。直接上传，或提供 Drive 等来源的准确文件引用，比要求遍搜全部文件更有效。
创建工作簿
- 上传资料，或连同来源给出准确文件引用。
- 运行提示词，要求可编辑 .xlsx。
- 全屏检查模型页、公式、假设和估值摘要。
- 在同一对话中核对公式链接、修改假设、加入情景或完善模型。
打开后审阅源输入、预测驱动、估值输出和敏感性表，再修订同一文件。
检查估值
使用前，像财务同事一样检查来源勾稽、公式、硬编码假设和估值输出。
官方提示词
英文原文 · 可复制后按实际材料修改
Review the DCF workbook before I use it.
Check:
- historicals tied to the source files
- forecast drivers and visible assumptions
- formulas versus hardcoded values
- unlevered free cash flow calculation
- WACC, terminal value, enterprise value, and any equity-value bridge
- sensitivity table formulas
- missing capital structure, diluted share count, or assumptions that need human review
Fix safe formatting or formula issues, then list anything I should review manually.修改单个假设
每次聚焦一个驱动因素，便于检查影响。
官方提示词
英文原文 · 可复制后按实际材料修改
Update the DCF model so [revenue growth, EBITDA margin, WACC, terminal growth, or capex] uses [new assumption].
Keep the old assumption visible in a note, update dependent formulas, and tell me which tabs changed.展开英文原文对照
Attach historical financials, valuation assumptions, and modeling notes, then ask ChatGPT for an editable DCF workbook you can inspect and revise in ChatGPT.
Introduction
ChatGPT can help you create a fully functional DCF workbook that you can inspect and revise.
It can use multiple files as context, including the historical financials, valuation assumptions, and any modeling notes. You can provide these files directly, or use file references when the inputs live in Google Drive or another connected source. If so, provide the exact file references, as it will be more effective than asking ChatGPT to search through all of your files.
Create the workbook
- Attach the historical financials, valuation assumptions, and any modeling notes, or provide exact file references along with the source.
- Run the starter prompt and ask for an editable .xlsx workbook.
- Open the generated workbook in ChatGPT. Expand it into the full-screen view to inspect the model tabs, formulas, assumptions, and valuation summary.
- Continue in the same chat to check formula links, change assumptions, add scenarios, or tighten the model.
When the workbook appears in the chat, open it and expand it full-screen. Review the source inputs, forecast drivers, valuation outputs, and sensitivity tables, then ask ChatGPT to revise the same workbook from there.
Check the valuation
Before using the workbook, ask ChatGPT to review the model like a finance teammate would: source tie-outs, formulas, hardcoded assumptions, and valuation outputs.
官方提示词
英文原文 · 可复制后按实际材料修改
Review the DCF workbook before I use it.
Check:
- historicals tied to the source files
- forecast drivers and visible assumptions
- formulas versus hardcoded values
- unlevered free cash flow calculation
- WACC, terminal value, enterprise value, and any equity-value bridge
- sensitivity table formulas
- missing capital structure, diluted share count, or assumptions that need human review
Fix safe formatting or formula issues, then list anything I should review manually.Revise one assumption
After reviewing the workbook, ask for targeted revisions in the same chat. Change one driver at a time so the impact is easy to inspect.
官方提示词
英文原文 · 可复制后按实际材料修改
Update the DCF model so [revenue growth, EBITDA margin, WACC, terminal growth, or capex] uses [new assumption].
Keep the old assumption visible in a note, update dependent formulas, and tell me which tabs changed.