Ratio Analysis Formula (Table of Contents)
What is the Ratio Analysis Formula?
The term “Ratio Analysis” refers to the analytical technique wherein a plethora of financial ratios is computed based on the financial information either available in the annual reports or public domain. The ratio analysis helps in assessing the subject company’s financial and operational position.
The financial ratios used in ratio analysis technique are broadly categorized into the following four major categories:
- Liquidity Ratios
- Solvency Ratios
- Efficiency Ratios
- Profitability Ratios
Explanation
The formula for Ratio Analysis can be calculated by using the following steps:
1. Liquidity Ratios
These ratios indicate the company’s cash level, liquidity position and the capacity to meet its short-term liabilities. The formula of some of the major liquidity ratios are:
- Current Ratio = Current Assets / Current Liabilities
- Quick Ratio = (Cash & Cash Equivalents + Accounts Receivables) / Current Liabilities
- Cash Ratio = Cash & Cash Equivalents / Current Liabilities
2. Solvency Ratios
These ratios indicate whether the company has the capability to meet its long-term obligations by comparing its debt level with its assets and equity etc. The formula of some of the major solvency ratios are:
- Debt-To-Equity Ratio = Total Debt / Total Equity
- Debt Ratio = Total Debt / Total Assets
- Interest Coverage Ratio = EBITDA / Interest Expense
3. Efficiency Ratios
These ratios indicate how efficiently a company is able to utilize its available assets or convert its inventories to cash. The formula of some of the major efficiency ratios are:
- Receivables Turnover Ratio = Sales / Accounts Receivable
- Inventory Turnover Ratio = COGS / Inventories
- Payable Turnover Ratio = COGS / Accounts Payable
- Asset Turnover Ratio = Sales / Total Assets
- Net Fixed Asset Turnover Ratio = Sales / Net Fixed Assets
- Equity Turnover Ratio = Sales / Total Equity
4. Profitability Ratios
These ratios demonstrate a company’s efficiency to use its assets to generate profits. The formula of some of the major profitability ratios are:
- Gross Margin = (Sales – COGS) / Sales
- Operating Profit Margin = EBIT / Sales
- Net Margin = Net Income / Sales
- Return on Total Asset (ROA) = EBIT / Total Assets
- Return on Total Equity (ROE) = Net Income / Total Equity
Example of Ratio Analysis Formula (With Excel Template)
Let’s take an example to understand the calculation of Ratio Analysis in a better manner.
Ratio Analysis Formula – Example #1
Let us take the example of Apple Inc.’s annual report for 2019 to illustrate the calculation of different ratios used in ratio analysis. As per the latest annual report, the following information is available. Based on the given information, calculate the liquidity, solvency, efficiency and profitability ratios of Apple Inc. for the year 2019.
Solution:
Liquidity Ratios
Current Ratio is calculated using the formula given below
Current Ratio = Current Assets / Current Liabilities
- Current Ratio = $162,819 million / $105,718 million
- Current Ratio = 1.54x
Quick Ratio is calculated using the formula given below
Quick Ratio = (Cash & Cash Equivalents + Accounts Receivables) / Current Liabilities
- Quick Ratio = ($48,844 million + $22,926 million) / $105,718 million
- Quick Ratio = 0.68x
Cash Ratio is calculated using the formula given below
Cash Ratio = Cash & Cash Equivalents / Current Liabilities
- Cash Ratio= $48,844 million / $105,718 million
- Cash Ratio = 0.46x
Solvency Ratios
Debt to Equity Ratio is calculated using the formula given below
Debt to Equity Ratio = Total Debt / Total Equity
- Debt to Equity Ratio = $108,047 million / $90,488 million
- Debt to Equity Ratio = 1.19x
Debt Ratio is calculated using the formula given below
Debt Ratio = Total Debt / Total Assets
- Debt Ratio = $108,047 million / $338,516 million
- Debt Ratio = 0.32x
Interest Coverage Ratio is calculated using the formula given below
Interest Coverage Ratio = EBITDA / Interest Expense
- Interest Coverage Ratio = $76,477 million / $3,576 million
- Interest Coverage Ratio = 21.39x
Efficiency Ratios
Receivables Turnover Ratio is calculated using the formula given below
Receivables Turnover Ratio = Sales / Accounts Receivable
- Receivables Turnover Ratio = $260,174 million / $22,926 million
- Receivables Turnover Ratio = 11.35x
Inventory Turnover Ratio is calculated using the formula given below
Inventory Turnover Ratio = COGS / Inventories
- Inventory Turnover Ratio = $161,782 million / $4,106 million
- Inventory Turnover Ratio = 39.40x
Payable Turnover Ratio is calculated using the formula given below
Payable Turnover Ratio = COGS / Accounts Payable
- Payable Turnover Ratio = $161,782 million / $46,236 million
- Payable Turnover Ratio = 3.50x
Asset Turnover Ratio is calculated using the formula given below
Asset Turnover Ratio = Sales / Total Assets
- Asset Turnover Ratio = $260,174 million / $338,516 million
- Asset Turnover Ratio = 0.77x
Net Fixed Asset Turnover Ratio is calculated using the formula given below
Net Fixed Asset Turnover Ratio = Sales / Net Fixed Assets
- Net Fixed Asset Turnover Ratio = $260,174 million / $37,378 million
- Net Fixed Asset Turnover Ratio = 6.96x
Equity Turnover Ratio is calculated using the formula given below
Equity Turnover Ratio = Sales / Total Equity
- Equity Turnover Ratio = $260,174 million / $90,488 million
- Equity Turnover Ratio = 2.88x
Profitability Ratios
Gross Margin is calculated using the formula given below
Gross Margin = (Sales – COGS) / Sales
- Gross Margin = ($260,174 million – $161,782 million) / $260,174 million
- Gross Margin = 37.8%
Operating Profit Margin is calculated using the formula given below
Operating Profit Margin = EBIT / Sales
- Operating Profit Margin = $63,930 million / $260,174 million
- Operating Profit Margin = 24.6%
Net Margin is calculated using the formula given below
Net Margin = Net income / Sales
- Net Margin = $55,256 million / $260,174 million
- Net Margin = 21.2%
Return on Total Asset (ROA) is calculated using the formula given below
Return on Total Asset (ROA) = EBIT / Total Assets
- Return on Total Asset (ROA) = $63,930 million / $338,516 million
- Return on Total Asset (ROA) = 18.9%
Return on Total Equity (ROE) is calculated using the formula given below
Return on Total Equity (ROE) = Net Income / Total Equity
- Return on Total Equity (ROE) = $55,256 million / $90,488 million
- Return on Total Equity (ROE) = 61.1%
Source Link: Apple Inc. Balance Sheet
Relevance and Use of Reserve Ratio Formula
One of the major uses of ratio analysis is that it makes it easier and simpler to compare companies with different scale of operations. Further, it also simplifies the analysis of the financial statements and helps in identifying deviation in historical trends.
Recommended Articles
This is a guide to Ratio Analysis Formula. Here we discuss how to calculate the Ratio Analysis Formula along with practical examples. We also provide a downloadable excel template. You may also look at the following articles to learn more –
- Example of Debt to Equity Ratio
- How to Calculate Cash Ratio?
- Guide to Inventory Turnover Ratio
- Guide to Advantages of Ratio Analysis
- Debt to GDP Ratio | Benefits
- Asset Turnover Ratio | Examples
- Guide to Ratio Analysis Types
123 Online Courses | 25 Hands-on Projects | 600+ Hours | Verifiable Certificate of Completion
4.9
View Course
Related Courses