[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
Many financial ratios and metrics are available to evaluate a company\u2019s financial health and performance. Often, a single metric can go by different names, and to make matters more confusing, different metrics often share similar names. For example, what exactly is the cost of debt? Is it the same as the before-tax cost of debt? And how does it differ from the after-tax cost of debt?<\/p>\n
The cost of debt refers to the effective interest rate paid on the company\u2019s total debt. This value is usually an estimate, particularly if calculated using averages. The amount paid in interest expenses varies from item to item and is subject to fluctuations over time.<\/p>\n
When the cost of debt is mentioned without qualification, it usually refers to the before-tax cost of debt, though it depends on context. This value can then be used to calculate the after-tax cost of debt, which also considers the tax rate. Additionally, the cost of debt can be used to calculate the Weighted Average Cost of Capital<\/a>, which considers both equity and debt.<\/p>\n In this guide, you will learn about the cost of debt, as well as how to calculate it before and after taxes have been paid. You will also learn how to use Microsoft Excel or Google Sheets to calculate the cost of debt and how Sheetgo’s AI finance virtual employee<\/a> can keep the data behind those calculations up to date.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-calculate-cost-of-debt” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To calculate the cost of debt, first add up all debt, including loans, credit cards, etc. Next, use the interest rate to calculate the annual interest expense per item and add them up. Finally, divide total interest expense by total debt to get the cost of debt or effective interest rate.<\/p>\n cost of debt = total interest expense \/ total debt<\/p>\n<\/blockquote>\n Fortunately, the information you need to calculate the cost of debt can be found in the company’s financial statements, such as the balance sheet<\/a>. The cost of debt metric is also used to calculate the Weighted Average Cost of Capital (WACC), which is often used as the discount rate in discounted cash flow analysis<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-calculate-after-tax-cost-of-debt” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The reason why the after-tax cost of debt is a metric of interest is the fact that interest expenses are tax deductible. This means that the after-tax cost of debt is lower than the before-tax cost of debt.<\/p>\n To calculate the after-tax cost of debt, use the following formula:<\/p>\n after-tax cost of debt = effective interest rate * (1 – tax rate)<\/p>\n<\/blockquote>\n In the formula above, the value for the effective interest rate is equal to the cost of debt, which can be obtained using the formula in the previous section:<\/p>\n effective interest rate = total interest expense \/ total debt<\/p>\n<\/blockquote>\n In the next section, you have examples of how to calculate the before-tax and after-tax cost of debt using spreadsheet software.<\/p>\n [\/et_pb_text][et_pb_text module_id=”examples-calculate-cost-of-debt-in-excel” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n For this example, I will calculate Company A\u2019s cost of debt. Company A\u2019s debt consists of two loans: the first is for $500,000 with a 4% interest rate, and the second is for $100,000 with a 6% interest rate. I want to calculate the cost of debt before and after taxes, knowing that the company\u2019s tax rate is 30%.<\/p>\n Follow the steps below to calculate the cost of debt using Microsoft Excel or Google Sheets.<\/p>\n As with most calculations, the first step is to gather the required data. To calculate the total cost of debt, you need the value of the total debt, as well as the total interest expense related to the total debt. If you also want to calculate the after-tax cost of debt, you will need the tax rate.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/cost-of-debt-loans-interest-rates-tax-rate.webp” alt=”Cost of debt \u2014 Google Sheets table with a $500,000 loan at 4%, a $100,000 loan at 6%, and a 30% tax rate” title_text=”Google Sheets table with a $500,000 loan at 4%, a $100,000 loan at 6%, and a 30% tax rate” 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 In an empty cell, type in the formula for cost of debt or before-tax cost of debt.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/cost-of-debt-formula-google-sheets.webp” alt=”Cost of debt formula \u2014 =((B2*C2)+(B3*C3))\/(B2+B3) typed in cell B5 next to the cost of debt label” title_text=”=((B2*C2)+(B3*C3))\/(B2+B3) typed in cell B5 next to the cost of debt label” 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_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/cost-of-debt-result-google-sheets.webp” alt=”Cost of debt \u2014 cell B5 showing a before-tax cost of debt of 4.33%” title_text=”Cell B5 showing a before-tax cost of debt of 4.33%” 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 To calculate the after-tax cost of debt, you need the effective interest rate, or the cost of debt calculated in the previous step, and the tax rate.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/after-tax-cost-of-debt-formula.webp” alt=”After-tax cost of debt formula \u2014 =B5*(1-F1) typed in cell F5, using the 30% tax rate in F1″ title_text=”=B5*(1-F1) typed in cell F5, using the 30% tax rate in F1″ 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_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/after-tax-cost-of-debt-result.webp” alt=”After-tax cost of debt \u2014 cell F5 showing 3.03% next to the 4.33% cost of debt” title_text=”Cell F5 showing 3.03% next to the 4.33% cost of debt” 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 When you need to perform calculations or carry out financial analyses, it\u2019s common for the data you need to be spread out over multiple spreadsheets, often in different formats. Additionally, collaboration and synchronization can be problematic if you work as part of a team. Sheetgo’s AI automations<\/a> connect those spreadsheets and update them on a schedule. You decide who can access each file, and everyone on the team works from the same numbers.<\/p>\n [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you have seen, the cost of debt metric represents how much you pay in interest expenses in relation to the total amount of debt. In other words, it represents the effective interest rate for the company. The cost of debt can be calculated before and after taxes, as interest expenses are tax-deductible. Additionally, the cost of debt is used to calculate other important financial metrics, such as the weighted average cost of capital (WACC).<\/p>\n You now know what the term cost of debt means and how to calculate it before and after taxes. You also know how to use Microsoft Excel or Google Sheets to automate the calculations. Sheetgo’s AI automations take this further by syncing data across files and formats and updating it on a schedule.<\/p>\n To see the other side of a company’s funding, read our guide to the cost of equity<\/a>. The debt-to-equity ratio<\/a> shows how much of that funding comes from debt. For the obligations a company must pay within a year, see our guide to current liabilities<\/a>.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Le co\u00fbt de la dette est le taux d'int\u00e9r\u00eat effectif qu'une entreprise paie sur sa dette. D\u00e9couvrez la formule et comment le calculer avant et apr\u00e8s imp\u00f4ts.<\/p>","protected":false},"author":2,"featured_media":266637,"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-266631","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\/266631","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=266631"}],"version-history":[{"count":1,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/266631\/revisions"}],"predecessor-version":[{"id":266638,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/266631\/revisions\/266638"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/266637"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=266631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=266631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=266631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}How to calculate cost of debt?<\/h2>\n
\n
How to calculate after-tax cost of debt?<\/h2>\n
\n
\n
Examples: calculate cost of debt in Excel or Google Sheets<\/h2>\n
1. Gather data<\/h3>\n
2. Calculate before-tax cost of debt<\/h3>\n
3. Calculate after-tax cost of debt<\/h3>\n
Conclusion<\/h2>\n