Activity/Efficiency Ratios

TL;DR

Activity ratios show how well a company uses its assets to generate sales. They help you understand operational effectiveness by measuring how quickly assets convert into revenue or cash. You'll use these ratios to spot inefficiencies and assess management's asset utilization.

1. The Mental Model

Think of activity ratios as speedometers for a company's operations. They tell you how quickly a business is turning its resources (like inventory or accounts receivable) into sales or cash. A faster "speed" generally means more efficient operations.

2. The Core Material

Activity ratios, also known as efficiency ratios, measure how effectively a company is managing its assets to generate revenue. They're crucial for understanding operational performance and identifying areas where a company might be tying up too much capital or not converting assets fast enough.

Let's break down some common ones:

Inventory Turnover

Photo by Pixabay on Pexels

This ratio tells you how many times a company has sold and replaced its inventory during a period. A high inventory turnover generally suggests efficient inventory management and strong sales. A low turnover might indicate slow sales, overstocking, or obsolete inventory.

Formula:
Inventory Turnover = Cost of Goods Sold (COGS) / Average Inventory

You can also calculate the Days Sales in Inventory (DSI), which shows how many days, on average, it takes to sell off inventory.
Days Sales in Inventory = 365 / Inventory Turnover

Accounts Receivable Turnover

Photo by Leeloo The First on Pexels

This measures how quickly a company collects cash from its customers who bought on credit. A higher turnover means customers are paying their bills faster, which is good for cash flow. A low turnover could signal problems with credit policies or collections.

Formula:
Accounts Receivable Turnover = Net Credit Sales / Average Accounts Receivable

Similar to DSI, you can find the Days Sales Outstanding (DSO), which is the average number of days it takes to collect an account receivable.
Days Sales Outstanding = 365 / Accounts Receivable Turnover

Accounts Payable Turnover

Photo by Leeloo The First on Pexels

This ratio indicates how many times a company pays off its suppliers during a period. It reflects how well a company manages its payments to vendors. A higher turnover implies paying suppliers quickly, while a lower turnover suggests taking longer to pay, potentially conserving cash but also risking supplier relationships.

Formula:
Accounts Payable Turnover = Cost of Goods Sold (COGS) / Average Accounts Payable

And, the Days Payable Outstanding (DPO) tells you the average number of days it takes for a company to pay its creditors.
Days Payable Outstanding = 365 / Accounts Payable Turnover

Fixed Asset Turnover

Photo by RDNE Stock project on Pexels

This ratio assesses how efficiently a company uses its fixed assets (like property, plant, and equipment) to generate sales. A higher ratio indicates that the company is effectively utilizing its investments in fixed assets to produce revenue.

Formula:
Fixed Asset Turnover = Net Sales / Average Net Fixed Assets

Total Asset Turnover

This is a broader measure, indicating how efficiently all of a company's assets (current and fixed) are being used to generate sales. A higher ratio means the company is getting more sales for every dollar of assets it owns.

Formula:
Total Asset Turnover = Net Sales / Average Total Assets

Here's a diagram to visualize how these core ratios relate to different parts of the balance sheet and income statement:

graph TD
    A["Sales/Revenue (Income Statement)"] -->|Generates| B(Activity Ratios)
    C["Cost of Goods Sold (COGS) (Income Statement)"] -->|Input for| B

    subgraph "Balance Sheet Items (Average)"
        D["Inventory"] -->|Used by| InventoryTurnover
        E["Accounts Receivable"] -->|Used by| AccountsReceivableTurnover
        F["Accounts Payable"] -->|Used by| AccountsPayableTurnover
        G["Net Fixed Assets"] -->|Used by| FixedAssetTurnover
        H["Total Assets"] -->|Used by| TotalAssetTurnover
    end

    B --> InventoryTurnover["Inventory Turnover"]
    B --> AccountsReceivableTurnover["Accounts Receivable Turnover"]
    B --> AccountsPayableTurnover["Accounts Payable Turnover"]
    B --> FixedAssetTurnover["Fixed Asset Turnover"]
    B --> TotalAssetTurnover["Total Asset Turnover"]

    InventoryTurnover --> DSI["Days Sales in Inventory (DSI)"]
    AccountsReceivableTurnover --> DSO["Days Sales Outstanding (DSO)"]
    AccountsPayableTurnover --> DPO["Days Payable Outstanding (DPO)"]

