Excel guide · 5 min read
How to calculate return on assets (ROA) in Excel
=C2/AVERAGE(B4:C4), formatted as a percentage. This business earned 182,000 in 2023 on 1,560,000 of average assets, an ROA of 11.7%: every 100 of assets produced 11.70 of profit.Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C | D | E | F | G | H | I |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Year | 2022 | 2023 | 2024 | 2025 | 2026 | Month | Net income | |
| 2 | Net income | 182000 | 205000 | 168000 | 231000 | Jun 2025 | 15000 | ||
| 3 | Revenue | 2600000 | 2850000 | 3050000 | 3400000 | Jul 2025 | 16500 | ||
| 4 | Total assets (year end) | 1500000 | 1620000 | 1700000 | 2150000 | 2230000 | Aug 2025 | 17200 | |
| 5 | Average total assets | 1560000 | 1660000 | 1925000 | 2190000 | Sep 2025 | 18800 | ||
| 6 | ROA | 0.11666666667 | 0.1234939759 | 0.087272727273 | 0.10547945205 | Oct 2025 | 16900 | ||
| 7 | Net profit margin | 0.07 | 0.071929824561 | 0.055081967213 | 0.067941176471 | Nov 2025 | 14100 | ||
| 8 | Asset turnover | 1.6666666667 | 1.7168674699 | 1.5844155844 | 1.5525114155 | Dec 2025 | 22400 | ||
| 9 | Jan 2026 | 15600 | |||||||
| 10 | Same ROA, different debt | Net income | Avg assets | Avg equity | ROA | ROE | Feb 2026 | 17300 | |
| 11 | Low-debt firm | 120000 | 1000000 | 800000 | 0.12 | 0.15 | Mar 2026 | 19200 | |
| 12 | High-debt firm | 120000 | 1000000 | 300000 | 0.12 | 0.4 | Apr 2026 | 20000 | |
| 13 | May 2026 | 21000 | |||||||
| 14 | |||||||||
| 15 | Total assets May 2025 | 1760000 | |||||||
| 16 | Total assets May 2026 | 2190000 |
Download this sheet as an Excel practice file (.xlsx)
Lay out the years side by side
ROA tells you how much profit the business makes from everything it controls: cash, stock, receivables, buildings and machines, whether owners or lenders paid for them. It's the profit side of asset turnover, which measures sales per unit of assets.
Put the years across row 1, 2022 to 2026 in B1:F1. Net income goes in row 2 and revenue in row 3, both from the income statement. Row 4 holds total assets at each year end from the balance sheet. 2022 only needs its closing assets, because it's there to be the opening balance for 2023.
Net income covers a whole year, but total assets is a snapshot on one day. Dividing a year of profit by an average of the opening and closing balances matches the two better than either balance on its own.
ROA year by year
In C5, =AVERAGE(B4:C4) averages the 2022 and 2023 year-end assets. In C6, =C2/C5 divides net income by it. Fill both right to 2026 and each year picks up its own opening balance from the column to its left. Format row 6 as a percentage with one decimal place.
ROA went 11.7%, 12.3%, 8.7% and 10.5%. The drop in 2025 isn't a bad year on its own: in November 2025 the business bought a 450,000 warehouse, so assets jumped while profit hadn't caught up yet.
Result: 0.11666666667 shows as 11.7% with Percent format
0.117 for 2023, 11.7%: 182,000 of net income over 1,560,000 of average total assets.
Can I divide by year-end assets instead?
You can, but it punishes any year with a late purchase. For 2025, net income over closing assets gives 7.8% instead of 8.7% on the average, because the closing figure includes a warehouse that was owned for only a few weeks of the year.
Result: 0.078139534884 shows as 7.8% with Percent format
0.078, 7.8% for 2025 on year-end assets alone, against 8.7% on the average.
Which profit figure should I use?
Net income is the standard version and the one most people mean. Some analysts add back interest after tax so ROA doesn't depend on how the assets were financed. Whichever you choose, use it for every year and say which one it is.
ROA mid-year: trailing twelve months
In June you can't wait for the year end. Use the last 12 months of profit instead, the trailing twelve months (TTM). Monthly net income for June 2025 to May 2026 sits in H2:I13, and total assets at the end of May 2025 and May 2026 in I15:I16.
Keep the two sides on the same 12 months: the assets you average are the balances 12 months apart at the start and end of that window. Next month, drop June 2025 and add June 2026, and swap in the new month-end balances.
Result: 0.10835443038 shows as 10.8% with Percent format
0.108, 10.8%: 214,000 of profit over the last 12 months, over 1,975,000 of average assets.
Why not multiply year-to-date profit up to a full year?
Annualizing five months of profit assumes the rest of the year looks the same, and it rarely does for a seasonal business. TTM always uses a full year of real results, so the number is comparable month to month.
ROA = profit margin x asset turnover
ROA splits into two parts that tell you what to work on. Net income / revenue is the profit margin (row 7, =C2/C3) and revenue / average assets is asset turnover (row 8, =C3/C5). Multiply them and revenue cancels out, leaving net income / assets.
Laid out year by year, the split explains 2025: margin fell from 7.2% to 5.5% and turnover from 1.72 to 1.58. In 2026 the margin recovered to 6.8%, but turnover slipped again to 1.55, because the warehouse is still a big asset relative to the sales it supports. The owners' question is about volume through the new warehouse, not about prices.
Result: 0.11666666667 shows as 11.7% with Percent format
0.117 for 2023, 11.7%: a 7.0% margin x a turnover of 1.67, the same answer as net income / average assets.
What does asset-heavy vs asset-light mean for ROA?
Two businesses can reach the same ROA in opposite ways. A grocer with a 2% margin and a turnover of 3.0 makes 6%, and so does an engineering firm with a 12% margin and a turnover of 0.5. That's why ROA comparisons only make sense between businesses with a similar model, or against your own history.
Why debt makes ROE higher on the same ROA
ROA ignores how the assets were paid for. Return on equity divides the same profit by the owners' equity only. Rows 10 to 12 compare two firms with the same 1,000,000 of assets and the same 120,000 of profit: one funded mostly by its owners, one mostly by loans.
Both have a 12% ROA. The low-debt firm's ROE is 15%, the high-debt firm's is 40%, because its owners put in far less. This example keeps profit equal to show the effect; in real life the borrower also pays interest, which comes out of net income. A high ROE with a modest ROA is a sign of borrowing, which also raises the risk when profits fall. Return on equity in Excel covers the full DuPont breakdown.
Result: 0.4 shows as 40% with Percent format
0.4, 40% ROE for the high-debt firm, against 15% for the low-debt firm. Both have an ROA of 12%.
Common mistakes
Dividing by year-end assets only
Average the opening and closing balances, or the 13 month ends when assets move a lot during the year.
Mixing a part-year profit with full-year assets
Use the trailing twelve months of profit, and average the balances at the start and end of the same 12 months.
Comparing ROA across industries
Asset-heavy businesses have lower turnover by nature. Compare with your own years and with similar businesses.
Reading a first-year dip as decline
Check for a big purchase near the year end; split ROA into margin and turnover to see which part moved.
FAQ
What is the formula for return on assets in Excel?
Net income / average total assets: =C2/AVERAGE(B4:C4) with net income in C2 and opening and closing total assets in B4 and C4. Format it as a percentage.
What is a good ROA?
There is no single good number, because it depends on how asset-heavy the business is. Compare ROA with your own previous years and with businesses that have a similar model.
What is the difference between ROA and ROE?
ROA divides profit by total assets, funded by owners and lenders. ROE divides it by equity only, so a business with debt shows a higher ROE than ROA.
How do I calculate ROA from monthly figures?
Add up the last 12 months of net income with SUM and divide by the average of total assets at the start and end of those 12 months.
Functions used
Related guides
- How to calculate return on equity in Excel
- How to calculate the asset turnover ratio in Excel
- How to make a balance sheet in Excel
- How to calculate profit margin in Excel
- Average excluding zeros (and blanks) in Excel
- How to calculate agent occupancy in Excel
Updated