{"id":9001,"date":"2019-09-11T06:35:07","date_gmt":"2019-09-11T04:35:07","guid":{"rendered":"http:\/\/www.officetodo.com\/public\/?p=9001"},"modified":"2019-09-11T06:35:09","modified_gmt":"2019-09-11T04:35:09","slug":"calculating-return-on-assets-roa-in-excel","status":"publish","type":"post","link":"https:\/\/www.officetodo.com\/public\/calculating-return-on-assets-roa-in-excel\/","title":{"rendered":"Calculating Return on Assets (ROA) in Excel"},"content":{"rendered":"\n<p>\n\nReturn on assets shows the percentage of profit that a company earns in relation to its resources. To calculate return on assets open your income statement and balance sheet. Divide net profit after tax from the income statement with total assets from the 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 Assets (ROA) in Excel\" width=\"625\" height=\"352\" src=\"https:\/\/www.youtube.com\/embed\/VFZpwa01VJU?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 assets shows the percentage of profit that a company earns in relation to its resources. To calculate return on assets open your income statement and balance sheet. Divide net profit after tax from the income statement with total assets from the 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":[3599,3600],"class_list":["post-9001","post","type-post","status-publish","format-standard","hentry","category-4-reporting","category-4-2-financial-ratios","tag-return-on-assets","tag-roa"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9001","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=9001"}],"version-history":[{"count":1,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9001\/revisions"}],"predecessor-version":[{"id":9002,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9001\/revisions\/9002"}],"wp:attachment":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/media?parent=9001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/categories?post=9001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/tags?post=9001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}