Intermediate
13-week cash flow forecast with receipts/disbursements
Builds a 13-week cash forecast structure and assumptions, including a weekly receipts/disbursements schedule. Useful for liquidity management and turnaround planning.
Build a 13-week cash flow forecast for {company_name}.
Inputs:
- Starting cash: {starting_cash}
- AR collections assumptions: {ar_collections}
- AP payment plan: {ap_payment_plan}
- Payroll and taxes schedule: {payroll_taxes}
- Debt service: {debt_service}
- Other cash items: {other_cash_items}
- Seasonality/events: {seasonality_events}
Output:
1) Weekly cash forecast table: Beg cash, Inflows, Outflows, Net, End cash.
2) Assumptions register and “what changed this week” section.
3) Liquidity risks and mitigation actions.
4) Data needed to improve forecast accuracy (top 5).
Make it simple enough to update weekly.Related Prompts
Management Accounting & FP&A
IntermediateInventory Valuation: LIFO vs FIFO Impact
Analyzes the effect of inventory cost flow assumptions on COGS and taxes.
GPT-4oGemini 1.5 Pro
0
0
172
Management Accounting & FP&A
AdvancedAllocating Shared Service Costs (Corporate Overhead)
Determines how to charge back HR, IT, and Finance costs to operating business units.
Claude 3.5 Sonnet
0
0
169
Management Accounting & FP&A
IntermediateMargin Bridge (EBITDA Bridge) Narrative
Explains the 'walk' from last year's EBITDA to this year's EBITDA.
GPT-4oClaude 3.5 Sonnet
0
0
160