预测企业十三周现金流
依据实际收付款时间编制十三周现金流预测,标出余额缺口和下行情景,并梳理可能的资金缓解措施。
完整提示词
<context>
You build a 13-week cash flow forecast the way a turnaround or treasury professional does: direct method (actual receipts and payments by week, not profit), conservative on timing of cash in, realistic on cash out, and updated weekly. Thirteen weeks is a quarter: long enough to see payroll, rent, tax and loan cycles collide, short enough to forecast from known invoices and bills. The point is to spot a shortfall six or eight weeks out, while there is still time to chase customers, move a payment or arrange financing, rather than discovering it the week payroll bounces.
Starting cash: {{starting_balance}}
{{#minimum_balance}}Minimum comfortable balance: {{minimum_balance}}{{/minimum_balance}}
</context>
<task>
Data:
<cash_data>
{{cash_data}}
</cash_data>
1. Set week 1 from the stated start date (or ask for it), and lay out weeks 1 to 13 with week-ending dates.
2. Receipts: place each receivable in the week it is likely to arrive, not when it is due. Apply each customer's known payment behaviour; if unknown, assume a lag (for example, 15 days after due) and say so. Put uncertain new sales in a separate line so they can be switched off.
3. Payments: payroll and payroll taxes on their actual dates, rent, loan repayments, supplier payments on their terms, recurring software and utilities, sales tax or VAT and income tax payments, and any known one-offs.
4. Compute net cash flow and closing balance each week. Opening balance of week 1 = starting cash.
5. Mark every week where the closing balance falls below the minimum balance (or zero), and the lowest point in the 13 weeks.
6. Run a downside case: the largest single expected receipt arrives 30 days later than in the base case and uncertain sales do not arrive. Name the receipt you moved and report the lowest balance in that case.
7. List levers to close each gap, with the amount and the week it would help: collect specific overdue invoices, invoice earlier or ask for deposits, negotiate supplier timing, defer discretionary spend, and financing options in general terms.
</task>
<constraints>
{{> guardrails/professional-limits}}
- Use only the data given; any amount you had to estimate is labelled "est." and listed in the assumptions. Never invent customers, bills or dates.
- Arithmetic must be exact: each week's opening balance equals the previous week's closing balance. If you can run code or a spreadsheet, build the weekly table there and paste the result; otherwise list each week's items before totalling, then re-add the closing-balance row once before answering.
- A date that falls on a weekend stays in the week that contains it; say so once in the assumptions rather than moving payments silently.
- Do not recommend specific lenders or financing products, and do not advise on whether to delay tax or payroll payments; if those look necessary, say this needs urgent advice from an accountant or insolvency professional, since rules and penalties are serious.
- If a shortfall is within the next four weeks, put it in the headline and say so plainly.
- If the start date or a key element (payroll, receivables) is missing, ask for it before building the forecast.
{{> output/uncertainty}}
</constraints>
<output_format>
## Headline
Three lines: lowest balance and week, first shortfall week (or none), downside-case lowest balance.
## 13-week forecast
Table with weeks as columns (W1 to W13 with dates) and rows: opening balance, each receipt line, total receipts, each payment line, total payments, net flow, closing balance, below minimum (yes or blank).
## Shortfall weeks
Bullets: week, amount short, cause.
## Levers
Table: lever | amount | week it helps | effort or risk.
## Assumptions
Bullets.
## Weekly update routine
Short checklist: replace forecast with actuals, roll forward a week, compare variance.
</output_format>可替换内容
- {{starting_balance}}
- {{#minimum_balance}}
- {{minimum_balance}}
- {{/minimum_balance}}
- {{cash_data}}
- {{> guardrails/professional-limits}}
- {{> output/uncertainty}}
分类与标签
财务理财、现金流预测、企业财务、资金缺口、情景分析