Cash Flow Analysis

ModelSheet: Custom spreadsheets in minutes

Control your cash with customized cash flow reporting 

Our cash-flow model offers you a ready-made, flexible and robust solution for monitoring the flow of cash through your business.

It allows you to concentrate on analyzing your business, rather than spreasdsheet construction.

Fully Customizable

Using our automated modelling technology you can create a report that exactly suits your needs. Turn on and off major features, specify time line and "dimensions" such as product lines, preferred currency symbols, and date formats in a simple online form.

There’s nothing to install or learn.

Easy to Use

Your spreadsheet has a logical and intuitive layout that includes:

  • A carefully arranged layout
  • Comments on every variable table
  • Collapsible groups hide detail until needed
  • Easy to understand symbolic formulas
  • Easy modifiable data and preferences

Compare Features

The cash-flow model has three versions, for businesses of different size and complexity. All versions provide you with:

  • Starting and ending cash
  • Sources of cash by trade and other receipts
  • A database that tracks receipts accounts
  • Cash use segmented into expenses and other disbursements
  • Databases that track employees, with start & end dates, pay rates
  • A schedule that break out payrolls, benefits, taxes & travel
  • A database that tracks disbursement accounts.

The Pro and Power Pro versions also include:

  • A database with a record for each sales order
  • Trade receivables aging report
  • A database with a record for each purchase invoice
  • Checking account cash float
  • Line of credit worksheet
  • Borrowing base from inventory and receivables
  • Loans, advanced funds, excess borrowing capacity
  • Routing of receipts to accounts controlled by creditors
  • Factoring of receivables (permanent sale or reversible)
  • Segmentation by business unit or location, with worksheet for each segment.

Go to the Features tab to see which Features are available in each version.

 
StandardProPower 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 $397 day free trial or $69$99
Microsoft Office Marketplace logo
Works with Microsoft® Excel® 2003 - 2010
 

Customize spreadsheets by filling in a simple form

Step 11. Choose
The model you want
Step 22. Customize
Online form does the work
Step 33. 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

Related spreadsheet models

Cash Flow for Small Start-up
 

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
 
 

Copyright © 2010, 2011 by ModelSheet Software LLC | All Rights Reserved | Privacy

Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.