Print this Page

Cashflow Plan Free

1. Introduction

Cashflow Plan Free is an Excel-based business cash flow planner for short-term / high-level projections. Based on your assumptions, it generates fully-integrated projections (income statements, cashflows, balances sheets etc.) for six months ahead using either UK/ International or US/ Canadian accounting conventions. It requires Excel (releases 5, 7, 8, 95, 97, 2000, XP, 2003, 2007, 2010, 2013, 2016) running on Windows (95/98/Me/NT/2000/XP/Vista/Win7,8,10). Check the advantages of using Cashflow Plan instead of building your own spreadsheet planner.

Cashflow Plan Free incorporates extensive formulae and preprogrammed menus and buttons. You only need a very basic knowledge of Excel to prepare highly professional and presentable projections. Advanced Excel users can utilize their expertise to enhance and expand Cashflow Plan to meet their particular needs.

Cashflow Plan Free is very suitable for generating short-range, high-level financial projections for business cashflow planning for both smaller and larger businesses. It is also an ideal introduction to financial modeling for first-time planners and to the other more extensive and powerful planners within the Cashflow Plan range.

2. Scope

Cashflow Plan Free is the most "junior" version in the Cashflow Plan range of six planners which offer different levels of detail and complexity. It is identical in all key respects to Cashflow Plan Micro (US$39) except that it generates projections for just 6 months instead of 12 months with Micro. If you need multi-year projections, you should look at our Exl-Plan range here.

Cashflow Plan Free generates fully-integrated monthly profit and loss accounts (income statements), balance sheets and ratio analyses for six months ahead. Its primary output includes:

Once loaded, Cashflow Plan Free automatically extends Excel's menu system (with about 130 additional options) and adds its own toolbar and online help system.

3. Facilities & Features

Cashflow Plan Free contains dozens of pre-formatted and protected worksheets incorporating thousands of formulae, assumption values etc. Its facilities and features include the following:

Cashflow Plan Free handles a wide range of assumption variables and financial functions. Many of these can be expanded or altered by the user in order to embrace existing spreadsheet-based data or to accommodate special user requirements. In addition, Cashflow Plan Free can be set to suppress the printing of rows containing no/zero values to enhance the conciseness and relevance of its output reports.

Cashflow Plan Free is an open system which can be expanded or customized by users. The online help and manual describe almost twenty techniques or procedures for extending and tailoring Cashflow Plan Free.

3.1 Sales, Cost, Inventory & Overhead Assumptions

The range of sales, cost, inventory and overhead expenses assumptions handled by Cashflow Plan Free includes:

3.2 Fixed Asset, Investment & Financing Assumptions

The range of fixed asset, investment and financing assumptions handled by Cashflow Plan Free covers:

3.3 Credit Assumptions & Input/Output Taxes

The range of credit assumptions and input/output tax - Sales Taxes, Value Added Tax (VAT) and Goods & Services Tax (GST) - facilities handled by Cashflow Plan Free includes:

Cashflow Plan Free incorporates extensive online help covering over 130 topics including the following:

Very Quick Start
Welcome to Cashflow Plan
Cashflow Planning
Introducing Cashflow Plan
Loading Cashflow Plan for the First Time
Getting Started with Cashflow Plan
Using Cashflow Plan
Changing Cashflow Plan
Support & Assistance
Adapting Cashflow Plan to Different Business Types
How Quik-Plan Handles Assumptions
Guidance on Entering Assumptions
Calculation Error Messages

It is also supplied with a 100-page Word-based version of its manual and a series of Flash-based tutorials (running for 19 minutes) covering setting up Excel, getting started, the basics and using Quik-Plan.

This support is supplemented by regularly updated Frequently Answered Questions for Users - see also Support for Users and Frequently Asked Questions for Using Excel 2007, 2010, 2013, 2016.

Because Cashflow Plan Free is extensively menu driven, minimal Excel expertise is required to use Cashflow Plan. At the same time, experienced spreadsheet users can use its open approach to extend and modify worksheets within Cashflow Plan Free. Very limited Excel expertise (e.g. creating simple formulae, inserting rows and similar) is needed to make some of the most powerful and useful changes to Cashflow Plan Free.

Intending users only need a (very) basic understanding of income statements, cash flow and balance sheets in order to get to grips with Cashflow Plan Free and from there they can easily graduate to more detailed and powerful versions of Cashflow Plan (details).

4. Download Cashflow Plan Free

