{"id":267387,"date":"2024-03-13T20:07:45","date_gmt":"2024-03-13T19:07:45","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=267387"},"modified":"2026-11-19T14:27:49","modified_gmt":"2026-11-19T13:27:49","slug":"taxa-crescimento-sustentavel","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/finance-processes\/sustainable-growth-rate\/","title":{"rendered":"Taxa de crescimento sustent\u00e1vel: f\u00f3rmula e como calcular"},"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>Growth rate is a very important variable for any business. However, it is a broad concept that can be measured and calculated using different metrics and methods. For example, the company\u2019s Internal Growth Rate (IGR) and its Sustainable Growth Rate (SGR) are both calculated based on specific assumptions regarding capital funding. While IGR only considers internal funding, SGR accounts for the current capital structure, so it includes existing debt and equity capital. This makes SGR an important indicator for long-term, sustainable growth.<\/p>\n<p>In this guide, you will learn about SGR and its importance in assessing a company\u2019s long-term financial performance. You will also learn how to calculate SGR and see examples of how to apply the formula. Finally, you will learn how SGR is evaluated and how it differs from IGR.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-a-sustainable-growth-rate-sgr&#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 sustainable growth rate (SGR)?<\/h2>\n<p>Sustainable growth rate represents the maximum growth rate that a company can sustain without changes to its capital structure. In other words, it\u2019s the maximum rate of growth that can be achieved without requiring additional financing in the form of debt or equity. The <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/debt-to-equity-ratio\/\">debt-to-equity ratio<\/a> measures that mix of debt and equity.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;why-is-sustainable-growth-rate-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 is sustainable growth rate important?<\/h2>\n<p>Sustainable Growth Rate (SGR) is an important financial metric. It shows how much the company can grow without needing additional financing and helps identify the company\u2019s current stage in the <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/business-life-cycle\/\">business life cycle<\/a>. Creditors or lenders use this metric to assess the likelihood of the company defaulting on loan payments.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-calculate-sustainable-growth-rate&#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 sustainable growth rate?<\/h2>\n<p>To calculate a company\u2019s SGR, you can use the following formula:<\/p>\n<blockquote>\n<p>sustainable growth rate = retention rate * return on equity<\/p>\n<\/blockquote>\n<p>The retention rate expresses the percentage of earnings that the company has not paid out in dividends, making them <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/retained-earnings\/\">retained earnings<\/a>. To calculate the retention ratio, you can use this formula:<\/p>\n<blockquote>\n<p>retention rate = (net income \u2013 dividends) \/ net income<\/p>\n<\/blockquote>\n<p>The retention rate can also be calculated as follows:<\/p>\n<blockquote>\n<p>retention rate = 1 \u2013 dividend payout ratio<\/p>\n<\/blockquote>\n<p>Return on equity, on the other hand, measures the company\u2019s profitability relative to its shareholder equity. To calculate return on equity, you can use the formula below.<\/p>\n<blockquote>\n<p>return on equity = net income \/ total shareholder equity<\/p>\n<\/blockquote>\n<p>In the next section, you have examples of how to calculate SGR using Microsoft Excel or Google Sheets.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;sustainable-growth-rate-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>Sustainable growth rate examples<\/h2>\n<p>Now that you know the formula used to calculate a company\u2019s Sustainable Growth Rate (SGR), let\u2019s see how you can use Microsoft Excel or Google Sheets to calculate it.<\/p>\n<h3>1. Gather data<\/h3>\n<p>The first step is to gather the required data in your spreadsheet: net income, total shareholder equity, and the amount paid out in dividends. The screenshot below shows the relevant data for Company A and Company B.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/sustainable-growth-rate-gather-data.webp&#8221; alt=&#8221;Sustainable growth rate \u2014 Google Sheets table with total dividend amount, net income, and total equity for Company A and Company B&#8221; title_text=&#8221;Google Sheets table with total dividend amount, net income, and total equity for Company A and Company B&#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 retention rate<\/h3>\n<p>In an empty cell, type the equal sign and add the retention rate formula using cell references.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/sustainable-growth-rate-retention-rate-formula.webp&#8221; alt=&#8221;Sustainable growth rate formula \u2014 retention rate formula =(B4-B3)\/B4 typed in cell B7 for Company A&#8221; title_text=&#8221;Retention rate formula =(B4-B3)\/B4 typed in cell B7 for Company A&#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>Press \u2018Enter\u2019 to see the retention rate.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/sustainable-growth-rate-retention-rate-result.webp&#8221; alt=&#8221;Sustainable growth rate \u2014 retention rate of 90.00% for Company A in cell B7&#8243; title_text=&#8221;Retention rate of 90.00% for Company A in cell B7&#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>Grab the fill handle and drag right to get the retention rate for Company B.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/sustainable-growth-rate-retention-rate-filled-right.webp&#8221; alt=&#8221;Sustainable growth rate \u2014 retention rate formula filled right, showing 90.00% for Company A and 91.67% for Company B&#8221; title_text=&#8221;Retention rate formula filled right, showing 90.00% for Company A and 91.67% for Company B&#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. Calculate return on equity<\/h3>\n<p>Now that you have the retention rate, you need to calculate the return on equity. In an empty cell, type in the equal sign and add the formula using cell references.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/sustainable-growth-rate-return-on-equity-formula.webp&#8221; alt=&#8221;Sustainable growth rate formula \u2014 return on equity formula =B4\/B5 typed in cell B8 for Company A&#8221; title_text=&#8221;Return on equity formula =B4\/B5 typed in cell B8 for Company A&#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>Grab the fill handle and drag right to get the return on equity for Company B.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/sustainable-growth-rate-return-on-equity-filled-right.webp&#8221; alt=&#8221;Sustainable growth rate \u2014 return on equity filled right, showing 12.50% for Company A and 10.00% for Company B&#8221; title_text=&#8221;Return on equity filled right, showing 12.50% for Company A and 10.00% for Company B&#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>4. Calculate sustainable growth rate<\/h3>\n<p>Finally, add the SGR formula in an empty cell by multiplying the retention rate by the return on equity.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/sustainable-growth-rate-sgr-formula.webp&#8221; alt=&#8221;SGR formula \u2014 =B7*B8 typed in cell B9 to multiply retention rate by return on equity&#8221; title_text=&#8221;=B7*B8 typed in cell B9 to multiply retention rate by return on equity&#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>Press \u2018Enter\u2019 to see the sustainable growth rate.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/sustainable-growth-rate-company-a-result.webp&#8221; alt=&#8221;Sustainable growth rate \u2014 SGR of 11% for Company A in cell B9&#8243; title_text=&#8221;SGR of 11% for Company A in cell B9&#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>Grab the fill handle and drag right to get the sustainable growth rate for Company B.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/sustainable-growth-rate-both-companies.webp&#8221; alt=&#8221;Sustainable growth rate \u2014 SGR formula filled right, showing 11% for Company A and 9% for Company B&#8221; title_text=&#8221;SGR formula filled right, showing 11% for Company A and 9% for Company B&#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 module_id=&#8221;what-is-a-good-sustainable-growth-rate&#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 sustainable growth rate?<\/h2>\n<p>The acceptable range of values for the Sustainable Growth Rate (SGR) depends on various factors. Generally speaking, the higher the SGR, the better. Higher SGR values are usually indicative of the early stages of the <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/business-life-cycle\/\">business life cycle<\/a>. However, a high SGR is very difficult to maintain in the long run.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-sustainable-growth-rate-vs-inter&#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 sustainable growth rate vs. internal growth rate?<\/h2>\n<p>Sustainable Growth Rate (SGR) is the company\u2019s maximum growth rate considering its current debt and equity financing but assumes the current mix will remain unchanged. Internal Growth Rate (IGR), on the other hand, is more restrictive and considers only internal funding or <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/retained-earnings\/\">retained earnings<\/a>.<\/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, Sustainable Growth Rate (SGR) is an important financial metric with multiple uses. Investors, lenders, and the company itself can all use this metric to assess long-term growth potential. Investors can use it to assess the attractiveness of different investment opportunities, while lenders can use it to estimate the likelihood that the company will default on loan payments. Companies can use it to plan long-term growth, project cash flows, and evaluate the limitations of their current capital structure.<\/p>\n<p>You now know what Sustainable Growth Rate (SGR) means, why it\u2019s important, and how it differs from Internal Growth Rate (IGR). You also know the formula for SGR and how to calculate it using Excel or Google Sheets.<\/p>\n<p>To learn more about another technique used to evaluate company growth, check out our guide on the <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/rule-of-40\/\">SaaS Rule of 40<\/a>.<\/p>\n<p>For a simpler growth measure, see how to <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/calculate-year-over-year-growth\/\">calculate year-over-year growth<\/a>. If net income, dividends, and equity figures live in separate spreadsheets, <a href=\"https:\/\/www.sheetgo.com\/virtual-employees\/finance\/\">Sheetgo&#8217;s AI finance virtual employee<\/a> can collect them and keep your SGR calculation 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>A taxa de crescimento sustent\u00e1vel (SGR) mostra o quanto uma empresa pode crescer sem nova d\u00edvida nem capital. Aprenda a f\u00f3rmula e como calcul\u00e1-la em uma planilha.<\/p>","protected":false},"author":2,"featured_media":267397,"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-267387","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\/267387","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=267387"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/267387\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/267397"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=267387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=267387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=267387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}