EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 250+ Courses All in One Bundle
  • Login
Home Finance Finance Resources Finance Formula Asset to Sales Ratio Formula
Secondary Sidebar
Finance Blog
  • Accounting Fundamentals Resources (720+)
  • Asset Management Tutorial (200+)
  • Banking (44+)
  • Corporate Finance Resources (374+)
  • Credit Research Fundamentals (6+)
  • Economics (104+)
  • Finance Formula (384+)
  • Financial Modeling in Excel (16+)
  • Investment Banking Resources (142+)
  • Investment Banking Careers (29+)
  • Trading for dummies (69+)
  • valuation basics (26+)
  • Insurance Resources (15+)
  • Top Finance Books (33+)
Finance Blog Courses
  • Investment Banking Course
  • Investment Banking Online Course
  • Financial Modeling Certification

Asset to Sales Ratio Formula

By Madhuri ThakurMadhuri Thakur

Asset-to-Sales-Ratio-Formula

Asset to Sales Ratio Formula (Table of Contents)

  • Asset to Sales Ratio Formula
  • Asset to Sales Ratio Calculator
  • Asset to Sales Ratio Formula in Excel (With Excel Template)

Asset to Sales Ratio Formula

An asset to sales ratio is one of the primary ratios which are used in determining the company’s efficiency. It shows how a company is generating revenue by managing its asset and correlation between them. A higher asset to revenue ratio indicates higher profitability with low investment.

Start Your Free Investment Banking Course

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

The Formula for Asset to Sales Ratio is

Asset to Sales Ratio Formula

Where,

Average Total Assets is calculated as:

Average Total Assets formula

Average total assets are taken into account as because most of the companies choose for capital investment during the year and to take a median of assets utilized for generating the entire revenue throughout the year average of opening and closing total assets are taken into account.

Assets can be built by means of shareholders equity and as well as borrowed fund. So summation of both borrowed amount and shareholders fund are taken into consideration for the base when the business revenue is determined.

Examples of Asset to Sales Ratio Formula

Let’s take an example to find out the Asset to Sales Ratio for a company: –

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

Asset to Sales Ratio Formula – Example #1

X Ltd. has a closing Asset in its Balance Sheet at INR 20000 and its opening balance stands at INR 16000. Revenue stands at INR 12000. Find the Asset to Revenue of the Business?

  • Total Asset of the company at the beginning (opening balance) of the year INR 16000
  • Total Asset of the company at the end (closing balance) of the year INR 20000
  • Total revenue of the company stands at INR 12000

Average Total Assets is Calculated using below formula

  • Average Total Assets = (Opening Assets + Closing Assets)/ 2
  • Average Total Asset of X ltd = INR (16000+20000) /2
  • Average Total Asset of X ltd = 36,000 / 2
  • Average Total Asset of X ltd = INR 18000

Asset to Sales Ratio is calculated using below formula

  • Asset to Sales Ratio =Total Revenue / Average Total Assets
  • Asset to Sales Ratio = 12000/ 18000
  • Asset to Sales Ratio = 0.66 or 66.66%

To conclude for every 1 rupee Investment, the company is able to generate 0.66 or 66% of the total investment.

Asset to Sales Ratio Formula – Example #2

The Consolidated income of Nocil Ltd for FY17 and FY18 are INR 751.73 Cr and INR 982.19 Cr respectively, whereas the Total Asset of the company during these periods stood at INR 1,160.94 Cr and INR 1,347.69 Cr. respectively. Find the asset to Sales of the company for FY18.

  • Total Asset of the company at the beginning (opening balance) INR 1,160.94 Cr
  • Total Asset of the company at the end (closing balance) of the year INR 1,347.69 Cr.
  • Total revenue (FY18) of the company stands at INR 982.19 Cr

Average Total Assets is Calculated using below formula

  • Average Total Assets = (Opening Assets + Closing Assets)/ 2
  • Average Total Asset of Nocil Ltd = INR (1160.94 +1347.69) /2
  • Average Total Asset of Nocil Ltd = INR 2508.63 Cr /2
  • Average Total Asset of Nocil Ltd = INR 1254.315 Cr

Asset to Sales Ratio is calculated using below formula

  • Asset to Sales Ratio =Total Revenue / Average Total Assets
  • Asset to Sales Ratio= INR 982.19 / 1254.315 Cr
  • Asset to Sales Ratio = 0.78. Or 78.3%

Thus to conclude the company generates 78 paisa for every INR investment into the company.

Asset to Sales Ratio Formula – Example #3

