Formula to Calculate Fixed Asset Turnover Ratio
Fixed Asset Turnover Ratio formula is used for measuring the ability of the company to generate the sales using the fixed assets investments and it is calculated by dividing the Net Sales with the Average Fixed Assets.
The fixed asset turnover ratio is a measure of the efficiency of a company and is evaluated as a return on their investment in fixed assets such as property, plant, and equipment. In other words, it assesses the ability of a company to efficiently generate net sales from its machines and equipment. The formula is represented as,
Steps to Calculate Fixed Asset Turnover Ratio
The fixed asset turnover ratio calculation can be simply done by using the following steps:
- Firstly, note the net sales of the company, which is easily available as a line item in the income statement.
- Next, the average net fixed assets can be calculated from the balance sheetCalculated From The Balance SheetA balance sheet is one of the financial statements of a company that presents the shareholders' equity, liabilities, and assets of the company at a specific point in time. It is based on the accounting equation that states that the sum of the total liabilities and the owner's capital equals the total assets of the company. by taking the average of opening and closing net fixed assets. On the other hand, gross fixed assets and accumulated depreciation can also be captured from the balance sheet to calculate the net fixed assets by deducting the accumulated depreciation from the gross fixed assets.
- Finally, the calculation of the fixed asset turnover ratio is done by dividing the net sales by the net fixed assets, as shown below.
Examples of Fixed Asset Turnover Ratio
Let us see some simple to advanced examples to understand it better.
Let us consider two independent companies X and Y, that manufactures office furniture and distribute it to the sellers as well as customers in various regions of the USA. The following information for both the companies is available:
|Particulars||Company X||Company Y|
|Net Sales During the Year||$75,000||$90,000|
|Opening Net Fixed Assets||$22,000||$26,000|
|Closing Net Fixed Assets||$25,000||$28,000|
From the above table, the following can be calculated,
Based on the above information, calculate the fixed assets turnover ratio for both the companies. Also, compare and determine which company is more efficient in using its fixed assets?
As per the question,
Average net fixed asset for Company X = (Opening net fixed assets + Closing net fixed assets) /2
The average net fixed asset for Company Y=(Opening net fixed assets + Closing net fixed asset)/2
Fixed asset turnover ratio for Company X = Net sales / Average net fixed assets
So, from the above calculation, the Fixed asset turnover ratio for company X will be:
Fixed asset turnover ratio for Company Y = Net sales / Average net fixed assets
So, from the above calculation, the Fixed asset turnover ratio for company Y will be:
Therefore, company Y generates a sales revenue of $3.34 for each dollar invested in fixed assets as compared to company X, which generates a sales revenue of $3.19 for each dollar invested in fixed assets. Based on the above comparison, it can be said that Company Y is slightly more efficient in utilizing its fixed assets.
Let us take the example of Apple Inc. for the fixed asset turnover ratio calculation of the fiscal year ended on September 29, 2018. As per the annual report, the following information is available:
|Particulars||Amount (in Million)|
|Net Sales During the Year||$265, 595|
|Gross Fixed Assets (2017)||$75,076|
|Gross Fixed Assets (2018)||$90,403|
|Accumulated Depreciation (2017)||$41,293|
|Accumulated Depreciation (2018)||$49,099|
Based on the above information, the Fixed Assets Turnover Ratio calculation for Apple Inc.will be as follows
As per the question,
Net fixed asset for 2017 = Gross fixed assets (2017) – Accumulated depreciation (2017)
Net fixed asset for 2018 = Gross fixed assets (2018) – Accumulated depreciationAccumulated DepreciationThe accumulated depreciation of an asset is the amount of cumulative depreciation charged on the asset from its purchase date until the reporting date. It is a contra-account, the difference between the asset's purchase price and its carrying value on the balance sheet. (2018)
Average net fixed asset = [Net fixed assets (2017) + Net fixed assets (2018)] /2
Fixed asset turnover ratio for Apple Inc. = Net sales / Average net fixed assets
Therefore, Apple Inc. generates a sales revenue of $7.07 for each dollar invested in fixed assets during 2018.
Fixed Asset Turnover Ratio Formula Calculator
You can use the following calculator
|Fixed Asset Turnover Ratio Formula =||
Relevance and Uses
- The fixed asset turnover ratio is important from the point of view of an investor and creditor who use this to assess how well a company is utilizing its machines and equipment to generate sales. This concept is important for investors because it can be used to measure the approximate return on their investment in fixed assets.
- On the other hand, the creditors use the ratio to check if the company has the potential to generate adequate cash flow from the newly purchased equipment in order to pay back the loan that has been used to purchase it. This ratio is typically useful in the case of the manufacturing industry, where companies have large and expensive equipment purchases.
- However, the senior management of any company seldom uses this ratio because they have insider informationInsider InformationInsider Information is a piece of fact, information or an understanding (M&A, New Contracts, R&D breakthrough, new product launch etc.) which could impact the prices of a listed entity or publicly-traded organizations once disclosed in the public domain. Trading based on such information is considered to be illegal. about sales figures, equipment purchases, and other such details that are not readily available to outsiders. The management prefers to measure the return on their purchases based on more detailed and specific information.
- If the company has too much invested in the company’s assets, then their operating capital will be too high. Otherwise, if the company does not have enough invested in its assets, then the company might end up losing sales, which will hurt its profitability, free cash flowFree Cash FlowThe cash flow to the firm or equity after paying off all debts and commitments is referred to as free cash flow (FCF). It measures how much cash a firm makes after deducting its needed working capital and capital expenditures (CAPEX)., and eventually, stock price. As such, it is important for the management to determine the right amount of investment in each of their assets.
- It can be done by comparing the ratio of the company to that of other companies in the same industry and analyze how much others have invested in similar assets. Further, the company can also track how much they have invested in each asset every year and draw a pattern to check the year-on-year trend.
This has been a guide to Fixed Asset Turnover Ratio Formula. Here we discuss how to calculate the Fixed Asset Turnover Ratio step by step using practical examples and a downloadable excel template. You can learn more about financial analysis from the following articles –