r/IndiaInvestments
RedditDiscordGitHubDisclaimers
  • Introduction
  • Disclaimers and Disclosures
  • FAQs
    • FAQs
    • Mutual Funds and ETFs
      • What is the best mutual fund app for investments?
      • Why should I invest in Direct Plans instead of Regular Plans?
      • What’s the best mutual fund I can invest in?
      • Which date(s) is/are best for SIP in a month?
      • I’ve to invest in ELSS for 80C tax saving. Which fund(s) should I pick?
      • Should I get a Demat Account to buy units in Mutual Funds?
      • Lumpsum investment vs SIP/DCA
      • Why are Index Funds in India not as cheap as Vanguard's Index Funds and ETFs?
    • Insurance
      • Should I invest in this LIC policy?
      • Opinions on investing in smart wealth plan by bank?
      • Up to what age should I take term cover?
      • Do I need my own health insurance? Employer already has group policy
      • Should I take top-up policy or super top-up?
      • Is it worth paying extra premium for term insurance?
    • Stocks
      • Should I invest in smallcase?
      • What is the best app for buying or trading stocks?
      • Which screener(s) should I use?
      • The Stock Market Has Crashed. Which Stocks Should I Buy?
    • Foreign Investing
      • Why should I invest in the US markets?
      • How should I invest in US equity?
    • Tax
      • I don't have any tax to pay. Do I still have to file ITR?
    • Miscellaneous
      • Where can I park money for a few days, a few months, or a few years?
      • What are chit funds? Should I invest?
      • Is Gold a good investment now? It has gone up ~50% this year
  • How To
    • How To
    • How to transfer shares from one demat account to another
    • How to move from one mutual fund platform to another
    • How to switch a Mutual Fund from Regular to Direct Plan
    • How to file SEBI SCORES complaint?
    • How to Update Nominee Details?
    • How to rematerialize mutual fund from demat form
    • How to Pay Advance Tax
  • STOCKS
    • Introduction to the Stocks Series
    • Can You Beat the Market?
    • Reading an Annual Report
    • Researching a Sector
    • Financial Metrics and Ratios
      • Profitability
    • Using Screeners
    • Due-Diligence Checklist
    • Work in Progress
      • Diving Deeper into Businesses
      • Efficiency
      • Liquidity and Solvency
  • EXCEL
    • Excel for Fun and Profit
    • Reactive UI & Updates
    • Using External Data : Google Finance
    • Using External Data : Working with CSV Format
      • CSV Format
      • Computing LTCG Eligible Equity Units
      • Process for Estimating Tax
    • Quantifying Returns: CAGR and XIRR
      • CAGR: Point-to-Point Annualized Returns
      • A Gentle Introduction to XIRR
      • A Rigorous Introduction to XIRR
  • BONDS
    • Bond Basics
    • Government Securities
    • Corporate Bonds
  • MISCELLANEOUS
    • Miscellaneous
    • US Investing
    • Recommended Reading
  • New to Investing
    • Zero to Investing
      • Getting Started
      • Part Two - Defensive Setup
      • Part Three - Spending Pattern
      • Part Four - How to Invest
    • Investment Philosophy and Strategy
      • Basics of Investment Strategy Plan
      • A simple Financial Planning Roadmap
      • Various types of Risks in Investments
      • Are you a Stock or Bond?
      • Assets and Asset Allocation
      • Critical Mass
      • Asset Rebalancing
      • Lumpsum or SIP/STP
    • Insurance
      • Life
        • Life Insurance: What it is exactly?
        • How to Evaluate Life Insurance Needs
        • ULIP - Unit Linked Insurance Plan
        • Some FAQs on Life Insurance
        • Links to Answers related to Life Insurance
      • Health
      • Others: Disability / Home
      • Child Plan
    • All About Mutual Funds
      • What is a Mutual Fund?
      • Types of Mutual Funds
      • What and Why of Mutual Fund Ratings
      • How to Select a Mutual Fund
      • FAQs for Mutual Funds
      • SIP and Mandates
      • How to Become Crorepati using Mutual Funds
      • Analysis using long term equity and debt funds in India
    • Retirement
      • Primer on Retirement Planning
      • Why You should not Opt for a Readymade Pension Plan
      • Studies of Long Term Portfolios and Retirement Withdrawal Rate Suggestions
      • Do-It-Yourself Retirement Plan
    • Personal Finance
    • Behavioral Biases
    • ELI5 Series
      • Time Value of Money
      • Inflation
      • Life Insurance
      • ELI5 guide to Selecting an Equity Mutual Fund
      • How do I start investing in mutual funds [ELI5 series]
      • Mis-selling of Insurance Products
  • BEGINNER'S GUIDE TO INVESTING
    • Zero To Investing
      • The First Step - Emergency Fund
      • The Final Step - Mutual Funds
  • Contributors Section
    • How Can I Start Contributing?
    • What is a Contributor License Agreement and why are we using it?
      • Contributor License Agreement
    • How to link FAQ via bot in Discord
    • Style Guides
      • General Style Guide
      • FAQ Style Guide
      • How To Style Guide
      • Excel Series Style Guide
      • Stocks Style Guide
  • Discord and Reddit
    • How to Search the Wiki From Discord
    • I'm unable to send messages to stocks-fundamentals channel on Discord. Why?
