Expert opinion

6 Things to Consider When Building a Good Financial Model

Colin Burns, Director and business funding advisor at Shaw & Co, shares six essentials for business owners to consider when preparing a financial model.

3 minutes
January 24, 2022
Words:
Colin Burns
Images:
Stil on Unsplash & Tim Gander Photography
PDF:
Report

Not only does a good financial model provide a business owner with a clear overview of their company’s financial health, it also provides a potential lender or equity investor with the reassurance that a SME is paying strict attention to the bottom line – money.

"Getting a financial model wrong can have perilous consequences."
Colin Burns
Director, Shaw & Co

Although it may seem like a given, getting a financial model wrong – or filling it with the wrong information – can have perilous consequences, especially when trying to secure funding for business growth. Recently we came across a profitable family-owned business that had gone into liquidation simply because it had a hugely inexperienced financial director (a family member) who had not kept the management team updated on the company’s financial situation. The company was taking on numerous – and very expensive - individual loans when it should have consolidated all borrowing and extended the overall repayment profile. This created an unworkable cash servicing requirement which was, ultimately, unaffordable.

So, with this in mind, here are six things to consider when building your financial model:

1 - The Basics

At the very least, your financial model should clearly show your Profit & Loss (P&L), balance sheet and details of your cashflow. It should also be integrated so the impact of any change in working capital, or deviation in P&L terms, can be immediately and clearly highlighted in the resultant cashflows, thereby identifying potential ‘pinch’ points in cash reserves.

2 - Live Data

Your financial model should be a working document which clearly shows month-by-month performance, as well as the projected growth over, say, a three or five year period.  

3 - Remember the Funders  

Funders will draw confidence from models that reflect how incoming capital will work in the business, tracking factors such as return on investment and cash burn (equity); or leverage, covenant performance and cash available for debt service (debt).

Colin Burns – Business Funding expert at Shaw & Co
Colin Burns – Business Funding expert at Shaw & Co

4 - The Right Details

Insufficient granularity in the model can let a business down; for example where multiple product lines are averaged instead of presenting the performance of each  product. It is also important to highlight other potential issues such as a vast majority of sales being harvested by a handful of star executives, or coming from too few key customers. Income seasonality can also be ‘hidden’ in quarterly rather than monthly projections.

5 - Not Too Much Detail

Businesses regularly try to capture every detail in their model. This is as bad as insufficient detail as the model soon becomes unworkable and falls out of date. Understanding the right balance is an art as much as science and one that can only be developed with experience.

6 - Company Strategy

Great models integrate a clear and concise monthly reporting pack for a company’s management team, enabling them to make key strategic decisions based on the very latest financial information ‘from the coalface’.

We work with growing UK SMEs and small-cap PLCs that have funding needs in excess of £2m and regularly approaching £100m. Our clients’ needs will typically be for sophisticated finance products such as cash flow based lending or private equity investments. Our value lies in helping clients access funding that relies on confidence in future trading and cash flows. For a confidential, independent, no obligation discussion on the funding options available click the 'Let's chat' button.
Words:
Colin Burns
 - 
Director
Read 
Colin Burns
's bio

Sector Content

See all Shaw Reports
The Shaw Report - Healthcare & Life Sciences Annual Review December 2022

Shaw Report

|

December 14, 2022

The Shaw Report - Wholesale & Retail Trade Industry Interim Review December 2022

Shaw Report

|

December 14, 2022

The Shaw Report - Leisure, Tourism and Sport Annual Review November 2022

Shaw Report

|

November 29, 2022

The Shaw Report - Property & Construction Industry Interim Review November 2022

Shaw Report

|

November 23, 2022

The Shaw Report - Technology Media & Telecoms Industry Annual Review October 2022

Shaw Report

|

October 19, 2022

The Shaw Report - Automotive, Transport & Logistics Industry Annual Review October 2022

Shaw Report

|

October 12, 2022

The Shaw Report - Professional Services Industry Interim Review September 2022

Shaw Report

|

September 26, 2022

The Shaw Report - Manufacturing & Engineering Industry Annual Review September 2022

Shaw Report

|

September 1, 2022

The Shaw Report - Banking, Financial and Insurance Services Industry Interim Review August 2022

Shaw Report

|

August 23, 2022

The Shaw Report - Healthcare & Life Sciences Interim Review August 2022

Shaw Report

|

August 11, 2022

Food & Beverages Industry Report 2022

Shaw Report

|

July 22, 2022

The Shaw Report - Leisure, Tourism & Sport Interim Review July 2022

Shaw Report

|

July 19, 2022

The Shaw Report - Energy & Natural Resources Interim Review June 2022

Shaw Report

|

June 27, 2022

Shaw & Co launches annual analysis of wholesale & retail trade industry

Shaw Report

|

June 29, 2022

The Shaw Report - Automotive, Transport & Logistics Interim Review May 2022

Shaw Report

|

May 19, 2022

Shaw & Co Launches Annual Analysis of Property and Construction Industry

Shaw Report

|

May 6, 2022

The Shaw Report - TMT Interim Review May 2022

Shaw Report

|

May 5, 2022

The Shaw Report - Manufacturing & Engineering Interim Review April 2022

Shaw Report

|

April 8, 2022

The Shaw Report - Food & Drink Interim Review March 2022

Shaw Report

|

March 25, 2022

The Shaw Report - Professional Services Annual Review 2022

Shaw Report

|

March 17, 2022

The Shaw Report - Leisure, Tourism & Sport December 2021

Shaw Report

|

December 14, 2021

The Shaw Report - Health & Life Sciences December 2021

Shaw Report

|

December 10, 2021

The Shaw Report - Banking, Financial & Insurance Services December 2021

Shaw Report

|

December 8, 2021

The Shaw Report - Energy & Natural Resources November 2021

Shaw Report

|

November 16, 2021

The Shaw Report - Technology, Media & Telecoms October 2021

Shaw Report

|

October 28, 2021

The Shaw Report - Automotive, Transport & Logistics October 2021

Shaw Report

|

October 14, 2021

The Shaw Report - Manufacturing & Engineering October 2021

Shaw Report

|

October 1, 2021

The Shaw Report - Food & Drink September 2021

Shaw Report

|

September 27, 2021