This is a Working Example of our Forecasts
Registered users can produce their own business forecasts in minutes; exactly as is shown here.

How to Calculate and Forecast Cash Flow After Dividends

Simply enter the value of proposed dividends and payment date to view changes to forecast monthly cash flow, liquidity and balance sheet net worth.

12 Months from 1st...

May 2017 May 2018 May 2019

Profits Available

114,238 213,118 465,478

 

Year End Dividend

Dates Dividends Paid

Bank overdraft limit

Factoring / Invoice discounting

Factoring Ratio (% invoice value discounted)
Factoring Service Charge
Factoring Interest
 

12 Months from 1st...

May 2017 May 2018 May 2019
 

Bank Plus Undrawn Financing

  Before After Before After Before After
  22,314 22,314 8,758 8,758 53,207 53,207
  7,629 7,629 -2,301 -2,301 49,062 49,062
  3,799 3,799 -3,092 -3,092 52,529 52,529
  -16,263 -16,263 -21,567 -21,567 44,302 44,302
  -13,400 -13,400 -14,744 -14,744 50,984 50,984
  8,171 8,171 15,719 15,719 77,613 77,613
  38,207 38,207 57,986 57,986 126,678 126,678
  50,460 50,460 87,725 87,725 216,116 216,116
  54,920 54,920 106,820 106,820 268,690 268,690
  29,339 29,339 81,134 81,134 251,183 251,183
  29,958 29,958 86,413 86,413 255,221 255,221
  14,561 14,561 77,770 77,770 266,366 266,366
 

Solvency and External Finance

  Before After Before After Before After
Debt to Asset Ratio 56.5% 56.5% 33.8% 33.8% 23.7% 23.7%

Increase / Decrease Borowings

53,854 53,854 -74,846 -74,846 -178,834 -178,834
 

Working Capital and Liquidity

  Before After Before After Before After

Net Current Assets: Working Capital

76,492 76,492 168,133 168,133 404,336 404,336
Quick Ratio (Short Term Liquidity) 0.66 0.66 1.17 1.17 2.74 2.74
 

Profit & Loss  and Equity

  Before After Before After Before After

Retained Profits C / Fwd

114,238 114,238 213,118 213,118 465,478 465,478

Net Assets / Equity C / Fwd

119,238 119,238 218,118 218,118 470,478 470,478

Reward for Enterprise

When declaring a year end dividend and when to pay it most SME s must first establish what it will do to liquidity, cash flow and solvency. Working with Figurewizard this calculator enables you to plan what will be sustainable.

Diidends cannot be declared on the expectation of profits alone no matter how reasonable that expectation may be. The profits have to be indisputably present in the company's balance sheet beforehand.

Using the What-If Calculator for Liquidity and Cash Flow.

You should always be careful when declaring dividends. For example if Figurewizard's dividend calculator tells you that for some months' the bank plus undrawn and available finance will be returning deficits, action must be taken to eliminate them.

Apart from changing the value of dividends you have three options to resolve forecast cash flow deficits; budgeting, financing or both. For financing you can update the bank overdraft and / or select factoring on this page but for more comprehensive planning Figurewizard makes it possible to plan with all three using the unique Interactive What-If Calculator. What follows describes how to do this.

1 Enter the proposed value for year-end dividend(s)
2 Select month payable - 1st month means the dividend is to be paid when declared. 
3 If in "after" any month's Bank and undrawn financing are in deficit, select "Apply Changes" and go to the What-If Calculator
4 Note: Applying changes updates all of the forecasts to include the value of the dividends.
5 In What-If make changes to overheads, assets and financing until Min Bank + undrawn (under Cash, Bank and Solvency) is zero or better.


The What-If calculator allows you to change youur original forecast values for profit margins, overheads, investment and all kinds of financing including bank overdraft, fixed term loans, asset finance and factoring / supply chain financing.

The key result when you are making changes will be "Min Bank and Undrawn Financing" under "Cash Bank and Solvency". Your target will be to see that is greater than zero. If your changes can't do that and you have no other options then you must reconsider the size of the dividend.

How the Dividend Calculator's Figures are Produced

Using Figurewizard, the first step is to produce a full set of forecasts. That is actually a lot simpler than it sounds.

The forecasts are produced from nothing more than a user's own forecast figures for for sales, margins, overheads, financial arrangements and investments. Entering those figures will be a matter of minutes.

That is all our system needs because it then does all of the work to produce the forcasts, including calculating and applying VAT, capital allowances and corporation tax. No further input is called for from a user.

This calculator and all of the sample forecasts on this site are working examples, based on a single set of such figures.

Dividends as a Current Liability

A dividend is charged as a current liability to the balance sheet from the day it is declared.

As a result working capital (net current assets) is reduced by the value of the dividend on the date of declaration, not on the date payable which may be sometime in the future. Similarly a shareholder's liability for personal tax on a dividend arises from the date of declaration not the date of payment.

Dividends and Director's Responsibilities

Great care should always be exercised when declaring dividends. Forecasting and planning their consequences on the future financial position of the business is important to avoid possible breaches of company law.

Under section 174 (1) of the Companies act directors have a stautory duty to exercise reasonable "care, skill and diligence". Declaring dividends that put future cash flow solvecy at risk is a classic example of not exercising care, skill and diligence.

In the event of a company becoming insolvent it becomes possible for directors' responsibilities under the Companies act to change. If insolvency remains unaddressed those responsibilities shift to acting in the best interests of creditors under the Insolvency act.

In the event of the company failing there might then be a risk of personal liabilty for part or in extreme cases even all creditor claims regardless of limited liability. Ignorance of the law is no defence.

Legal and Illegal Dividends

The Companies act 2006 sec. 830 (1) states: A company may only make a distribution out of "profits available for the purpose". That means retained profits as recognised in the balance sheet.

Dividends that fail to comply with this requirement are deemed to be illegal and their declaration as "ultra virus" meaning that by declaring them directors have acted beyond their powers. That would result either in an order to repay the dividend or for its value to be assigned to directors' loan accounts and subject to a corporation tax charge.

HMRC's options don't stop there though as it is also possible for them to take the view that illegal dividends should be treated as salary, making them chargeable for both income tax and NI plus employer's contribution for NI.

Forecasting the Consequences of Dividends

Despite all of the above, the process of declaring dividends is not really a minefield as long as at the time of declaration their consequences on future liquidity and cash flows have been taken into account and resolved if need be.

That is what this dividend forecaster and the What-If Calculator are for and why they are recommended to you and your advisors.

FAQs
Corporation Tax and Marginal Relief From 2023 Deferred Income Explained What is a Monthly Cash Flow Forecast What is Pretax Profit How does a balance sheet balance? Lockdown Recovery: Forecasting Profits, Cash and Finance. How to Apply for Business Interruption Scheme with Figurewizard 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 How Depreciation is Calculated 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