Powered by GitBook
On this page
  • Asset Turnover Ratios
  • Inventory Turnover and Days Sales of Inventory
  • Receivables Turnover and Days Sales Outstanding
  • Payables Turnover and Days Payable Outstanding
  • Cash Conversion Cycle
  • Working Capital

Was this helpful?

Export as PDF
  1. STOCKS
  2. Work in Progress

Efficiency

Efficiency Ratios, also known as Activity Ratios, help investors evaluate the efficiency with which a business is able to use its assets to generate revenue.

PreviousDiving Deeper into BusinessesNextLiquidity and Solvency

Last updated 3 years ago

Was this helpful?

Asset Turnover Ratios

One of the most basic operational aspects of a business is generating sales using its assets. We can measure the efficiency of this operational aspect using the asset turnover ratio which can be defined as

Asset Turnover Ratio = Total Income / Average Assets

We’ll consider the average of the total assets during a financial year to account for potentially abrupt changes in total assets due to unusual events like sales of fixed assets, increase in goodwill etc.

Asset Turnover Ratio is one of the components in the DuPont Identity we used to calculate the Return on Equity in the .

As we’ve mentioned before, it wouldn’t make sense to compare ratios between companies in different sectors. FMCG companies usually enjoy high asset turnover while asset heavy companies and financial institutions don’t.

The total income of Hindustan Unilever Ltd for the year 2019 is ₹39,860 crores and the average total assets are (₹18,629 + ₹17,862)/2 = ₹18,245.5 crores. The asset turnover ratio of Hindustan Unilever for the year 2019 is ₹39,860 / ₹18,245 = 2.18. In contrast, the asset turnover ratio of Nestle India for the year 2019 is 1.66. If we observe the past 5 year trend, Hindustan Unilever has had an asset turnover ratio of greater than 2 while Nestle India has had an asset turnover ratio of greater than 1 but less than 2. Using this information, we can infer that Hindustan Unilever is possibly more efficient at generating revenue from its assets than Nestle India.

The asset turnover ratio of a company can get skewed due to a number of unusual events such as asset sales, issue of additional shares, investment into assets for long term growth, deliberately increasing inventory to meet demand etc. It’s best if we look at a trend of how asset turnover ratio has been in the past 5 years before jumping to conclusions. Let’s consider the financial statements of Avenue Supermarts for the year 2020.

The asset turnover ratio of Avenue Supermarts for the year 2019 is 3.16. However, due to issue of additional shares and the investment of the capital gained into non-current financial assets, the asset turnover ratio drops to 2.61 in the financial year 2020.

Although we’ve seen what asset turnover ratio is, we can go ahead and refine it further to get a more useful metric. Instead of considering total assets, we’ll now consider only the non-current, or fixed, assets of a company to calculate the Fixed Asset Turnover Ratio. Why not consider the current assets? Well, most companies and sectors where asset turnover ratios are relevant often invest in long term assets to generate sales. We’ll focus on current assets in the working capital and cash conversion cycle.

We can define fixed asset turnover ratio as

Fixed Asset Turnover Ratio = Total Income / Average Non Current Assets

The fixed asset turnover ratio of Hindustan Unilever Ltd for the year 2019 is ₹39,860 / ((₹6,715 + ₹6,202) / 2) = 6.17 while that of Nestle India for the year 2019 is 3.82.

