Calculating Profit and Loss and Cash Flow Forecasts

Rapidly turn a business plan for sales, margins, overheads and investment into detailed profit; liquidity; cash flow; bank; tax and equity forecasts.

Calculating Comprehensive Business Forecasts

Straightforward, simple to use and inexpensive Figurewizard makes possible the rapid creation of comprehensive forecasts for profits, liquidity, cash flows, balance sheets, solvency and net worth plus three powerful calculators.

All that is needed to produce the forecasts and calculators are your projected sales, profit margin, overheads, investment in new assets and four simple ratios.

Thirteen forecasts and three calculator / planners (listed below). No further input other than a user's predicted figures for the year (s) ahead (up to three years) is required from a user.  The system does all of the work including from those projected figures, including calculating and applying VAT transactions and corporation tax.

Forecasts are flexible and can be retrieved from "My Account" for amendment or updating at any time.

Creating a New Forecast

Users simply enter their forecast figures into the input screens. Entering those figures should take no more than a minute or so for each screen. 

As the figures are being entered the system will be doing all of the work required in real time to produce the forecasts.

For example sales, including domestic, export, by cash, card or open credit are calculated from a list of monthly percentages of annual sales you provide, such as Jan 6%; Feb 4%; March 8% and so on. 

The same percentages are then applied to other variables such as revenue from delivery or service charge, the costs of shipping merchandise and provisions for bad debts.

The Input Forms

All you need to do is to enter your predicted figures for one, two or three years and nothing else. That should only take around ten minutes. From then on Figurewizard does all of the work to create the forecasts and calculators, ready for you to use them. 

1 Title; Start Date; no. of Years to Forecast (1 - 3)
2 Capital; Bank; Loans; Factoring / Invoice Discounting
3 Sales info. Gross Profit Margin
4 Purchases; Import and Export Percentages
5 Overheads and Expenses
6 Monthly Sales % and Simple Cash Ratios
7 Values of Fixed assets Bought and Sold
8 B/Fwd Balance Sheet Values (summary) for Going Concerns


With the exception of company cars all entries are made excluding VAT. Company cars are entered including VAT as that cannot be set off as input tax.

The Forecasts

Despite its ease of use these are the forecasts and planners Figurewizard produces from your figures:

Cost of Goods Sold and Gross Profit Monthly Bank Balances and Cash Flows
Profit and Loss: Operating: Pre-Tax: Post-Tax Operating and Net Cash Flows
Balance Sheet Monthly Accrued Net Profit Charts
Overheads Anaslysis Monthly Break-Even Sales Charts
Assets and Liabilities Analysis Business Ratios - Liquidity
Fixed Assets - Depreciation; Net Book Values Business Ratios - Performance
Corporation Tax and Step with Step Computations Cash and Factoring Calculator and Chart
What-If Calculator / Planner Dividend Cash & Solvency Calculator / Planner

The What-If Calculator and Planner

Unique to Figurewizard, the What-If Calculator and Planner enables a user to change their original input figures with single clicks of the mouse which in turn updates all of the forecasts in real time.

For example, you may choose to apply a reduction of 5% for overheads, to change the gross profit margin from 41% to 42% or increase the bank overdraft limit or loans.

As you do so the key elements of the forecasts which are displayed on that screen such as pre-tax profit, minimum / maximum months’ cash flow and bank, working capital and net worth and so on also change in real time.

Dividend, Cash and Solvency Calculator

A new and important Year-End Dividend Calculator, illustrating how the value and payment dates of a dividend will affect cash, liquidity and solvency going forward has been added to Figurewizard.

The value of a proposed year-end dividend and date of payment are entered. That then returns a breakdown showing how the monthly bank balances, available and undrawn financing, such as loans and overdraft, working capital and solvency all change, again in real time.

Cash and Factoring / Supply Chain Finance Calculator and Chart

All you have to do here is to select the percentage of your sales on open credit you with to finance, the percentage service charge if applicable and the annual rate of interest.

Figurewizard then immediately updates all of the forecasts to include this new information to show how that will change the monthly accrued bank account olus available and undrawn financing from overdraft and the factoring facility itself.

Cash and Factoring also features in the What-If Caculator and Planner.

A Note for Visitors

The sample forecasts shown on the site are based on a single working example. There is a menu to take you to these at the top left of this screen.

Sample forecasts are fully interactive. Visitors are invited to make their own changes to the sample forecasts either by selecting "edit" which takes you to the forms menus or better still by using the powerful What-If Calculator to see for yourself exactly how Figurewizard makes it possible for you to properly calculate and plan your business's profits finances and performance going forward.

The Cost, Subscribing and Saving Forecasts

For registered users all forecasts are automatically saved to "my account". Up to one hundred full sets of forecasts can be saved. These can be retrieved at any time for amending or updating.

Registration costs £20 p. a. 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