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 Profit and Cash Flow Forecasts

Easy to use and affordable; from proposed annual sales, gross profit margin, overheads, assets, financing and a few simple ratios Figurewizard produces forecasts for profits, cash, the bank, balance sheets and more. It is unique in this respect.

There is nothing to learn, anyone can work with Figurewizard: All that is needed to create forecasts and calculator / planners 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.

Entering Data into the Forms

For registered users everything is held in a password protected "my account" there is nothing to download.  Entering your proposed figures is as follows:

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

All of your figures are entered excluding VAT, excpet for company cars. This is because unlike commercial vehicles, VAT on company cars is not recoverable as input tax. All VAT transactions are calculated and applied to the forecasts and calculators by our system.

The Forecasts

  • Gross Profit: Cost of Goods Sold
  • Profit and Loss
  • Analysis: Assets: Liabilities: Overheads
  • Monthly Cash Flows: Bank Balances: Undrawn and available Financing
  • Operating Cash Flow: Net Cash Flow; Increase / Decrease in Borrowings
  • Business Ratios: Performance: Liquidity
  • Chart: Accrued Monthly Pre-Tax Profits
  • Chart: Accrued Monthly Break even Sales to Profit
  • Depreciation: Net Book Values of Fixed assets
  • Taxable Profit: Capital Allowances: Corporation Tax Charge

VAT: Taxable Profit: Corporation Tax

With the exception of company cars (the tax is not recoverable) all of your figures are entered excluding VAT.

As with everything else VAT and corporation tax, are calculated and applied by to the forecasts our system from your original figures without any further input called for from you.

Saving and Editing Forecasts

Up to one hundred complete sets of forecasts can be saved to "my account". These can all be retrieved at any time for editing

In addition three important and unique calculators are also produced, which can be used in place of editing forecasts. The What-If Calculator / Planner is especially valuable in this respect.

Figurewizard Calculators and Planners

When working with the calculators your original input figures can be increased or decreased, which in turn instantly recalculates and displays updated profits, cash, the bank and solvency in real time. They are:

  • What-If Calculator / Planner
  • Dividend: the Bank; Cash Flow: Working Capital; Equity
  • Factoring / Supply Chain Finance and Monthly Cash Flow 

The What-If Calculator / Planner

This displays your key original figures such as gross margin, overheads, year-end stock, the bank, loans and what % of new fixed assets are financed. These are shown as "before." As you increase / decrease your figures, their revised values are calculated to appear alongside as "after."

At the same time profits, cash flow, the bank plus undrawn facilities, working capital and capital and reserves (equity) also update in real time. The values for these too are displayed "before" and "after".

Below that, charts illustrating accrued profits and cash flows also update (also before and after) and again in real time.

Forecast Dividend Calculator

All that is needed is the value of the forecast dividend and the month it is to be paid.

That then updates (before and after) month by month bank plus undrawn and available financing, increase / decrease in working capital, borrowings, retained profits and capital and reserves.

Factoring / Supply Chain Financing and Cash Flow Chart

Here, all that is needed is to select the percentage of invoicing to be factored, the percentage service charge (if any) and rate of interest payable.

The bank, undrawn facilities such as unused overdraft and cash still  available to be drawn down in the factoring account will all update the chart, illustrating the monthly levels of cash. This can show quite dramatic results.

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.

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.

Registration costs £30 p.a. approximately €50 or US$35 – a lot less that the average cost of a 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 What is Business Operating Activity What are Fixed Assets Liquidity and Cash Flow Balance Sheet Liabilities and Leases Stock or Inventory Control What is Distressed Stock or Inventory What is Interest Suspense Account Product Safety Laws What is a Bill of Exchange What is Payment at Sight What is a Pro Forma Invoice What is a Bill of Lading What is a packing note What is Demurrage Cash Flow Forecasts and Planning Factoring: Invoice Discounting and Cash Flow How Does VAT Work Figurewizard as a Sales Aid for Factoring and Invoice Discounting