sign in · new user? sign up
 · feedback
 
Browse Other Models

Browse Other Models
  In Finance

Customizable Spreadsheet Template: Cash Flow

Available Versions

These are not rigid spreadsheet templates. You can customize them in dozens of ways to get the features you want while reducing unneeded complexity.

VersionDescription Download
Price
LightThe Light version has the same features as the Standard version, only it is smaller. It lets you try the customization process and download a customized working template for free. Free
StandardOffers a cash flow statement with starting and ending cash, sources and uses of cash, and receipts and payment accounts with one transaction record per account. Size is adequate for many models. $79 $49
AdvancedIncludes all features in the Standard version, plus line of credit analysis, asset borrowing base, factoring of receivables, bank cash float, and optional tracking of receipts by sales order and disbursements by purchase order. It handles larger models with more of everything. $129 $89
Advanced Extra-LargeHas all the features in the Advanced version, plus larger models with more of everything. $169 $119
* Customization and preview is always free. If applicable, you'll be asked to buy before downloading a working spreadsheet.
  We offer a money-back guarantee.

Customizable Feature Comparison

Feature Standard & Light
Version		 Advanced & Extra-Large
Version		 Comments
Cash flow worksheet Check Check Starting and ending cash balances and sources and uses of cash for each time period
Accounts Receivable
Account data by customer account Check Check Enter receipts data by account or customer
Account data by sales invoice   Check Enter receipts data by sales invoice in Excel database
Receivables aging report   Check Reports receivables in five age groups (if you choose to list receivables by sales invoice)
Accounts Payable
Account data from input tables Check Check Enter disbursements data by account or vendor
Account data from database   Check Enter disbursements data by purchase invoice in Excel database
Payables aging report   Check Reports payables in five age groups
Employment data Check Check Two Excel databases for hourly and salaried employee data
Borrowing and Credit
Line of credit worksheet   Check Displays weekly borrowing base composed of receivables and inventory, and starting and end ending loan balances, new loan funds, funds applied to loans
Factoring of receivables   Check Sell receivables or use as collateral. Specify sale of AR or loan and time of buy-back of old ARs.
Checking Account Float   Check Provide a second version of cash float that includes the checking account cash float
Compare Actual and Planned Cash Flow   Check Compare actual and planned cash flows with limited detail.
Time Check Check You choose the time grain and the number of time periods
Time grain Check Check Choose time grain of day, week, month, quarter, or year.
Additional Features Check Check  
Segment cash flows Check Check Segment the cash flow (for example by business unit, geographic location). Get separate cash flow statements for each segment and for total.
Compare Actual and Planned Cash Flow Check Check Compare actual and planned cash flows with limited detail.
Graphs Check Check Excel graphs of key variables

Version Size Limits

Feature Standard Version Advanced Version Extra-Large Version
Trade receipts accounts, 1 record each 10
Trade receipts accounts, 1 or many records each 30 60
Other receipts accounts, 1 record each 10 40 60
Disbursement accounts, 1 record each 20 40 60
Disbursement accounts, many records 0 30 60
Time periods 26 48 128
 

Copyright © 2010 by ModelSheet Software LLC | All Rights Reserved | Corporate Home | Privacy

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