background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for May 2024 for May 2024
:
Private EquityReal Estate Investing
Buy-Side InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for May 2024 is Open
Wall Street Prep

Asset Turnover Ratio

Step-by-Step Guide to Understanding Asset Turnover Ratio

Last Updated December 28, 2023

Learn Online Now

Asset Turnover Ratio

How to Calculate Asset Turnover Ratio?

The asset turnover ratio is calculated by dividing the net sales of a company by the average balance of the total assets belonging to the company (i.e., the average between the beginning and end of period asset balances).

If management’s operating capital spending has been inefficient, the company is most likely losing out on potential sales due to the misallocation of capital, which will eventually show up on its financials via lower profitability and free cash flow.

Generally, the higher the asset turnover ratio, the better, as this suggests that the company is producing more sales per dollar of asset owned (i.e., faster conversion into turnover, or revenue), and is an indication of being better at putting its assets to use.

Unless specified otherwise, the asset turnover metric answers the question, “How much in revenue does the company generate per dollar of assets owned?”

For instance, if the total turnover of a company is 1.0x, that would mean the company’s net sales are equivalent to the average total assets in the period. In other words, this company is generating $1.00 of sales for each dollar invested into all assets.

The turnover metric falls short, however, in being distorted by significant one-time capital expenditures (Capex) and asset sales.

If you are assessing another company’s financials or attempting to determine the right amount of capital to allocate for your business, you can obtain the most useful information by comparing your company’s ratio to that of industry peers.

Additionally, you can track how your investments into ordering new assets have performed year-over-year to see if the decisions paid off or require adjustments going forward.

Asset Turnover Ratio Formula

The formula to calculate the total asset turnover ratio is as follows.

Total Asset Turnover Ratio = Net Sales ÷ Average Total Assets

Where:

  • Net Sales = Gross Sales – Returns – Discounts – Allowances
  • Average Total Assets = (Beginning Total Assets + Ending Total Assets) ÷ 2

While the income statement measures a metric across two periods, balance sheet items reflect values at a certain point of time.

Hence, we use the average total assets across the measured net sales period in order to align the timing between both metrics.

Next, a common variation includes only long-term fixed assets (PP&E) in the calculation, as opposed to all assets.

As shown in the formula below, the ratio compares a company’s net sales to the value of its fixed assets.

Fixed Asset Turnover Ratio = Net Sales ÷ Average Fixed Assets

Where:

  • Net Sales = Gross Sales – Returns – Discounts – Allowances
  • Average Fixed Assets = (Beginning Fixed Assets + Ending Fixed Assets) ÷ 2

The ratio is meant to isolate how efficiently the company uses its fixed asset base to generate sales (i.e., capital expenditures).

Hence, it is often used as a proxy for how efficiently a company has invested in long-term assets.

Considering how costly the initial purchase of PP&E and maintenance can be, each spending decision towards these long-term investments should be made carefully to lower the chance of creating operating inefficiencies.

What is a Good Asset Turnover Ratio?

Irrespective of whether the total or fixed variation is used, the asset turnover ratio is not practical as a standalone metric without a point of reference.

The asset turnover ratio is most helpful when compared to that of industry peers and tracking how the ratio has trended over time.

  • Low Asset Turnover Ratio ➝ Often indicates excess production capacity or inefficient inventory management
  • High Asset Turnover Ratio ➝ Suggests the company is allocating capital and deriving more benefits from its assets

Comparisons of the ratio among companies are going to be most meaningful among those within the same vertical or industry, and setting the parameters to determine what should be considered “high” or “low” ratios should be made within a specific industry context.

Over time, positive increases in the turnover ratio can serve as an indication that a company is gradually expanding into its capacity as it matures (and the reverse for decreases across time).

Companies should strive to maximize the benefits received from their assets on hand, which tends to coincide with the objective of minimizing any operating waste.

On the flip side, a turnover ratio far exceeding the industry norm could be an indication that the company should be spending more and might be falling behind in terms of development.

Thus, a sustainable balance must be struck between being efficient while also spending enough to be at the forefront of any new industry shifts.

As with all financial ratios, a closer look is necessary to understand the company-specific factors that can impact the ratio. And such ratios should be viewed as indicators of internal or competitive advantages (e.g., management asset management) rather than being interpreted at face value without further inquiry.

How to Interpret Asset Turnover Ratio by Industry?

One critical consideration when evaluating the ratio is how capital-intensive the industry that the company operates in is (i.e., asset-heavy or asset-lite).

For example, a company may have made significant asset purchases in anticipation of coming growth or have gotten rid of non-core assets in anticipation of stagnating or declining growth – and either change could artificially increase or decrease the ratio.

Companies with fewer assets on their balance sheet (e.g., software companies) tend to have higher ratios than companies with business models that require significant spending on assets.

To reiterate from earlier, the average turnover ratio varies significantly across different sectors, so it makes the most sense for only ratios of companies in the same or comparable sectors to be benchmarked.

Asset Turnover Ratio Calculator

We’ll now move to a modeling exercise, which you can access by filling out the form below.

dl

Get the Excel Template!

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

1. Balance Sheet Assumptions

In our hypothetical scenario, the company has net sales of $250m, which is anticipated to increase by $50m each year.

Moreover, the company has three types of current assets (cash & cash equivalents, accounts receivable, and inventory) with the following balances as of Year 0.

  1. Cash and Cash Equivalents = $15m
  2. Accounts Receivable = $20m
  3. Inventory = $25m

For the entire forecast, each of the current assets will increase by $2m. As a quick example, the company’s A/R balance will grow from $20m in Year 0 to $30m by the end of Year 5.

For the final step in listing out our assumptions, the company has a PP&E balance of $85m in Year 0, which is expected to increase by $5m each period and reach $110m by the end of the forecast period.

2. Total Asset Turnover Calculation Example

We now have all the required inputs, so we’ll take the net sales for the current period and divide it by the average asset balance of the prior and current periods.

To calculate the ratio in Year 1, we’ll divide Year 1 sales ($300m) by the average between the Year 0 and Year 1 total asset balances ($145m and $156m). Upon doing so, we get 2.0x for the total asset turnover.

  • Total Asset Turnover Ratio, Year 1 = $300 million ÷ AVERAGE($145 million, $156 million) = 2.0x

Asset Turnover Ratio Calculation Example

3. Fixed Asset Turnover Calculation Example

Once this same process is done for each year, we can move on to the fixed asset turnover, where only PP&E is included rather than all the company’s assets.

For Year 1, we’ll divide Year 1 sales ($300m) by the average between the Year 0 and Year 1 PP&E balances ($85m and $90m), which comes out to a ratio of 3.4x.

  • Fixed Asset Turnover Ratio = $300 million ÷ AVERAGE($85million, $90 million) = 2.0x

Fixed Asset Turnover Calculator

Considering that the total turnover ratio increased from 2.0x in Year 1 to 2.6x in Year 5 while the fixed turnover ratio increased from 3.4x to 4.7x during the same time horizon, these positive trends could be interpreted as the company using its assets more efficiently over time.

For a more practical assessment, however, the relevant market data on industry peers is required – including the specific details regarding the company’s asset management plans and recent operating changes – to confirm the validity of the findings compiled from analyzing its asset turnover ratio.

Asset Turnover Ratio Calculator

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today
Comments
0 Comments
Inline Feedbacks
View all comments
Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.