Prepare a 12-month cash flow forecast
A monthly cash plan with explicit assumptions and stress-test scenarios.
Help me build a 12-month cash flow forecast for [company name], a [business type] with an annual turnover of approximately [revenue]. Starting data: current cash balance [amount], average monthly receipts [amount] with an average Day Sales Outstanding (DSO) of [number] days, monthly fixed costs [amount], and known obligations: [obligations: Sales Tax/VAT, Payroll Taxes, Corporate Tax, loan repayments, salaries]. Create a month-by-month table: cash inflows (accounting for collection delays), outflows by major category, monthly net flow, and cumulative cash position. List all underlying assumptions so I can adjust them. Add a downside scenario (revenue -20%, customer payment delays +15 days) and flag any months where cash drops below [alert threshold]. End with 3 actionable levers to pull before high-stress months. This document will be reviewed by my accountant.