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
0
0
155
Management Accounting & FP&A
Advanced

SaaS Churn & LTV Analysis Model

Generates a Python script or Excel logic to calculate SaaS metrics. Perfect for FP&A professionals in the tech industry.

GPT-4oClaude 3.5 Sonnet
0
0
136
Management Accounting & FP&A
Intermediate

SaaS Rule of 40 Performance Review

Calculates the balance between growth and profitability for technology companies.

GPT-4oClaude 3.5 Sonnet
0
0
173