{"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":"http:\/\/www.officetodo.com\/public\/calculating-return-on-assets-roa-in-excel\/","title":{"rendered":"Calculating Return on Assets (ROA) in Excel"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\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":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"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\" \/>\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-assets-roa-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-assets-roa-in-excel\\\/#article\",\"name\":\"Calculating Return on Assets (ROA) in Excel | Office ToDo\",\"headline\":\"Calculating Return on Assets (ROA) in Excel\",\"author\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"publisher\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\"},\"datePublished\":\"2019-09-11T06:35:07+02:00\",\"dateModified\":\"2019-09-11T06:35:09+02:00\",\"inLanguage\":\"en\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/calculating-return-on-assets-roa-in-excel\\\/#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/calculating-return-on-assets-roa-in-excel\\\/#webpage\"},\"articleSection\":\"4 Reporting, 4.2 Financial Ratios, return on assets, roa\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/calculating-return-on-assets-roa-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-assets-roa-in-excel\\\/#listItem\",\"name\":\"Calculating Return on Assets (ROA) 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-assets-roa-in-excel\\\/#listItem\",\"position\":5,\"name\":\"Calculating Return on Assets (ROA) 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-assets-roa-in-excel\\\/#webpage\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/calculating-return-on-assets-roa-in-excel\\\/\",\"name\":\"Calculating Return on Assets (ROA) in Excel | Office ToDo\",\"description\":\"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\",\"inLanguage\":\"en\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/calculating-return-on-assets-roa-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:35:07+02:00\",\"dateModified\":\"2019-09-11T06:35:09+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 Assets (ROA) in Excel | Office ToDo","description":"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","canonical_url":"http:\/\/www.officetodo.com\/public\/calculating-return-on-assets-roa-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-assets-roa-in-excel\/#article","name":"Calculating Return on Assets (ROA) in Excel | Office ToDo","headline":"Calculating Return on Assets (ROA) in Excel","author":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"publisher":{"@id":"http:\/\/www.officetodo.com\/public\/#organization"},"datePublished":"2019-09-11T06:35:07+02:00","dateModified":"2019-09-11T06:35:09+02:00","inLanguage":"en","mainEntityOfPage":{"@id":"http:\/\/www.officetodo.com\/public\/calculating-return-on-assets-roa-in-excel\/#webpage"},"isPartOf":{"@id":"http:\/\/www.officetodo.com\/public\/calculating-return-on-assets-roa-in-excel\/#webpage"},"articleSection":"4 Reporting, 4.2 Financial Ratios, return on assets, roa"},{"@type":"BreadcrumbList","@id":"http:\/\/www.officetodo.com\/public\/calculating-return-on-assets-roa-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-assets-roa-in-excel\/#listItem","name":"Calculating Return on Assets (ROA) 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-assets-roa-in-excel\/#listItem","position":5,"name":"Calculating Return on Assets (ROA) 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-assets-roa-in-excel\/#webpage","url":"http:\/\/www.officetodo.com\/public\/calculating-return-on-assets-roa-in-excel\/","name":"Calculating Return on Assets (ROA) in Excel | Office ToDo","description":"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","inLanguage":"en","isPartOf":{"@id":"http:\/\/www.officetodo.com\/public\/#website"},"breadcrumb":{"@id":"http:\/\/www.officetodo.com\/public\/calculating-return-on-assets-roa-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:35:07+02:00","dateModified":"2019-09-11T06:35:09+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":"9001","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 Assets (ROA) 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 Assets (ROA) in Excel","link":"http:\/\/www.officetodo.com\/public\/calculating-return-on-assets-roa-in-excel\/"}],"_links":{"self":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9001","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=9001"}],"version-history":[{"count":1,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9001\/revisions"}],"predecessor-version":[{"id":9002,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9001\/revisions\/9002"}],"wp:attachment":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/media?parent=9001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/categories?post=9001"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/tags?post=9001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}