Calculating Quick Ratio in Excel

Quick ratio shows company’s ability to meet its short-term obligations using its most liquid assets. To calculate quick ratio open your balance sheet, subtract inventory from total current assets and divide the result with the total of current liabilities.