EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 250+ Courses All in One Bundle
  • Login

Turnover Ratios

By Madhuri ThakurMadhuri Thakur

Home » Finance » Blog » Corporate Finance Basics » Turnover Ratios

TURNOVER RATIOS

What are Turnover Ratios?

The term “Turnover Ratios” refers to the set of financial ratios that indicate how efficiently a company is leveraging its assets and managing its liabilities. The formula (Receivables, Payables, and Inventory) is expressed as,

Receivables Turnover Ratio = Net Sales / Average Receivables
Payables Turnover Ratio = Cost of Goods Sold / Average Payables
Inventory Turnover Ratio = Cost of Goods Sold / Average Inventory

Types of Turnover Ratios

In this article we will discuss three of the major ratios:

Start Your Free Investment Banking Course

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

  1. Receivable Turnover Ratio (RTR) is an asset side turnover ratio that assesses the ability of a company to collect the receivables from the customers due to credit sales during a given period.
  2. Payables Turnover Ratio (PTR) is a liability side turnover ratio that determines how well a company can manage and extend the payments that are to be made to the suppliers during a given period.
  3. Inventory Turnover Ratio (PTR) is another asset side turnover ratio that indicates how effectively a company manages raw material, WIP and finished goods stock during a given period.

Examples

Let’s take an example to understand the calculation in a better manner.

You can download this Turnover Ratios Excel Template here – Turnover Ratios Excel Template

Example #1

Let us take the example of a company to illustrate the calculation of turnover ratios. According to the company’s annual report for the year 2019, it booked net sales of $250 million and incurred the cost of goods sold of $130 million. Further, average receivables, average payables and average inventory for the period were $85 million, $65 million and $80 million respectively. Based on the given information, calculate the following: Receivables, Payables, and Inventory Turnover Ratio.

example of a company

Solution:

RTR is calculated using the formula given below

Receivables Turnover Ratio = Net Sales / Average Receivables

Receivables

  • RTR = $250 million / $85 million = 2.94x

Payables Turnover Ratio is calculated using the formula given below

PTR = Cost of Goods Sold / Average Payables

Turnover Ratios - 1.3

  • PTR = $130 million / $65 million = 2.00x

Inventory Turnover Ratio is calculated using the formula given below

Inventory Turnover Ratio = Cost of Goods Sold / Average Inventory

Turnover Ratios - 1.4

  • ITR = $130 million / $80 million = 1.63x

Therefore, the company’s receivables, payables, and inventory ratio during 2019 were 2.94x, 2.00x and 1.63x respectively.

Popular Course in this category
Sale
Business Valuation Training (16 Courses)16 Online Courses | 80+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.5 (9,200 ratings)
Course Price

View Course

Related Courses
Equity Research Training (17 Courses)Project Finance Training (8 Courses with Case Studies)

Example #2

Let us now calculate the turnover ratios using the example of Walmart Inc. As per its income statement for 2018, it booked net sales of $495,761 million and incurred the cost of sales of $373,396 million. Further, its balance sheet shows that receivables, payables, and inventory at the start of 2018 were $5,835 million, $41,433 million and $43,046 million respectively and at the end of the year were $5,614 million, $46,092 million and $43,783 million respectively. Calculate Walmart Inc.’s Receivable, Payables and Inventory ratio for 2018.

example of Walmart Inc.

Solution:

Receivables Turnover Ratio is calculated using the formula given below

RTR = 2 * Net Sales / (Opening Receivables + Closing Receivables)

Turnover Ratios - 2.2

  • RTR = 2 * $495,761 million / ($5,835 million + $5,614 million) = 86.60x

Payables Turnover Ratio is calculated using the formula given below

PTR = 2 * Cost of Sales / (Opening Payables + Closing Payables)

Turnover Ratios - 2.3

  • PTR = 2 * $373,396 million / ($41,433 million + $46,092 million) = 8.53x

Inventory Turnover Ratio is calculated using the formula given below

ITR = 2 * Cost of Sales / (Opening Inventory + Closing Inventory)

Turnover Ratios - 2.4

  • ITR = 2 * $373,396 million / ($43,046 million + $43,783 million) = 8.60x

Therefore, Walmart Inc.’s receivable, payables and inventory turnover ratio during 2018 were 86.60x, 8.53x and 8.60x respectively.

Source Link: Walmart Inc. Balance Sheet

Explanation of Turnover Ratios

The formula can be calculated by using the following points:

Step 1: Firstly, determine the net sales registered by the company during the given period.

Step 2: Next, determine the average receivables during the period based on the receivables at the start (opening) and at the end (closing) of the period.

Average Receivables = (Opening Receivables + Closing Receivables) / 2

Step 3: Finally, the formula for the receivables can be expressed as net sales (step 1) divided by average receivables (step 2) as shown below.

RTR = Net Sales / Average Receivables

