EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Finance Finance Resources Finance Formula Activity Ratio Formula
 

Activity Ratio Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated July 21, 2023

Activity Ratio Formula

 

 

Activity Ratio Formula (Table of Contents)

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

  • Formula
  • Examples
  • Calculator

What is the Activity Ratio Formula?

The term “activity ratio” refers to the set of financial ratios that helps determine whether or not a company’s management can efficiently utilize the assets to generate operational cash. In other words, these ratios indicate how effectively the company’s management is converting its assets into cash.

The following four ratios are the primary activity ratios that are predominantly used in financial analysis:

  1. Accounts Receivable Turnover Ratio
  2. Merchandize Inventory Turnover Ratio
  3. Total Asset Turnover Ratio
  4. Net Fixed Asset Turnover Ratio

Example of Activity Ratio Formula (With Excel Template)

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

You can download this Activity Ratio Formula Excel Template here – Activity Ratio Formula Excel Template

Activity Ratio Formula – Example #1

Let us take Apple Inc.’s example to calculate the various activity ratios based on its annual report for the year 2019. During the year, the company booked revenue of $260,174 million against the cost of sales of $161,782 million. At the beginning of the year, the accounts receivable, total assets, net fixed assets, and inventories stood at $23,186 million, $365,725 million, $41,304 million, and $3,956 million. On the other hand, accounts receivable, total assets, net fixed assets, and inventories stood at $22,926 million, $338,516 million, $37,378 million, and $4,106 million, respectively, at the year’s end. Calculate the following activity ratios for Apple Inc:

Activity Ratio Formula - 1

Solution:

The formula to calculate Accounts Receivable Turnover Ratio is as below:

Accounts Receivable Turnover Ratio = 2 * Revenue / (Opening Accounts Receivable + Closing Accounts Receivable)

Activity Ratio Formula - 2

  • Accounts Receivable Turnover Ratio  = 2 * $260,174 million / ($23,186 million + $22,926 million)
  • Accounts Receivable Turnover Ratio = 11.28x

The formula to calculate Merchandize Inventory Turnover Ratio is as below:

Merchandize Inventory Turnover Ratio = 2 * Cost of Sales / (opening Inventories + Closing Inventories)

Activity Ratio Formula - 3

  • Merchandize Inventory Turnover Ratio = 2 * $161,782 million / ($3,956 million + $4,106 million)
  • Merchandize Inventory Turnover Ratio = 40.13x

The formula to calculate Total Asset Turnover Ratio is as below:

Total Asset Turnover Ratio = 2 * Revenue / (Opening Total Assets + Closing Total Assets)

Total Asset Turnover Ratio

  • Total Asset Turnover Ratio = 2 * $260,174 million / ($365,725 million + $338,516 million)
  • Total Asset Turnover Ratio = 0.74x

The formula to calculate Net Fixed Asset Turnover Ratio is as below:

Net Fixed Asset Turnover Ratio = 2 * Revenue / (Opening Net Fixed Assets + Closing Net Fixed Assets)

Net Fixed Asset Turnover Ratio

  • Net Fixed Asset Turnover Ratio = 2 * $260,174 million / ($41,304 million + $37,378 million)
  • Net Fixed Asset Turnover Ratio = 6.61x

Source Link: Apple Inc. Balance Sheet

Explanation

To calculate the Activity Ratio Formula, you can use the following points:

1. Accounts Receivable Turnover Ratio

This ratio is indicative of a company’s credit policies and, in the process, measures its ability to collect its accounts receivable that are created due to credit sales. Typically, a higher value means the company can collect its receivables quickly, indicating strong credit policies and vice versa. The ratio is also known as the debt turnover ratio. The formula for the accounts receivable turnover ratio is expressed as the revenue of the subject company divided by its average accounts receivable. Mathematically, it is represented as,

Accounts Receivable Turnover Ratio = Revenue / Average Accounts Receivable

2. Merchandise Inventory Turnover Ratio

This ratio shows how effectively a company can convert its stock and work-in-progress (WIP) inventory into cash. Typically, a higher value means the company can sell its inventory quickly to generate sales and vice versa. The ratio is also known as a stock turnover ratio. The merchandise inventory turnover ratio formula expresses the ratio as the division of the cost of sales by average inventories. Mathematically, one can represent it as

Merchandise Inventory Turnover Ratio = Cost of Sales / Average Inventories

3. Total Asset Turnover Ratio

This ratio indicates the ability of a company to generate sales by leveraging all the available long-term and short-term assets. Typically, a higher value means that the company can generate higher sales by leveraging its assets which is desirable. The total asset turnover ratio expresses revenue divided by the average value of total assets during the given period. Mathematically, one can represent it as

Total Asset Turnover Ratio = Revenue / Average Total Assets

4. Net Fixed Asset Turnover Ratio

This ratio shows the ability of a company to generate sales by utilizing its fixed assets in the form of plant, property, and machinery. A higher value indicates that the company utilizes its fixed assets very efficiently. The net fixed asset turnover ratio formula expresses revenue divided by the average net fixed assets for the period. Mathematically, one can represent it as

Net Fixed Asset Turnover Ratio = Revenue / Average Net Fixed Assets

Relevance and Use of Activity Ratio Formula

The formula of activity ratio is very useful as it shows how well a business can convert its available assets into cash or sales. As such, it is considered a good performance metric to check how efficiently a business runs. Accounting departments and management predominantly use these activity ratios to assess business efficiency.

Activity Ratio Formula Calculator

You can use the following Activity Ratio Formula Calculator

Revenue
Opening Accounts Receivable
Closing Accounts
Accounts Receivable Turnover Ratio
 

Accounts Receivable Turnover Ratio = 2 *Revenue /(Opening Accounts Receivable+Closing Accounts)
= 2 *0 /(0+0)= 0

Recommended Articles

This is a guide to the Activity Ratio Formula. Here we discuss how to calculate the Activity Ratio along with practical examples. We also provide an Activity Ratio calculator with a downloadable Excel template. You may also look at the following articles to learn more –

  1. Activity Ratio
  2. Accounting Ratios
  3. Turnover Ratios
  4. Average Collection Period Formula

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
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

EDUCBA

Download Activity Ratio Formula Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

डाउनलोड Activity Ratio Formula Excel Template

🚀 Limited Time Offer! - ENROLL NOW