Excel Formula Return on Assets ROA and Return on Equity ROE

The Return on Assets (ROA) ratio measures the efficiency of using assets to generate income. For example, a company with a high ROA can generate the same profit with fewer assets or asset tranches as a company with a lower ROA.



Formula for Calculating Return on Assets (ROA) in Excel

To calculate the ROA ratio, you need to divide the profit generated over the accounting period by the average value of assets at the beginning and end of the period. Below is an example of a balance sheet and ROA calculation in Excel:

Source data table:

BalanceStartEnd Profit and Loss StatementFact
Cash1186124 Revenue55656
Accounts Receivable38843026 Cost of Goods Sold41454
Inventory83557651 Gross Profit14202
Total Current Assets1342510801 Research and Development2046
Equipment and Property43204516 Sales Expenses6528
Other Assets578322 Operating Profit5628
Total Long-Term Assets48984838 Interest Expenses465
Total Assets1832315639 Other Costs and Expenses1368
Accounts Payable16702644 Net Profit3795
Accruals13341431 Return on Assets (ROA)22.35%
Current Notes Payable788761 Return on Equity (ROE)40.13%
Total Current Liabilities37924836
Long-Term Notes Payable31773244
Total Liabilities69698080
Public Actions453453
Additional Capital45624562
Retained Earnings63392544
Total Equity113547559
Total Liabilities and Equity1832315639

Example of how to use a formulas in Excel:

ROA = Net Income / Average Total Assets

ROE = Net Income / Shareholders Equity

ROA Formula in Excel.

The numerator is net profit, taken from the income and expenses statement. The denominator uses the AVERAGE function to calculate the average value of assets for the accounting period.

Formula for Return on Equity (ROE) in Excel

Another commonly used indicator of a company's financial performance is the Return on Equity (ROE) ratio. Investors use it to assess how efficiently their investments will be used. The formula for calculating ROE in Excel is shown below:

ROE Formula in Excel.

Download examples of Return on Assets and Return on Equity Formulas in Excel download file

Also read: Download Return on Equity Excel Template.

Similar to the previous example, the ROE ratio is calculated by dividing net profit by the average equity balance over the accounting period. However, in the ROE ratio, the average total equity is used instead of the average total assets.