27th March 2020

We are aware ​that many businesses are having to quickly prepare 12 week cash flow forecasts. This is either as part of the application process for the Coronavirus Business Interruption Loan Scheme (CBILS) and/or as part of their own internal cash management process.

Whilst many businesses have the resources and experience available to do this, we are aware many do not. ​To lend our support to business in the North East, we have prepared a user friendly template, which is free to download. We hope this will ​give a head start to companies ​grappling with managing their cashflow in these uncertain times.

Click here to download our 12 week cash flow forecast model (Excel worksheet 87KB) 

 

This template is designed for relatively straight forward businesses, and it will not be appropriate for more complex scenarios. We are also aware that banks, in many cases, will require a more comprehensive ​suite of financial information in order for them to be able to make an informed lending decision. It is impossible to provide a template for this, but should you need help in preparing more comprehensive forecasts please get in touch and we can assist. UNW has one of the largest and most active corporate finance teams in the North East and we are on-hand to help ​our clients and North East Business through these difficult and uncertain times.

As a reminder, CBILS was announced by the Chancellor, Rishi Sunak, in order to support businesses, public services, and people throughout this uncertain period. It is a temporary initiative where-in the government will provide certain lenders with a guarantee of 80% on loans to businesses with a turnover of up to £45m. Loans from between £1,000 to £5,000,000 will be made available and delivered by the British Business Bank through its participating providers. More details about the CBILS scheme can be accessed here.

Please get in touch with our corporate finance team should you have any questions relating to the CBILS application process.

John Healey (Corporate Finance Partner)
johnhealey@unw.co.uk or 07949 235813

Paul Kaiser (Corporate Finance Partner)
paulkaiser@unw.co.uk or 07768 808877

 

IMPORTANT DISCLAIMER

This model template has been made available as a download to provide a tool to be used by potential applicants to the CBILS scheme. Any forecasts derived using this model have not been reviewed or checked whatsoever by UNW. Furthermore users of this model should not hold out or imply in any way that UNW are engaged to provide advice to the user.

By using this model template you agree to conduct your own validation and take responsibility for the outputs of the model. You agree that UNW LLP, its partners and staff neither owe nor accept any duty to you, whether in contract or in tort (including without limitation, negligence and breach of statutory duty) or howsoever otherwise arising, and shall not be liable, in respect of any loss, damage or expense of whatsoever nature which is caused by your reliance upon this model template. If you wish to rely on the outputs of this model template you agree to do so entirely at your own risk.

The Government announced more details of changes to the Coronavirus Job Retention Scheme (CJRS) rules on Friday evening (12th June),

These are clearly unprecedented times, and we are dedicated to keeping our clients and contacts updated on measures announced by

In the wake of the COVID-19 pandemic, many organisations have been understandably focused on stabilising cash-flow. As restrictions start to

In his announcement on Friday (29 May), the Chancellor gave further details of the changes to the Coronavirus Job Retention

In the wake of the COVID-19 pandemic, many businesses have been understandably focused on stabilising cash-flow. As restrictions start to