Cash flow forecasting: 12-month rolling projections for strategic growth

Published 24 March 2026

Table of contents

• What is cash flow forecasting?
• Why rolling forecasts matter
• Build your 12-month cash flow forecast
• Plan for different scenarios: best, worst, and likely cases
• Using forecasts to plan growth investments
• When to update your rolling cash forecast
• Take control of cash flow forecasting with Xero
• FAQs on cash flow forecasting

Key takeaways

• Rolling 12-month cash flow forecasts maintain a consistent time period and roll forward at the end of each month.
• Rolling forecasts enable companies to respond more quickly to marketplace changes than annual budgets, which only update once a year.
• Scenario planning is a cash flow forecasting technique that compares a most likely case (baseline), best case, and worst case scenario to show how changes in income or costs may affect cash.
• Companies use rolling cash flow forecasts for short-term liquidity planning, debt management, and growth investment planning.

What is cash flow forecasting?

Cash flow forecasting estimates how money will move in and out of your business in the future. It shows whether you’ll have enough cash to meet your obligations, fund operations, and invest in growth.

While budgets are financial plans that are 'locked in' for the year, forecasts evolve as your business and market conditions change. This makes them useful to help business leaders manage their business’s cash flow and make informed financial decisions.

Here’s more on the basics of cash flow forecasting.

Why rolling forecasts matter

Rolling forecasts are continuously updated financial planning methods in which a new future period is added as each current period ends, keeping the forecast horizon constant (e.g., always looking 12 months ahead). Rolling 12-month cash flow projections support agile financial planning, which in turn helps executives and boards of directors pay bills on time, adapt to changing conditions, and set goals for growth.

Lenders, investors, and boards also often need regular forecasts as part of compliance reporting or loan covenants. Up-to-date projections help meet these requirements and show proactive risk management.

Rolling forecasts adapt to changing conditions

A rolling forecast is more responsive to changes in revenue, expenses, and market conditions, making it an important tool for managing your cash flow. This is because a rolling cash-flow forecast continuously extends your financial outlook. Each month, you update your forecast by removing the completed time period and adding a new one, giving you a consistent 12-month view of your cash flow.

With this up-to-date reporting, you can respond quickly to new information, shifting demand, or capital opportunities without waiting for the next annual cycle.

Rolling forecasts support strategic growth planning

Rolling forecasts turn financial reporting into a decision-making tool. By integrating actual results into cash flow forecasts each month and regularly looking ahead, you can track sales trends, margin pressures, and cost fluctuations in real time.

This visibility helps you identify the best time to invest in new locations, expand your team, delay capital expenditures, and seek funding to manage your liquidity.

A 12-month rolling forecast supports longer-term strategic planning by helping you:

• make investment decisions by identifying when and where to allocate capital for the best return
• plan and manage resources, such as people, equipment, or office space, to meet future demand
• anticipate periods of tight cash flow and take action early, such as securing funding (approaching investors, refinancing loans, or extending credit)

A shorter-term 13-week (90-day) forecast complements this by helping you manage:

• short-term liquidity, ensuring you have enough cash to cover immediate obligations
• cash flow timing, by tracking when income is received and expenses are paid

Using both forecast types gives you visibility into immediate cash needs while supporting more informed, strategic decision-making.

Here’s help from the Australian government on improving your cash flow.

Build your 12-month cash flow forecast

You can build your rolling forecast in a spreadsheet, accounting software, or other forecasting tool. This way, you can link your cash flow projection to the timing of invoices you’ve raised against your expected payments.

Here are the basic steps:

1. Confirm your opening cash balance

Begin with your current cash position – this is what’s actually in the bank. The starting balance anchors your forecast and gives you context for projected inflows and outflows.

But first, make sure your books are up to date (reconciled) before you start. This will help prevent any discrepancies affecting your forecasts over time.

2. Estimate your cash inflows

There are three steps here:

• Record your revenue projections, ideally linked to sales forecasts or pipeline data.
• Factor in debtor days or collection patterns. For example, if your average debtor period is 45 days, your December sales might not be collected until February. Including these assumptions regularly helps keep your forecasts realistic.
• Include expected loan drawdowns, asset sales, grants, or tax refunds. These inflows often have longer lead times, so consider projected timeframes for these sources carefully.

3. Project your cash outflows

To start, set a baseline for operating expenses by reviewing current spending patterns, including average monthly payroll, rent, utilities, and subscriptions (like software). Then:

• Include your payroll – usually a large and predictable outflow. Account for pay cycles, superannuation, bonuses, and planned new hires in your forecast.
• Include capital expenditure and major projects, noting timings and funding sources. In your projection, spread out large purchases and align them with expected inflows to ease the pressure at times when you expect cash flow to be tight.
• Finally, adjust your projected outflows for inflation, cost increases, or planned initiatives. Group these by department or cost centre for clarity.

4. Apply the rolling forecast formula

Use this simple model to underpin your cash flow forecast:

Closing cash balance opening cash + cash inflows – cash outflows

With this model, your closing balance at the end of each month becomes the opening balance for the next.

By regularly updating inflows, outflows, and assumptions figures, you keep a live forecast that’s consistently looking 12 months ahead.

Plan for different scenarios: best, worst, and likely cases

Creating different cash flow scenarios helps you understand how your finances might change if conditions go better or worse than you expect. This allows you to plan for risks, seize opportunities, and make confident growth decisions.