The formula for payables can be derived by using the following steps:

Step 4: Firstly, determine the cost of goods sold or cost of sales incurred by the company during the given period, which is the aggregate of all directly assignable costs of production.

Step 5: Next, determine the average payables during the period based on the payables at the start (opening) and at the end (closing) of the period.

Average Payables = (Opening Payables + Closing Payables) / 2

Step 6: Finally, the formula for the payables can be expressed as the cost of goods sold (step 4) divided by average payables (step 5) as shown below.

PTR = Cost of Goods Sold / Average Payables

The formula for inventory can be derived by using the following steps:

Step 7: Same as step 4.

Step 8: Next, determine the average inventory during the period based on the inventory held at the start (opening) and at the end (closing) of the period.

Average Inventory = (Opening Inventory + Closing Inventory) / 2

Step 9: Finally, the formula for inventory turnover ratio can be expressed as the cost of goods sold divided by average inventory.

Importance

These ratios basically indicate the working capital requirement of a business. Typically, a higher value of receivable and inventory coupled indicates that receivables are collected quickly and inventory is well utilized resulting in the lower amount of working capital is engaged in the business, while a lower value of payables means that the company is able to stretch the supplier payment which again reduces working capital requirement.

Conclusion

So, it can be easily said that the turnover ratios are very important for a company as it indicates its short-term liquidity position and working capital cycle during a given period.

Recommended Articles

This is a guide to the Turnover Ratios. Here we discuss how to calculate along with practical examples. We also provide a downloadable excel template. You may also look at the following articles to learn more –

  1. What is Efficiency Ratio?
  2. Example of Percentage Change Formula
  3. Calculation of Gross Margin Formula
  4. How to Calculate Elasticity?

All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)

250+ Online Courses

40+ Projects

1000+ Hours

