How to Use Figurewizard

To produce profit, liquidity and cash flow forecasts simply enter your forecast figures for sales, margins, overheads and investment. We do the rest.

Creating a New Forecast

Fast, simple to use and inexpensive, Figurewizard uniquely produces profit, balance sheets, monthly cash flows and bank balance forecasts from your proposed annual sales, margin, overheads, investment, a few simple ratios and nothing else.

Anyone can work with Figurewizard. All that is needed to create the forecasts and calculators are those proposed annual figures. Forms are in short format meaning that entering them to create the perfect business plan should take no more than a matter of a few minutes.

VAT, fixed asset net book values, capital allowances, taxable profit and corporation tax are all automatically calculated and applied to the forecasts by the system.

Figurewizard Calculators and Planners

Three calculators are also produced . With these you can change your original figures and view how that changes profits, cash, the bank and solvency in real time.

One calculator covers factoring / supply chain finance and cash flow, another the effects on forecast cash flow, liquidity and the bank arising from a dividend and the third; the unique and all encompassing What-If calculator and planner.

Entering Data into the Forms is Simple

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)

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.

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 Calculator / Planner which, with single clicks updates key forecasts in real time for profit, liquidity, cash flows and the monthly bank account. 

The two charts shown at the bottom of the What-If calculator represent monthly accrued profits and the monthly bank balance including undrawn and available financing facilities. These also update in real time as you increase or decrease your original values.

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 What-If Calculator and Planner

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

The What-If 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

Figurewizard does not hide its light under a bushel: All sample forecasts on the site are live working examples. They are fully interactive for appraisal, either by choosing "edit" or better still using the What-If Calculator, a link for which is below.

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

How to calculate liquidity and short-term liquidity How to calculate markup and margin The Truth about Monarch Airlines Labour's Spending over 10 years from 2000 How to make profits and not run out of cash 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