How to make business strategies using Financial Modeling amidst COVID-19?



Quick Summary
The COVID-19 pandemic has forced businesses, especially SMEs and start-ups, into crisis management, with cash and liquidity being paramount. Companies must prepare for various recovery shapes and potential financial risks like sales dips and delayed payments. Implementing flexible risk models and daily cash flow simulations is crucial for identifying 'red zones' and devising strategies to manage late payments, liquidity issues, and debt servicing.

With the Covid-19 induced pandemic having disrupted economies around the world, companies have been in a fire fighting mode. And the impact is more magnified for SMEs, start-ups and scale-ups. The first most critical area of consideration is cash and liquidity management.

Business owners need to clearly have a contingency plan in place and be prepared for the worst-case scenarios.

Because of the prolonged shutdown, when we re-open, the recovery could be 'V' Shaped, 'U' shaped, 'W' shaped, 'L' shaped, or as the latest report by World Economic Forum puts it - tick mark-style SWOOSH shaped.

In each of the scenarios, there is a high risk that

Financial Modelling: A COVID-19 Strategic Imperative

a) Sales will dip and inventory would choke your balance sheet
b) Debtors won't pay up on time
c) Fresh fundraising for capex will certainly take longer, so would roll-over of existing lines such as Commercial Papers (CPs)

While certainly the intensity of the Covid19 impact will vary industries, with the ones like Food probably emerging unscathed and ones like Auto and Energy would be hemorrhaging.

Companies need flexible risk models, which take into consideration the operating risk. The challenge is to model how market price and sales volume changes would impact future profits. Instead of considering a string of certain and constant cash flows, one would need to model the uncertain cash flows, which can change because of any of the underlying factors - Cash Flow at Risk (CFaR) model

The need of the hour is to have cash flow models and perform simulations/ scenario analysis on a daily basis. So maybe you could do a 2-way data table on % Dip in Revenues and % Dip in Operational Expenses.

Financial Modeling in a COVID-19 World  

In terms of cash flows, this will help you find out your red zones, as also Containment Zones.

The models would help you devise strategies for:

a) Dealing with late payments customers
b) Predict the likely delay in financial closure and project implementation due to liquidity issues
c) Model a loss of revenue, and see how you would best deal with cash shortfalls and consequent delays in servicing debt

 

Also you could model the cash flow impact of any likely relief that your business could get due to government interventions.

 

If you are a start-up in India, with the double whammy of Covid-19 and restrictions on FDI from neighbouring countries, maybe consider your cash burn rates and how long you would survive with cash in hand. You might have to revise the periodicity of cash flow forecasting from monthly to even daily and to match expenditure with collections.

Your Banking & Treasury team would have to be on its toes - assessing whether there is one cash in the war-chest in different potential downside scenarios. In scenarios where debt covenants are likely to be breached, they should immediately get into negotiations with bankers for relaxations. Also, they should keep their credit rating agencies well informed so that there are no nasty surprises.

As Covid-19 takes its toll, a surge in insolvencies can be expected. In India, the government has decided to amend the Insolvency & Bankruptcy Code (IBC) to suspend up to one-year provisions that trigger insolvency proceedings against defaulters. Still, if you have cash in your coffers, these interesting times could throw up M&A targets at quite reasonable valuations. Cash flow modeling could help in agile decision-making, giving you a competitive advantage when opportunities may be available for short windows of time. Thus, it's all the more important to find out your Cash Flow bands.

Summing up; in preparing robust financial models, businesses can react to their specific reality and, possibly, forecast a brighter tomorrow.

To register for the webinar on Financial Modeling click here

FAQ :

Financial modelling is crucial because the pandemic has disrupted economies, necessitating robust plans for cash and liquidity management, and preparing for various worst-case scenarios and recovery shapes.

Companies face risks such as dipping sales, choked inventory, delayed debtor payments, and longer timelines for fresh fundraising or rolling over existing credit lines.

The CFaR model is used to model uncertain cash flows that can change due to underlying factors, moving away from assuming constant cash flows.

Daily simulations, like using a 2-way data table on revenue and expense dips, help identify 'red zones' and 'containment zones' within cash flows, aiding in strategy development.

The Banking & Treasury team must constantly assess cash reserves, negotiate with bankers for covenant relaxations if breaches are likely, and keep credit rating agencies informed.

By enabling agile decision-making and helping identify cash flow bands, financial modelling can equip businesses to seize M&A opportunities that may arise during uncertain times with short windows.


2656 Views 4 Likes Comment   Share Career   Report


About the Author

Manager

I am a CA and graduated from IIM Ahmedabad in 2015. Worked for 10 yrs across across the likes of Deloitte,ITC Tata Steel. Our startuphttp://cajobportal.com/ is Indias first recruitment website for Chartered Accountants For Careers Guidance, do watch this channel Anurag Singal YouTube 38,000+ subscribers in June19 ... Read more

Click here to Login and post comments    OR


Related Articles


Loading


Popular Articles





CCI Pro

CCI Articles

submit article


Company
23 July 2026
CA Inter

Vikram Jadhav and Company

Pune

CA Inter

View Details
Company
11 July 2026
CA semi qualified

Vakilsearch.com

Chennai

CA Inter

View Details
Company
Featured 02 August 2026
Accounts Executive

Aashok F&C Advisory

Guwahati

CA

View Details
Company
29 July 2026
Audit Executive

RBSM Corporate Advisors Private Limited

Pune

CA

View Details
Company
21 July 2026
Chartered Accountant

Keshri & Associates

Thiruvananthapuram

CA

View Details
Company
23 July 2026
Semi qualified CA

Garg Bros & Associate CA

New Delhi

CA Inter

View Details
Company
16 July 2026
Manager - Finance & Accounts

Aliens Group

Hyderabad

CA Final

View Details
Company
ARTICLESHIP 17 July 2026
Article Assistant and B.com pass

BANSAL YOGESH AND CO

Gautam Budh Nagar

B.Com

View Details
Follow