What is a 13-week rolling cash flow forecast model?
As the name suggests, this model helps you forecast weekly business cash flow over a period of 13 weeks by subtracting cash disbursements (outflows) from cash receipts (inflows) for every week.
Why should you download this template?
This free ready-to-use Excel template makes it easy for treasury professionals to proactively plan, record, and manage the company’s cash. It allows you to compare predicted cash receipts and payments against your operational costs and other outflows on a daily, weekly, and monthly basis.
How to use the 13-week cash flow forecast template?
List the dates for each week, starting with the first week of your forecast, and enter the expected cash inflows and cash outflows for each week.
In the "Net Cash Flow" column, subtract the cash outflows from the cash inflows to calculate the net cash flow for each week. Then, calculate the total cash inflows, outflows, and the total net cash flow for the forecast period.