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.
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.
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.