Cashflow Plan Free is immediately usable and useful both as a package in its own right and as a great introduction to the entire Cashflow Plan range.

To download Cashflow Plan Free, go to Cashflow Plan's download page, scroll down to Free and select the appropriate download link.

Once Cashflow Plan Free has been downloaded (and unzipped, if appropriate), run the CASH*.EXE installation file and you will be guided through the simple installation procedures - refer to the README.DOC file for further guidance. You will be informed in README.DOC how to uninstall Cashflow Plan Free.

Once installed, do one of the following to run Cashflow Plan:

Online Tutorial
View a Tutorial (2 minutes) on how to set up Excel (this is based on Exl-Plan Free which shares many common features with Cashflow Plan Free). *
* if using Excel 2007, 2010, 2013, 2016, see the special Frequently Asked Questions about using Cashflow Plan with Excel 2007, 2010, 2013, 2016.

To fully load Cashflow Plan Free, you may need to change Excel's security setting to Medium to allow Cashflow Plan's extensive macros to run (via Tools | Macro | Security) - click the thumbs below. For more help, refer to the Tutorial or to Loading and Running Problems at the Frequently Asked Questions for Newcomers.

This guidance relates to Excel 5, 7, 8, 95, 97, 2000, XP and 2003. If using Excel 2007, 2010, 2013, 2016, see Frequently Asked Questions for Using Excel 2007, 2010, 2013, 2016.

Click to display full size Click to display full size Click to display full size
Load Excel, select Tools, Macro, Security ... ... click Medium security level and close Excel. Reload Excel, load Cashflow Plan and, when prompted, enable macros.

This guidance relates to Excel 5, 7, 8, 95, 97, 2000, XP and 2003. If using Excel 2007, 2010, 2013, 2016, see Frequently Asked Questions for Using Excel 2007, 2010, 2013, 2016.

Support for Cashflow Plan Free

1. Cashflow Plan Free is unsupported but, for assistance, refer to its online help; accompanying MANUAL.DOC and README.DOC files; the Flash-based tutorials (running for 19 minutes) covering setting up Excel, getting started, the basics and using Quik-Plan; and the FAQ for Users. If using Excel 2007, 2010, 2013, 2016, see FAQ for Using Excel 2007, 2010, 2013, 2016.
2. When using Cashflow Plan, make regular backup copies of the file in use e.g. COPY-1.XLS, COPY-2.XLS, COPY-3.XLS and so on.

Note: Registered copies of Cashflow Plan Micro, Lite, Plus, Super and Ultra are fully supported.

For further information, refer to Installation & Running Notes.

4. Other Cashflow Plan Versions

Cashflow Plan Free is the least detailed and powerful version in the Cashflow Plan range. All other versions generate comprehensive 12-month projections and incorporate many more variables and additional tools and facilities.

The following table offers you guidance on the suitability of all versions for different size firms. The complexity of your business, sector, detail/sophistication required, planning objectives and your expertise should also be considered.

Typical Projected
Annual Sales (US$/£stg) (Mln = millions):
<50k 100k 200k 300k 500k 750k 1 Mln 2 Mln 5 Mln 5 to 100+ Mln 
Free Suitable for High Level / Shorter Term
Micro OK Best OK
Lite No OK Best OK
Plus No OK Best OK
Super * No OK Best
Ultra * No OK Best

*Incorporates tool for consolidating projections (i.e. cash flow and income statements plus forecast balance sheets) for subsidiary businesses using a special Report for Consolidation. This linked to an additional workbook (Cashflow Plan Consolidator) which facilitates the consolidation process and includes tools for changing currencies/ denominations and eliminating inter-company transactions.

The basic specifications and prices of the all versions of Cashflow Plan are summarized below:

Basic Specifications Free Micro Lite Plus Super Ultra
Time Horizon 6 Mths +
12 Weeks
12 Mths + 12 Weeks
Number of built-in formulae 2,900 5,900 6,600 7,700 14,400 16,100
Revenue/cost streams 1 1 2 4 6 10
Number of Reports 22 24 25 25 27 27
Number of Charts 10 10 10 10 10 10
Consolidation Facility No Yes
Sensitivity Analysis Tools 1 2 3
Prices (US$)

Visit other pages for more detailed information, trial downloads and purchase methods.

Note: If you need multi-year projections, have a look at Exl-Plan, our range of fully-integrated business finance planners which generate projections for 3-5-7 years ahead. Details and trial-version downloads.

Print this Page

Top - Business Plan WareTop of Page