For professional quality cash flow forecasting
please review our comprehensive Advanced Cash Flow Forecasting Template.
featuring
Two tier data entry system 'Scheduled' and 'Periodic'
Features 25 separate user definable 'Trading Scenarios'
Automatic Scheduling of Sales and Income streams
Automatic Scheduling of Cost of Sales payments
Automatic Quarterly VAT payment calculations
Caters for Debtor and Creditor balances brought forward
Use of up to 28 separate Overhead Types
The Cash Flow Forecasting Template allows you to tailor your income streams by Profit Margins and Payment Periods
| |
Customer |
Supplier |
Product |
Overhead |
| Set Payment Terms (days) |
 |
|
|
|
| Set Gross Profit Margins % |
|
|
|
n/a |
| Set VAT Rates |
|
|
|
|
The Cash Flow Statement
Create your own 'Trading Scenarios' (see below) and let the program automatically compute the income and expenditure streams. The system allows you to design up to 25 separate 'Trading Scenarios' which cover Sales, Cost of Sales and Gross Margins. If you are VAT Registered the system will automatically calculate and schedule your Quarterly VAT Returns.
Cash Flow Sales by Product
Cash Flow Cost of Sales by product
The system can accommodate up to 28 user definable Overhead Types. Using a combination of scheduled and periodic payments this section ideal for a comprehensive analysis of your business overheads.
Cash Flow Overheads
Our two tier data entry system allows you to have both Scheduled and Periodic income and expenditure streams.
These two separate data entry systems then consolidate to produce the final Cash Flow Statement.
The consolidated SCHEDULED Cash Flow
The consolidated PERIODIC Cash Flow
Additional information and small print
Mr. Spreadsheet is a registered trading name and division of Heron Accounting Services, Poole, Dorset. This software is protected by international copyright and is sold on a single-user license agreement for the use by the licensee or licensees business only. Unlawful copying and distribution will result in prosecution.We make no warranty or representation, either express or implied, with respect to this software and documentation, their quality, performance, merchantability, or fitness for a particular purpose. This software is licensed ‘as is’, and you, the licensee, by making use thereof, are assuming the entire risk as to their quality and performance. In no circumstances will we be held liable for direct, indirect, special, incidental or consequential damages arising out of the use or inability to use the software or documentation.
