{"id":265692,"date":"2024-03-13T20:08:15","date_gmt":"2024-03-13T19:08:15","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=265692"},"modified":"2026-10-29T15:18:35","modified_gmt":"2026-10-29T14:18:35","slug":"ratio-de-liquidite-generale","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/finance-processes\/current-ratio-calculation\/","title":{"rendered":"Ratio de liquidit\u00e9 g\u00e9n\u00e9rale : calcul, formule et exemples"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Whether you\u2019re an accountant, an investor, or a business owner, you probably spend quite a bit of time worrying about the state of the company\u2019s health. One particular area of interest is the company\u2019s liquidity: given its assets, can the business pay back its debt in time? Two frequently used liquidity ratios are the current ratio and the quick ratio. The current ratio divides current assets by short-term liabilities to indicate the company’s ability to pay the latter using the former.<\/p>\n

In this article, you will learn about the current ratio and how to use it. You will also learn how to add the formula to your spreadsheet to automatically perform current ratio calculations. Additionally, you will learn how tools like Google Sheets and Sheetgo, an AI-powered data automation platform, can help you set up a template and automate data flows, calculation updates, and sharing.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”why-is-current-ratio-calculated” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Why is current ratio calculated?<\/h2>\n

The current ratio is one of multiple financial ratios used to assess the financial health of a company. Specifically, the current ratio expresses a business\u2019 ability to pay back short-term debt using only current assets. These include highly liquid assets like cash and marketable securities, but also less liquid assets, like inventory<\/a>.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”current-ratio-calculation” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Current ratio calculation<\/h2>\n

You can calculate the current ratio – also known as the current asset ratio – by dividing current assets by current liabilities. Remember to only include current assets and liabilities in your total – no long-term investments or debt.<\/p>\n

The data you need is in the company’s financial statements<\/a>; the values for current assets and current liabilities are on the balance sheet.<\/p>\n

Current ratio formula<\/h3>\n

To calculate a business\u2019 current ratio, use the following formula:<\/p>\n

\n

current ratio = current assets \/ current liabilities<\/p>\n<\/blockquote>\n

[\/et_pb_text][et_pb_text module_id=”what-is-a-good-current-ratio” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

What is a good current ratio?<\/h2>\n

A current ratio between 1.5 and 3 is generally considered good. Since this ratio is calculated by dividing current assets by current liabilities, a ratio above 1 implies that the company can cover current liabilities within a year.<\/p>\n

If the ratio is above 3, the company may be mismanaging or underutilizing assets. If the ratio is below 1, the company\u2019s current liabilities are greater than its assets. This can cast doubt on the company\u2019s liquidity and its ability to pay back short-term debt.<\/p>\n

However, there are always exceptions, particularly as some accounting methods and financial strategies could result in abnormally high or low current ratios. For example, keeping a very tight inventory control or heavily reinvesting in the company can lead to lower current ratios. That\u2019s why it\u2019s important to consider multiple ratios and metrics in your analysis: to avoid drawing inaccurate conclusions.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”quick-ratio-vs-current-ratio” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Quick ratio vs current ratio<\/h2>\n

Another popular liquidity ratio is the quick ratio. Unlike the current ratio – which weighs all current assets against current liabilities – the quick ratio focuses exclusively on quick assets. These assets can be converted into cash quickly, usually within 3 months.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”current-ratio-examples” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Current ratio examples<\/h2>\n

If a company has current assets valued at $185,000.00 and its current liabilities total $103,000.00, the current ratio can be calculated as follows:<\/p>\n

\n

$185,000.00 \/ $103,000.00 = 1.796116505<\/p>\n<\/blockquote>\n

A ratio of 1.8 would usually be considered a healthy current ratio.<\/p>\n

However, if current assets are worth $56,000.00 and liabilities are $135,000.00:<\/p>\n

\n

$56,000.00 \/ $135,000.00 = 0.4148148148<\/p>\n<\/blockquote>\n

A current ratio with a value of 0.41 is something that most investors would be concerned about, barring exceptional circumstances.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”how-to-calculate-the-current-ratio-in-go” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to calculate the current ratio in Google Sheets?<\/h2>\n

Let\u2019s say you want to calculate the current ratio for Company A in Google Sheets. The company has the data shown below on the balance sheet.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/current-ratio-calculation-balance-sheet-data.webp” alt=”Current ratio calculation \u2014 Company A balance sheet in Google Sheets with total current assets and total liabilities for 2021″ title_text=”Company A balance sheet in Google Sheets with total current assets and total liabilities for 2021″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

1.<\/strong> In an empty cell, type in the ‘=’ sign and click on the cell with the value for total current assets.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/current-ratio-formula-current-assets.webp” alt=”Current ratio formula \u2014 =B9 typed next to Current Ratio, pointing at total current assets of $1,085,500.00″ title_text=”=B9 typed next to Current Ratio, pointing at total current assets of $1,085,500.00″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

2.<\/strong> Add the ‘\/’ sign and click on the cell with the value for total current liabilities.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/current-ratio-formula-divide-current-liabilities.webp” alt=”Current ratio formula \u2014 =B9\/B29 dividing total current assets by total liabilities of $801,833.00″ title_text=”=B9\/B29 dividing total current assets by total liabilities of $801,833.00″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

3.<\/strong> Press \u201cEnter\u201d to get the current ratio.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/current-ratio-calculator-result.webp” alt=”Current ratio calculator \u2014 current ratio of 1.353773167 returned in cell E1″ title_text=”Current ratio of 1.353773167 returned in cell E1″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Conclusion<\/h2>\n

You now know how to calculate the current ratio and how to interpret its value. You also know how to add the formula to your financial statement spreadsheets to calculate it automatically. With Sheetgo’s AI finance virtual employee<\/a>, you can automate the entire process, from collecting the balance sheet data to sharing the results. Automate the tedious tasks to focus on staying updated to make informed decisions.<\/p>\n

As you have seen, the current ratio is one of various ratios commonly used by accountants and investors to evaluate a company\u2019s financial health in terms of its liquidity. Another popular liquidity ratio is the quick ratio, which you can learn more about in our blog.<\/p>\n

To learn more about other financial ratios and analyses, check out the articles below:<\/p>\n