EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Finance Finance Resources Finance Formula Fixed Asset Turnover Ratio Formula
 

Fixed Asset Turnover Ratio Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated July 21, 2023

Fixed Asset Turnover Ratio Formula

 

 

Fixed Asset Turnover Ratio Formula (Table of Contents)
  • Formula
  • Examples
  • Calculator

What is the Fixed Asset Turnover Ratio Formula?

The term “Fixed Asset Turnover Ratio” refers to the operating performance metric that shows how efficiently a company utilizes its fixed assets (machinery and equipment) to generate sales. In other words, this ratio is used to determine the amount of dollar revenue generated by each dollar of available fixed assets.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

The fixed asset turnover ratio formula is expressed as the subject company’s net sales divided by the average value of its net fixed assets, which is mathematically represented as,

Fixed Asset Turnover Ratio = Net Sales / Average Net Fixed Assets

Example of Fixed Asset Turnover Ratio Formula (With Excel Template)

Let’s take an example to understand the calculation of the Fixed Asset Turnover Ratio in a better manner.

You can download this Fixed Asset Turnover Ratio Formula Excel Template here – Fixed Asset Turnover Ratio Formula Excel Template

Example #1

Let us take the example of two companies, ABC Inc. and XYZ Inc., to illustrate the fixed asset turnover ratio concept. Both companies belong to the same industry of ice cream manufacturing. Calculate the fixed assets turnover ratio of both of those businesses on the basis of the above-given information. Also, calculate which company utilizes its fixed assets better. According to the latest annual reports, the following information is available:

example of two companies

Solution:

The formula to calculate Average Net Fixed Assets is as below:

Average Net Fixed Assets = (Opening Net Fixed Assets + Closing Net Fixed Assets) / 2

Average Net Fixed Assets

For ABC Inc.

  • Average Net Fixed Assets = ($20 million + $24 million) / 2
  • Average Net Fixed Assets = $22 million

For XYZ Inc.

  • Average Net Fixed Assets = ($22 million + $26 million) / 2
  • Average Net Fixed Assets = $24 million

The formula to calculate the Fixed Asset Turnover Ratio is as below:

Fixed Asset Turnover Ratio = Net Sales / Average Net Fixed Assets

Fixed Asset Turnover Ratio Formula - 1.3

For ABC Inc.

  • Fixed Asset Turnover Ratio = $50 million / $22 million
  • Fixed Asset Turnover Ratio = 2.27x

For XYZ Inc.

  • Fixed Asset Turnover Ratio = $70 million / $24 million
  • Fixed Asset Turnover Ratio = 2.92x

Therefore, XYZ Inc.’s fixed asset turnover ratio is higher than that of ABC Inc., which indicates that XYZ Inc. was more effective in the use of its fixed assets during 2019.

Example #2

Let us take Apple Inc.’s example now’s annual report for the year 2019 and illustrate the computation of the fixed asset turnover ratio. During the year, the company booked net sales of $260,174 million, while its net fixed assets at the start and end of 2019 stood at $41,304 million and $37,378 million, respectively. Calculate Apple Inc.’s fixed assets turnover ratio based on the given information.

Apple Inc.

Solution:

The formula to calculate Average Net Fixed Assets is as below:

Average Net Fixed Assets = (Opening Net Fixed Assets + Closing Net Fixed Assets) / 2

Fixed Asset Turnover Ratio Formula - 2.2

  • Average Net Fixed Assets = ($41,304 million + $37,378 million) / 2
  • Average Net Fixed Assets = $39,341 million

The formula to calculate the Fixed Asset Turnover Ratio is as below:

Fixed Asset Turnover Ratio = Net Sales / Average Net Fixed Assets

Fixed Asset Turnover Ratio Formula - 2.3

  • Fixed Asset Turnover Ratio = $260,174 million / $39,341 million
  • Fixed Asset Turnover Ratio = 6.61x

Therefore, Apple Inc.’s fixed asset turnover ratio was 6.61x for the year 2019.

Source Link: Apple Inc. Balance Sheet

Explanation

The formula for the Fixed Asset Turnover Ratio can be calculated by using the following steps:

Step 1: First, determine the value of the net sales the company recognizes in its income statement for the given period.

Step 2: Next, the company’s net fixed assets value at the beginning of the period (opening) and at the end of the period (closing). Now, compute the average net fixed assets for the given period based on the opening and closing value of the net fixed assets.

Average Net Fixed Assets = (Opening Net Fixed Assets + Closing Net Fixed Assets) / 2

Step 3: Finally, the formula for the fixed asset turnover ratio can be derived by dividing net sales (step 1), as shown below, by the average net fixed assets (step 2).

Fixed Asset Turnover Ratio = Net Sales / Average Net Fixed Assets

Relevance and Use

It is important to understand the concept of the fixed asset turnover ratio as it is helpful in assessing the operational efficiency of a company. This ratio primarily applies to manufacturing-based companies as they have huge investments in plants, machinery, and equipment. As such, fixed assets’ utilization is critical for their business well-being. Investors and analysts can use the ratio to compare the performances of companies operating in similar industries.

Although it is a very useful metric, one of the major flaws with this ratio is that it can be influenced by manipulating the depreciation charge, as the ratio is calculated based on the net value of fixed assets. So, the higher the depreciation charge, the better will be the ratio, and vice versa.

Fixed Asset Turnover Ratio Formula Calculator

You can use the following Calculator

Net Sales
Average Net Fixed Assets
Fixed Asset Turnover Ratio
 

Fixed Asset Turnover Ratio = Net Sales /Average Net Fixed Assets
= 0 /0 = 0

Recommended Articles

This is a guide to the Fixed Asset Turnover Ratio Formula. Here we discuss calculating the Fixed Asset Turnover Ratio along with practical examples. We also provide a Fixed Asset Turnover Ratio calculator with a downloadable Excel template. You may also look at the following articles to learn more –

  1. Pearson Correlation Coefficient Formula
  2. Accounting Formula
  3. Cost-Benefit Analysis Formula
  4. Annuity Due Formula
  5. Guide to Asset Turnover Ratio

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Fixed Asset Turnover Ratio Formula Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

डाउनलोड Fixed Asset Turnover Ratio Formula Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW