{"id":266843,"date":"2024-03-13T20:08:10","date_gmt":"2024-03-13T19:08:10","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=266843"},"modified":"2026-11-18T14:50:08","modified_gmt":"2026-11-18T13:50:08","slug":"como-calcular-margem-de-lucro","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/finance-processes\/how-to-calculate-profit-margin\/","title":{"rendered":"Como calcular a margem de lucro no Google Sheets: f\u00f3rmula e exemplos"},"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 any company, the initial objective is to break even. However, the main aim is to become profitable as soon as possible. Profit margins are some of the most commonly used metrics in the analysis of a company\u2019s profitability, together with other financial ratios. Since the term profit is rather broad, specific ratios focus on different profit categories.<\/p>\n<p>In this article, you will learn about profit margins and the formulas used to calculate them. You will also learn how to calculate the most commonly used margins using Google Sheets: gross profit margin, operating profit margin, and net profit margin. To learn about other profitability ratios, check out our article on <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/profitability-analysis\/\">profitability analysis: step-by-step guide<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-profit-margin&#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 profit margin?<\/h2>\n<p>The profit margin is the proportion of revenue that represents profit. Since profit is a rather broad term, there are multiple ratios that focus on different aspects of it. Some use broader interpretations of profit, such as the gross profit margin, and some use more specific ones, such as the net profit margin.<\/p>\n<p>Additionally, you should check what margins are commonly used within your industry. Depending on the industry and business model, you need to consider different types of expenses and liabilities. When calculating these margins, remember to compare them to similar companies in your industry.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-a-good-profit-margin&#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 profit margin?<\/h2>\n<p>The range of acceptable profit margin values depends on many factors, including industry, company size, and business model. You will see references to general rules of thumb, indicating that 10% is average and 20% is good. However, this is meaningless without identifying competitors and benchmarking your industry.<\/p>\n<p>In addition to their individual values, it\u2019s important to analyze the differences between ratios. For instance, how large is the difference between gross profit and operating profit? If the second is much lower, you may want to look into current operational procedures and identify areas for improvement.<\/p>\n<p>For SaaS companies, the <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/rule-of-40\/\">Rule of 40<\/a> puts profit margin and revenue growth rate into a single health check.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-calculate-profit-margin&#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 profit margin?<\/h2>\n<p>Generally speaking, you can calculate the profit margin by dividing profit by revenue and multiplying by 100. However, depending on the specific margin you want, you can use different formulas to calculate profit: gross, operating, and net profit are the three most commonly used.<\/p>\n<h3>How to calculate gross profit margin?<\/h3>\n<p>This is probably the most commonly used and broadest measure of profitability. However, it only considers the cost of goods sold. To calculate the gross profit margin, you first need to subtract the value of the cost of goods sold from the value of revenue. Next, divide by the value of revenue and multiply the result by 100.<\/p>\n<blockquote>\n<p>gross profit margin = ((revenue &#8211; COGS) \/ revenue) * 100<\/p>\n<\/blockquote>\n<p>In some industries, using the adjusted gross profit margin is more common, as it also considers inventory carrying costs.<\/p>\n<h3>How to calculate operating profit margin?<\/h3>\n<p>The operating profit margin, aka the EBIT margin, is more restrictive than the gross profit margin but less than the net profit margin. It expresses the proportion of revenue the company earns from operations before deducting interest and taxes. To calculate it, divide operating profit by revenue and multiply by 100.<\/p>\n<blockquote>\n<p>operating profit margin = (operating profit \/ revenue) * 100<\/p>\n<\/blockquote>\n<h3>How to calculate net profit margin?<\/h3>\n<p>The net profit margin, or bottom line, provides an overall picture of profitability after all expenses have been considered, including taxes and interest. The fact that this margin accounts for all costs makes it a comprehensive measure of net profit. However, this also means it will include one-off gains and losses that are not likely to be repeated.<\/p>\n<blockquote>\n<p>net profit margin = (net income \/ revenue) * 100<\/p>\n<\/blockquote>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-calculate-profit-margin-in-excel&#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 profit margin in Excel or Google Sheets?<\/h2>\n<p>As you can see, you can calculate these margins using the data available in the company\u2019s financial statements. If you use templates for these statements in <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-templates\/income-statement-template-excel\/\">Excel<\/a> or Google Sheets, you can add the profit margin formulas to your templates.<\/p>\n<p>If you don\u2019t currently use templates for your financial statements, you can use these <a href=\"https:\/\/golayer.io\/blog\/resources\/templates\/balance-sheet\" target=\"_blank\" rel=\"noopener\">free Balance Sheet<\/a> and <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-templates\/automated-income-statement-template-for-google-sheets\/\">income statement<\/a> templates. Using templates will allow you to calculate these margins for new data quickly. If you work in a team and use multiple files, you may want to consider <a href=\"https:\/\/www.sheetgo.com\/automations\/\">Sheetgo&#8217;s AI automations<\/a>. You can connect data from several files and formats and keep track of progress and results.<\/p>\n<p>In the next section, you have examples of the three main profit margin ratios calculated directly using the <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-templates\/automated-income-statement-template-for-google-sheets\/\">free Income Statement template<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;profit-margin-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>Profit margin examples<\/h2>\n<p>The following examples are based on this <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-templates\/automated-income-statement-template-for-google-sheets\/\">free Income Statement template<\/a>, using data for ThisCompany between 2020 and 2022, as shown below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/profit-margin-formula-google-sheets-income-statement.webp&#8221; alt=&#8221;Profit margin formula Google Sheets \u2014 income statement for ThisCompany with total net revenue, cost of goods sold, gross profit, operating profit, and net profit for 2020 to 2022&#8243; title_text=&#8221;Income statement for ThisCompany with total net revenue, cost of goods sold, gross profit, operating profit, and net profit for 2020 to 2022&#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> Below the data, under the corresponding year, type in the formula for gross profit margin. Divide &#8216;Gross Profit&#8217; by &#8216;Total Net Revenue.&#8217; In this template, the formula in cell B38 is =B15\/B9. Instead of multiplying by 100, you can simply pre-format the cells as percentages, and Google Sheets will do it automatically. Click the percent format button (%), marked with a red square below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/gross-profit-margin-formula-google-sheets.webp&#8221; alt=&#8221;Gross profit margin formula in Google Sheets \u2014 =B15\/B9 typed in cell B38, with the percent format button marked by a red square in the toolbar&#8221; title_text=&#8221;=B15\/B9 typed in cell B38, with the percent format button marked by a red square in the toolbar&#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> Drag the formula to the right to cover as many years as you need.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/gross-profit-margin-google-sheets-drag-formula.webp&#8221; alt=&#8221;Gross profit margin formula in Google Sheets \u2014 formula dragged right, showing 51.66%, 51.72%, and 52.31% for 2020, 2021, and 2022&#8243; title_text=&#8221;Formula dragged right, showing 51.66%, 51.72%, and 52.31% for 2020, 2021, and 2022&#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> Below the \u2018Gross Profit Margin\u2019, add the formula for \u2018Operating Profit Margin\u2019 below the corresponding year. Divide &#8216;Operating Profit&#8217; by &#8216;Total Net Revenue&#8217; and remember to format the cell as a percentage. In this template, the formula in cell B39 is =B32\/B9.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/operating-profit-margin-formula-google-sheets.webp&#8221; alt=&#8221;Operating profit margin formula in Google Sheets \u2014 =B32\/B9 typed in cell B39 below the gross profit margin row&#8221; title_text=&#8221;=B32\/B9 typed in cell B39 below the gross profit margin row&#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>4.<\/strong> Drag the formula to the right to calculate the \u2018Operating Profit Margin\u2019 for additional years.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/operating-profit-margin-google-sheets-drag-formula.webp&#8221; alt=&#8221;Operating profit margin formula in Google Sheets \u2014 formula dragged right, showing 17.48%, 18.14%, and 18.47% for 2020, 2021, and 2022&#8243; title_text=&#8221;Formula dragged right, showing 17.48%, 18.14%, and 18.47% for 2020, 2021, and 2022&#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>5.<\/strong> Next, type the formula for the \u2018Net Profit Margin\u2019 below the corresponding year. Divide &#8216;Net Profit&#8217; by &#8216;Total Net Revenue&#8217; and format it as a percentage. In this template, the formula in cell B40 is =B36\/B9.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/net-profit-margin-formula-google-sheets.webp&#8221; alt=&#8221;Net profit margin formula in Google Sheets \u2014 =B36\/B9 typed in cell B40 below the operating profit margin row&#8221; title_text=&#8221;=B36\/B9 typed in cell B40 below the operating profit margin row&#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>6.<\/strong> Finally, drag the \u2018Net Profit Margin\u2019 formula to the right to calculate this margin for the years you want.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/net-profit-margin-google-sheets-drag-formula.webp&#8221; alt=&#8221;Net profit margin formula in Google Sheets \u2014 formula dragged right, showing 11.38%, 11.84%, and 12.03% for 2020, 2021, and 2022&#8243; title_text=&#8221;Formula dragged right, showing 11.38%, 11.84%, and 12.03% for 2020, 2021, and 2022&#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>That\u2019s it! You now have the profit margin values for three consecutive years.<\/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>As you have seen, profit margins are easy to calculate and can provide valuable insight into a company\u2019s profitability. By comparing the values for different types of profit margins for the same company, you can also get insights into the distribution of costs. Since they are expressed as percentages, it\u2019s also easy to compare with other companies. However, be careful when comparing, as values vary significantly by industry.<\/p>\n<p>You now know about profit margins and how to calculate the three most commonly used. You also know how to add the formulas to your financial statements in Excel or Google Sheets to automate calculations. If those statements are spread across several spreadsheets, <a href=\"https:\/\/www.sheetgo.com\/virtual-employees\/finance\/\">Sheetgo&#8217;s AI finance virtual employee<\/a> can collect the figures on a schedule and keep your margin reports up to date.<\/p>\n<p>To learn more about other financial ratios and analyses, check out these articles:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/profitability-analysis\/\">Profitability analysis: step-by-step guide<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/cost-volume-profit-analysis\/\">Cost-volume-profit analysis: CVP formula and examples<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/break-even-point\/\">Break-even analysis: How to calculate break-even point<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/what-is-operating-cash-flow-and-how-to-calculate-it\/\">What is operating cash flow and how to calculate it<\/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>Aprenda a f\u00f3rmula da margem de lucro no Google Sheets. Calcule passo a passo as margens bruta, operacional e l\u00edquida a partir de uma Demonstra\u00e7\u00e3o de resultados.<\/p>","protected":false},"author":2,"featured_media":266851,"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-266843","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\/pt\/wp-json\/wp\/v2\/posts\/266843","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=266843"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/266843\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/266851"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=266843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=266843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=266843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}