Closing cash, December
$112,700
Lowest cash balance
$28,800
Months below minimum
0
12-Month Cash Flow Forecast
Monthly receipts and payments with opening and closing cash, the lowest point and how many months it covers.
SpreadsheetCash Flow ManagementFree
Week-by-week cash in and out for the next quarter, with your lowest point, shortfalls and runway.
Shown with sample data
Week-by-week cash in and out for the next quarter, with your lowest point, shortfalls and runway.
Latest: $16,750
The 13-week cash flow forecast is the tool lenders, CFOs and turnaround advisers rely on to manage liquidity. Enter expected receipts and payments for each week; the forecast rolls the balance forward, flags any week below your minimum cash buffer or overdrawn, finds the lowest point in the quarter and when it happens, and shows how many weeks of costs your cash covers.
Thirteen weeks is one quarter: long enough to see problems coming and short enough to forecast accurately week by week.
The cash you never want to drop below, often two to four weeks of fixed costs.
Today's cash divided by average weekly money out across the 13 weeks.
Download a copy
Downloads need a free account.