The Consolidated Income of Sunteck Realty Ltd for FY17 and FY18 is INR 960.36 Cr and INR 897.56 Cr respectively, whereas the Total Asset of the company during these periods stood at INR 3678.62 Cr and INR 3656.33 Cr. respectively. Find the asset to Sales of the company for FY18.

  • Total Asset of the company at the beginning (opening balance) INR 3678.62 Cr
  • Total Asset of the company at the end (closing balance) of the year INR 3656.33 Cr.
  • Total revenue (FY18) of the company stands at INR 897.56 Cr

Average Total Assets is Calculated using below formula

  • Average Total Assets = (Opening Assets + Closing Assets)/ 2
  • Average total asset of Sunteck Realty Ltd = INR (3678.62+3656.33) /2
  • Average total asset of Sunteck Realty Ltd = INR 7334.95 Cr /2
  • Average total asset of Sunteck Realty Ltd = INR 3667.475 Cr.

Asset to Sales Ratio is calculated using below formula

  • Asset to Sales Ratio = Total Revenue / Average Total Assets
  • Asset to Sales Ratio = INR 897.56 / 3667.475 Cr
  • Asset to Sales Ratio = 0.244 or 24.47%

Thus to conclude the company generates 24 paisa for every INR investment into the company.

Explanation

This Asset to Sales Ratio formula measures the efficiency of the particular company in terms the operating performance. The amount of Revenue generating from its existing assets is an Indicator of the health of the Business. Commonly it is used in case of peer analysis of different companies within the same sector. The higher the ratio, the better the operating efficiency of the management. Higher Revenue denotes better product acceptability and better competitive advantage of the business compared with its competitors. The Management of the business would get to know about the primary operating assets and they would probably concentrate on Restructuring by means of Asset Sales to improve the ratio and as well as lower Cost of borrowings(In case the Assets are purchased on behalf of Borrowed capital), several expenses like Depreciation, maintenance expense, servicing expense etc.

Significance and Use of Asset to Sales Ratio Formula

  • The day’s sales to Revenue shows how quickly the stock of a particular business is churning or in other words what is the demand of the product?
  • The Creditors, the Loan provider or the Financial Institution who are associated with the company would be able to know about the manufacturing status and the capacity utilization of the particular Business and get to know about the financial health of the Company.
  • The management would be able to forecast the current scenario, expected strategies and last but not the least they would be able to communicate with the third parties with the Sales Figure and the Capacity addition.
  • A company has to incur several expenses on its assets such as maintenance cost, depreciation, repayment costs etc. So if a company has a lower Asset to Sales ratio, and the ratio is dropping with every financial year, then the company has to restructure its operating Assets so as to narrow its costs and improve margin. Sell of unwanted assets would lower the denominator of the ratio and the Asset to Sales figure would look healthy.
  • Analysts pay utmost attention to this particular ratio before they recommend the stock for buying for the Investors. This is one of the primary criteria (based on the specific industry) to determine the competitiveness of a business. The diminishing Asset to Sales ratio indicates low business viability and low competence of the management.
  • Last but not least, head to head comparison would indicate the product earning capacity of different business, the cycle of the business and the economic scenario based on the

Asset to Sales Ratio Calculator

You can use the following Asset to Sales Ratio Calculator

Total Revenue
Average Total Assets
Assets to Sales Ratio Formula
 

Assets to Sales Ratio Formula =
Total Revenue =
Average Total Assets
0 = 0
0

Asset to Sales Ratio Formula in Excel (With Excel Template)

Here we will do the same example of the Asset to Sales Ratio formula in Excel. It is very easy and simple. You need to provide the two inputs i.e Total Revenue and Average Total Assets

You can easily calculate the Asset to Sales Ratio using Formula in the template provided.

First, we calculate Average Total Assets

Calculation of Average Total Assets

Then, we calculate Asset to Sales Ratio is calculated using formula

Calculation of Average Total Assets 1

Recommended Articles

This has been a guide to an Asset to Sales Ratio formula. Here we discuss its uses along with practical examples. We also provide you with Asset to Sales Ratio Calculator with downloadable excel template. You may also look at the following articles to learn more –

  1. Formula for Days in Inventory
  2. Calculate Debt to Income Ratio Using Formula
  3. Net Profit Margin Formula Template
  4. Examples of Net Interest Margin Formula
  5. Asset to Sales Ratio ( Examples and Excel Template)
  6. Price to Sales Ratio (Examples)
Popular Course in this category
Financial Analyst Masters Training Program
  250+ Online Courses |  1000+ Hours |  Verifiable Certificates |  Lifetime Access
4.9
Price

View Course

Related Courses

Investment Banking Training4.9
Investment Banking Training4.8
Financial Modeling Training4.7
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

ISO 10004:2018 & ISO 9001:2015 Certified

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

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

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*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 Asset to Sales Ratio Formula Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Asset to Sales Ratio Formula Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more