WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Investment Banking Tutorials » Financial Statement Analysis » Asset to Sales Ratio

Asset to Sales Ratio

What is Asset to Sales Ratio?

An asset to sales ratio formula calculates total assets divided by total sales of a company; this ratio helps in determining the efficiency of a company in managing its assets to generate enough sales for the company so as to make the assets worthwhile.

An asset to Sales Ratio Formula

It indicates how much asset a company possesses in regards to the revenue it earns using its assets. The formula is as follows –

Assets to Sales Ratio = Total Assets / Sales

Assets to Sales Ratio Formula

Explanation

This formula is the complete opposite of the asset turnover ratio formula.

In this ratio, we compare the assets with the revenue the company generates.

For example, if a company has $100,000 of assets and its revenue in the current year is $50,000; then the asset to sales would be = $100,000 / $50,000 = 2.

To find out the assets, you need to look into the balance sheet of the company.

Sometimes, you need to consider both the beginning assets & ending assets and then average it to get the average total assets.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

In that case, the Asset to sales formula then would change to –

Assets to Sales Ratio = Average Total Assets / Sales

For sales, you need to look at the income statement.

You need to remember that “sales” means “revenue,” and it has nothing to do with a profit of the year. So look straight up in the income statement.

Example

Let’s take a practical example to understand this formula.

You can download this Asset to Sales Ratio Excel Template here – Asset to Sales Ratio Excel Template

John wants to look at RMB Company. John finds out that at the end of the year, RMB Company has total assets of $400,000. And John also discovers that last year, RMB Company has revenues of $100,000. What would be the asset to the sales ratio of RMB Company?

We will simply put the data into the formula.

  • Asset to Sales formula = Total Assets / Sales;
  • Or, = $400,000 / $100,000 = 4.
  • The ratio RMB Company is 4.
  • If we get to know the average ratio of a similar company under the same industry, we would be able to figure out whether 4 is a good ratio or not.

How to Interpret?

An asset to Sales ratio isn’t a common ratio and not very widely used. However, this ratio can tell a lot about a company and how it is operating.

Let’s say that you, as an investor, have been monitoring this ratio of a company for the last 2-3 years. You saw that the company had a ratio of 5 in the previous year. This year, the ratio is 6. How would you interpret it?

There can be two possible reasons.

  • The first reason behind the increased asset to sales ratio is the lack of proper utilization of company assets. If the revenue is not increasing (or not increasing at the pace of the increase of assets), then the assets of the company are under-utilized.
  • The second reason can be due to the installation of new machinery; the sales couldn’t be increased. As a result, you may see an increased asset to sales ratio.

As an investor, you should always look at this ratio to ensure that the assets are properly utilized, and the revenue of the company has been increasing at a decent rate. Otherwise, how would you ensure that you would be able to earn a decent return from your investments?

An asset to Sales Ratio Calculator

You can use the following Calculator

Total Asset
Sales
Asset to Sales Ratio Formula
 

Asset to Sales Ratio Formula =
Total Asset
=
Sales
0
= 0
0

Calculate Asset to Sales Ratio in Excel (with excel template)

Let us now do the same example above in Excel.

It is very simple. You need to provide the two inputs of Total Assets and Total Sales.

You can easily calculate the ratio in the template provided.

Asset to Sales Ratio in Excel

An asset to Sales Ratio Video

Recommended Articles:

This article has been a guide to Asset to Sales Ratio. Here we discuss the formula to calculate Asset to Sales Ratio, its interpretation along with a practical example and excel templates. You may also have a look at these articles below to learn more about Financial Analysis –

  • OIBDA
  • Calculate Asset Coverage Ratio
  • Sales Invoice Excel Template
  • Compare – Trailing PE vs. Forward PE Ratio
  • Capital Loss Example
5 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

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

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

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

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Ratio Analysis Course

Step by Step Guide to Calculating Financial Ratios in excel

WallStreetMojo

Download Asset to Sales Ratio Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More