Category: General Business News

This metric, which is also referred to as the cash cycle or the net operating cycle, looks at the time a business takes to recover its investment in inventory to eventually sell. The process starts from selling its goods, collecting on outstanding receivables or invoices, and satisfying its operating costs with the sale proceeds. It’s normally measured in days to determine the company’s financial health.

The less time necessary to complete the CCC, the healthier a company is financially because it means the business’ money spends less time tied up in inventory or collecting on outstanding inventory. It’s important to be mindful that different industries have different CCC time frames. Generally speaking, most calculations are done on either a quarterly (90 day) or an annual basis (365 days).

How to Calculate CCC

The formula is as follows:

(CCC) = Days Inventory Outstanding (DIO) + Days Sales Outstanding (DSO) − Days Payable Outstanding (DPO)

It can be broken down into three different stages:

Stage 1

Days Inventory Outstanding (DIO) looks at how many days the inventory takes to sell to customers. It’s calculated as follows:

DIO = (Average Inventory (AI) / COGS) x Time-Frame (In Days)

AI = 1/2 x (BI + FI)

BI = Beginning Inventory

FI = Final Inventory

It’s important to define COGS, taken from the Income Statement, which is Cost of Goods Sold or the costs personally connected to creation of goods or services (raw materials, labor or electricity). The lower the number, the faster a business is selling its goods.

Stage 2

Days Sales Outstanding (DSO) measures the time it takes the business to collect payment from all outstanding sales completed.

DSO = Average Accounts Receivable (AAR) / Daily Revenue

AAR = 1/2 x (SAR + FAR)

SAR = Starting AR

FAR = Final AR

Accounts Receivable are what companies record on their balance sheet to keep track of what customers owe for the goods delivered or services rendered. The lower the results, the better the company’s cash position is because they’re able to satisfy outstanding invoices.

Stage 3

Days Payable Outstanding (DPO) is the third and final stage that calculates how much businesses owe to their suppliers the business has sourced input materials from, within the time frame the suppliers’ invoices are due.  

DPO = Average Accounts Payable (AAP) / Daily COGS

Where:

AAP = 0.5 x (SAP + FAP)

SAP = Starting AP

FAP = Final AP

COGS = Cost of Goods Sold

There are different ways to interpret the DPO result. A low DPO means the business is taking care of its bills from suppliers. However, potential investors, internal managers, and supervisors can see if the business can either negotiate lengthier payment terms while still maintaining good terms or if the company negotiates early payment terms or invests the money on a short-term basis to earn more for the company before paying suppliers’ bills. A high DPO, after an investigation of a company’s financials, might show the company is taking longer than its peers to pay creditors.

While calculating the CCC is relatively straightforward, the more complex process is interpreting it correctly and using judgment for a business based on industry averages and how the numbers relate to current economic conditions.

Analyzing a company’s Accounts Receivables is an effective way to measure its current cash flows and the likelihood of maintaining healthy cash flows. According to the U.S. Chamber of Commerce’s Small Business Index (Third Quarter 2024), 68 percent of small business owners reported being content with their third quarter cash flow performance. This illustrates the importance for small business owners to do everything possible to maintain healthy cash flows, including evaluating the quality of accounts receivables (A/R).

Defining Accounts Receivables

This account or line item on the balance sheet gives the business’ managers/owners and investors a measure on how much money a business expects to receive from selling goods or services. It’s an important metric because it’s a measure of what’s owed, but not yet collected from rendered services/goods.

Consideration for Uncollectable Accounts Receivables

While businesses hope to collect 100 percent of their A/Rs, businesses take a realistic view that not everyone will pay up. For whatever reason, A/Rs aren’t always collected and must be accounted for as uncollectable. Therefore, a contra account is setup to account for accounts receivables that turn into bad debt. This contra account is linked to the accounts receivable, an asset reported on the balance sheet, offsetting the accounts receivable balance. However, there are many metrics for companies to manage their health internally, and some of these metrics are discussed below.

Accounts Receivable-to-Sales Ratio

This is determined by taking a “snapshot” of the ratio or division of the accounts receivables divided by sales over a period of time. The resulting calculation is the percentage of a business’ unpaid sales. The higher the accounts receivable-to-sales ratio, the riskier the company’s financial health. It indicates a business has accounts receivables with a low likelihood of being collected. It’s calculated as follows:

AR to Sales = AR / Sales

