Posted in

5 Free Cash Flow Projection Templates in Excel

5 Free Cash Flow Projection Templates in Excel – free download preview

Reviewed & updated by WordNExcel Team — Updated November 6, 2026

A cash flow projection template shows how much cash you expect to come into and go out of your business each month, and what your bank balance will be at the end of each period. On this page you can use the free cash flow projection calculator above to see a quick six-month forecast, then download five free cash flow projection templates in Excel: a 12-month cash flow projection, a 13-week cash flow forecast and a startup cash flow projection, plus a daily cash position sheet and a cash flow budget vs actual.

Each file is a real, editable .xlsx spreadsheet created for this page. Totals for cash in and cash out, net cash flow and opening and closing balances are calculated automatically, and each sheet shows the lowest closing balance so you can spot a cash shortfall before it happens. The templates open in Excel, Google Sheets and LibreOffice Calc and print in landscape on one page.

Cash Flow Projection Calculator (6 Months)

MonthCash inCash outNetClosing
Closing cash after 6 months: 0.00
Lowest balance: 0.00

Runs in your browser; nothing is sent or saved. A quick estimate only; use the spreadsheet for line-by-line planning.

Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.

What Is a Cash Flow Projection?

A cash flow projection, also called a cash flow forecast, is an estimate of the money that will move in and out of your business over a future period. It starts with the cash you have today, adds expected receipts such as sales and customer payments, subtracts expected payments such as wages, rent and supplier bills, and shows the closing balance for each week or month.

Profit and cash are not the same. A business can be profitable on paper and still run out of cash, for example when customers pay late, stock has to be bought in advance or a large tax bill falls due. A cash flow projection shows when those gaps will appear, so you can plan for them.

How to Use the Cash Flow Projection Calculator

Enter your opening cash, your expected monthly cash in, an optional monthly growth rate and your monthly cash out. If you expect a one-off payment, such as equipment or a tax bill, enter it for month three. The calculator builds a six-month table showing cash in, cash out, net cash flow and the closing balance for each month, and it shows the lowest balance in the period.

With the example figures, opening cash of 5,000, monthly cash in of 12,000 and monthly cash out of 10,400 give a closing balance of 14,600 after six months. Enter a one-off payment of 20,000 and the lowest balance falls below zero, which means you would need extra funding or a different payment plan. The calculator runs only in your browser and nothing is saved.

Download the Free Cash Flow Projection Templates

The five Excel files below cover annual planning, short-term cash management and new businesses.

12-Month Cash Flow Projection

The 12-month projection has a column for each month from January to December. Cash-in rows cover cash sales, collections from customers, loans or investment and other income. Cash-out rows cover purchases and stock, wages, rent, utilities, marketing, loan repayments, tax and other costs. Each month carries its closing balance forward as the next month's opening balance.

12-month cash flow projection template in Excel with closing balances

13-Week Cash Flow Forecast

A 13-week forecast covers one quarter week by week. It is the standard tool for managing cash closely when money is tight, because weekly figures show exactly when payroll, rent and supplier payments fall compared with customer receipts. Update it every week, replacing forecasts with actual figures.

13-week cash flow forecast template in Excel

Startup Cash Flow Projection

A new business usually spends money before it earns it. The startup projection includes rows for owner investment, loans received and startup costs alongside regular sales and expenses. Use it to work out how much funding you need before the business can pay its own way.

Startup cash flow projection template in Excel with startup costs and funding

Daily Cash Position

Daily cash position template in Excel with opening, cash in, cash out and closing balance

A day-by-day cash book for the month. Set the starting cash once, then enter cash in and cash out for each date; opening and closing balances roll forward automatically. The header shows the lowest closing balance and the net change for the period, so you can see a tight Friday before it happens. Owners of small firms and café or retail managers use this when a weekly forecast is too coarse. Fill it every evening or from your bank feed export.

Cash Flow Budget vs Actual

Cash flow budget vs actual template in Excel with variance and percent of budget by category

Compares planned cash movements with what really happened. Enter budget and actual for receipts and for each outflow category (payroll, suppliers, rent, loans, tax and other). Totals, net cash flow, variance and percent of budget calculate for each line. Negative variance on receipts or positive variance on costs means you are behind plan. Use it at month-end with the 12-month projection: update the forecast for next month from the variances you see here.

What to Include in a Cash Flow Projection

Cash in:

  • Cash sales received at the time of sale.
  • Payments from customers for invoices, entered in the month you expect to be paid, not the month you invoice.
  • Loans, grants or owner investment.
  • Other receipts such as interest, refunds or asset sales.

