Ratio analysis provides investors and operators with a consistent framework for organizing and benchmarking numbers from a financial statement. By converting the raw financials into ratios, we can more easily spot relationships and trends across stocks.
In this post, I discuss the 15 credit & balance sheet ratios that allows investors to quickly gauge a company’s credit health and management’s operation of capital efficiency.
Credit ratios vary greatly by sector. I provide a table for each ratio listing the median of firms in the finbox.io database by sector so that you can benchmark your subject firm appropriately. The sector medians listed are as of November 8th, 2017. You may also find my posts on Valuation Ratios, Profit & Return Ratios, and Cash Flow Ratios helpful.
Interested in example calculations of the ratios discussed? I’ve created a spreadsheet template you can use to calculate these 15 credit ratios. The spreadsheet contains three tabs:
- Cheat Sheet: This tab lists Credit & Balance Sheet ratios and formulas used to calculate each ratio.
- [Example] Calculator: You can use this tab calculate all the ratios discussed for any business by manually entering the financials required in designated cells colored in yellow under the "Required Data" section.
- [Linked] Calculator: This tab has formulas that are powered by finbox.io's Spreadsheet add-on so you can use it to automatically fetch data for supported public companies by simply changing the ticker symbol in the designated cell.
You can make a copy of the Google Spreadsheet by clicking File > Make a copy in the menu or using the link below:
The Top 15 Credit & Balance Sheet Ratios
The EBIT Interest Coverage ratio is one of three popular "interest coverage ratios" used to assess a firm's ability to pay interest expenses based on operating profits. As the name suggests, the EBIT Interest Coverage ratio uses earnings before interest and taxes (EBIT) in the numerator.
EBIT Interest Coverage = EBIT ÷ Interest Expense
|Sector||EBIT Interest Coverage|
The primary difference between the EBIT Interest Coverage ratio and the EBITDA Interest Coverage ratio is the exclusion of Depreciation and Amortization (D&A) expenses from the numerator in the latter. EBITDA Interest Coverage ratio uses earnings before interest, taxes, depreciation, and amortization (EBITDA) since depreciation and amortization represent a non-cash charge and therefore do not impact the amount of cash available to pay interest expenses.
EBITDA Interest Coverage = EBITDA ÷ Interest Expense
|Sector||EBITDA Interest Coverage|
While is true that depreciation and amortization don't directly impact the cash available, a firm must eventually replace depreciable assets in order to continue operating. A variant of the EBIT Interest Coverage ratio that accounts for these requirements is the EBITDA - CapEx Interest Coverage ratio. EBITDA - CapEx is preferred over EBIT Interest Coverage when a firm is growing and needs capital expenditures to support this growth since historical D&A will underestimate its cash needs in that scenario.
EBITDA - CapEx Interest Coverage = (EBITDA - CapEx) ÷ Interest Expense
|Sector||EBITDA less CapEx Coverage|
Capital structure is the mix of debt and equity used to finance operations and is the primary driver of credit risk. The Debt to Equity ratio is the most common ratio used to represent capital structure. Typically, a higher Debt to Equity ratio indicates higher credit risk. This is not always the case - utility companies, real estate investment trusts and commercial banks often operate with high leverage since they commonly have cash flows that are predictable and stable.
Debt to Equity = Total Debt ÷ Common Equity
|Sector||Debt / Equity|
Debt to Tangible Equity is a variant of the Debt to Equity ratio. Instead of common equity, tangible common equity (TCE) is used in the denominator. Tangible common equity is calculated by subtracting the value of goodwill and intangible assets from common equity. The Debt to Tangible Equity gained popularity during the 2008–2009 economic crisis since it is a stricter measure of balance sheet health for common shareholders.
Debt to Tangible Equity = Total Debt ÷ (Common Equity - Intangible Assets)
|Sector||Debt / Tangible Equity|
Debt To Total Capital measures the level of the debt relative to the market value of total capital. When the market value of equity is far above the amount listed on the Balance Sheet, the Debt to Total Capital ratio provides a more accurate representation of risk and leverage. The lower the Debt to Total Capital percentage, the higher the equity cushion provided to lenders and the lower the charged interest rate.
Debt To Total Capital = Total Debt ÷ (Total Debt + Market Capitalization)
|Sector||Debt / Total Capital|
Cash Flow to Total Debt is used in two different useful ways - a) to measure cash flow coverage and b) to find the ratio's inverse in order to estimate the length of time needed to pay off debts if all available dollars are allocated to repayment. Here at finbox.io, we use Cash Flow from Operations reported in the Statement of Cash Flows to calculate Cash Flow to Total Debt. Some analysts nevertheless prefer to compute this ratio using EBITDA in the numerator.
Cash Flow to Total Debt = Cash Flow from Operations ÷ Total Debt
|Sector||Cash Flow / Total Debt|
The Liabilities to Assets ratio (also referred to as Debt Ratio) measures the proportion of a firm's assets financed by liabilities. This ratio is similar to Debt / Equity as it measures leverage in the capital structure. A ratio greater than 0.5 indicates that the firm primarily uses credit and payables to finance assets.
Liabilities to Assets = Total Liabilities ÷ Total Assets
|Sector||Liabilites / Assets|
9. Cash Ratio
The Cash Ratio is a strict ratio used to assess a company's short-term liquidity. This ratio is considered "strict" because it only uses cash and short-term investments as sources of liquidity to service liabilities.
Cash Ratio = (Cash & ST Investments) ÷ Current Liabilities
10. Quick Ratio
The Quick Ratio is used to assess a company's short-term liquidity. This ratio is more relaxed than the Cash Ratio, but still only considers cash, short-term investments like marketable securities, and receivables which can all be "quickly" converted into cash at their book values as sources of liquidity.
Quick Ratio = (Cash & ST Investments + Receivables) ÷ Current Liabilities
11. Current Ratio
The Current Ratio is also used to assess a company's short-term liquidity. Unlike the Quick Ratio, this ratio considers all current assets as sources of liquidity. Current assets represent the assets a firm expects to convert to cash over the next 12 months. Current liabilities represent the obligations a firm must pay with cash over the next 12 months. In the event of distress, some of the current assets may not be available to be converted into cash at their carrying values. For example, if there is little demand for a firm's inventory, the carrying value may be overstated. Likewise, current assets like prepaid insurance, prepaid legal expenses, and office supplies can be difficult to convert into cash.
Current Ratio = Current Assets ÷ Current Liabilities
The popular Piotroski Score uses the Current Ratio and awards a point when the change in Current Ratio is greater than zero.
12. Asset Turnover
Asset Turnover represents the dollars in revenue that a company generates per dollar of assets. Asset Turnover is typically used to measure the efficiency of a firm and its management at deploying capital for assets that yield revenue. Note that we use average Total Assets from the start and end of the year in the denominator, since sales are made over the course of a year.
Asset Turnover = Sales ÷ Average Total Assets
The Asset Turnover ratio is also a component of the Piotroski Score. The Piotroski Score awards a point to stocks with increasing Asset Turnover.
The Fixed Asset Turnover ratio measures how well a firm uses its fixed assets to generate revenues. While fixed assets like plant, property, and equipment aren't consumed directly in a sale-like inventory, they’re still assets that are necessary to sustain operations. Consequently, it's important to measure how well management is purchasing capital assets to generate revenue.
Fixed Asset Turnover = Sales ÷ Average Net Property, Plant, and Equipment
|Sector||Fixed Asset Turnover|
The Inventory Turnover ratio illustrates how many times a firm's inventory is sold and replaced over the course of a year. A declining Inventory Turnover ratio can be a leading indicator of pricing pressure and sales slumps.
Inventory Turnover = COGS ÷ Average Inventory
Cash Conversion Cycle is a metric that compares the number of days it takes a company to sell inventory and collect receivables relative to the number of days afforded to pay bills. It attempts to measure the time between the outflow and inflow of cash in the sales cycle. A negative figure suggests that the firm can receive payments for product sales before having to pay suppliers.
Cash Conversion Cycle = Days Sales Outstanding (+) Days Inventory Outstanding (-) Days Payable Outstanding
|Sector||Cash Conversion Cycle|
|Consumer Discretionary||38 days|
|Consumer Staples||50 days|
|Information Technology||46 days|
I’ve created a simple cheat sheet listing the formulas and short descriptions that you can download and print for quick reference.
Article by Finbox.io