[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
Retained earnings are one of the many financial metrics<\/a> used to assess a company\u2019s financial health. They can be defined as what remains of a company\u2019s net income after all expenses, including shareholder dividends, have been paid out. The company\u2019s management usually decides whether to use these profits to pay off debt or reinvest in the company. Since management decides how much to pay out in dividends, they can decide to reduce or not pay them out for that period for companies focused on growth or expansion.<\/p>\n In this guide, you will learn what retained earnings are and how they are related to other financial metrics, like profit or dividends. You will also learn how to calculate retained earnings in Google Sheets or Excel with the data available on the company balance sheets.<\/p>\n [\/et_pb_text][et_pb_text module_id=”what-are-retained-earnings” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Retained earnings are the company\u2019s remaining profits after paying off all of its expenses. This includes all costs, whether direct or indirect, as well as shareholder dividends. These retained earnings can be used to pay off debt obligations, or they can be reinvested in different areas of the company, like equipment or research and development.<\/p>\n You can find a company’s retained earnings on its balance sheet in the shareholders\u2019 equity section.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/retained-earnings-balance-sheet-shareholders-equity.webp” alt=”Retained earnings \u2014 balance sheet with Retained Earnings of $6,000 under Shareholder’s Equity” title_text=”Balance sheet with Retained Earnings of $6,000 under Shareholder’s Equity” 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=”are-retained-earnings-assets” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Retained earnings are considered equity and are listed as such in the corresponding section of the balance sheet under shareholders\u2019 equity. However, while they are not assets in themselves, they can certainly be used to purchase or invest in assets of different types<\/a>. Retained earnings are often used to buy new equipment or finance research and development.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-calculate-retained-earnings” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Retained earnings are calculated at the end of each accounting period: monthly, quarterly, or annually. To calculate retained earnings, take the beginning value for retained earnings and add net income or subtract net loss as appropriate. Finally, subtract the value of net dividends paid to shareholders.<\/p>\n You can use the following formula, also called the retained earnings equation, to calculate retained earnings:<\/p>\n retained earnings = beginning retained earnings +\/- net income\/net loss – net dividends<\/p>\n<\/blockquote>\n In the next section, you have examples of how to calculate retained earnings using the information reported on the company\u2019s balance sheet.<\/p>\n [\/et_pb_text][et_pb_text module_id=”what-is-an-example-of-retained-earnings” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Say your company had a beginning balance of $5000, and the net income at the end of the period was $3000. You also paid out $4000 in dividends to shareholders. You can calculate your retained earnings as follows: $5000 + $3000 – $4000 = $4000.<\/p>\n Let’s see how to calculate retained earnings using Google Sheets. You can easily add this calculation to existing spreadsheet templates for financial statements<\/a> or financial analysis.<\/p>\n The steps below show how to calculate retained earnings in Google Sheets when the company has reported positive net income.<\/p>\n 1.<\/strong> Gather the necessary data from the balance sheet and income statement.<\/p>\n Net income is the bottom line of the income statement, also called the profit and loss statement<\/a>. If you don’t have one yet, start with this automated income statement template for Google Sheets<\/a>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/calculate-retained-earnings-company-a-data.webp” alt=”Calculate retained earnings \u2014 Company A beginning retained earnings, net income, and dividends for 2021″ title_text=”Company A beginning retained earnings, net income, and dividends 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 2.<\/strong> In an empty cell, type the equal sign to start the formula and click on the cell containing beginning retained earnings.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/calculate-retained-earnings-beginning-balance.webp” alt=”Calculate retained earnings \u2014 =B2 typed in cell B6 for retained earnings at end of period” title_text=”=B2 typed in cell B6 for retained earnings at end of period” 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> Add net income. As you will see in the second example, you can use the same formula for net loss, as Sheets will add or subtract depending on whether the value is positive or negative.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/calculate-retained-earnings-add-net-income.webp” alt=”Calculate retained earnings \u2014 =B2+B3 adds the $5,000 net income to beginning retained earnings” title_text=”=B2+B3 adds the $5,000 net income to beginning retained earnings” 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 4.<\/strong> Subtract the cell with the amount paid out in dividends to shareholders.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/calculate-retained-earnings-subtract-dividends.webp” alt=”Calculate retained earnings \u2014 =B2+B3-B4 subtracts the $4,000 in shareholder dividends” title_text=”=B2+B3-B4 subtracts the $4,000 in shareholder dividends” 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 5.<\/strong> That\u2019s it. You have the value for retained earnings.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/calculate-retained-earnings-net-income-result.webp” alt=”Calculate retained earnings \u2014 Company A retained earnings at end of period of $7,000″ title_text=”Company A retained earnings at end of period of $7,000″ 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 The steps below show how to calculate retained earnings in Google Sheets when the company has reported negative net income or net losses.<\/p>\n 1.<\/strong> Gather the necessary data from the company\u2019s financial statements.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/retained-earnings-net-loss-company-b-data.webp” alt=”Retained earnings with net loss \u2014 Company B data with a -$1,000 net loss next to Company A” title_text=”Company B data with a -$1,000 net loss next to Company A” 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> Start the formula by typing the equal sign in an empty cell. Add the cell containing the value of beginning retained earnings.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/retained-earnings-net-loss-beginning-balance.webp” alt=”Retained earnings with net loss \u2014 =E2 typed in cell E6 for Company B” title_text=”=E2 typed in cell E6 for Company B” 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> Add the cell with the value of net loss. Since the value is negative, Sheets will subtract it from the value of beginning retained earnings.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/retained-earnings-net-loss-add-net-loss.webp” alt=”Retained earnings with net loss \u2014 =E2+E3 adds the -$1,000 net loss” title_text=”=E2+E3 adds the -$1,000 net loss” 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 4.<\/strong> Subtract the cell with the amount paid out to shareholders in dividends.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/retained-earnings-net-loss-subtract-dividends.webp” alt=”Retained earnings with net loss \u2014 =E2+E3-E4 subtracts the $4,000 in dividends” title_text=”=E2+E3-E4 subtracts the $4,000 in dividends” 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 5.<\/strong> That\u2019s it. You have the value for retained earnings. As you can see, Company B has positive retained earnings despite reporting a net loss for the period.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/retained-earnings-net-loss-result.webp” alt=”Retained earnings with net loss \u2014 Company B retained earnings at end of period of $1,000″ title_text=”Company B retained earnings at end of period of $1,000″ 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=”what-do-retained-earnings-tell-you” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Unlike profits, retained earnings also consider the amount paid out in shareholder dividends. If the company pays out a large amount in dividends, the company\u2019s profits can indicate a positive net income, while retained earnings may still go down for the period.<\/p>\n Therefore, a company\u2019s retained earnings, revenue, and net income are all good indicators of its financial health. Just like with any financial metric, retained earnings should not be considered in isolation. For example, an acceptable range of values will depend not only on the industry and business model but also on the company’s current maturity or status.<\/p>\n Retained earnings are an accounting figure, and they don’t tell you how much cash the company holds. To see how much cash the business actually generates, look at its operating cash flow<\/a> as well.<\/p>\n For example, low retained earnings are common for young companies that are focusing on survival, as well as more mature companies that are focusing on expansion. However, lower retained earnings are also common to more established companies that pay out large amounts in dividends.<\/p>\n [\/et_pb_text][et_pb_text module_id=”what-does-it-mean-to-have-negative-retai” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Given the formula used above, a company can have negative retained earnings if it records net losses with an absolute value higher than its beginning retained earnings. This can also happen if the sum of beginning retained earnings and net income is less than the amount paid out in shareholder dividends.<\/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, retained earnings are the profits remaining after all expenses and shareholder dividends have been paid out. The information you need to calculate these is reported on the company\u2019s financial statements, so you can easily add this formula to your current templates in Google Sheets or Microsoft Excel to automate the calculation.<\/p>\n You now know what retained earnings are and how the formula relates them to income and equity. You also know how to calculate retained earnings using Google Sheets. If you work in Excel, the same formula fits into this income statement template for Excel<\/a>. If your finance team still copies figures between spreadsheets by hand, Sheetgo’s AI finance virtual employee<\/a> can take on much of that repetitive work, so you can focus on what matters to you and your company.<\/p>\n To learn more about financial statements, and other financial metrics used to assess a company\u2019s financial health, check out:<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Aprende a calcular los beneficios retenidos con la f\u00f3rmula, un ejemplo resuelto y ejemplos paso a paso en Google Sheets con beneficio neto y con p\u00e9rdidas netas.<\/p>","protected":false},"author":2,"featured_media":264971,"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-264959","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\/264959","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=264959"}],"version-history":[{"count":2,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/264959\/revisions"}],"predecessor-version":[{"id":266563,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/264959\/revisions\/266563"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/264971"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=264959"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=264959"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=264959"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}What are retained earnings?<\/h2>\n
Are retained earnings assets?<\/h2>\n
How to calculate retained earnings?<\/h2>\n
\n
What is an example of retained earnings?<\/h2>\n
Retained earnings with net income<\/h3>\n
Retained earnings with net losses<\/h3>\n
What do retained earnings tell you?<\/h2>\n
What does it mean to have negative retained earnings?<\/h2>\n
Conclusion<\/h2>\n
\n