Cash Flow Calculator
What's Inside the Cash Flow Calculator Template?
Details | 8 Sheets
Supported Versions | Excel 2010, 2013, 2016, 2019, Office 365 (Mac)
Category | Finance
Tags | Statement, Discount, Assets, Forecast, Projection
Why Professionals Choose Simple Sheets
It's simple. Access to the largest library of premium Excel Templates, plus world-class training.
100+ Professional Excel Templates
Optimized for use with Excel. Solve Excel problems in minutes, not hours.
World-Class Excel University
With our university, you'll learn how we make templates & how to make your own.
Inside Our Cash Flow Calculator
Rapper, and apparent business mind, Ace Hood, once said “Cash Flow, I need it on time. I'm talking bankroll, my money, my money, my money.” While it wouldn’t take long to find more advanced analysis on the importance of cash flow, Ace summed it up in a way we can all universally understand.
Our Cash Flow Excel Template enables you to track monthly cash flows from accounts receivable and accounts payable using structured tables and rich formulas for automating calculations.
Managing your cash flows is crucial to ensuring the business has sufficient funds at their disposal. By entering in your Sales and Invoices data, it will automatically translate into cash flow planning.
Let’s start off by customizing the spreadsheet to your business needs in the Mapping sheet. Enter the applicable Year, Month, Conversion Factor, Products, Raw Material, Customer, Payment Terms and Vendor.
Update the Sales Data and Invoice Data with corresponding records that will help populate our other sheets.
In the Sales and Invoice sheet (keep in mind, these are not the data sheets), ensure the payment terms align with your data in the Mapping sheet.
The Accounts Receivable and Accounts Payable sheets will chart based on your inputs and calculate important metrics for understanding cash flow such as New Receivables, New Payables, Payments, Collection and Net Movement.
Below the tables are a Net Account Movement histogram for analyzing the changes by month.
These calculations will prove vital in helping you understand the cash you have available, runway, burn rate and cushion in case of a downturn in business or negative net movement.
So next time you find yourself needing to add to your receivables, feel free to cite Ace Hood as one of the foremost scholars on cash flow analysis.