Since it measures the mix of how much a business relies on cash versus credit, it can prompt an analyst to determine whether a company is able to operate on minimal cash with low fixed costs and limited outstanding debt. It can also prompt an analyst to determine if a company is subject to cyclical sales and is dependent on the business cycle and whether it’s the right time to invest in a company or hold off until a better entry point is established.

Accounts Receivable Turnover Ratio

This calculation determines how fast a business can convert its accounts receivables into cash. It calculates this over a discrete period, be it a month, quarter, year, etc. It’s calculated as the sales over a period divided by the average accounts receivables balance over the same period. It’s calculated as follows:

ARTR = Net Credit Sales / Average Accounts Receivable

Net Credit Sales = Sales on Credit – Sales Returns – Sales Allowances

Average Accounts Receivable = (Starting + Ending A/R Over a Fixed Time) / 2

The higher the ratio, the less friction businesses have in converting their accounts receivables into cash. One important consideration to keep in mind is that if total sales are used for this calculation, which some business do, the results don’t reflect the original formula because it doesn’t remove the sales on credit or sales allowances.

Days Sales Outstanding (DSO)

This metric reveals how fast (in average number of days) a company is able to turn its receivables into cash. It’s the average accounts receivables divided by net credit sales multiplied by 365. It’s calculated as follows:

DSO = (A/R / net credit sales) x 365 days

The lower the DSO, the better quality and the more efficient a company is in converting its accounts receivables into cash. The higher the DSO, and especially when it goes beyond 90 days, can represent two different financial measures. The first is that the business’ accounts receivables might not be collectable. The second is that the company might be able to make sales but with deteriorating earnings.

While there are many ways to analyze a company’s health, along with many ways to analyze the quality of existing and future accounts receivables, these are a few ways to evaluate a company’s present financial health and prospects for the future.

Sources

https://www.uschamber.com/sbindex/key-findings

Whether it’s a private equity transaction or an institutional or retail investor, analyzing a company’s financial statements is an important part of fundamental analysis. One important but basic way to analyze whether a company is worth investing in is through the expanded accounting equation. The most straightforward equation to analyze a business’s balance sheet is:

Assets = Liabilities + Shareholder’s Equity

However, there are more detailed equations that analysts can employ to more closely examine a company’s financial situation. One way to look at it is by more comprehensive equations that break down net income and the transactions related to the equity owners (dividends, etc.).

This equation is a building block of accounting because it focuses on double-entry accounting – or that each occurrence impacts the bifurcated accounting equation – requiring the correct solution to always be in balance. This system is used for journal entries, regardless of the type of transaction. Looking at this equation in greater detail, here’s a more granular example:

Assets = Retained Earnings + Liabilities + Share Capital

Assets are the capital that give a business the ability to benefit from projected, increased productivity and hopefully increased gains. Whether it’s short-term (less than 12 months) or long-term (more than 12 months), it can take the form of real estate, cash, cash-equivalents, pre-paid expenses, accounts receivable, etc.

Liabilities are the amounts owed to lenders due to past agreements. This is related to the sum of liabilities, which is the total of current (up to 12 months) liabilities, plus long-term (more than 12 months) debt and related obligations. This takes the form of loans, accounts payable, owed taxes, etc. Shareholder’s equity is how much the company owners may assert ownership on after accounting for all liabilities.

Another way this equation can be expressed is as follows:

Assets = Liabilities + Contributed Capital + Beginning Retained Earnings + Revenue + Expenses + Dividends

Depending on the financial outcome of the company, dividends and expenses may be negative numbers.

To further explain, these variations on the equation help analysts break down shareholder’s equity. Revenues and expenses illustrate the delta in net income over discrete accounting/earning periods from sales and costs, respectively. Stockholder transactions are able to be accounted for by looking at what capital the original stockholders provided to the business and dividends, or earnings distributed to the company’s stockholders. Retained earnings are carried over from a prior accounting period to the present accounting period. Despite being elementary, the information is helpful for business managers and investors to develop a higher level of analysis.

When it comes to evaluating bankruptcy, it can help investors determine the likelihood of receiving compensation. When it comes to liabilities, should debts be due sooner or over longer periods of time, these debts always have priority. When it comes to liquidated assets, these are then used to satisfy shareholders’ equity until funds are exhausted.  

While this is not a comprehensive look at how to analyze a company, it provides internal and external stakeholders with a way to build a strong financial analytical foundation.