Common cash flow scenarios are the baseline (most likely), best-case and worst-case scenarios. Here’s what they are and what you can use them for:

Create your baseline “most likely” scenario

Your baseline scenario reflects the business’s expected performance under current conditions, based on confirmed orders, typical margins, and known cost trends.

Use your most recent actuals as a starting point, then project forward using realistic assumptions for revenue, costs, and payment timing. This forms the reference point for other scenarios.

Model best-case scenarios for growth opportunities

A best-case scenario explores what happens if things go better than expected – for example, stronger sales, improved margins, or faster customer payments.

To build this scenario, adjust key drivers upward (e.g., increase sales volume, improve pricing, shorten receivable days) and assess how much additional cash becomes available for reinvestment or expansion.

Prepare worst-case scenarios for risk management

A worst-case scenario models potential downside risks, such as delayed collections, higher costs, or the loss of a key customer.

To create this, apply conservative assumptions (e.g., lower revenue, higher expenses, slower payments) to understand how your cash position could be affected – and whether you would need to reduce costs or secure additional funding.

Key variables to adjust across scenarios

By adjusting certain key variables between these three scenarios, you can test how different decisions or market shifts might affect cash flow, and how resilient the business is to these changes. This gives decision-makers a chance to respond quickly to these scenarios.

The common variables to adjust and test are:

• sales volume or pricing changes
• cost of goods sold or supplier pricing
• payroll and headcount
• capex timing or project deferrals
• tax payments and financing terms

Adjust one or more of these variables in each scenario to test how sensitive your cash flow is to change.

Using scenarios to make better decisions

Compare your projected cash position across scenarios to understand both risk and opportunity. This helps identify potential shortfalls early, plan mitigating actions, and confidently invest when conditions are favorable.

Using forecasts to plan growth investments

A 12-month rolling cash flow forecast highlights when surplus cash is expected, so you can allocate funds strategically (ATO website) and make informed investment decisions.

Your forecasts can help in three key areas.

Timing major expenditures and expansion

Use forecasted data to schedule major purchases, upgrade your systems, or open new sites.

Aligning capital spending with strong projected cash periods can reduce the chance of the business needing to borrow more money to invest.

Testing acquisition scenarios

Before pursuing an acquisition or merger, you can integrate its projected inflows and outflows into the rolling cash forecast to reveal whether the business can absorb the investment without running short of cash.

Balancing growth with liquidity requirements

Sustained growth requires businesses to closely monitor their investments against expected future financial obligations.

A rolling 12-month forecast helps you strike the right balance between overspending – creating a liquidity shortfall – and missing out on growth opportunities. It helps give your executives, investors, and lenders confidence that planned growth demonstrates ambition while remaining calculated and financially sustainable.

When to update your rolling cash forecast

Regular forecast updates help improve the model’s accuracy and credibility. Many mid-sized and larger businesses update rolling forecasts monthly, and align it with their management reporting.

But during periods of rapid change – like expansion or market volatility – a weekly update can give you more oversight and control.

Compare forecast to actuals

Compare the business’s actual cash flow outcomes to the rolling forecast each month to identify timing differences or structural changes in performance.

Adjust assumptions based on performance

Refine your assumptions when patterns emerge in your cash flow reporting. Look for patterns like:

• customers paying slower than expected
• supplier costs increasing
• sales consistently beating forecast

Avoid common forecasting mistakes

To deliver credible reporting, watch out for common mistakes in cash flow forecasting:

• Relying on static budgets: Don’t treat forecasts as fixed – unlike static budgets, rolling forecasts are meant to evolve over time.
• Timing differences: Even profitable businesses can face liquidity crunches if inflow timing is off.
• Ownership: Make sure each department leader knows, and contributes, the data they’re responsible for to make sure forecasts are correct.
• Version control: Keep one live version, with historical versions archived for auditing and learning.

Take control of cash flow forecasting with Xero

Xero’s cash flow forecasting and reporting features make it easier to manage rolling cash flow projections.

By integrating real-time bank data, invoices, and bills, it helps you update your forecasts with minimal manual data entry.

Your finance teams can build best- and worst-case scenarios, track actuals against projections, and share clear visual dashboards with your executives and the board.

Xero gives you live financial data to build accurate forecasts, turning cash flow visibility into strategic foresight and a powerful business advantage.

Get one month free

FAQs on cash flow forecasting

What's the difference between a budget and a rolling forecast?

A budget sets fixed financial targets for a set period – often a year. A rolling forecast continuously updates your financial projections based on actual results and changing conditions.

How far ahead should I forecast my cash flow?

Most structured businesses maintain a 12-month rolling forecast because it supports budgeting, funding decisions, and longer-term planning, adding a new month as each period ends. But to manage your short-term liquidity, a separate 13-week (quarterly) view is often best.

How do I create best- and worst-case scenarios?

Start with your baseline projection, then adjust key variables, like sales, costs, collections, and capex, to model the best-case (optimistic) and conservative (worst-case) outcomes.

How often should I update my rolling forecast?

Under normal operating conditions, it’s probably enough to update your forecast monthly. But during growth phases or periods when cash is tight, you might find it better to update your forecast weekly – for example, so you have the latest view of your cash flow if you need to take action immediately.

What's the most important metric in cash flow forecasting?

Your closing cash balance is the key cash flow forecasting metric. It shows whether your business can meet its commitments and fund investment, and how prepared you’ll be for challenging market conditions.