No matter the type of business or industry, being able to analyze and deduce patterns is essential to discovering a business’ financial health. Here are four commonly used calculations to help internal and external stakeholders determine an organization’s ability to manage its finances.

Break-Even Analysis

This formula analyzes fixed costs versus the profitability a business earns for every extra item it creates and sells.

Businesses that have smaller thresholds to meet their fixed costs to realize profitability have an easier break-even point to meet and exceed. Once the fixed costs threshold is satisfied and sales revenue outpaces variable costs, a business will know when it hits the break-even point.

Break Even Point (BEP) = Total Fixed Costs/(Price Per Unit – Variable Cost Per Unit)

This takes the total fixed costs divided by the price per individual unit minus each unit’s variable cost.

Examples of fixed costs are rent, taxes, insurance and wages. Examples of variable costs are raw materials, production supplies, utilities and packaging.

Another way to determine a company’s break-even point is as follows:

Contribution Margin = Item Price – Variable Cost Per Unit

This is illustrated by: $55 = ($85 – $30)

The item’s priced at $85, with a variable cost of $30, the contribution margin is $55 of how much revenue a company earns to pay for the remaining fixed costs.

Cash Ratio Formula

The cash ratio formula offers one way to look at a company’s liquidity position by comparing a company’s cash and cash equivalents to its current liabilities or debts due within the next 12 months. It shows how well positioned a business is (or is not) able to pay debts due within 12 months, and to satisfy the near-term obligations of its long-term debt.

It’s an important ratio that lenders look at when evaluating a company’s loan application. Instead of including assets such as accounts receivables, it factors in a business’ ability to take care of its financial obligations. It’s thought of as being a more real world look at how financially stable a business is.

It’s calculated as follows: Cash Ratio: Cash + Cash Equivalents/Current Liabilities.

Gross Profit Margin

This is defined as all income minus the cost of goods sold (COGS). COGS is comprised of expenses attributable to the creation of products, which include input materials and salaries for workers to produce such goods. However, it excludes expenses for taxes, overhead, debt, asset acquisitions, etc., among others. Another way to explain this calculation is to ask how much a business retains as profit once production costs are accounted for.

It’s calculated as follows: Gross Profit Margin = [(Net Sales – Cost of Goods Sold)/(New Sales)] x 100

Debt-to-Equity (D/E) Ratio

This is used to determine how much debt or financial leverage a company has on its books. It tells internal stakeholders and external parties what percentage of debt a company is using to operate compared to the business’ available operating reserves. This ratio contrasts a business’ complete financial obligations against its shareholder equity. Its primary use is to see how extensively it uses debt to operate.

It’s calculated as follows: Debt/Equity Ratio = Total Liabilities/Total Shareholders’ Equity.

While these calculations may seem straightforward, these are only a few examples of how businesses can calculate and analyze a company’s position – be it the owner, an employee or an outside lender or investor.

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