Cash out:

  • Stock and supplier payments.
  • Wages and payroll taxes.
  • Rent, utilities and insurance.
  • Marketing and advertising.
  • Loan repayments, including interest.
  • Taxes, when they are actually paid.
  • Equipment purchases and other one-off costs.

Leave out items that do not involve cash, such as depreciation, because the projection is only about money moving in and out of the bank.

How to Build Your Projection

  1. Enter your current bank balance as the opening cash balance.
  2. Estimate cash in for each period. Base sales on past results where you can, and allow for how long customers take to pay.
  3. List every regular payment and enter it in the period it will actually be paid.
  4. Add one-off payments, such as annual insurance, tax or equipment, in the right month.
  5. Check the closing balance for each period and the lowest closing balance.
  6. If any balance is negative or too low for comfort, plan an action: delay a purchase, chase customer payments, arrange an overdraft or reduce costs.
  7. Update the projection each month with actual figures, and roll it forward so you always look ahead.

Reading the Results

The most important figure is the lowest closing balance. If it is below zero, the business will not have enough cash at that point unless you act. If it is positive but small, any delay in customer payments could cause a problem. Many businesses set a minimum cash buffer, such as one month of fixed costs, and treat any balance below that level as a warning.

Look also at the net cash flow row. A run of negative months may be normal for a seasonal business or a growing business buying stock, but it should be planned and funded, not a surprise.

Ways to Improve Cash Flow

  • Invoice promptly and state clear payment terms.
  • Follow up late payments quickly and politely.
  • Offer easy ways to pay, such as bank transfer or card payments.
  • Negotiate supplier terms so you pay closer to when you are paid.
  • Hold less stock where possible, and order in smaller amounts.
  • Spread large costs by leasing equipment or paying annual bills monthly.
  • Plan tax payments by setting aside money each month.
  • Arrange funding early. An overdraft or credit line is easier to arrange before you need it.

Cash Flow Projections for Lenders and Investors

Banks and investors often ask for a cash flow projection with a loan or investment application. They want to see that the business can meet its repayments and survive slow periods. Keep your assumptions realistic and write them down, for example "customers pay in 30 days" or "sales grow 2% a month". A projection with clear, sensible assumptions is far more convincing than one with optimistic numbers and no explanation.

Weekly vs. Monthly Projections

A monthly projection is best for annual planning, budgeting and funding applications. A weekly projection, like the 13-week forecast, is better when cash is tight or when large payments fall at different times within a month. Many businesses keep both: a 12-month view for the big picture and a 13-week view for day-to-day decisions.

Common Cash Flow Projection Mistakes

The most common mistake is entering sales in the month they are made rather than the month the cash arrives. Others include forgetting annual or quarterly bills, underestimating how long customers take to pay, leaving out loan repayments and never updating the projection once it is made. Review the projection at the start of each month, replace last month's estimates with real figures and check whether your assumptions still hold.

Sharing the Projection with Your Team

Share the projection with anyone who approves spending, so that large purchases are timed for months when cash allows. A short monthly review of actual against forecast figures keeps everyone working from the same numbers.

Related Templates

You can also check these important templates like the profit and loss statement templates for seeing whether your business is profitable, and the family monthly budget planner templates for planning household cash flow.

You may also like the marketing budget plan templates for planning one of the main costs in your projection.

Frequently Asked Questions

What is the difference between a cash flow projection and a budget?

A budget plans income and spending, often on a profit basis. A cash flow projection shows when cash actually comes in and goes out, and what the bank balance will be.

How far ahead should a cash flow projection go?

Twelve months is common for planning and funding applications. A 13-week forecast is useful for managing cash closely in the short term.

What does a negative closing balance mean?

It means the business would not have enough cash at that point unless you act, for example by delaying payments, collecting receipts sooner or arranging funding.

Can I use the templates in Google Sheets?

Yes. Upload the .xlsx files to Google Drive and open them with Google Sheets. All the formulas keep working.

Should I include depreciation?

No. Depreciation is not a cash payment. Include the actual payment for equipment in the month you pay for it.

How often should I update my cash flow projection?

At least monthly, replacing estimates with actual figures. Update a 13-week forecast every week.

Rumaish is a professional computer designer with extensive experience navigating the demands of the corporate and business sectors. Combining a sharp eye for functional design with a deep understanding of office workflows, he crafts practical, high-quality Word and Excel templates that help professionals save time and streamline their daily operations.