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.
Figurewizard produces thirteen accurate budgeted forecasts, including profit and loss, balance sheets, the bank, cash flows and business ratios from nothing more than your own projected figures for sales, gross margin, overheads, financing and so on plus a few simple ratios.
A complete set of profit and loss, balance sheet, liquidity and cashflow forecasts can set the average business backs several hundred pounds.
The average cost of producing these can run into charges or annual subscriptions of hundreds of pounds. Figurewizard however produces thirteen such forecasts (listed below) for half the price of a parking ticket. That includes saving up to a hundred complete sets of forecasts to “my account.”
Everything, including forecast corporation tax and VAT are calculated and applied to forecasts by the system with no further input called for from you.
The forecasts come simply from your own projected figures for sales, gross margin, overheads and so on plus a few simple ratios. Entering your figures should take no more than a matter of a few minutes.
As you are doing so, our system is automatically calculating and applying VAT and corporation tax. Options include apply adding factoring / supply chain financing and purchases by letter of credit to the forecasts.
Up to a hundred complete sets of forecasts for one, two or three years can by saved.
Two key calculators are also produced: One, the What-If Calculator enables before and after fine tuning for profits, cashflows and liquidity. The other takes just the value and date issued for a dividend forecast to return before and after values for monthy cash flows, liquidity and net assets / equity.
Unlike other forecasters costing hundreds of pounds a year in subscriptions, Figurewiard costs just £30 a year. In addition everything that it produces is shown on the site as live working examples. Up to a hundred complete sets of forecasts can be saved to "my account".
Visitors are free to try everything out and make their own changes to the forecasts shown, either by editing its original figures or better still, by using the What-If Calculator. Another is the important Dividend Calculator that shows how proposed dividends will change cash flow and liquidity forecasts going forward.
These are the forecasts and planners that Figurewizard creates from your projected figures:
Up to a hundred complete sets of forecasts can be saved to "My Account." They can be retrieved for amendment or update at any time. Forecasts can be exported to Excel for formatting and printing.
Two powerful calculator / planners are created too including the unique and powerful What-If Calculator - Results are all delivered online in real time.
Entering your proposed annual figures and ratios into the forms is nothing more than a matter of "how much" or "how many". As a result, each of the forms should take more than a minute or two to complete. They are as follows:
The system does the rest, turning your figures into the forecasts and calculator / planners. That includes calculating and applying VAT transactions, quarterly VAT remittances and corporation tax.
You enter your figures excluding VAT with the sole exception of purchasing or leasing new company cars: That is because VAT cannot be recovered as input tax for cars. That does not apply however to commercial vehicles whose values are always recognised as "main pool assets."
By the same token when a company car is sold, VAT is not added to the sale.
Forecast sales by month are calculated as percentages of the sales forecast for the year. For example January may represent 6% of annual sales, February 4%, March 7% and so on up to 100%.
The system calculates sales by transaction type. All that is needed is for you to select percentages from the drop down boxes as follows:
Receipts are similarly broken down as percentages of the year's sales. All you have to do is select the appropriate percentage from the drop-down list as follows:
The forecast values of these are charged to monthly profits in line with monthly sales volume, again by selecting the appropriate simple percentages:
Details of cash collection for credit sales are simply entered as the percentages of invoicing you expect to be paid up by month as follows:
And so on up to 100%. Payments for purchases from suppliers of goods and overheads on open credit are entered in exactly the same way. Purchases by letter of credit (if used) are dealt with separately in the form.
A powerful planning tool and unique to Figurewizard, the What-If Calculator and Planner enables you to change your 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 or change the gross profit margin from 41% to 42% or to increase the bank overdraft limit and loans.
As you make those changes the key elements of the forecasts which are displayed on the screen such as pre-tax profit, minimum / maximum months’ cash flow and the bank, working capital and net worth immediately update.
These are displayed as "before" and "after" together with the values by which they have been changed. The same before and after values are displayed in the accompanying charts illustrating profitability and accrued cashflow.
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 instantly update.
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.
That results in all of the forecasts instantly updating to include this new information to illustrate how the monthly bank account plus undrawn financing from the bank overdraft and factoring facility changes.
The Cash and Factoring / Supply Chain Finance calculator also features in both the What-If Caculator and the Dividend Planner.
All calculators work in real time. As changes are made, the results to profits, balance sheets, cash flows, the bank and so on change too. That includes re-calculating and applying VAT, corporation tax and interest charges.
There are two important optional extras - Forecasting cash flow from factoring / supply chain finance and purchases by Letter of Credit.
With factoring / supply chain finance, you simply select the following.
The system then automatically calculates and applies the effect of these to all forecasts.
With purchases by letter of credit, select the following:
Note that "confirmed arrival" represents the point at which the documents supporting the shipment of your order have been accepted by yourself.
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 (without any prior obligation) either by selecting "edit" which takes you to the forms' menus or better still 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.
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.
The subscription costs £30 p. a. There are no other charges.