Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Return on Assets (ROA) Formula | Calculator (with Excel Template)

Return on Assets Ratio (ROA)

Flow of the article

  • Return on Assets ratio Formula
  • ROA Calculator
  • ROA Template

Return on Assets (ROA) ratio Formula

ROA Ratio is a measure of profitability for the company.

ROA shows the profitability of the company in relation to its Average Total Assets.

Here’s the return on Assets Ratio formula:

Return on Assets Ratio (ROA) Formula

Explanation of ROA Ratio Formula

ROA shows the profit earned as a percentage from its Average Total Assets for the period by a company. It shows that how efficiently the company can convert its investment in Assets into profits. For better results, some analysts add back the cost of acquiring capital (interest expense) to Net profits while calculating the ratio.

While measuring profitability ROA takes into account the assets financed by equity holders as well as debt holders, hence, interest expense is added back to the Net Income. Due to the various operations of the company, assets may vary over the period of time, which is why average of the total assets are considered.

It is given by (Opening Assets + Closing Assets)/2. It helps in missing out on major changes in asset positions happening in the whole year.

Use of ROA Ratio Formula

  • Return on assets formula gives the investors and creditors an overview of the top management’s efficiency to bring out earnings from the company’s assets.
  • Whenever comparison of companies with similar capitalization is to be done, Return on assets formula proves to be an apt profitability measure.
  • Return on assets formula showcases the profit generating strength of the assets that are employed by the company.
  • It is internally used by the managers to track the asset use over a period of time, to monitor the performance of the company in regards to industry performance.

Return on assets ratio formula Example

Below is the information given about the Company A and B. Find the ROA of both the company.

Company A:

  • Net Income = $40,000
  • Opening Assets = $150,000
  • Closing Assets = $190,000

Average Total Assets = (Opening + Closing)/2 = (150,000 + 190,000)/2 = $170,000

Company B:

  • Net Income = $70,000
  • Opening Assets = $280,000
  • Closing Assets = $110,000

Average Total Assets = (Opening + Closing)/2 = (280,000 + 110,000)/2 = $195,000

Calculation of Return on assets ratio formula:

ROA formula = Net Income / Average Total Assets

Company A Company B
= $40,000/$170,000 = $70,000/$195,000
=0.2353 or 24% = 0.3590 or 36%

Interpretation of Return on Assets Ratio

  • It is always better for the company to have a higher ratio. The higher the better.
  • It shows that the management is efficient and capable of generating more and more profits from the available assets.
  • In the above example Company B is comparatively better as it has a higher ratioof 36% as compared to that of Company A which has a ROA of 24%. It means that every dollar that company B invests in debt or equity it is able to return 36 cents as profits per year. If this percentage (36%) has a y-o-y increasing trend then it can be said that the company is managing its assets efficiently.

Return on Assets Ratio Calculator

You can use the following Return on Assets (ROA) Calculator

Net Income
Average Total Assets
Return on Assets Ratio =

Return on Assets Ratio =
Net Income
Average Total Assets
= 0

Return on Assets Ratio in Excel (with Excel Template)

Let us now do the same example above in Excel.

This is very simple. You need to provide the two inputs of Net Income and Average Total Sales.

You can easily calculate the ratio in the template provided.

Return on Assets Ratio (ROA) in excel

Calculation of ROA Ratio

Return on Assets Ratio (ROA) in excel template

You can download this Return on Assets template here – Return on Assets (ROA) Excel Template

Recommended Articles:

This has been a guide to Return on Assets Formula, practical examples, and Return on Assets calculator along with excel templates. You may also have a look at these articles below to learn more about Financial Analysis –

  • Financial Ratios Guide
  • Return on Total Assets
  • Retention Ratio Formula
  • Dividend Payout Formula
  • ROCE

The post Return on Assets (ROA) Formula | Calculator (with Excel Template) appeared first on Learn Investment Banking: Financial Modeling Training Courses Online.

This post first appeared on Free Investment Banking Tutorials |WallStreetMojo, please read the originial post: here

Share the post

Return on Assets (ROA) Formula | Calculator (with Excel Template)


Subscribe to Free Investment Banking Tutorials |wallstreetmojo

Get updates delivered right to your inbox!

Thank you for your subscription