COVID-19 Cashflow Survival & Stimulus Assessment Tool

Read our instructional guide below on how to use this template more effectively

Analysing cashflows

There are many ways to analyse cashflow required. One way is to prepare a cashflow forecast incorporating all the elements of cash inflows and outflows in a business. From there, one can determine the likely cash position at any period in time provided that the assumptions used are accurate.

Quick analysis

This template is designed to help businesses analyse how long their cash reserves can last before they run out of cash. The template also helps them to understand the government measures in the Stimulus Packages which can assist them to find more cash (eg via wage subsidy scheme), defer cash usage (eg via CP204) and obtaining more cash (eg via getting more loans).

This template provides a quick and less detailed analysis of cashflows. From the information in the "Home & Snapshot" page, we can estimate how long the company can survive before its cash reserves run out, what measures could be used to improve cashflow and the effect of these measures on the company's survival.

How to key-in Information

Please key in information only in the spaces in blue. The non-blue cells are locked. The light yellow cells are likely to contain formulas.

Navigation

Please use the sidebar hyperlinks to navigate. It is best to start from the "Home & Snapshot" page.

Assessment Tool Sidebar

How to use this template

Key in Company name and Period for this exercise

Assessment Tool Fill in details

Key in Funds available

Assessment Tool Funds

Key in Outflows for period

Assessment Tool Outflow

Key in Govt assistance

Assessment Tool Govt Assistance

Key in other figures in Tax measures / WSP / Loans / ERP / HRDF / ERP (sidebar)

Assessment Tool Tax Measures

Meaning of "period"

You can use this template to calculate the position for a period longer than 1 month. However, you have to key in the period used for this exercise in the "Home & Snapshot" page. "Period" used in this exercise means the period for calculating the results. For example, if we use a period of 3 months, we are estimating the cash outflows in the next 3 months and using that figure to compare against the funds available to calculate the period of survival.

Base case, best case and worst case

You can use the different columns in the various pages to assess the results under the respective base case, best case and worst case.

Assessment tool Base case, best case and worst case

Some useful tips to manage in a crisis

Act fast. You don't have time.
Stringent measures may be needed to save the business. You should be mentally prepared to make difficult decisions for the good of the organization as a whole.
Speak with sincerity to staff, customers and suppliers alike.
Address every item of cost and income. Nothing is sacred in a crisis.
You have no control over the waves of COVID-19 but you can plug the hole in your company.

COVID-19 Cashflow Survival & Stimulus Assessment Tool

How long can your cash reserves last during this COVID-19 pandemic?
To help you in the most critical phase of this crisis, we have designed a Cashflow Survival & Stimulus Assessment Template. The purpose of this template is to help you analyse how long your business’ cash reserves can last. This will give you a clear view of your business' financial health, thus empowering you to plan ahead of time before your cash reserves run dry.

The template can also help you to understand the Malaysian government’s measures in the Stimulus Packages which can assist you in:

Maximizing your cashflow (e.g. via the Wage Subsidy Scheme (WSP)
Defer cash usage (e.g. via revision of the CP204 tax estimates); or
Obtain more funding (e.g. via loans).

Contact us

Crowe is the fifth largest accounting firm in Malaysia, providing audit, tax, corporate advisory, risk advisory, growth consulting and wealth management. Discover extraordinary ways to grow.

or talk to us