Financial Statement Analysis
 Ratio Analysis of Financial Statements (Formula, Types, Excel)
 Ratio Analysis Advantages
 Ratio Analysis
 Liquidity Ratios
 Cash Ratio
 Cash Ratio Formula
 Quick Ratio
 Quick Ratio Formula
 Current Ratio
 Current Ratio Formula
 Acid Test Ratio Formula
 Defensive Interval Ratio
 Working Capital Ratio
 Working Capital Formula
 Net Working Capital Formula
 Changes in Net Working Capital
 Current Ratio vs Quick Ratio
 Bid Ask Spread
 Liquidity vs Solvency
 Liquidity
 Solvency
 Solvency Ratios
 Liquidity Risk
 Altman Z Score
 Turnover Ratios
 Profitability Ratios
 Profitability Ratios Formula
 Profit Margin
 Gross Profit Margin Formula
 Operating Profit Margin Formula
 Operating Income Formula
 Net Profit Margin Formula
 EBIDTA Margin
 OIBDA
 Earnings Per Share
 Basic EPS
 Diluted EPS
 Basic EPS vs Diluted EPS
 Return on Equity (ROE)
 Return on Capital Employed (ROCE)
 Return on Invested Capital (ROIC)
 ROIC vs ROCE
 ROE vs ROA
 CFROI
 Cash on Cash Return
 Return on Total Assets (ROA)
 Return on Average Capital Employed
 Capital employed Employed
 Return on Average Assets (ROAA)
 Return on Average Equity (ROAE)
 Return on Assets Formula
 Return on Equity Formula
 DuPont Formula
 Net Interest Margin Formula
 Earnings Per Share Formula
 Diluted EPS Formula
 Contribution Margin Formula
 Unit Contribution Margin
 Revenue Per Employee Ratio
 Operating Leverage
 EBIT vs EBITDA
 EBITDAR
 Capital Gains Yield
 Tax Equivalent Yield
 LTM Revenue
 Operating Expense Ratio Formula
 Overhead Ratio Formula
 Variable Costing Formula
 Capitalization Rate
 Cap Rate Formula
 Comparative Income Statement
 Capacity Utilization Rate Formula
 Total Expense Ratio Formula
 Efficiency Ratios
 Dividend Ratios
 Debt Ratios
 Debt to Equity Ratio
 Debt Coverage Ratio
 Debt Ratio
 Debt to Income Ratio Formula (DTI)
 Capital Gearing Ratio
 Capitalization Ratio
 Interest Coverage Ratio
 Times Interest Earned Ratio
 Debt Service Coverage Ratio (DSCR)
 Financial Leverage Ratio
 Financial Leverage Formula
 Net Debt Formula
 Leverage Ratios
 Operating Leverage vs Financial Leverage
 Current Yield
 Debt Yield Ratio