Verifiable Certificates

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary Sidebar
Finance Blog
  • Corporate Finance Basics
    • BPO vs KPO
    • C Corporation
    • Brick and Mortar
    • Business Entity Concept
    • Bounced Check
    • Capital Maintenance
    • Bridge Financing
    • Business Exit Strategy
    • Callable Bonds
    • Affiliated Companies
    • Certified Check
    • Chattel Mortgage
    • Contingent Beneficiary
    • Debt Collector
    • Closed Corporation
    • Cumulative Voting
    • Consumer Loan
    • Commercial Loans
    • Collateralization
    • Commercial Credit
    • Collection Agency
    • Classification of Financial Markets
    • Class Action Lawsuits
    • Prudence Concept in Accounting
    • Calmar Ratio
    • Asset Classes
    • Audit Evidence
    • Contingent Liability
    • Employee Stock
    • Financial Liabilities
    • Incurred Cost
    • Partial Income Statement
    • Deferred Tax Asset
    • Tax Fraud
    • Non-Operating Income
    • Variable Costing
    • Mixed Cost
    • Prime Cost
    • Regressive Tax Examples
    • Unqualified Opinion of Auditor
    • Bonds Payable
    • Class A Shares
    • Contingent Liability Example
    • Contingent Shares
    • Contributed Capital
    • Brownfield Investment
    • Internal Audit
    • Indirect Taxes
    • Fund Management
    • Fixed Cost
    • Debt Equity Swap
    • Cash Flow Hedge
    • Risk Shifting
    • High Yield Investments
    • General Obligation Bond
    • Forward Market
    • Box Spread
    • Fixed Income Trader
    • Trade Discount
    • Quick Assets
    • Notes Payable
    • Revenue Bonds
    • Euribor
    • Settlement Date
    • Short Covering
    • Short Selling
    • Dividend Examples
    • Time to Market
    • Junior Accountant
    • Commodity Derivatives
    • Flash Report
    • Idle Time
    • Leasehold Improvement
    • Product Portfolio
    • Risk Parity
    • Branch Accounting
    • Credit Enhancement
    • Basis Trading
    • At the Money
    • Collateralized Mortage Obligation
    • Accounts Receivable
    • Long Term Investments
    • Negative Goodwill
    • Recourse Factoring
    • Residual Value
    • Short Term Loan
    • Tax Exempt
    • Audit Report Format
    • Cash Investment
    • 457 Plan
    • Audit Procedure
    • Audit Materiality
    • Audit Committee
    • Asset Allocation
    • Non-Cash Expenses
    • Dividend Policy Types
    • Credit Terms
    • Dividend Payable
    • Profit Center
    • Absorption Costing
    • Final Dividend
    • Hybrid Securities
    • Other Current Assets
    • Simple Random Sample
    • Dependency Ratio
    • Effective Duration
    • Loan to Value Ratio
    • Inventory Turnover Ratio
    • Advantages of Ratio Analysis
    • Loss Ratio
    • Delaware Corporation
    • Debt to GDP Ratio
    • Articles of Incorporation
    • Negative Covenants
    • Statutory Liquidity Ratio
    • Leverage Ratio for Banks
    • Accrued Liabilities
    • Activity Ratio
    • Debt Service Coverage Ratio
    • Return on Investment Ratio
    • Turnover Ratios
    • Cash Conversion Cycle
    • Lumion vs V-Ray
    • Capital Intensive
    • Voided Check
    • Negotiable Instruments
    • Portfolio Optimization
    • 401k Plan
    • Non-Marketable Securities
    • Stock Certificate
    • Treasury Stock
    • Appropriate Retained Earnings
    • Stockholder
    • Share Vesting
    • Shares Issued
    • Preferred Shares
    • Share Buyback
    • Shareholder Types
    • Tax Loss Harvesting
    • Statutory Audit
    • Audit Risk
    • Fund of Funds
    • Accredited Investor
    • Cost Centre
    • Lessee
    • Golden Handcuffs
    • Ordinary Shares
    • Restricted Stock Units
    • Goodwill Valuation
    • Share Classes
    • Lessor
    • Preferred Dividends
    • LIFO Liquidation
    • Dilutive Securities
    • Restructuring Cost
    • Non-Cumulative Preference Shares
    • Pass Through Entity
    • Management Discussion and Analysis
    • Premium on Stock
    • Leveraged Loans
    • Dividend
    • Dividend Policy
    • Financial Reporting Objectives
    • Financial Reporting
    • Internal Controls
    • Capital Investment
    • Debt to Equity Ratio
    • Dividend Growth Rate
    • Market Capitalization
    • Deal Origination
    • Importance of Working Capital
    • SWOT Analysis
    • White Knight
    • Root Cause Analysis
    • Realized Gain
    • Return on Operating Assets
    • Offshore Investments
    • Transfer Price
    • Times Interest Earned Ratio
    • Debt Coverage Ratio
    • Dividend Discount Model
    • Combined Ratio
    • Merger Arbitrage
    • Gordon Growth Model
    • Advantages of Joint Venture
    • Interest Coverage Ratio
    • Reserve Requirements
    • Asset Turnover Ratio
    • Price to Rent Ratio
    • Ratio Analysis Types
    • Debt Ratio
    • Business Risk
    • Financial Leverage
    • Dividend Payout Ratio
    • Mistakes in DCF
    • Risk/Reward Ratio
    • Full Form of FIPB
    • Financial Risk
    • CAPE Ratio
    • Overcapitalization
    • Systematic Risk
    • Hedge Ratio
    • Full Form of NHB
    • Sensitivity Analysis
    • Current Ratio
    • Corporation Examples
    • Asset to Sales Ratio
    • Balance Sheet Ratios
    • List of Financial Ratios
    • Coverage Ratio
    • Forward PE Ratio
    • Interpretation of Debt to Equity Ratio
    • Capitalization Ratio
    • Importance of Ratio Analysis
    • Quick Ratio Interpretation
    • Corporate Finance Basics
    • PEG Ratio
    • Corporate Finance Interview Questions
    • Price to Earnings Ratio
    • Structured Note
    • Limitations of Ratio Analysis
    • NPV vs IRR
    • IRR vs ROI
    • Imputed Interest
    • Full Form of HR
    • Shareholders Agreement
    • Earnings Per Share
    • Corporate Finance Jobs
    • About Corporate Finance
    • Corporate Finance Theory & Practices
    • Career in Corporate Finance
    • Simple Interest Rate vs Compound Interest Rate
    • Stocks vs Shares
    • Bonds vs Debenture
    • Bull Market vs Bear Market
    • Mortgagee vs Mortgagor
    • Horizontal Integration vs Vertical Integration
    • Money Market vs Capital Market
    • Leveraged vs Unleveraged
    • Dividends vs Capital Gains
    • Present Value vs Net Present Value
    • Qualified vs Ordinary Dividends
    • ROE vs ROA
    • Bond vs Loan
    • Stock Dividend vs Stock Split
    • Audit vs Assurance
    • Coupon Rate vs Interest Rate
    • Growth Stock vs Value Stock
  • Accounting fundamentals (614+)
  • Asset Management Tutorial (181+)
  • Banking (43+)
  • Credit Research Fundamentals (6+)
  • Economics (44+)
  • Finance Formula (382+)
  • Financial Modeling in Excel (13+)
  • Investment Banking Basics (114+)
  • Investment Banking Careers (26+)
  • Trading for dummies (67+)
  • valuation basics (27+)
Finance Blog Courses
  • Online Business Valuation Training
  • Equity Research Certification
  • Project Finance Course
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

© 2022 - 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

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

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

EDUCBA
Free Investment Banking Course

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

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

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

Let’s Get Started

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA Login

Forgot Password?

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

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

EDUCBA

Download Turnover Ratios Excel Template

EDUCBA

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

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

Special Offer - Online Business Valuation Training Learn More