How to Use Figurewizard

Simply enter your forecasts for sales, margins, overheads and investment: Profit, liquidity and cash flow forecasts are then produced automatically.

Creating a New Forecast

Fast, easy to use and inexpensive Figurewizard produces forecast profits, balance sheets, monthly cash flows and bank balances from your predicted sales, margin, overheads, investment and a few simple cash ratios.

Nothing more than that is needed. The system is designed to make using it as simple as possible by doing all of the work needed to calculate the forecasts and calculators needed to create the perfect business plan.

In addition, VAT, fixed asset net book values, taxable profits, capital allowances and corporation tax payable are all calculated and included in the forecasts with no input for that called for from a user.

Updating or Changing Saved Forecasts

Figurewizard is flexible: Forecasts can be saved to be revisited and updated as often as you wish. One way is by choosing to edit the data you previously entered into the forms. 

Better still this can also be done using the unique What-If forecaster / planner which, with single clicks updates key forecasts for profit, liquidity, cash flows and the monthly bank account in front of you. 

The two charts shown at the bottom of the calculator - one for monthly accrued profits and the other for the monthly bank balance plus undrawn and available financing facilities also update in real time.

Entering Data into the Forms is Simple

Go to “My Account” to sign in. This takes you to the welcome page. Click on “Create a Report.” This takes you to the entry screens.

To create a new set of forecasts, go to “My Account” and sign in, which brings up the "Welcome screen". Click on the button “Create a Report” which brings up the input screens as follows:

1 Title; Start Date; no. of Years to Forecast
2 Capital; Bank; Loans
3 Sales Info; Gross Profit Margin
4 Purchases; Imports; Exports
5 Overheads
6 Monthly Sales Ratios; Simple Cash Ratios
7 Value of Fixed Assets Bought & Sold
8 B/Fwd. Balance Sheet Values (for going concerns)

The screens are short form. Entering your figures into each of them should take no more than a minute or so.

Once your figures are entered it's a case of job done: Figurewizard will have then performed all of the calculations needed to create all of the forecasts. That includes calculating and applying forecasts for VAT transactions, corporation tax, monthly bank balances and undrawn and available finance facilities such as from the bank overdraft or factoring / supply chain finance.

Saving Forecasts

Up to one hundred complete sets of forecasts can be stored to "my account". These can be retrieved for updating at any time and can be exported to excel for formatting and printing.

Figurewizard and VAT

All values are entered excluding VAT, with the sole exception of the acquisition or disposal of company cars, which are always entered including VAT. This is because VAT is not recoverable as input tax for company cars.

VAT on non-EU imports is calculated seperately by the system as payment for that is normally due one month after importation instead of quarterly. We get that information from the values you select for % of purchases imported followed by % of non-EU imports.

This is all done without the need for intervention on the part of the user. The same goes for corporation tax.

Sales, Cash Collection and Payment Ratios

Sales ratio is simply the anticipated annual percentage value of each month's sales. For example, January 5%, February 4%, March 7% and so on up to 100%.

Cash collection represents the percentage of cash collected for sales made on credit by month. For example, 5% of invoicing is paid in the same month as they were issued = 5% Month 1. 50% collected one month later = 50% Month 2 and so on up to 100%.

Percentages representing payments for goods and overheads are applied in the same fashion as cash collection.

Planning and the WhatIf Calculator

Every forecasting exercise will require a degree of re-appraisal and this is where our unique WhatIf Calculator comes in. This is an essential tool for successfully planning a business.

The WhatIf Planner displays the key values you will have entered for borrowings, margins, overheads and investment. Changes can be made to these individual values which in turn will change the summaries it displays for forecast profitability, liquidity and cash flow in real time:

The charts below those forecasts will also change. At the finish there is an option button enabling you to permanently apply the changes to your forecasts if you so wish.

Visitors Interacting with Sample Forecasts

All sample forecasts on the site are working examples. They are fully interactive for appraisal, either by choosing "edit" or better still using the WhatIf calculator, a link for which is below.

Registration costs £20 p.a. approximately €25 or US$30 – a lot less that the average parking ticket. There are no other charges.

The Truth about Monarch Airlines Labour's Spending over 10 years from 2000 Business Planning and Forecasting: What to Look For. Credit Checking - How to Read Micro or Short Form Accounts Amortisation of Arrangement Fees for Long Term Loans BHS Profits Performance 2010 - 2014 BHS profits, liquidity and cash flows 2009 - 2014 How to Calculate a Free Cash Flow Forecast Campari: How to apply for a bank business loan What are Current Liabilities What are Current Assets Late Payers and Cash Flow What is Operating Cash Flow What is Working Capital How to Read a Balance Sheet Business Planning Cash Flow Calculator Short Term Liquidity Business Liquidity Corporation Tax is not Calculated on Net Profit Small Business Corporation Tax Cash Flow Calculator Using Figurewizard - VAT Using Figurewizard - Sales by Month Using Figurewizard - HP or Instalment Plan Budgets Using Figurewizard - How the budgeted cash flow forecast is calculated Using Figurewizard - Fixed Asset Budgets Using Figurewizard - Calculate Purchase of Goods Using Figurewizard - Forecasting Payments to Suppliers Using Figurewizard - How to Forecast Cash Collection Solvency and the Balance Sheet Property in the Balance Sheet Why Equity is a Liability Asset Management and Liquidity Selling Fixed Assets Contracts: Invitation to Treat What is Deferred Income Loss on the Sale of Fixed Assets Calculating Gross Profit Margin Profit and Loss Statement What is Operating Profit What is Net Operating Revenue What is Equity Profit on the Sale of Fixed Assets How Taxable Profit is Calculated What are Operating Overheads Overheads - Provisions Depreciation What is Business Operating Activity What are Fixed Assets