ROA Calculator
See how efficiently your business generates profit from everything it owns.
Last updated: October 2026
Reading this result: every dollar of assets the business controls produced 8.00 cents of profit. Compare it only against businesses with similar asset bases.
General information only, not financial advice. Check any figure before you act on it.
Free ROA calculator Excel workbook
The same method as the calculator above, in a spreadsheet you can keep, edit and share — with a profit and asset sensitivity grid, a DuPont breakdown that links ROA to ROE, and a four-company comparison.
- ROA Calculator — ROA on average and closing assets, profit per 1 of assets and a sensitivity grid
- DuPont Breakdown — net margin × asset turnover, and how debt turns ROA into ROE
- Compare — up to four companies ranked by ROA, with ROE and the equity multiplier
- Worked examples, formula guide and checks — including the sale-and-leaseback trap
Opens in Microsoft Excel or LibreOffice Calc. General information only, not financial advice.
ROA is one ratio of many. The Financial Ratio Analysis Template is a paid spreadsheet that calculates twenty-one liquidity, profitability, efficiency and leverage ratios from one sheet of figures, each with a plain-English note. Browse all templates
What return on assets actually measures
Return on assets asks how hard the things a business owns are working. Take every asset on the balance sheet — buildings, machines, stock, cash, receivables — and ask what profit the business squeezed out of that whole pile in a year.
The crucial difference from return on equity is the denominator. ROE divides by the owners’ slice only; ROA divides by everything the business controls, no matter who paid for it. Borrowed money bought assets too, and those assets are in the denominator. That makes ROA largely immune to the leverage trick that inflates ROE, and it is why the two should always be read together.
What ROA is really testing is capital intensity: how much stuff you need to own in order to earn a dollar. A consultancy needs laptops. A steel mill needs a mill. Both can be excellent businesses, and their ROAs will never be comparable.
The ROA formula
ROA (%) = Net income ÷ Total assets × 100Average assets = (Opening assets + Closing assets) ÷ 2As with ROE, profit is earned over a year while the balance sheet is a single day, so average assets is the fairer denominator. Some analysts use operating profit (EBIT) on the top line instead of net income, on the grounds that assets are funded by lenders as well as owners, so the return should be measured before interest is paid. Both are defensible. Pick one, and say which you used.
Three worked examples
Ordinary case
A retailer
A shop earns $120,000 after tax. Total assets opened at $1,400,000 and closed at $1,600,000, mostly stock and fit-out.
ROA = 120,000 ÷ 1,500,000 × 100 = 8.00%
On closing assets alone: 120,000 ÷ 1,600,000 = 7.50%
Eight percent is respectable for retail, where large amounts of capital sit in inventory. The same 8% would be poor for a software business and excellent for a utility.
Capital intensity
Same profit, different businesses
A consultancy and a manufacturer each earn $200,000 after tax. The consultancy owns $400,000 of assets. The manufacturer owns $4,000,000 of plant and inventory.
Manufacturer: 200,000 ÷ 4,000,000 × 100 = 5.00%
A tenfold difference in ROA, identical profit. This is not a verdict on management — it is a description of two different business models. It is also why ROA comparisons are only meaningful within an industry. Across industries the ratio measures the industry, not the company.
Accounting effects
Sale and leaseback
A distributor owns its warehouse and earns $300,000 on $2,500,000 of assets. It sells the warehouse, leases it back, and now pays rent — so profit falls to $270,000 while assets drop to $1,200,000.
After: 270,000 ÷ 1,200,000 × 100 = 22.50%
ROA nearly doubled while profit actually fell. Taking assets off the balance sheet shrinks the denominator faster than the rent reduces the numerator. Any time ROA jumps sharply, check whether assets left the balance sheet before concluding the business improved.
Where ROA misleads you
How ROA and ROE fit together
ROE = ROA × Equity multiplierEquity multiplier = Total assets ÷ Shareholders’ equityThe retailer above earns 8% on its assets. If its assets are $1,500,000 and its equity $666,667, the equity multiplier is 2.25 and the owners see an ROE of 18%. The extra ten percentage points are not operating performance — they are borrowed money amplifying the same 8%. Read the pair together and the whole story appears: ROA tells you how good the business is, and the gap up to ROE tells you how much debt is behind it.
ROA, ROE and ROI compared
| Measure | Question it answers | Denominator | Distorted by debt? |
|---|---|---|---|
| ROA | Are the assets working hard? | Total assets | Barely |
| ROE | Are the owners being rewarded? | Shareholders’ equity | Yes — strongly |
| ROI | Did this one decision pay off? | Money put into it | Only if included |
How to calculate ROA in Excel or Google Sheets
Net income in B1, opening assets in B2, closing assets in B3:
=B1/AVERAGE(B2:B3)=B1/B3 ← closing-assets versionFormat as Percentage rather than multiplying by 100, so the underlying value stays usable in later calculations.
Frequently asked questions
What is a good ROA?
There is no universal figure, because the answer is set by how asset-heavy the industry is. Software and services businesses can exceed 20%; manufacturers, retailers and utilities often sit in low single digits and are perfectly healthy. The only useful benchmarks are the company’s own trend and its direct competitors.
Should the numerator be net income or EBIT?
Either, as long as you are consistent. Net income is simpler and widely quoted. EBIT is arguably more correct, because assets are funded by lenders as well as owners, so measuring the return before interest matches the numerator to the denominator. When comparing companies, make sure both sides use the same definition.
Average assets or closing assets?
Average, when you have both balance sheet dates. Profit accrues over the year while the balance sheet is a single-day photograph, so averaging opening and closing is fairer — particularly for a business that grew or shrank its asset base significantly during the year.
Why is ROA usually lower than ROE?
Because total assets are almost always larger than equity — the difference being liabilities. The ratio between them is the equity multiplier, and ROE equals ROA times that multiplier. A wide gap between the two means the business carries a lot of debt.
Can ROA be negative?
Yes, whenever the business makes a loss. Unlike ROE, the denominator cannot realistically go negative — a company always has some assets — so a negative ROA is straightforward to read: the assets destroyed value that year rather than creating it.
Does depreciation affect ROA?
Considerably, in both directions. It reduces profit on the numerator while also reducing the carrying value of assets on the denominator. Over time the denominator effect usually dominates, so a business with old, heavily depreciated assets will report a higher ROA than an identical business that recently reinvested.
References
- Brealey, R. A., Myers, S. C. & Allen, F. Principles of Corporate Finance, 13th edition, McGraw-Hill Education — on asset productivity and financial ratio analysis.
- Damodaran, A. Investment Valuation: Tools and Techniques for Determining the Value of Any Asset, 3rd edition, Wiley — on accounting returns and their limitations.
Keep going
Written and reviewed by Ghayas Uddin, MS (Finance), financial analyst. Last reviewed 21 September 2026. Found an error? Email support@babadigit.com and we will correct it.