Financial Statement Analysis
 Ratio Analysis of Financial Statements (Formula, Types, Excel)
 Ratio Analysis Advantages
 Ratio Analysis
 Liquidity Ratios
 Cash Ratio
 Cash Ratio Formula
 Quick Ratio
 Quick Ratio Formula
 Current Ratio
 Current Ratio Formula
 Acid Test Ratio Formula
 Defensive Interval Ratio
 Working Capital Ratio
 Working Capital Formula
 Net Working Capital Formula
 Changes in Net Working Capital
 Cash Flow from Operations Ratio
 Cash Reserve Ratio
 Operating Cycle Formula
 Current Ratio vs Quick Ratio
 Bid Ask Spread
 Liquidity vs Solvency
 Liquidity
 Solvency
 Solvency Ratios
 Equity Ratio
 Capital Adequacy Ratio
 Liquidity Risk
 Altman Z Score
 Turnover Ratios
 Inventory Turnover Ratio
 Accounts Receivable Turnover
 Accounts Receivables Turnover Ratio
 Accounts Payable Turnover Ratio
 Days Inventory Outstanding
 Days in Inventory
 Days Sales Outstanding
 Average Collection Period
 Days Payable Outstanding
 Cash Conversion Cycle
 Cash Conversion Cycle (CCC) Formula
 Fixed Asset Turnover Ratio Formula
 Debtor Days Formula
 Working Capital Turnover Ratio
 Profitability Ratios
 Profitability Ratios Formula
 Common Size Income Statement
 Vertical Analysis of Income Statement
 Profit Margin
 Gross Profit Margin Formula
 Gross Profit Percentage
 Operating Profit Margin Formula
 EBIT Margin Formula
 Operating Income Formula
 Net Profit Margin Formula
 EBIDTA Margin
 Degree of Operating Leverage Formula (DOL)
 NOPAT Formula
 OIBDA
 Earnings Per Share
 Basic EPS
 Diluted EPS
 Basic EPS vs Diluted EPS
 Return on Equity (ROE)
 Return on Capital Employed (ROCE)
 Return on Invested Capital (ROIC)
 Return on Sales
 ROIC Formula (Return on Invested Capital)
 Return on Investment Formula (ROI)
 ROIC vs ROCE
 ROE vs ROA
 CFROI
 Cash on Cash Return
 Return on Total Assets (ROA)
 Return on Average Capital Employed
 Capital employed Employed
 Return on Average Assets (ROAA)
 Return on Average Equity (ROAE)
 Return on Assets Formula
 Return on Equity Formula
 DuPont Formula
 Net Interest Margin Formula
 Earnings Per Share Formula
 Diluted EPS Formula
 Contribution Margin Formula
 Unit Contribution Margin
 Revenue Per Employee Ratio
 Operating Leverage
 EBIT vs EBITDA
 EBITDAR
 Capital Gains Yield
 Tax Equivalent Yield
 LTM Revenue
 Operating Expense Ratio Formula
 Overhead Ratio Formula
 Variable Costing Formula
 Capitalization Rate
 Cap Rate Formula
 Comparative Income Statement
 Capacity Utilization Rate Formula
 Total Expense Ratio Formula
 Efficiency Ratios
 Dividend Ratios
 Debt Ratios
 Debt to Equity Ratio
 Debt Coverage Ratio
 Debt Ratio
 Debt to Asset Ratio Formula
 Coverage Ratio
 Coverage Ratio Formula
 Debt to Income Ratio Formula (DTI)
 Capital Gearing Ratio
 Capitalization Ratio
 Interest Coverage Ratio
 Times Interest Earned Ratio
 Debt Service Coverage Ratio (DSCR)
 DSCR Formula (Debt service coverage ratio)
 Financial Leverage Ratio
 Financial Leverage Formula
 Degree of Financial Leverage Formula
 Net Debt Formula
 Leverage Ratios
 Leverage Ratios Formula
 Operating Leverage vs Financial Leverage
 Current Yield
 Debt Yield Ratio
 Solvency Ratio Formula
Asset Turnover Ratio Formula (Table of Contents)
What is Asset Turnover Ratio Formula?
This formula is an efficiency ratio that judges how efficiently a company uses its assets to generate revenue.
Here’s this formula –
Asset Turnover Ratio Formula Example
Now, let’s take a practical example of the asset turnover ratio formula
YMC Company has gross sales of $75,000 at the end of 2017. The sales return for the year was $5000. The total assets at the beginning of the year were $120,000 and at the end of the year were $160,000. Calculate the asset turnover ratio of YMC Company.
First of all, we need to calculate net sales.
 We have gross sales and that is $75,000.
 We also have a sales return and that is $5000.
 Then, the net sales would be = ($75,000 – $5000) = $70,000.
Now, we will calculate the average total assets by using the simple average method.
 The total assets at the beginning of the year were $120,000. And the total assets at the end of the year were $160,000.
 Then, the average total assets for the year would be = ($120,000 + $160,000) / 2 = $280,000 / 2 = $140,000.
Now, we will put the data into the formula.
 Asset Turnover Ratio formula = Net Sales / Average Total Assets
 = $70,000 / $140,000 = 0.50.
If we compare the asset turnover of YMC Company with the asset turnover of a similar company under the same industry, we would be able to tell 0.50 is a good number or not.
Recommended Courses
Explanation
This is the opposite of asset to sales ratio. In this ratio, we look at the net sales and average total assets.
In the income statement, the first item is “gross sales”.
4.8 (388 ratings)
If we deduct “sales discount” or “sales return” from “gross sales”; we would get “net sales”.
On the other hand, to find the average total assets we need to look at the assets at the beginning of the year and the assets at the end of the year. And then we can take the average of the assets at the beginning and the assets at the ending.
If we want to go deep, we can use the weighted average method to calculate the average total assets.
Use of Asset Turnover Ratio Formula
Unlike the asset to sales ratio, in the case of calculation, more is better.
Why?
If this ratio is more, it indicates that the assets of the company are properly utilized and vice versa.
For example, if we find that the asset turnover ratio calculation is 0.6; that means net sales are 60% of the average total assets. Now, if this ratio is 1; then the net sales are 100% of the average total assets.
When a company buys new machinery, the sole objective is to increase the sale.
By installing new machinery, the company can produce more products, and sell out more products as well.
As a result, the revenue of the company increases along the way.
However, if installing new machinery don’t result in an increase in sales; that means either the machinery are defective or the company isn’t able to utilize the assets properly.
Asset Turnover Ratio Calculator
You can use the following Asset Turnover Ratio Calculator
Net Sales  
Average Total Assets  
Assets Turnover Ratio Formula =  
Assets Turnover Ratio Formula = 


Asset Turnover Ratio Formula in Excel (with excel template)
Let us now do the same example above in Excel.
This is very simple. First, we need to calculate the net sales and then we will calculate the average total assets by using the simple average method.
You can easily calculate the ratio in the template provided.
Asset Turnover Ratio Formula Video
Recommended Articles:
This has been a guide to Asset Turnover Ratio Formula, practical examples and asset turnover ratio calculator along with excel templates. You may also have a look at these articles below to learn more about Financial Analysis –
Leave a Reply