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 produces profit, balance sheets, monthly cash flow and bank balance forecasts from your predicted sales, margin, overheads, investment in a matter of minutes.

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.

That includes calculating and applying VAT, fixed asset net book values, capital allowances, taxable profit and corporation tax payable to the forecasts with no further input from the user.

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

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 planner/ planner which, with single clicks updates key forecasts for profit, liquidity, cash flows and the monthly bank account as you go. 

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.

FAQs
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