keyboard_backspace

Cash ratio

share close
Bookmark Posts
check_circle

Bookmark Successfully Added

error_outline

Bookmark Successfully Removed

You can view all your Bookmarks from "My Bookmarks" section

What is Cash ratio?

The cash ratio or cash coverage ratio is an important liquidity ratio which is closely related to Quick Ratio and Current Ratio.

Analyzing cash ratio helps in identifying the liquidity position of the company purely in terms of cash and cash equivalents.

Cash ratio Meaning

Cash Ratio tries to build a relationship between cash available with the company and the overall current liabilities.

It shows how much Cash does the company has as against its Current Liabilities.

Hence, the Cash coverage ratio indicates the company’s ability to pay off its current liabilities using only cash.

Unlike Quick ratio and Current Ratio, Cash coverage ratio is considered as even more stringent liquidity measure since it considers only cash and cash equivalent to pay off the current liabilities.

Now, let us look understand the formula in depth.

Cash ratio formula

Cash Ratio Formula

The formula is closely related to other liquidity ratios.

We take Cash and Cash equivalent in the numerator and Current Liabilities in the denominator.

Both  Cash and Cash equivalent and  Current Liabilities can be obtained from the Balance Sheet

Below are the few important consideration for calculating the numerator and denominator.

Cash and cash equivalents

  • Only cash balance needs to be considered.
  • Other marketable securities that can be liquidated immediately should not be considered.

Current liabilities

  • Current liabilities refers to the liabilities of the company which are expected to be paid off within the current operating cycle of the company
  • It is important to note that only Current liabilities should be taken in the denominator and not total liabilities

 

Cash Ratio vs Quick Ratio

Let us quickly look at how this ratio is related to the Quick ratio.

The formula for Quick ratio is as given below

Quick Ratio Formula

 

Now, look at the formula for the Cash ratio. 

 

Cash Ratio Formula

As you can compare, in the formula of Cash ratio, Receivable balances are not considered in the numerator. 

But, when we calculate Quick Ratio, they are considered.

 

Below is a small comparison that highlights which Current Assets need to be excluded from the numerator while calculating Quick Ratio and Cash Ratio.

Quick Ratio vs Cash ratio

 

Now that we have understood the difference & relation with Quick ratio, let us look at few examples.

 

[yuzo id=1213 ]

Cash ratio example

This example is taken from the current ratio resource.

Consider the below given two hypothetical companies – Company A and Company B.

The given values are in $million.

Cash Ratio Formula example

 

To calculate the Cash Coverage ratio we need,

  • Cash and Cash equivalent
  • Current liabilities

Both the values can be obtained from the above-given Balance Sheet extract.

Company A

  • Cash and cash equivalent = $110
  • Current liabilities = $220

Company B

  • Cash and cash equivalent = $120
  • Current liabilities =$800

Now, we can use the above values to calculate the ratio.

Cash Coverage Ratio = Cash and cash equivalents / Current liabilities

Company A = $110/$220 = 0.5 times

Company B = $110/$800 = 0.14 times

 

The ratio for Company A is 0.5 times.

What this means is that for each dollar of current liability, Company A has only $0.5 worth of cash and cash equivalent.

On the contrary, Company B has $0.14 worth of cash and cash equivalent as against each dollar of current liabilities.

Compared to both the companies, Company A tends to have a higher liquidity position since it’s Cash ratio is greater than Company B.

Ideally, it is preferred to have a coverage ratio which is greater than 1. This will indicate that the company’s cash balance is sufficient to pay off its current liabilities.

But, in our example, both the companies have a coverage ratio which is less than 1. 

We need to compare this ratio with the industry benchmark and understand if such a low ratio is only company-specific or it is seen in other companies as well.

Hence, a conclusion should be drawn only after detailed peer comparison.

Cash Ratio using excel

To understand the practical application of the ratio, let us consider the Financial Statements of Walmart and calculate the cash ratio using excel.

You can download the Cash ratio template using the below option.

Cash Ratio Template

grade grade grade grade grade

6677

46

FREE

Once you download, you will see the consolidated Balance Sheet of Walmart and related calculations using excel.

 

Cash Ratio Analysis

Cash and cash equivalent

To calculate the coverage ratio, we need to exclude few current assets like Receivables, Inventory, Prepaid Expenses, etc and consider only cash and cash equivalent.

Cash and cash equivalent = $7,722

 

Similarly, from the Balance extract of Liabilities and Equity section, we can calculate Total Current Liabilities for Walmart.

 

Walmart current liabilities

 

Current Liabilities

After adding all the items which are part of current liabilities we get the total value of

Current Liabilities  = $77,477

 

Now that we know all the values, let us calculate the ratio for Walmart.

 

Cash Ratio using excel

 

Cash ratio= Cash & cash equivalent / Current Liabilities

= $ 7,722 /$ 77,477 =  0.10 times

Hence, the ratio for Walmart is 0.10 times.

 

What this means is that for each dollar of Current liabilities, Walmart has only $0.1 worth of Cash and Cash equivalents.

Ideally, it is preferred to have a cash ratio that is more than 1.

But, in the case of Walmart, the ratio is as low as 0.1 times. 

Instead of concluding on a standalone basis, the ratio has to be compared with other companies in a similar sector.

This helps in understanding if such a low cash ratio is a company-specific issue or it is an industry-wide phenomenon.

 

Cash ratio Interpretation

As already highlighted, the ratio indicates how much cash and cash equivalent does the company have as against its overall current liabilities.

Cash Ratio Less Than 1

  • If the cash ratio is less than 1, it shows that the company’s cash is insufficient to pay off its current liabilities.
  • Under such a situation, the company may have to tap other current asset life Receivables, Inventory, etc to meet its current liabilities.
  • As already highlighted, the conclusion should always be drawn after comparing the ratio for other companies in a similar sector.

