{"id":8997,"date":"2019-09-11T06:32:00","date_gmt":"2019-09-11T04:32:00","guid":{"rendered":"http:\/\/www.officetodo.com\/public\/?p=8997"},"modified":"2019-09-11T06:32:02","modified_gmt":"2019-09-11T04:32:02","slug":"calculating-return-on-equity-roe-in-excel","status":"publish","type":"post","link":"http:\/\/www.officetodo.com\/public\/calculating-return-on-equity-roe-in-excel\/","title":{"rendered":"Calculating Return on Equity (ROE) in Excel"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\n\nReturn on equity shows how much profit a company earned in comparison to the total amount of shareholder equity. To calculate return on equity open your income statement and balance sheet. Divide net profit after tax from income statement with shareholder equity from balance sheet\n\n<\/p>\n\n\n\n<!--more-->\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Calculating Return on Equity (ROE) in Excel\" width=\"625\" height=\"352\" src=\"https:\/\/www.youtube.com\/embed\/MwHHoEHxgZI?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Return on equity shows how much profit a company earned in comparison to the total amount of shareholder equity. To calculate return on equity open your income statement and balance sheet. Divide net profit after tax from income statement with shareholder equity from balance sheet<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,47],"tags":[3596,3597],"class_list":["post-8997","post","type-post","status-publish","format-standard","hentry","category-4-reporting","category-4-2-financial-ratios","tag-return-on-equity","tag-roe"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"Return on equity shows how much profit a company earned in comparison to the total amount of shareholder equity. To calculate return on equity open your income statement and balance sheet. Divide net profit after tax from income statement with shareholder equity from balance sheet\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Karl\"\/>\n\t<link rel=\"canonical\" href=\"http:\/\/www.officetodo.com\/public\/calculating-return-on-equity-roe-in-excel\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/calculating-return-on-equity-roe-in-excel\\\/#article\",\"name\":\"Calculating Return on Equity (ROE) in Excel | Office ToDo\",\"headline\":\"Calculating Return on Equity (ROE) in Excel\",\"author\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"publisher\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\"},\"datePublished\":\"2019-09-11T06:32:00+02:00\",\"dateModified\":\"2019-09-11T06:32:02+02:00\",\"inLanguage\":\"en\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/calculating-return-on-equity-roe-in-excel\\\/#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/calculating-return-on-equity-roe-in-excel\\\/#webpage\"},\"articleSection\":\"4 Reporting, 4.2 Financial Ratios, return on equity, roe\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/calculating-return-on-equity-roe-in-excel\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.officetodo.com\\\/public\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/financial-reporting\\\/#listItem\",\"name\":\"Financials\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/financial-reporting\\\/#listItem\",\"position\":2,\"name\":\"Financials\",\"item\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/financial-reporting\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/financial-reporting\\\/4-reporting\\\/#listItem\",\"name\":\"4 Reporting\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/financial-reporting\\\/4-reporting\\\/#listItem\",\"position\":3,\"name\":\"4 Reporting\",\"item\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/financial-reporting\\\/4-reporting\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/financial-reporting\\\/4-reporting\\\/4-2-financial-ratios\\\/#listItem\",\"name\":\"4.2 Financial Ratios\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/financial-reporting\\\/#listItem\",\"name\":\"Financials\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/financial-reporting\\\/4-reporting\\\/4-2-financial-ratios\\\/#listItem\",\"position\":4,\"name\":\"4.2 Financial Ratios\",\"item\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/financial-reporting\\\/4-reporting\\\/4-2-financial-ratios\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/calculating-return-on-equity-roe-in-excel\\\/#listItem\",\"name\":\"Calculating Return on Equity (ROE) in Excel\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/financial-reporting\\\/4-reporting\\\/#listItem\",\"name\":\"4 Reporting\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/calculating-return-on-equity-roe-in-excel\\\/#listItem\",\"position\":5,\"name\":\"Calculating Return on Equity (ROE) in Excel\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/financial-reporting\\\/4-reporting\\\/4-2-financial-ratios\\\/#listItem\",\"name\":\"4.2 Financial Ratios\"}}]},{\"@type\":\"Organization\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\",\"name\":\"Office ToDo\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/\",\"name\":\"Karl\"},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/calculating-return-on-equity-roe-in-excel\\\/#webpage\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/calculating-return-on-equity-roe-in-excel\\\/\",\"name\":\"Calculating Return on Equity (ROE) in Excel | Office ToDo\",\"description\":\"Return on equity shows how much profit a company earned in comparison to the total amount of shareholder equity. To calculate return on equity open your income statement and balance sheet. Divide net profit after tax from income statement with shareholder equity from balance sheet\",\"inLanguage\":\"en\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/calculating-return-on-equity-roe-in-excel\\\/#breadcrumblist\"},\"author\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"creator\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"datePublished\":\"2019-09-11T06:32:00+02:00\",\"dateModified\":\"2019-09-11T06:32:02+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#website\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/\",\"name\":\"Office ToDo\",\"inLanguage\":\"en\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Calculating Return on Equity (ROE) in Excel | Office ToDo","description":"Return on equity shows how much profit a company earned in comparison to the total amount of shareholder equity. To calculate return on equity open your income statement and balance sheet. Divide net profit after tax from income statement with shareholder equity from balance sheet","canonical_url":"http:\/\/www.officetodo.com\/public\/calculating-return-on-equity-roe-in-excel\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.officetodo.com\/public\/calculating-return-on-equity-roe-in-excel\/#article","name":"Calculating Return on Equity (ROE) in Excel | Office ToDo","headline":"Calculating Return on Equity (ROE) in Excel","author":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"publisher":{"@id":"http:\/\/www.officetodo.com\/public\/#organization"},"datePublished":"2019-09-11T06:32:00+02:00","dateModified":"2019-09-11T06:32:02+02:00","inLanguage":"en","mainEntityOfPage":{"@id":"http:\/\/www.officetodo.com\/public\/calculating-return-on-equity-roe-in-excel\/#webpage"},"isPartOf":{"@id":"http:\/\/www.officetodo.com\/public\/calculating-return-on-equity-roe-in-excel\/#webpage"},"articleSection":"4 Reporting, 4.2 Financial Ratios, return on equity, roe"},{"@type":"BreadcrumbList","@id":"http:\/\/www.officetodo.com\/public\/calculating-return-on-equity-roe-in-excel\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public#listItem","position":1,"name":"Home","item":"http:\/\/www.officetodo.com\/public","nextItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/#listItem","name":"Financials"}},{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/#listItem","position":2,"name":"Financials","item":"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/","nextItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/4-reporting\/#listItem","name":"4 Reporting"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public#listItem","name":"Home"}},{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/4-reporting\/#listItem","position":3,"name":"4 Reporting","item":"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/4-reporting\/","nextItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/4-reporting\/4-2-financial-ratios\/#listItem","name":"4.2 Financial Ratios"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/#listItem","name":"Financials"}},{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/4-reporting\/4-2-financial-ratios\/#listItem","position":4,"name":"4.2 Financial Ratios","item":"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/4-reporting\/4-2-financial-ratios\/","nextItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/calculating-return-on-equity-roe-in-excel\/#listItem","name":"Calculating Return on Equity (ROE) in Excel"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/4-reporting\/#listItem","name":"4 Reporting"}},{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/calculating-return-on-equity-roe-in-excel\/#listItem","position":5,"name":"Calculating Return on Equity (ROE) in Excel","previousItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/4-reporting\/4-2-financial-ratios\/#listItem","name":"4.2 Financial Ratios"}}]},{"@type":"Organization","@id":"http:\/\/www.officetodo.com\/public\/#organization","name":"Office ToDo","url":"http:\/\/www.officetodo.com\/public\/"},{"@type":"Person","@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author","url":"http:\/\/www.officetodo.com\/public\/author\/admin\/","name":"Karl"},{"@type":"WebPage","@id":"http:\/\/www.officetodo.com\/public\/calculating-return-on-equity-roe-in-excel\/#webpage","url":"http:\/\/www.officetodo.com\/public\/calculating-return-on-equity-roe-in-excel\/","name":"Calculating Return on Equity (ROE) in Excel | Office ToDo","description":"Return on equity shows how much profit a company earned in comparison to the total amount of shareholder equity. To calculate return on equity open your income statement and balance sheet. Divide net profit after tax from income statement with shareholder equity from balance sheet","inLanguage":"en","isPartOf":{"@id":"http:\/\/www.officetodo.com\/public\/#website"},"breadcrumb":{"@id":"http:\/\/www.officetodo.com\/public\/calculating-return-on-equity-roe-in-excel\/#breadcrumblist"},"author":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"creator":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"datePublished":"2019-09-11T06:32:00+02:00","dateModified":"2019-09-11T06:32:02+02:00"},{"@type":"WebSite","@id":"http:\/\/www.officetodo.com\/public\/#website","url":"http:\/\/www.officetodo.com\/public\/","name":"Office ToDo","inLanguage":"en","publisher":{"@id":"http:\/\/www.officetodo.com\/public\/#organization"}}]}},"aioseo_meta_data":{"post_id":"8997","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2021-08-05 05:13:27","updated":"2026-05-26 23:33:29","ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.officetodo.com\/public\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/\" title=\"Financials\">Financials<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/4-reporting\/\" title=\"4 Reporting\">4 Reporting<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/4-reporting\/4-2-financial-ratios\/\" title=\"4.2 Financial Ratios\">4.2 Financial Ratios<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tCalculating Return on Equity (ROE) in Excel\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"http:\/\/www.officetodo.com\/public"},{"label":"Financials","link":"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/"},{"label":"4 Reporting","link":"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/4-reporting\/"},{"label":"4.2 Financial Ratios","link":"http:\/\/www.officetodo.com\/public\/lessons\/financial-reporting\/4-reporting\/4-2-financial-ratios\/"},{"label":"Calculating Return on Equity (ROE) in Excel","link":"http:\/\/www.officetodo.com\/public\/calculating-return-on-equity-roe-in-excel\/"}],"_links":{"self":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/8997","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/comments?post=8997"}],"version-history":[{"count":1,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/8997\/revisions"}],"predecessor-version":[{"id":8998,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/8997\/revisions\/8998"}],"wp:attachment":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/media?parent=8997"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/categories?post=8997"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/tags?post=8997"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}