{"id":267149,"date":"2024-03-13T20:08:15","date_gmt":"2024-03-13T19:08:15","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=267149"},"modified":"2026-11-18T15:51:40","modified_gmt":"2026-11-18T14:51:40","slug":"ratio-de-liquidez-tipos-calculo","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/finance-processes\/liquidity-ratio\/","title":{"rendered":"Ratio de liquidez: tipos, c\u00e1lculo y ejemplos"},"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>When evaluating a company\u2019s financial situation, you can choose from multiple financial ratios and analyses, depending on your purpose. <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/how-to-calculate-leverage-ratio\/\">Leverage ratios<\/a> focus on a company\u2019s reliance on debt, solvency ratios on its ability to cover long-term debt obligations, and liquidity ratios on its ability to pay off short-term debt using liquid assets.<\/p>\n<p>In this article, you will learn about liquidity ratios and why they are important. You will also learn how to set up a template for liquidity analysis in Google Sheets, using the formulas for the most popular liquidity ratios. Finally, you will learn how to interpret the values you get for these ratios. Although Google Sheets or Excel lets you automate calculations to save time and avoid mistakes, with <a href=\"https:\/\/www.sheetgo.com\/automations\/\">Sheetgo&#8217;s AI automations<\/a>, you can connect data from several platforms and formats and schedule updates.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-a-liquidity-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 liquidity ratio?<\/h2>\n<p>Liquidity ratios are financial metrics that measure a company\u2019s ability to meet its short-term obligations. In other words, these ratios indicate whether current liabilities can be paid using current or liquid assets. Depending on the specific ratio, the focus will be on current assets in general or highly liquid assets.<\/p>\n<p>These ratios are of particular interest to short-term lenders and investors because they indicate the likelihood that the company will be able to pay off its short-term debt.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;why-are-liquidity-ratios-important&#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>Why are liquidity ratios important?<\/h2>\n<p>Liquidity ratios are important metrics when evaluating a company\u2019s short-term financial health. Because they measure a business&#8217;s ability to pay off current liabilities, short-term lenders and investors can use them to assess risk. These ratios indicate whether the company would be able to pay back short-term debt in the event of unexpected setbacks.<\/p>\n<p>Current liabilities, generally used as the denominator for these ratios, usually refer to debt the company must pay back within a year. There are different types of liquidity ratios, and each considers a narrower subset of current assets. Together, they provide an overview of the company\u2019s liquidity. These ratios are frequently analyzed together with <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/solvency-ratio\/\">solvency ratios<\/a>, which focus on paying off long-term financial obligations, including any due interest.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;types-of-liquidity-ratios&#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>Types of liquidity ratios<\/h2>\n<p>Depending on your role or the purpose of your analysis, you\u2019ll be interested in different types of liquidity ratios. Although they all express a company\u2019s ability to meet current liabilities, they differ in the selection of current assets considered.<\/p>\n<p>The current ratio, for example, takes into account a broad range of current assets, including inventory and prepaid expenses; the quick ratio, however, only considers highly liquid assets, i.e., assets that can be converted into cash quickly. The cash ratio is even more restrictive since it only accounts for cash and cash equivalents. However, there are even more stringent liquidity ratios. The operating cash flow ratio only considers the <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/what-is-operating-cash-flow-and-how-to-calculate-it\/\">cash flow generated directly by operations<\/a>.<\/p>\n<p>In the next section, you will learn the formulas to calculate these four liquidity ratios.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-the-most-widely-used-liquidity-r&#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 the most widely used liquidity ratio?<\/h2>\n<p>The current ratio is the most widely used liquidity ratio. It takes two figures straight from the balance sheet and covers all current assets, so lenders and analysts usually check it first. The quick ratio comes next. It leaves out inventory and prepaid expenses, which gives a stricter view of what the company could pay right away.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;liquidity-ratio-formula-how-to-calculate&#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>Liquidity ratio formula: how to calculate each ratio<\/h2>\n<p>Use the formulas below to calculate four of the most popular liquidity ratios.<\/p>\n<ul>\n<li><strong><a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/current-ratio-calculation\/\">Current Ratio<\/a><\/strong> represents the company\u2019s ability to cover current liabilities using current or liquid assets.<\/li>\n<\/ul>\n<blockquote>\n<p>current ratio = current assets \/ current liabilities<\/p>\n<\/blockquote>\n<ul>\n<li><strong><a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/quick-ratio-calculation\/\">Quick Ratio<\/a><\/strong> represents the company&#8217;s ability to pay off current liabilities using highly liquid assets. It&#8217;s also called the acid-test ratio or liquid ratio.<\/li>\n<\/ul>\n<blockquote>\n<p>quick ratio = (cash + marketable securities + accounts receivable) \/ current liabilities<\/p>\n<\/blockquote>\n<ul>\n<li><strong>Cash Ratio<\/strong> represents a company\u2019s ability to pay for current liabilities using cash and cash equivalents.<\/li>\n<\/ul>\n<blockquote>\n<p>cash ratio = (cash + marketable securities) \/ current liabilities<\/p>\n<\/blockquote>\n<ul>\n<li><strong>Operating Cash Flow Ratio<\/strong> represents the company\u2019s ability to pay off its current liabilities using the cash flow generated by core operations.<\/li>\n<\/ul>\n<blockquote>\n<p>operating cash flow ratio = operating cash flow \/ current liabilities<\/p>\n<\/blockquote>\n<p>In the next section, you have examples of calculating these in Google Sheets, using data from the company\u2019s financial statements.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;liquidity-ratio-examples&#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>Liquidity ratio examples<\/h2>\n<p>The data you need to calculate liquidity ratios is on the company&#8217;s financial statements, like <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/how-to-read-a-balance-sheet-with-examples\/\">balance sheets<\/a> or cash flow statements. You can easily set up a template in Google Sheets to calculate the ratios you need.<\/p>\n<h3>1. Gather data<\/h3>\n<p>The first step is to gather the necessary data in your spreadsheet. The data below belong to Company A.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/liquidity-ratio-financial-statement-data.webp&#8221; alt=&#8221;Liquidity ratio data in Google Sheets \u2014 Company A balance sheet and cash flow figures: cash, marketable securities, accounts receivable, operating cash flow, total current assets, and total current liabilities&#8221; title_text=&#8221;Company A balance sheet and cash flow figures: cash, marketable securities, accounts receivable, operating cash flow, total current assets, and total current liabilities&#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<h3>2. Add formulas<\/h3>\n<p>Now that you have the data, you can add the formula for each ratio using cell references. Check the previous section for the formulas.<\/p>\n<h4>Current ratio<\/h4>\n<p>In cell E3, enter =B7\/B8 (total current assets divided by total current liabilities).<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/liquidity-ratio-current-ratio-formula.webp&#8221; alt=&#8221;Current ratio formula in Google Sheets \u2014 =B7\/B8 typed in cell E3 next to the current ratio label&#8221; title_text=&#8221;=B7\/B8 typed in cell E3 next to the current ratio label&#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<h4>Quick ratio<\/h4>\n<p>In cell E4, enter =(B3+B4+B5)\/B8.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/liquidity-ratio-quick-ratio-formula.webp&#8221; alt=&#8221;Quick ratio formula in Google Sheets \u2014 =(B3+B4+B5)\/B8 typed in cell E4, below a current ratio of 2.45&#8243; title_text=&#8221;=(B3+B4+B5)\/B8 typed in cell E4, below a current ratio of 2.45&#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<h4>Cash ratio<\/h4>\n<p>In cell E5, enter =(B3+B4)\/B8.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/liquidity-ratio-cash-ratio-formula.webp&#8221; alt=&#8221;Cash ratio formula in Google Sheets \u2014 =(B3+B4)\/B8 typed in cell E5, below the current and quick ratio results&#8221; title_text=&#8221;=(B3+B4)\/B8 typed in cell E5, below the current and quick ratio results&#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<h4>Operating cash flow ratio<\/h4>\n<p>In cell E6, enter =B6\/B8.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/liquidity-ratio-operating-cash-flow-ratio-formula.webp&#8221; alt=&#8221;Operating cash flow ratio formula in Google Sheets \u2014 =B6\/B8 typed in cell E6, below the current, quick, and cash ratio results&#8221; title_text=&#8221;=B6\/B8 typed in cell E6, below the current, quick, and cash ratio results&#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<h3>3. Analyze &amp; compare the results<\/h3>\n<p>Once you have the values for your chosen liquidity ratios, you can interpret them using the general guidelines from the next section. However, remember that it\u2019s important to compare your values to those of similar companies and use industry-specific benchmarks.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/liquidity-ratio-results-google-sheets.webp&#8221; alt=&#8221;Liquidity ratio results in Google Sheets \u2014 current ratio 2.45, quick ratio 2.46, cash ratio 1.34, and operating cash flow ratio 0.97&#8243; title_text=&#8221;Current ratio 2.45, quick ratio 2.46, cash ratio 1.34, and operating cash flow ratio 0.97&#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;liquidity-ratio-interpretation&#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>Liquidity ratio interpretation<\/h2>\n<p>As mentioned, financial ratios, including liquidity ratios, should be analyzed in context by comparing them to those of similar companies in the industry. Every industry has its specific customs and accounting practices, which could significantly impact the range of acceptable values for these ratios.<\/p>\n<h3>What is a good liquidity ratio?<\/h3>\n<p>Because liquidity ratios divide assets by liabilities, higher values are better. For the current ratio, a value of 1 indicates that the company can cover current debt using current assets. A ratio of 2 indicates it could pay for it twice, a more comfortable financial position.<\/p>\n<p>However, some liquidity ratios take a much stricter approach and only consider cash and cash equivalents. A cash ratio below 1 shouldn\u2019t necessarily be the cause for concern, particularly in specific industries.<\/p>\n<p>[\/et_pb_text][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>You now know about liquidity ratios and what they can tell you about a company\u2019s current finances. Together, these ratios provide an overview of how well a company can cover its current liabilities using current assets. You also know the formulas for the four most common liquidity ratios and how to interpret their values. As with any financial ratio, it\u2019s important to get industry benchmarks and compare values to those of similar companies.<\/p>\n<p>From the current ratio, which provides the broadest view of liquid assets, to the operating cash flow ratio, which is very specific, you can easily set up a quick template in Google Sheets. For a more comprehensive analysis, you can add other types of financial ratios to the template. If the figures come from several spreadsheets, <a href=\"https:\/\/www.sheetgo.com\/virtual-employees\/finance\/\">Sheetgo&#8217;s AI finance virtual employee<\/a> can collect them on a schedule and keep your ratios up to date.<\/p>\n<p>To learn more about financial ratios and analyses used to assess a company\u2019s financial health and performance, check out these articles on:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/quick-ratio-calculation\/\">Quick Ratio<\/a><\/li>\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\/scenario-analysis\/\">Scenario 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>Los ratios de liquidez miden si una empresa puede cubrir sus deudas a corto plazo. Descubre los tipos, las f\u00f3rmulas y ejemplos pr\u00e1cticos, adem\u00e1s del ratio m\u00e1s utilizado.<\/p>","protected":false},"author":2,"featured_media":267156,"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-267149","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\/es\/wp-json\/wp\/v2\/posts\/267149","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=267149"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/267149\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/267156"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=267149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=267149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=267149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}