[Excel Template] 13-Week Cash Flow Forecast For Treasury Professionals

[Excel Template] 13-Week Cash Flow Forecast For Treasury Professionals

27 June, 2023

Trusted by 1000+ Enterprise and Mid Market Businesses WorldWide

customers-logo
CONTENT
What is a 13-week rolling cash flow forecast model?
Why should you download this template?
How to use the 13-week cash flow forecast template?
Print Bookmark

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.

highradius

Most Popular Resources

All Topics
Cash Forecasting
Treasury & Risk