Intermediate

Cash Flow Forecast (Direct Method)

Projects short-term liquidity based on expected cash receipts and disbursements.

Create a 13-week cash flow forecast for {company_name}. Use the following inputs: Beginning Cash {start_balance}, Projected AR Collections {ar_collections}, Planned AP Payments {ap_payments}, and Payroll {payroll_cycle_amount}. Identify any weeks where the cash balance falls below the {minimum_cash_reserve} and suggest mitigation steps.

Related Prompts

Management Accounting & FP&A

Intermediate

Inventory Valuation: LIFO vs FIFO Impact

Analyzes the effect of inventory cost flow assumptions on COGS and taxes.

GPT-4oGemini 1.5 Pro

172

Management Accounting & FP&A

Advanced

Allocating Shared Service Costs (Corporate Overhead)

Determines how to charge back HR, IT, and Finance costs to operating business units.

Claude 3.5 Sonnet

167

Management Accounting & FP&A

Intermediate

Margin Bridge (EBITDA Bridge) Narrative

Explains the 'walk' from last year's EBITDA to this year's EBITDA.

GPT-4oClaude 3.5 Sonnet

160