3. Worked Example

Let's analyze a fictional company, "GadgetCo," using some data from their recent financial statements (all figures in thousands):

• Net Sales: $1,000
• Cost of Goods Sold (COGS): $600
• Average Inventory: $150
• Average Accounts Receivable: $100
• Average Accounts Payable: $80
• Average Net Fixed Assets: $300
• Average Total Assets: $750

Let's calculate some activity ratios:

1. Inventory Turnover:
   COGS / Average Inventory = $600 / $150 = 4 times
   This means GadgetCo sold and replaced its inventory 4 times during the year.
   DSI = 365 / 4 = 91.25 days (It takes about 91 days to sell off inventory).

2. Accounts Receivable Turnover:
   Net Sales / Average Accounts Receivable = $1,000 / $100 = 10 times
   GadgetCo collected its receivables 10 times during the year.
   DSO = 365 / 10 = 36.5 days (It takes about 37 days to collect from customers).

3. Accounts Payable Turnover:
   COGS / Average Accounts Payable = $600 / $80 = 7.5 times
   GadgetCo paid its suppliers 7.5 times during the year.
   DPO = 365 / 7.5 = 48.67 days (It takes about 49 days for GadgetCo to pay its suppliers).

4. Fixed Asset Turnover:
   Net Sales / Average Net Fixed Assets = $1,000 / $300 = 3.33 times
   For every dollar in fixed assets, GadgetCo generated $3.33 in sales.

5. Total Asset Turnover:
   Net Sales / Average Total Assets = $1,000 / $750 = 1.33 times
   For every dollar in total assets, GadgetCo generated $1.33 in sales.

By comparing these numbers to industry averages or GadgetCo's past performance, you could determine if they're efficient or if there are areas for improvement (e.g., if their DSO is much higher than the industry average, they might need to improve their collections process).

4. Key Takeaways

• Activity ratios measure how effectively a company uses its assets to generate sales and manage operations.
• Inventory Turnover shows how quickly inventory is sold; a higher number is usually better.
• Accounts Receivable Turnover indicates how fast customer payments are collected; quicker collections are good for cash flow.
• Accounts Payable Turnover reflects how often a company pays its suppliers, affecting cash management and supplier relations.
• Asset Turnover ratios (Fixed and Total) tell you how much sales revenue is generated per dollar of assets.
• Calculating "days" (DSI, DSO, DPO) converts turnover ratios into a more intuitive time frame.
• High turnover generally implies efficiency, but too high can signal issues like stockouts or aggressive credit terms.

Common Mistakes to Avoid:
- Not using averages: Always use average inventory, receivables, etc., when available, to smooth out seasonal fluctuations.
- Comparing apples to oranges: Don't compare a retail company's inventory turnover to a manufacturing company's; industries vary widely.
- Ignoring context: A single ratio isn't enough; analyze trends over time and against competitors.
- Focusing only on high numbers: While high turnover is often good, excessively high inventory turnover could mean insufficient stock and lost sales.

5. Now Try It

Find the latest annual financial statements (Balance Sheet and Income Statement) for a publicly traded company you're interested in (e.g., Apple, Coca-Cola, Starbucks). Calculate their Inventory Turnover, Accounts Receivable Turnover, and Total Asset Turnover for the most recent year.

What success looks like: You'll have three calculated ratios for your chosen company. Then, in a few sentences, you should be able to interpret what each ratio tells you about that company's operational efficiency. For example, "Company X's Inventory Turnover of 6 means they sold and replaced their inventory 6 times last year, which seems efficient for their industry."