{"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":"https:\/\/www.officetodo.com\/public\/calculating-return-on-equity-roe-in-excel\/","title":{"rendered":"Calculating Return on Equity (ROE) in Excel"},"content":{"rendered":"\n<p>\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":[],"_links":{"self":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/8997","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/comments?post=8997"}],"version-history":[{"count":1,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/8997\/revisions"}],"predecessor-version":[{"id":8998,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/8997\/revisions\/8998"}],"wp:attachment":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/media?parent=8997"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/categories?post=8997"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/tags?post=8997"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}