At SWIG Finance, we are seeing first-hand the impact that the COVID-19 pandemic is having on businesses across the South West region. As part of a series, we have been speaking with our professional and business contacts to gain their insight on how businesses can navigate the business landscape during these challenging times.
In this instalment, Richard Wadman, Corporate Finance Director at PKF Francis Clark, explores how to manage financial projections for an uncertain future.
Given the interruption caused to businesses by the social distancing measures and the closure of non-essential business premises, business owners and decision makers are having to consider the impact that this has on their business and what actions will need to be taken to protect its’ short and long term future.
Financial projections are key
Financial projections will be vital for business owners to understand the implications that Covid-19 might have, what measures need to be taken as a result and what the business might ultimately look like in a few months or a years’ time.
These projections may end up being only for an internal audience but given the anecdotal statistics on applications for funding – one in three of you could be using the projections for quantifying the amount of external funding being sought.
Unfortunately for decision makers and those in a finance role, there are currently more unknowns than ever which will make this task frustrating and problematic for those involved.
Top tips – a baker’s dozen
To assist you at this time, I have compiled a list of useful hints and tips from the practices that I and my colleagues are deploying when assisting our clients with the financial projections. I also highlight the financial modelling implications of some of the key business support measures announced by the government (of which more in depth information can be found on our webpage):
Normally I would start this list by asking you to consider the purpose and target audience of the projections; specifically are they for internal planning only, or perhaps going to third parties in order to raise finance? But in this environment I would probably make sure that they are in a format suitable for sharing with third parties).
1. Remember that projections are only ever going to be a “best guess”. So,
a. Do not fret over figures being “exactly right” (whilst making sure that nothing is significantly definitely wrong!)
b. Make sure your projections models are easy to update for changes in key variables (see below)
c. Document assumptions
2. Create / use a template for the projections that separates out data entry from the production of the profit and loss account, balance sheet and cash flow forecasts. Ensure that the template integrates update of those three statements e.g., if you change assumed sales in given month and/ or cash collection of those sales ideally you make change to your inputs and the key statements are updated.
3. Start populating the model with the things you “know” e.g., current (management accounts) balance sheet and previous projections/ estimate of what the businesses’ profit and loss account for the year ahead would have looked like if not for Covid-19.
4. Consider the implications of Covid-19 on your business. We have taken the approach of starting by considering the impact on the significant profit and loss captions in the immediate future e.g.,
a. Sales reduced
b. Cost savings?
c. Government interventions (see further below)
5. Make broad assumptions about years 2 and 3 in your projections e.g., return to normality (being pre Covid figures for Year 1?)
6. Make sure you consider the cash flow implications of all balance sheet captions. You may decide to leave some balances as “brought forward, carry forward” throughout the term of the projections but make sure that is a conscious decision after due consideration.
7. Fully consider the cash flow implications of your working capital cycle and sense check debtor days etc. to historic performance.
8. Do not forget about capital expenditure, debt servicing costs and tax (on profits and VAT).
9. Project beyond the next 12 months – to give you a clearer idea as to finding requirement and debt serviceability (if applicable);
10. Where you have modelled some of the governments business support measures make sure you consider the cash flow implications:
- Coronavirus Job Retention Scheme – you pay the furloughed employees and then reclaim. Best guess as to when HMRC may be making reclaims? (My colleagues are modelling repayments a month in arrears)
- Grants (SBGF and RHLGF) – due to be with the qualifying businesses by the end of April?
- Business rates holidays – take care to ensure you separate out business rates from water rates)
- The deferral of VAT payments – take care to only carry forward the liability due for payment in the qualifying period and to include repayment of the amount deferred by 31 March 2021
- Coronavirus Business Interruption Loan Scheme – interest after year 1?
11. Consider the risk factors that could prejudice achievement of the projections and model a couple of alternative scenarios e.g., reduced sales.
12. Take a step back, consider if the resulting profit and loss, balance sheet and cash flow forecasts appear reasonable;
13. Double check the modelling assumptions to any narrative that will accompany them – see further below.
We would strongly recommend that the projections are accompanied by the “funding pack” and we have a proforma (for Covid-19 funding applications) that we are willing to share with any client who requests it. I know I and colleagues have found it useful when working with clients – in terms of structuring their thoughts and as aide memoire to ensure key aspects are covered
About Francis Clark
As the largest firm of chartered accountants, financial planners and business advisers in the region, we understand our clients’ ambitions because we share them.
This is an incredibly challenging time for all of us. We know that some difficult decisions are having to be made and we would like you to know that we are here ready to help if you need us to provide advice, support or a business sounding board.
Find out more here; https://www.pkf-francisclark.co.uk/
About SWIG Finance
We are the South West region’s dedicated CDFI (Community Development Finance Institution). This means our purpose is to make finance accessible to viable local SME’s and startups.
We lend to businesses that are unable to secure all their requirements from mainstream sources – whether due to a lack of track record, security requirements which can’t be met, historic financial issues or simply not meeting conventional credit scoring methods.
We understand that bank lending isn’t the right fit for every business, and at SWIG Finance we can often lend when the bank can’t.
For more information on out funds, visit https://www.swigfinance.co.uk/funds-available/