Cash Flow Analysis
ModelSheet: Custom spreadsheets in minutes
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 |
|
|
|
|
Compare Versions
| | Standard | Pro | Power Pro |
| Cash-flow Worksheet | | | |
| 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 |

Works with Microsoft® Excel® 2003 - 2010
Watch our video on how easy it is to customize our models
Customize spreadsheets by filling in a simple form
 | 1. Choose The model you want |
 | 2. Customize Online form does the work |
 | 3. Download And it's ready to use |
Each spreadsheet offers:
- Carefully organized layout
- Comments on every variable table
- Collapsible groups hide details until wanted
- Easy-to-read symbolic formulas show what the model does
- Easily change input data, start date, label text...
Meet your exact needs better than any static template.
Learn more about ModelSheet spreadsheet customization solutions
Can't find your solution
Need to know more?
Find out how our consulting services can help you create and manage your ideal custom spreadsheet models.
Go to Consulting Services