Cash Ratio Greater Than 1

  • On the contrary, if the ratio is more than 1, it indicates that the current liabilities of the company can be paid off comfortably with cash and cash equivalent.
  • Under such a situation, there wouldn’t be any need to utilize other current assets like Receivables, Inventory, etc.
  • Hence, having a high cash ratio is often considered as the strongest liquidity position since all of the current liabilities can be paid off with just Cash and cash equivalents keeping other current assets untouched.

Trend Analysis

Another important way of interpreting financial ratios is by performing a Trend Analysis.

Trend Analysis refers to plotting the historical financial ratios to see how the ratio has moved over time.

It helps in understanding if the financial performance of the company is sustainable in the near future.

In this resource let us look at how the Coverage ratio profile has changed for Facebook.

 

Facebook Cash ratio

Source

Facebook generates a significant amount of cash as part of its business and tries to maintain low Current liabilities.

As evident from the chart above,  the cash ratio for the company has been increasing for the past few years. It even increased to a level of almost 11 times back in 2017.

This shows not only the efficient management of current liabilities but also the ability of the company to generate cash continuously.

Now, for the year ending 31st December 2018, the growth in cash balance was lower than that of current liabilities. Hence there is a drastic fall in the ratio.

Currently, the Facebook coverage ratio is 5.9 times.

Hence, with the help of trend analysis, we can identify any volatility in the financial ratios and try to understand its impact in the near future.

Comparison with similar companies

Similar to performing trend analysis, it is also important to understand how different is the ratio when compared to other companies.

Such a comparison with similar companies helps in understanding where is the company placed among its peers.

Home Depot Vs Walmart

Amazon Cash Ratio

 

Walmart

As we compare the coverage ratio for companies in the Retail Sector, we can clearly see that they are in lower decimals.

Generally, the companies in the retail sector have a tight working capital requirement. 

This is applicable to Walmart as well.

The company is unable to increase it’s cash and cash equivalent balance against its current liabilities.

Hence,  the ratio has been stagnant for the past 5 years in the range of 0.1 to 0.14 times.

For the year ending 31st December 2018, Walmart cash ratio is 0.1 times which is almost similar compared to the previous period.

Home Depot

As we look at Home Depot, the scenario is no different.

Even Home Depot operates with a tight working capital environment. 

The company was able to increase its ratio marginally from 2014 to 2017.

But, as evident from the chart above, the ratio has fallen back to its earlier levels.

Now, for the year ending 31st December 2018, Home Depot Cash ratio is 0.1 times which is almost similar to that of Walmart.

Amazon

When compared to companies like Walmart and Home Depot, Amazon clearly has a higher coverage ratio.

Although the ratio is not greater than 1, the company is able to manage its Current liabilities and Cash balance efficiently such that the ratio is steady in the range of 0.5 to 0.7 times.

For the year ending 31st December 2018, the Amazon cash ratio is 0.6 times.

Comparison with Tech-based companies.

Apart from companies in the Retail sector, let us now understand how different is the ratio in the case of Tech-based companies.

We will quickly analyze the ratio profile for companies like Facebook, Google, Apple, and Microsoft.

Unlike Retail companies, Tech-based companies generally have a low working capital requirement.

Hence, they have a significant amount of cash and other current assets on their Balance Sheets to meet current liabilities.

As evident from the chart below unlike other companies whose values are in decimals, Tech-based companies’ have a coverage ratio that is relatively higher.

Apple Cash Ratio

Apple

Apple is known for maintaining a huge cash balance on its Balance Sheet.

For the year ending 28th September 2019, the company had, approximately $36,600 million worth Cash and cash equivalents.

But, as we look at the coverage ratio for the company, it is less than 1. 

Back in 2015, the ratio was as low as 0.52 times.

Subsequently, the company was able to manage its Current liabilities in a better manner and increases Cash balance.

As a result of which the ratio increased to 0.7 times.

Although the value is still less than 1, the company is continuously generating significant Cash every year. This is a great indication of improving liquidity position.

Currently, for the year ending 28 September 2019, Apple cash ratio is 0.95 times compared to 0.57 times for the previous period.

Facebook

We have seen the coverage ratio profile for Facebook as part of Trend analysis above.

The company was able to generate a significant amount of cash and cash equivalents relative to its current liabilities. This helped the company in improving its overall liquidity position.

Currently, for the year ending 31st December 2018, Facebook Cash ratio is 5.9 times compared to 11 times for the previous period.

Google

As we look at the coverage ratio profile for Google, volatility in the ratio is clearly evident.

Back in 2014, the ratio was 3.8 times which increased to almost 5.1 times in 2016 and subsequently it is back to 3.7 times.

The company is trying to improve its cash coverage ratio yet the fluctuations in current liability is posing a challenge in increasing the ratio. 

Nonetheless, the company has maintained a ratio that is greater than 1.

For the year ending 31st December 2018, Google cash ratio is 3 times compared to 4.2 times for the previous period.

Microsoft

Similar to Apple, even Microsoft is unable to increase its ratio for the past 5 years.

The ratio is stagnant in the range of 1.8 to 2 times

Currently, for the year ending 30th June 2019, Microsoft cash ratio is 1.93 times. 

 

Next reading

Scroll through below recommended resources or learn other important Liquidity ratios.

Share on facebook
Facebook
Share on linkedin
LinkedIn
Share on twitter
Twitter
Share on pinterest
Pinterest
Share on whatsapp
WhatsApp
Share on email
Email

Cash Ratio Template

grade grade grade grade grade

6677

46

FREE

        

Exclusive Premium Content