Inventory Turnover and Days Sales of Inventory

The efficient management of inventory is one of the key operational aspects of a business, especially in cases where making forecasts about inventory is essential to prepare a business for seasonal effects. The sales projections of a business depend upon how efficiently inventory is managed.

One of the metrics that can help businesses make better decisions about pricing, manufacturing, and purchasing inventory is the inventory turnover ratio. This ratio tells us how quickly a business can replace its inventory by turning it into sales. It’s a measure of how many times a business can sell its entire inventory in a specific time period.

We can define the inventory turnover ratio as

Inventory Turnover Ratio = Cost of Goods Sold / Average Inventory

Although we could’ve used Net Sales in the numerator instead of COGS, it would’ve ended up artificially inflating the inventory turnover ratio. After all, the costs associated with the inventory in the balance sheet does not include the potential markup in prices due to profits earned.

Generally, high inventory turnover ratios indicate that a company is able to sell its inventory quickly and generate sales, which is reflected due to changes the numerator, but it can also indicate that a company is running low on inventory which might be needed to fulfill obligations and generate sales. In any case, inventory turnover ratio is extremely useful in sectors like FMCG, supermarkets, automobile etc.

Let’s compare the inventory turnover of two supermarket businesses — Avenue Supermarts and V-Mart Retail.

The COGS of Avenue Supermarts for the year 2020 is ₹21,441.68 - ₹338.75 = ₹21,102.93 crores and its average inventory is (₹1,947.40 + ₹1,608.65) / 2 = ₹1,778.02 crores. This gives us an inventory turnover ratio of ₹21,102.93 / ₹1,778.02 = 11.8.

The COGS of V-Mart Retail for the year 2020 is ₹1,275.20 - ₹148.93 + ₹11.47 = ₹1,137.74 crores and its average inventory is (₹477.92 + ₹328.98) / 2 = ₹403.45 crores. This gives us an inventory turnover ratio of ₹1,137.74 / ₹403.45 = 2.82.

Although both Avenue Supermarts and V-Mart Retail are supermarket businesses, their revenue sources are different. V-Mart Retail derives about 80% of its revenue from apparels while Avenue Supermarts gets less than 27% from apparel. How about we compare Avenue Supermarts’ inventory turnover ratio with Reliance Retail?

The COGS of Reliance Retail for the year 2020 is ₹2.99 + ₹1,22,745.81 + ₹1,941.48 + ₹135.62 = ₹1,24,825.9 crores and its average inventory is (₹9,583.11 + ₹11,493.53) / 2 = ₹10,538.32 crores. This gives us an inventory turnover ratio of ₹1,24,825.9 / ₹10,538.32 = 11.8.

Now that we know how to calculate the inventory turnover ratio, we can calculate the average time in days that it takes to turn inventory into sales. This metric is known as Days Sales of Inventory (DSI). It is also known as Days Inventory Outstanding (DIO). DSI can be calculated using the following formula

Days Sales of Inventory = 365 / Inventory Turnover Ratio

For Avenue Supermarts, the DSI turns out to be 365 / 11.8 = 30 days. For V-Mart Retail, DSI is 365 / 2.8 = 129 days.

Generally speaking, lower the DSI, the more efficient a company is in translating inventory to sales. However, this may not always be the case. Sometimes, companies need to pile up inventory due to seasonal effects or to take advantage of product shortage and sell the inventory at a higher price later.

Receivables Turnover and Days Sales Outstanding

Payables Turnover and Days Payable Outstanding

Cash Conversion Cycle

Working Capital

We’ve already defined when we discussed gross profit in profitability ratios. The average inventory is simply the average of the inventory at the start and at the end of a financial year.

COGS
Profitability section
The Profit and Loss Statement of Hindustan Unilever for the financial year 2019
Part 1 of the Balance Sheet of Hindustan Unilever for the financial year 2019
Part 1 of the Balance Sheet of Avenue Supermarts for the financial year 2020
Current Assets of Avenue Supermarts for the financial year 2020
Expenses of Avenue Supermarts for the financial year 2020
Current Assets of V-Mart Retail for the financial year 2020
Expenses of V-Mart Retail for the financial year 2020
Current Assets of Reliance Retail for the financial year 2020
Expenses of Reliance Retail for the financial year 2020