{"id":265911,"date":"2024-03-13T20:08:23","date_gmt":"2024-03-13T19:08:23","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=265911"},"modified":"2026-10-29T14:17:06","modified_gmt":"2026-10-29T13:17:06","slug":"ciclo-de-conversion-de-efectivo","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/finance-processes\/cash-conversion-cycle\/","title":{"rendered":"Ciclo de conversi\u00f3n de efectivo: qu\u00e9 es, f\u00f3rmula y c\u00e1lculo"},"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>For companies that need to manage physical inventory, such as those involved in manufacturing or retail, inventory management and control are crucial. One of the main aims of cash management is to run the company with as little cash as possible tied up in inventory or accounts receivable. In other words, you need to turn inventory into accounts receivable as soon as possible.<\/p>\n<p>The cash conversion cycle (CCC) follows this process from purchasing inventory to settling <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/what-is-accounts-payable-and-receivable\/\">accounts receivable and accounts payable<\/a>. Therefore, it doesn\u2019t apply to businesses that deal with intangible goods, as they don\u2019t need to manage physical inventory.<\/p>\n<p>In this article, you will learn about the cash conversion cycle and the formula used to calculate its value. You will also learn how to calculate the metrics used in the formula to find the number of days it takes a company to convert cash investment into sales revenue.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-the-cash-conversion-cycle&#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 cash conversion cycle?<\/h2>\n<p>The cash conversion cycle is a financial metric that expresses the number of days a business takes to convert inventory and accounts receivable into <a href=\"https:\/\/www.10xsheets.com\/terms\/cash-flow\" target=\"_blank\" rel=\"noopener\">cash flows<\/a> from sales. This metric only applies to companies that manage physical inventory. You should calculate the cycle for multiple periods to analyze historical variations.<\/p>\n<p>For example, companies that provide software or financial services have no use for this metric because they work with intangible goods. However, if you work with tangible goods, you need inventory management and control; this metric can help you track results.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-a-good-cash-conversion-cycle&#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 cash conversion cycle?<\/h2>\n<p>Generally speaking, lower values are better since they show that the business can quickly convert cash on hand into cash from sales. However, when comparing values to those of competitors, be careful to choose only similar companies in your industry, as the values can vary significantly.<\/p>\n<p>Higher values may indicate that the company is not managing its cash efficiently. There are many factors that could increase this value, such as settling accounts payable too early, waiting too long to collect accounts receivable, or having a low <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/how-to-calculate-inventory-turnover\/\">inventory turnover ratio<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;cash-conversion-cycle-calculations&#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>Cash conversion cycle calculations<\/h2>\n<p>The formula for calculating the cash conversion cycle is very straightforward. However, it involves calculating three different metrics first. Below, you have the main formula for CCC, as well as all the formulas needed to calculate the different metrics involved. In all cases, a period of 1 year (365 days) is considered. If you want to calculate it quarterly, multiply by 90 instead of 365 days.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;cash-conversion-cycle-formula&#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>Cash conversion cycle formula<\/h2>\n<p>You can use the following formula to calculate the cash conversion cycle:<\/p>\n<blockquote>\n<p>CCC = DIO + DSO &#8211; DPO<\/p>\n<\/blockquote>\n<p>where<\/p>\n<ul>\n<li><strong>DIO =<\/strong> days of inventory outstanding<\/li>\n<li><strong>DSO =<\/strong> days of sales outstanding<\/li>\n<li><strong>DPO =<\/strong> days of payables outstanding<\/li>\n<\/ul>\n<p>Now that you know the cash conversion cycle formula, let\u2019s see how the required metrics are calculated.<\/p>\n<h3>Days of inventory outstanding<\/h3>\n<p>The first metric expresses the number of days it takes to turn inventory into sales. A related metric is the inventory turnover ratio. You can calculate the DIO using the following formula:<\/p>\n<blockquote>\n<p>DIO = (average inventory \/ COGS) * 365<\/p>\n<\/blockquote>\n<p>You can find the value for COGS on the <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-templates\/income-statement-template-excel\/\">income statement<\/a>, and you can calculate the average inventory using the formula below:<\/p>\n<blockquote>\n<p>average inventory = (beginning inventory + end inventory) \/ 2<\/p>\n<\/blockquote>\n<h3>Days of sales outstanding<\/h3>\n<p>This metric provides an average for the number of days it takes to collect payment after a sale. To calculate days of sales outstanding, use the following formula:<\/p>\n<blockquote>\n<p>DSO = (average accounts receivable \/ total credit sales) * 365<\/p>\n<\/blockquote>\n<p>The value for average accounts receivable can be calculated using this formula:<\/p>\n<blockquote>\n<p>average accounts receivable = (beginning accounts receivable + end accounts receivable) \/ 2<\/p>\n<\/blockquote>\n<h3>Days of payables outstanding<\/h3>\n<p>The average number of days it takes to settle accounts payable is expressed by the days of payables outstanding metric. The formula used to calculate it is the following:<\/p>\n<blockquote>\n<p>DPO = days of payables outstanding = (average accounts payable \/ COGS) * 365<\/p>\n<\/blockquote>\n<p>To get the value of COGS per day, divide the COGS value for the period by the number of days in it. To find the average accounts payable, use the following formula:<\/p>\n<blockquote>\n<p>average accounts payable = (beginning accounts payable + end accounts payable) \/ 2<\/p>\n<\/blockquote>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-calculate-cash-conversion-cycle-i&#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 cash conversion cycle in Excel or Google Sheets?<\/h2>\n<p>As you have seen, the cash conversion cycle requires multiple calculations involving similar and related metrics. This can lead to becoming confused and making avoidable mistakes. Fortunately, Excel or Google Sheets can help you structure the data and automate calculations. With Sheetgo, an AI-powered data automation platform, you can save time and avoid mistakes by automating the tedious tasks in your business processes.<\/p>\n<p>In the next section, you have an example of how to calculate the cash conversion cycle using Google Sheets.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;cash-conversion-cycle-example&#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>Cash conversion cycle example<\/h2>\n<p>The following example is calculated based on Company A\u2019s data for a period of 1 year.<\/p>\n<h3>1. Gather data<\/h3>\n<p>In Google Sheets, set up a table with the data you\u2019ll need, as shown in the screenshot below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/cash-conversion-cycle-google-sheets-data.webp&#8221; alt=&#8221;Cash conversion cycle data \u2014 Company A table with COGS, inventory, accounts receivable, credit sales, and accounts payable&#8221; title_text=&#8221;Company A table with COGS, inventory, accounts receivable, credit sales, and accounts payable&#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. Calculate the days of inventory outstanding<\/h3>\n<p>To find the DIO, you first need to calculate the average inventory.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/cash-conversion-cycle-average-inventory.webp&#8221; alt=&#8221;Cash conversion cycle calculation \u2014 average inventory formula =(B3+B4)\/2 in cell E2&#8243; title_text=&#8221;Average inventory formula =(B3+B4)\/2 in cell E2&#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>Once you have the average inventory, type the formula for DIO in an empty cell.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/cash-conversion-cycle-dio-formula.webp&#8221; alt=&#8221;Cash conversion cycle calculation \u2014 DIO formula =(E2\/B2)*365 next to an average inventory of $8,000&#8243; title_text=&#8221;DIO formula =(E2\/B2)*365 next to an average inventory of $8,000&#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<h3>3. Calculate the days of sales outstanding<\/h3>\n<p>For the DSO, first, calculate the average accounts receivable.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/cash-conversion-cycle-average-accounts-receivable.webp&#8221; alt=&#8221;Cash conversion cycle calculation \u2014 average accounts receivable formula =(B5+B6)\/2, with DIO of 73&#8243; title_text=&#8221;Average accounts receivable formula =(B5+B6)\/2, with DIO of 73&#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>Once you know the value for average accounts receivable, you can calculate the DSO.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/cash-conversion-cycle-dso-formula.webp&#8221; alt=&#8221;Cash conversion cycle calculation \u2014 DSO formula =(E5\/B7)*365 next to average accounts receivable of $6,500&#8243; title_text=&#8221;DSO formula =(E5\/B7)*365 next to average accounts receivable of $6,500&#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<h3>4. Calculate the days of payables outstanding<\/h3>\n<p>Just like with the other metrics, you\u2019ll have to calculate the average accounts payable before calculating the DPO.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/cash-conversion-cycle-average-accounts-payable.webp&#8221; alt=&#8221;Cash conversion cycle calculation \u2014 average accounts payable formula =(B8+B9)\/2, with DSO of 14.38&#8243; title_text=&#8221;Average accounts payable formula =(B8+B9)\/2, with DSO of 14.38&#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>Next, type the formula for DPO.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/cash-conversion-cycle-dpo-formula.webp&#8221; alt=&#8221;Cash conversion cycle calculation \u2014 DPO formula =(E8\/B2)*365 next to average accounts payable of $6,750&#8243; title_text=&#8221;DPO formula =(E8\/B2)*365 next to average accounts payable of $6,750&#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<h3>5. Calculate the cash conversion cycle<\/h3>\n<p>Now that you know the values for DIO, DSO, and DPO, you can type the formula for calculating the cash conversion cycle in an empty cell.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/cash-conversion-cycle-ccc-formula.webp&#8221; alt=&#8221;Cash conversion cycle formula \u2014 =E3+E6-E9 in the CCC cell, adding DIO and DSO and subtracting DPO&#8221; title_text=&#8221;=E3+E6-E9 in the CCC cell, adding DIO and DSO and subtracting DPO&#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>That\u2019s it. The cash conversion cycle takes approximately 26 days for Company A.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/cash-conversion-cycle-result.webp&#8221; alt=&#8221;Cash conversion cycle result \u2014 CCC of 25.79 days for Company A, with DIO 73, DSO 14.38, and DPO 61.59&#8243; title_text=&#8221;CCC of 25.79 days for Company A, with DIO 73, DSO 14.38, and DPO 61.59&#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>You now know about the cash conversion cycle and what it can tell you about a company\u2019s cash management and <a href=\"https:\/\/golayer.io\/blog\/finance\/liquidity-ratio\/\" target=\"_blank\" rel=\"noopener\">liquidity<\/a>. A low value indicates that the company manages its cash effectively. You can obtain a lower value through different methods, but it helps to collect on accounts receivable promptly while deferring slightly on accounts payable.<\/p>\n<p>Finally, you also know that a single value for this metric can\u2019t tell you very much. To get valuable insights, you should calculate it periodically and compare these values to those of similar companies in the industry. It also helps to track the CCC alongside <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/what-is-operating-cash-flow-and-how-to-calculate-it\/\">operating cash flow<\/a> and the <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/current-ratio-calculation\/\">current ratio<\/a>. You can quickly set up the required calculations in Google Sheets or Excel, following the steps in the examples. If your finance team pulls these figures from several spreadsheets, <a href=\"https:\/\/www.sheetgo.com\/virtual-employees\/finance\/\">Sheetgo&#8217;s AI finance virtual employee<\/a> can gather the numbers and keep your reports up to date.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>El ciclo de conversi\u00f3n de efectivo indica cu\u00e1ntos d\u00edas tarda un negocio en convertir su inventario en efectivo. Aprende la f\u00f3rmula del CCC y c\u00f3mo calcularlo en Google Sheets.<\/p>","protected":false},"author":2,"featured_media":265921,"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-265911","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\/265911","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=265911"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/265911\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/265921"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=265911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=265911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=265911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}