Excel guide · 5 min read
How to calculate the asset turnover ratio in Excel
=C2/AVERAGE(B3:C3). This business made 1,840,000 of revenue in 2023 on 1,150,000 of average assets, a turnover of 1.60: every 1 of assets produced 1.60 of sales.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 | J | K |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Year | 2022 | 2023 | 2024 | 2025 | 2026 | Asset (2026 register) | Cost | Accumulated depreciation | Net book value | |
| 2 | Revenue | 1840000 | 2010000 | 2190000 | 2780000 | Production line | 480000 | 48000 | 432000 | ||
| 3 | Total assets (year end) | 1120000 | 1180000 | 1250000 | 1690000 | 1760000 | Building fit-out | 350000 | 105000 | 245000 | |
| 4 | Average total assets | 1150000 | 1215000 | 1470000 | 1725000 | Vehicles | 180000 | 72000 | 108000 | ||
| 5 | Total asset turnover | 1.6 | 1.6543209877 | 1.4897959184 | 1.6115942029 | Machinery | 240000 | 120000 | 120000 | ||
| 6 | Net PP&E (year end) | 520000 | 500000 | 540000 | 960000 | 905000 | |||||
| 7 | Average net PP&E | 510000 | 520000 | 750000 | 932500 | ||||||
| 8 | Fixed asset turnover | 3.6078431373 | 3.8653846154 | 2.92 | 2.981233244 |
Download this sheet as an Excel practice file (.xlsx)
Lay out the years side by side
Asset turnover measures how hard the assets work: how many units of revenue each unit of assets brings in over a year. It's one of the three parts of the DuPont breakdown of return on equity, next to profit margin and leverage.
Put the years across the top: 2022 to 2026 in B1:F1. Revenue goes in row 2 and total assets at each year end in row 3, both straight from the income statement and the balance sheet. 2022 needs only its closing assets, because it's there to be the opening balance for 2023.
Revenue covers the whole year, while total assets is a snapshot on one day. That's why the formula averages the opening and closing balances: it gives a rough figure for the assets in use during the year that the revenue was earned.
Total asset turnover
In C4, =AVERAGE(B3:C3) averages the 2022 and 2023 year-end assets. In C5, =C2/C4 divides revenue by it. Fill both right to 2026 and each year picks up its own opening balance from the column to its left.
The ratio went 1.60, 1.65, 1.49 and 1.61. The dip in 2025 is the interesting one, and the next section explains it. Compare the ratio over time and with businesses in the same industry only: a retailer turns its assets far faster than a utility or a manufacturer, simply because of what it needs to own.
Result: 1.6 shows as 1.60 with Number format
1.60 for 2023: 1,840,000 of revenue over 1,150,000 of average total assets.
Can I just use the closing balance?
You can, but it distorts any year in which assets jumped. For 2025, revenue over closing assets gives 1.30 instead of 1.49 on the average, because the closing figure includes a production line that was bought right at the end of the year.
Result: 1.2958579882 shows as 1.30 with Number format
1.30 for 2025 on year-end assets alone, against 1.49 on the average.
Why a new asset drags the ratio down in its first year
In December 2025 the business installed a 480,000 production line. Total assets jumped from 1,250,000 to 1,690,000, but the line had produced almost nothing by year end. The 2025 average includes half of that jump, so turnover fell from 1.65 to 1.49 even though nothing went wrong in the business.
In 2026, with a full year of output from the line, revenue rose to 2,780,000 and turnover recovered to 1.61. When you see a drop, check the balance sheet for a big purchase before you call it a decline. If assets move a lot during the year, average the 13 month-end balances instead of two, in the same way as average inventory, so a December purchase only counts for the month it was owned.
Result: 1.4897959184 shows as 1.49 with Number format
1.49 for 2025: 2,190,000 of revenue over 1,470,000 of average total assets.
Fixed asset turnover from the register
Fixed asset turnover narrows the bottom line to property, plant and equipment (PP&E), net of depreciation: revenue / average net PP&E. It's the version that tells a manufacturer whether its machines are earning their keep, without stock and cash muddying the picture.
The 2026 net PP&E in F6 comes straight from a fixed asset register: H:K lists each asset's cost and accumulated depreciation, K takes one from the other, and =SUM(K2:K5) gives 905,000. Linking the cell to the register means the ratio updates when you post depreciation. Rows 7 and 8 then repeat the averaging and division for PP&E.
Result: 2.981233244 shows as 2.98 with Number format
2.98 for 2026: 2,780,000 of revenue over 932,500 of average net PP&E.
Should I use net book value or cost?
Net book value is the usual choice and matches the balance sheet. But it falls every year as assets depreciate, so an ageing factory looks more efficient each year without doing anything better. Showing the ratio on cost as well removes that effect.
Result: 2.224 shows as 2.22 with Number format
2.22 on the 1,250,000 original cost of the assets, against 2.98 on average net book value.
Reading the two ratios together
Fixed asset turnover went 3.61, 3.87, 2.92 and 2.98. It fell harder than total asset turnover in 2025 because the new line is a much bigger share of PP&E than of total assets. Two years on, it still hasn't returned to the 2024 level, which is the real question for the owners: is the line running at the volume that justified buying it?
These ratios describe what happened; they don't say what to do. A lower ratio after an investment can be fine if margins improved, which is why it's worth reading turnover next to profit margin and return on assets rather than on its own.
Result: 2.92 shows as 2.92 with Number format
2.92 for 2025: 2,190,000 of revenue over 750,000 of average net PP&E, down from 3.87 in 2024.
Common mistakes
Dividing by year-end assets only
Average the opening and closing balances, or the 13 month ends when assets change a lot during the year.
Reading a first-year drop as decline
Check for a large purchase near year end. The asset counts in the average before it has earned a full year of revenue.
Comparing across industries
Asset-heavy businesses have low turnover by nature. Compare with your own history and with similar businesses.
Ignoring the effect of depreciation
Net PP&E shrinks every year, which lifts fixed asset turnover on its own. Show the ratio on cost as a check.
FAQ
What is the formula for asset turnover ratio?
Revenue / average total assets, with average total assets = (opening + closing total assets) / 2. In Excel: =C2/AVERAGE(B3:C3).
What is the difference between total and fixed asset turnover?
Total asset turnover divides revenue by all assets, including cash, receivables and stock. Fixed asset turnover divides it by net property, plant and equipment only.
What is a good asset turnover ratio?
It depends heavily on the industry. Compare the ratio with your own previous years and with businesses like yours, not with a general benchmark.
How does asset turnover relate to return on assets?
Return on assets = profit margin x asset turnover, because (net income / revenue) x (revenue / assets) = net income / assets. See return on equity in Excel for the full DuPont breakdown.
Functions used
Related guides
- How to build a fixed asset register in Excel
- How to make a balance sheet in Excel
- How to calculate return on equity in Excel
- How to calculate revenue per employee in Excel
- How to calculate return on assets (ROA) in Excel
- Average excluding zeros (and blanks) in Excel
- How to calculate the cash conversion cycle in Excel
Updated