Print this Page
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.
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.
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:
- Monthly sales forecasts for a single sales group with five product/market subgroups which can be defined by the user.
- Facilities for specifying the cost of materials/goods in percentage terms and for setting material inventory targets.
- Direct labor head count and four other user-definable direct/variable cost categories.
- Over fifteen user-definable categories of overhead expense.
- Credit terms (up to four months) can be specified for each cost/expense variable.
3.2 Fixed Asset, Investment & Financing Assumptions
The range of fixed asset, investment and financing assumptions handled by Cashflow Plan Free covers:
- Fixed assets with provision for handling depreciation (calculated from original cost or using double declining balance) and additions/disposals.
- Separate interest rates for cash balances, overdraft and long-term debt with facilities for deferring interest payments and receipts.
- Facilities for increasing and decreasing long-term debt and assigning it between short- and long-term liabilities.
- Handling of revenue grants/subsidies and non-repayable capital grants.
- Share issues, dividends and corporation tax for corporations and cash injections, drawings and income taxes for sole traders, partnerships etc.
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:
- Provision for setting credit terms (up to 6 months ahead) for sales and related purchases (materials or goods for resale).
- Facilities for deferring cash payments relating to many categories of monthly overheads, capital expenditure, dividends, grants etc.
- Where applicable, sales/output tax rates can be set for sales.
- Where taxes apply to inputs, there are facilities for defining these taxes (VAT, GST etc.), setting different tax rates for inputs & capital expenditure; for specifying tax payment months; and for paying tax on an invoice or cash-received basis.
Cashflow Plan Free incorporates extensive online help covering over 130 topics including the following:
|Very Quick Start
Welcome to Cashflow Plan
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).
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:
- Select Cashflow Plan from the Start, Programs menu (W95/98/Me/NT/2000/XP/Vista/Win7,8,10). Also, access Cashflow Plan Free's online help, accompanying manual (MANUAL.DOC) and tutorials using this menu.
- Load Excel and open the CASHPLAN.XLS file from within CASH* subdirectory or folder specified during installation (this may be located below the EXCEL subdirectory or MY DOCUMENTS folder)
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.
|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.
Note: Registered copies of Cashflow Plan Micro, Lite, Plus, Super and Ultra are fully supported.
For further information, refer to Installation & Running Notes.
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.
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|
*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:
|Time Horizon||6 Mths +
|12 Mths + 12 Weeks|
|Number of built-in formulae||2,900||5,900||6,600||7,700||14,400||16,100|
|Number of Reports||22||24||25||25||27||27|
|Number of Charts||10||10||10||10||10||10|
|Sensitivity Analysis Tools||1||2||3|
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 PageTop of Page