Cash Flow Analysis

ModelSheet: Custom spreadsheets in minutes

Browse all spreadsheet models

Overview

Features

Description

Guides & Tools

Control your cash with customized cash flow reporting

This model is offered in a number of fully customizable versions. Compare these below and choose the one that suits your business size and needs. Once selected, customizing your spreadsheet is quick and easy. Your business could be using powerful, professional Excel analysis in minutes.

Each version is free to customize and preview.

Standard	Pro	Power Pro
Statement with starting and ending cash Cash sources and cash uses Receipts and payments by account Employment data Suitable for small or medium-sized businesses	All Standard features plus: Receipts and payments for each invoice Receivables and payables aging reports Line of credit with borrowing base Factoring of receivables Bank checking account float Segment by business units (such as divisions, geography) Compare planned and actual cash flow Optional databases for receipts and payment data Larger models	All Pro features plus: More items of all types More time periods
7 day free trial or $39	7 day free trial or $69	$99
Customize Now	Customize Now	Customize Now

Compare Versions

Cash-flow Worksheet
	Standard	Pro	Power Pro
Starting and ending cash balances
Sources and uses of cash
Accounts Receivable
Data by customer account
Data by sales invoice with optional receipts database
Receivables aging report – up to 5 aged groups
Accounts Payable
Data by vendor account – 1 record per account
Data by purchase invoice with optional payments database
Payables aging report up to 5 aged groups
Employment data – 2 databases for hourly and salaried employees
Borrowing and Credit
Line of credit – borrowing base is composed of receivables and inventory. Includes finished, work in process, and raw materials inventory.
Line of credit worksheet – displays borrowing base composed of receivables and inventory, start and end loan balances, new loan funds, funds applied to loans
Factoring of receivables – sell receivables or use as collateral. Specify sale of AR or loan and time of back-buy of old ARs
Checking account float – second version of cash float that includes the checking account cash float
Compare actual and planned cash-flow
Time
Choose time grain (e.g. day, week, month)
Additional Features
Segment cash-flows (e.g. business unit, location)
Compare actual and planned cash-flow
Graphs of key variables
Custom Model Size Limits
Trade receipts accounts – 1 record each	10	40	60
Trade receipts accounts – 1 record per invoice	-	30	60
Other receipts accounts – 1 record each	10	40	60
Disbursement accounts – 1 record each	20	40	60
Disbursement accounts – record per invoice	-	30	60
Business segments	-	3	8
Time periods	26	48	128