What is Cash Ratio Formula?
Cash ratio is also known as a liquid ratio or cash asset ratio is a liquidity ratio.
The formula for Cash Coverage Ratio can be represented as:
Cash ratio is a liquidity ratio which measures the ability of the Company to repay the current liabilities only using its cash and cash equivalents. It is an extreme liquidity ratio than the other liquidity ratios i.e. current ratio and quick ratio as it requires the current liability to be settled using only the cash and cash equivalents.
Examples of Cash Coverage Ratio Formula (with Excel Template)
Let’s see some simple to advanced example to understand the calculation of the cash coverage ratio formula better.
Cash Coverage Ratio Formula – Example #1
A Company XYZ Inc. has following items on its balance sheet. Calculate the cash ratio formula for the same.
For the calculation of cash ratio formula first, we will need to calculate Cash and Cash Equivalents and Current Liabilities
Cash and Cash Equivalents
Thus, Cash and Cash Equivalents = 15000 + 12000 = $ 27000
Current Liabilities
Therefore, Current Liabilities = Accounts Payable + Short term debt = 20000 + 5000 = $ 25000
So, the calculation of cash ratio equation can be done as –
i.e. Cash Ratio Formula = 27000/25000
So, Cash Ratio will be –
Therefore, Cash Ratio =1.08
The value of cash ratio = 1.08 shows that the Company has enough cash and cash equivalents to cover its company’s current liabilities. Thus, the Company is considered liquid and can service its debt easily.
Cash Coverage Ratio Formula – Example #2
Let us look at this industry example to understand Cash Ratio Equation better:
The following snapshot shows a consolidated balance sheet of Apple Inc. for the year ended 2018 and 2017.
Source: Apple SEC Filings
With the help of the above balance sheet, we have gathered the following information.
Calculation of Cash Ratio for the year 2018
Cash ratio for year 2018 = 25913/116858 = 0.22
Calculation of Cash Ratio for the year 2017
Cash ratio for year 2017 = 20289/100814 = 0.20
The cash ratio of the Company increased from 0.20 to 0.22 from the year 2017 to 2018. This shows that the liquidity position of the Company bettered from the year 2017 to 2018.
Cash Ratio Formula – Example #3
A Company XYZ Inc. has cash bank balance as $ 50000 and cash equivalents of $ 60000. The Company has current liabilities of $ 200000. The cash ratio of Company XYZ Inc. is as below.
The Cash ratio can be found by adding both cash and cash equivalents and dividing them by the current liabilities. The calculation of Cash Ratio Formula will be –
Cash Ratio will be –
Cash Ratio of Company XYZ Inc. is 0.55
You can download this Cash Ratio Formula Excel Template here – Cash Ratio Formula Excel Template
Cash Ratio Formula Calculator
You can use the following Cash Ratio Formula calculator.
Cash & Cash Equivalents  
Current Liabilities  
Cash Ratio Formula =  
Cash Ratio Formula = 


Relevance and Use of Cash ratio Formula
 Creditors are more likely to look at the cash ratio of the Company than the investors as it guarantees whether the Company can service its debt or not. Since the ratio does not use inventory and accounts receivables, the creditors are assured that their debt is serviceable if the ratio is greater than 1.
 Accounts receivables can take weeks or months to be converted to cash and inventory may take months to be sold, however, cash is the best form of an asset which is used to pay off the liabilities. Hence, creditors take solace and provide loans to Companies with better cash ratios.
 Although a higher cash ratio is preferred by the creditors the Company does not keep it too high, Cash ratio of more than 1 suggests that the Company has too high cash assets and it is not able to use it for profitable activities. The Companies do not maintain high cash assets because idle cash in bank accounts do not generate good returns hence, they try to use it for projects, acquiring new businesses, mergers, and acquisition, research, and development process so as to generate better returns. Due to this reason, a cash ratio in the range 0.51 is considered good.
 Although cash ratio is a stringent liquidity measure, the investors do not look at the ratio very frequently during fundamental analysis of the Company. Investors would like the company to utilize its idle cash to generate more profit and income.
 The investors are better off if the company pays off its debt in time and uses idle cash to reinvest in the business activities and generating better returns.
Conclusion
Cash ratio formula is Cash and Cash equivalents/Current Liabilities. It is a liquidity ratio which measures the ability of the company to pay its current liabilities utilizing its cash assets only. It is the most stringent liquidity ratio and highly restrictive as compared to the current ratio and quick ratio. It is most helpful to the creditors of the company as they would like the company to have more assets in the form of cash and cash equivalents.
The investors would like to have less cash on the balance sheet as they would prefer the company to invest in business activities to generate higher returns. Cash ratio of 0.5 – 1 is most preferred. Cash ratio may not be a good measure of fundamental analysis of the company; it only provides the ability of the company to remain solvent in short term.
Recommended Articles
This has been a guide to Cash Ratio Formula. Here we discuss how to calculate cash coverage ratio using its formula along with practical examples and excel downloadable template. You can learn more about financial analysis from the following articles –
Leave a Reply