{"id":267337,"date":"2024-03-13T20:08:06","date_gmt":"2024-03-13T19:08:06","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=267337"},"modified":"2026-11-18T14:37:44","modified_gmt":"2026-11-18T13:37:44","slug":"ratio-liquidite-immediate-calcul","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/finance-processes\/quick-ratio-calculation\/","title":{"rendered":"Ratio de liquidit\u00e9 imm\u00e9diate : calcul, formule et exemples"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Liquidity ratios are among the many financial ratios used to evaluate a business&#8217;s financial health and performance. Specifically, they express the company\u2019s ability to pay back short-term debt using current assets. Popular liquidity ratios include the quick ratio and <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/current-ratio-calculation\/\">current ratio<\/a>.<\/p>\n<p>The quick ratio, aka quick asset ratio or acid test, considers only highly liquid assets, like cash or securities. The company&#8217;s financial statements have the information you need for the quick ratio calculation.<\/p>\n<p>In this article, you will learn about the quick ratio and what it says about a company\u2019s financial situation. You will also learn how to calculate the quick ratio in Google Sheets and interpret its value in the context of the company\u2019s industry.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;quick-ratio-calculation&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Quick ratio calculation<\/h2>\n<p>The quick ratio, or quick asset ratio, results from dividing quick assets by current liabilities. Quick assets are those that can be turned into cash quickly &#8211; within 90 days. The value of quick assets can be added using the <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/how-to-read-a-balance-sheet-with-examples\/\">balance sheet<\/a> data. This is easy to set up in a template, using tools like Excel or Google Sheets. Remember to only include highly liquid assets like cash, accounts receivable, and marketable securities &#8211; no inventory or prepaid expenses.<\/p>\n<h3>Quick ratio formula<\/h3>\n<p>The quick ratio can be calculated using the following formula:<\/p>\n<blockquote>\n<p>quick ratio = quick assets \/ current liabilities<\/p>\n<\/blockquote>\n<p>If the value of quick assets is not directly available, you can always calculate it yourself from the data available on the balance sheet.<\/p>\n<blockquote>\n<p>quick ratio = (cash + marketable securities + accounts receivable) \/ current liabilities<\/p>\n<\/blockquote>\n<p>or<\/p>\n<blockquote>\n<p>quick ratio = (current assets &#8211; (inventory + prepaid expenses)) \/ current liabilities<\/p>\n<\/blockquote>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-a-good-quick-ratio&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>What is a good quick ratio?<\/h2>\n<p>A quick ratio above 1 is considered good, as this usually means current debt can be paid for using highly liquid assets, like cash and marketable securities. This makes creditors and investors happy, as it implies financial stability; current liabilities can be covered without having to sacrifice long-term assets.<\/p>\n<h3>What if the quick ratio is less than 1?<\/h3>\n<p>A quick ratio below 1 usually means that the company could struggle to meet short-term obligations using quick assets. An unexpected setback could force the company to sell long-term assets to pay the short-term debt. However, they might find that long-term assets are harder to sell, particularly without incurring significant losses.<\/p>\n<p>Within reason, the higher the ratio, the better: a ratio that is too high could indicate problems in the company\u2019s management and accounting practices. Remember to get industry benchmarks to compare quick ratio values. Depending on various factors &#8211; like the type of industry and the size of the company &#8211; the acceptable top range of values may vary.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;quick-ratio-vs-current-ratio&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Quick ratio vs current ratio<\/h2>\n<p>While the quick ratio focuses exclusively on highly liquid assets, the <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/current-ratio-calculation\/\">current ratio<\/a> provides a broader view by considering all current assets. In other words, it expresses the company\u2019s ability to cover its short-term liabilities within a year using current assets.<\/p>\n<p>Quick ratio examples<\/p>\n<p>If a company has quick assets valued at $85,000.00 and its current liabilities total $53,000.00, the quick ratio can be calculated as follows:<\/p>\n<blockquote>\n<p>$85,000.00 \/ $53,000.00 = 1.603773585<\/p>\n<\/blockquote>\n<p>A ratio of 1.6 would usually be considered very healthy.<\/p>\n<p>However, if quick assets are worth $53,000.00 and liabilities are $85,000.00:<\/p>\n<blockquote>\n<p>$53,000.00 \/ $85,000.00 = 0.6235294118<\/p>\n<\/blockquote>\n<p>A quick ratio with a value of 0.62 is something that most investors would be concerned about, although there may be exceptions.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-calculate-the-quick-ratio-in-goog&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to calculate the quick ratio in Google Sheets?<\/h2>\n<p>Let\u2019s say you want to calculate the quick ratio for Company A in Google Sheets. The company has the data shown below on the balance sheet.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/quick-ratio-balance-sheet-data.webp&#8221; alt=&#8221;Quick ratio in Google Sheets \u2014 balance sheet with total current assets of $1,085,500.00 and total current liabilities of $801,833.00&#8243; title_text=&#8221;Balance sheet with total current assets of $1,085,500.00 and total current liabilities of $801,833.00&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>1.<\/strong> In an empty cell, type in the &#8216;=&#8217; sign and open the parenthesis. Add the cells with the values for the quick assets.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/quick-ratio-formula-add-quick-assets.webp&#8221; alt=&#8221;Quick ratio formula \u2014 =(B3+B4+B5) in cell E1 next to the Quick Ratio label, adding cash, marketable securities, and accounts receivable&#8221; title_text=&#8221;=(B3+B4+B5) in cell E1 next to the Quick Ratio label, adding cash, marketable securities, and accounts receivable&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> After closing the parenthesis, add the &#8216;\/&#8217; sign and click on the cell with the value for total current liabilities.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/quick-ratio-formula-divide-current-liabilities.webp&#8221; alt=&#8221;Quick ratio formula \u2014 =(B3+B4+B5)\/B29 dividing quick assets by total liabilities of $801,833.00&#8243; title_text=&#8221;=(B3+B4+B5)\/B29 dividing quick assets by total liabilities of $801,833.00&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> Press \u201cEnter\u201d to get the quick ratio.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/quick-ratio-calculation-result.webp&#8221; alt=&#8221;Quick ratio calculation \u2014 cell E1 showing a quick ratio of 0.9858661342&#8243; title_text=&#8221;Cell E1 showing a quick ratio of 0.9858661342&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;conclusion&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Conclusion<\/h2>\n<p>Now you know how to calculate the quick ratio using data found on the balance sheet. You also know how to add the formula directly in your spreadsheet and include this ratio in your balance sheet template. With <a href=\"https:\/\/www.sheetgo.com\/automations\/\">Sheetgo&#8217;s AI automations<\/a>, you can connect the spreadsheets that hold your balance sheet data and keep them in sync on a schedule, so the ratio uses the latest figures. For recurring finance work, <a href=\"https:\/\/www.sheetgo.com\/virtual-employees\/finance\/\">Sheetgo&#8217;s AI finance virtual employee<\/a> can collect the figures and keep your ratios up to date.<\/p>\n<p>The quick ratio is one of the various liquidity ratios available. While these ratios are generally good indicators of a company\u2019s financial health, it\u2019s important to interpret them in context and not rely on individual indicators. You can easily set up the formulas for multiple indicators in your spreadsheets. To learn more about these, as well as other financial ratios and analyses, check out the articles below:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/current-ratio-calculation\/\">Current Ratio<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/how-to-calculate-leverage-ratio\/\">Leverage Ratio<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/cost-volume-profit-analysis\/\">Cost-Volume-Profit Analysis<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/profitability-analysis\/\">Profitability Analysis<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/budget-variance-analysis\/\">Budget Variance Analysis<\/a><\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The quick ratio is a good measurement of a company&#8217;s liquidity. Here&#8217;s everything you need to know about the quick ratio and its calculation.<\/p>","protected":false},"author":2,"featured_media":267342,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[36],"tags":[],"class_list":["post-267337","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-finance-processes"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/267337","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=267337"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/267337\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/267342"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=267337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=267337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=267337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}