原文核对：2026-10-13 · 中文正文 · 英文提示词与演示
场景定位
提供输入与模型约束，生成可编辑工作簿，保留原始时间粒度，标记安全余额突破并解释现金压力驱动因素。
- 难度
- 中级
- 时间跨度
- 30 分钟
适合用于
- 建立 13 周或月度现金预测的财务运营团队。
- 需整合回款、工资、供应商付款和营运资本假设的预测。
- 会议前审阅资金可支撑时间、安全余额和情景驱动因素的团队。
相关工具
构建可编辑预测工作簿，将公式连接假设，检查情景与输入缺口。
起步提示词
英文原文 · 可复制后按实际材料修改
Use $spreadsheets to build an editable cash-flow forecast workbook from the attached source files.
Use beginning cash, expected receipts, payroll, vendor payments, debt, tax, capex, working-capital items, and timing assumptions where available. Preserve the source cadence, whether weekly or monthly.
Include a summary view that flags the liquidity low point, the minimum ending cash balance, and any breach of the safety cash threshold. Use formulas so I can change assumptions later, and call out missing timing assumptions before using placeholders.简介
上传现金流输入、运营假设和约束，生成可检查修订、反映业务现实的工作簿。来源在 Drive 等连接工具时可提供文件引用。
建立预测
- 上传输入、运营假设和模型约束。
- 运行提示词，要求可编辑 .xlsx。
- 在 ChatGPT 中全屏打开，检查假设、公式、情景和摘要页。
- 在同一对话中调整回款、工资、付款、增长或安全余额假设。
生成后全屏检查时间假设、公式、情景和摘要，再继续修订同一工作簿。
审阅现金压力
使用前识别现金最低点、核对源输入，并列出待审阅假设。
官方提示词
英文原文 · 可复制后按实际材料修改
Review the cash-flow forecast.
Tell me:
- the first week or month cash drops below the safety balance
- the liquidity low point
- the main drivers of cash pressure
- formulas or tabs that do not tie to the source inputs
- assumptions that need human review
- which scenario I should review before using this with the team
Fix safe formatting or formula issues, then list anything I should review manually.运行情景
审阅后每次只修改一个驱动因素，方便观察影响。
官方提示词
英文原文 · 可复制后按实际材料修改
Add a scenario where [collections slow by X days, payroll increases by X%, vendor payments move earlier, or bookings increase by X% with collection timing of N days].
Keep the base case visible, update dependent formulas, and tell me how ending cash and the liquidity low point change.展开英文原文对照
Give ChatGPT cash-flow inputs and model constraints, then ask it to create an editable workbook that preserves the source cadence, flags safety-balance breaches, and shows which assumptions drive cash pressure.
Introduction
When you are building a cash-flow forecast, you want to make sure it is accurate and reflects the reality of your business. You can use ChatGPT to help you create a forecast workbook that you can inspect and revise in ChatGPT. Attach the cash-flow inputs, operating assumptions, and model constraints. You can also use file references when the inputs live in Google Drive or another connected source.
Make the forecast
- Attach the cash-flow inputs, operating assumptions, and model constraints.
- Run the starter prompt and ask for an editable .xlsx workbook.
- Open the workbook in ChatGPT. Expand it into the full-screen view to inspect assumptions, formulas, scenarios, and the summary tab.
- Continue in the same chat to change collections, payroll, vendor payment, growth, or safety-balance assumptions.
When the workbook appears in the chat, open it and expand it full-screen. Review the timing assumptions, formulas, scenarios, and summary tab, then ask ChatGPT to revise the same workbook from there.
Review cash pressure
Before using the forecast, ask ChatGPT to identify the low point, tie the workbook back to the source inputs, and list assumptions that need review.
官方提示词
英文原文 · 可复制后按实际材料修改
Review the cash-flow forecast.
Tell me:
- the first week or month cash drops below the safety balance
- the liquidity low point
- the main drivers of cash pressure
- formulas or tabs that do not tie to the source inputs
- assumptions that need human review
- which scenario I should review before using this with the team
Fix safe formatting or formula issues, then list anything I should review manually.Run a scenario
After reviewing the workbook in ChatGPT, use follow-up prompts to change one scenario driver at a time.
官方提示词
英文原文 · 可复制后按实际材料修改
Add a scenario where [collections slow by X days, payroll increases by X%, vendor payments move earlier, or bookings increase by X% with collection timing of N days].
Keep the base case visible, update dependent formulas, and tell me how ending cash and the liquidity low point change.