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
153
Management Accounting & FP&A
IntermediateSaaS Rule of 40 Performance Review
Calculates the balance between growth and profitability for technology companies.
GPT-4oClaude 3.5 Sonnet
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
159