Calculating Cash Ratio in Excel

Cash ratio is used to measure a company’s liquidity and how easily it is able to cover for its short-term liabilities. To calculate cash ratio open your balance sheet, divide cash and cash equivalents with the total of current liabilities