Cellwise Start free

Excel guide · 5 min read

How to calculate the asset turnover ratio in Excel

Quick answerTotal asset turnover = revenue / average total assets, where average total assets is (opening + closing) / 2. With revenue in C2 and total assets at the end of the previous and current year in B3 and C3: =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.

RowABCDEFGHIJK
1Year20222023202420252026Asset (2026 register)CostAccumulated depreciationNet book value
2Revenue1840000201000021900002780000Production line48000048000432000
3Total assets (year end)11200001180000125000016900001760000Building fit-out350000105000245000
4Average total assets1150000121500014700001725000Vehicles18000072000108000
5Total asset turnover1.61.65432098771.48979591841.6115942029Machinery240000120000120000
6Net PP&E (year end)520000500000540000960000905000
7Average net PP&E510000520000750000932500
8Fixed asset turnover3.60784313733.86538461542.922.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.

=C2/AVERAGE(B3:C3)

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.

=E2/E3

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.

=E2/AVERAGE(D3:E3)

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.

=F2/AVERAGE(E6:F6)

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.

=F2/SUM(I2:I5)

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.

=E2/AVERAGE(D6:E6)

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

Updated