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



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 Modeling in a COVID-19 World : A 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


2652 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


CCI Pro

Comments


Related Articles


Loading


Popular Articles





CCI Pro
Meet our CAclubindia PRO Members

CCI Articles

submit article


Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
09 June 2026
Accounts Associate

S Madan and CO

New Delhi

Graduate (Any)

View Details
Company
Featured 15 June 2026
Senior Auditor

N. Dhawan & Co

New Delhi

CA Inter

View Details
Company
Featured 28 May 2026
SEMI QUALIFIED/ CA DROPOUTS/ ARTICLES

T R SOOD & CO

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 23 May 2026
Article Assistants

Acupro Consulting

Gurgaon

CA Inter

View Details
Company
29 May 2026
Company Secretary - Part time

Shaswat initial support private limited

Ahmedabad

CS

View Details
Company
22 May 2026
U.S. Financial Reporting & Consolidation Manager

Karia Overseas

Ahmedabad

CA

View Details
Company
23 May 2026
Article Assistant

Geeta Manchanda & CO.

New Delhi

CA Inter

View Details