TEMPLATE

Cash Flow Projection Model Excel Template

Cash flow is the lifeblood of your business. Purpose built for SaaS, our cash flow projection model template makes it fast and easy to get a granular view of how money moves in your business so you can more fully optimize your working capital management.

Download the template

A flexible template built specifically for SaaS

Unlike generic cash flow forecasting templates online, all of Drivetrain’s templates, including this one are tailored for SaaS. They’re flexible by design, allowing you to easily modify them to suit the needs of your business. This template will make it easier than ever to create a detailed, accurate cash flow forecast, with:

Simple instructions on how to modify and use the template and a worksheet to enter your model timeline and assumptions
A worksheet to enter your historical data and actuals each month and a cash flow model summary template that automatically calculates and updates cash flow for individual customers and customer categories
A collections forecast template for you to track collections at the individual customer level or by customer categories you define
A dashboard that provides a 13-week cash flow forecast, a cash waterfall chart, and your cash balance projection

Download the free template

Improve your working capital management

Optimize cash flow to position yourself for growth

Respond more quickly to unexpected challenges

Take advantage of new opportunities in the market

Let's walk you through the template!

Watch the video below for a step-by-step guide on using this template and see for yourself why it's the perfect Excel template for your 13-week cash flow projection.

Start with the Timeline & Assumptions tab. Enter your beginning cash balance, the start and end dates for your historical period, and the template automatically builds out the forecast period. You’ll also see a clear visual of months and weeks, with flags marking actual vs. forecast.

Move to the Actuals section. Cash movements are split into three categories: cash in (by customer), cash out (by vendor), and other cash movements like salaries or equity infusions. Inputs happen weekly, with monthly summaries auto-calculated above. Cash out is typically added manually, while cash in is mostly formula-driven. Other cash movements can include both inflows and outflows. Keep in mind, forecast inputs won’t show up in the summary until your timeline reaches that week.

In the Collections Forecast section, enter your AR aging data, invoice number, customer name, and amount. Add a DSO (Days Sales Outstanding) for each customer type, and the model calculates expected payment dates. You can also set a collection rate to account for bad debt. Weekly collection projections are automatically calculated based on these inputs.

The cash flow summary brings everything together. The summary shows beginning cash, inflows, outflows, other movements, and ending cash. It’s available at both weekly and monthly levels and breaks down inflows by customer and outflows by vendor.

Head to the Dashboard for a clean view of your cash position over time. The waterfall layout shows how cash is moving week by week. Change your start date, and the dashboard updates automatically.

The template includes built-in BvA (Budget vs. Actual) tracking to help you compare forecast vs. reality. Drill into customers, vendors, and even individual transactions.

Understand your cash flow at a more granular level than ever before

Get your free download

Level up your cash flow forecasting & analysis with Drivetrain!

Schedule a Demo

Cash Flow Projection Model Excel Template

A flexible template built specifically for SaaS

Improve your working capital management

Let's walk you through the template!

Understand your cash flow at a more granular level than ever before

More related content

SaaS Financial Model Template in Google Sheets

SaaS metrics based planning: A template for top-down revenue planning

Level up your cash flow forecasting & analysis with Drivetrain!