Hello! Welcome back to the course.
In our last lesson, we focused on using waterfall charts to tell a story about change over time—explaining the specific drivers that bridge the gap between a budget and an actual result, or between one period and the next. This is a crucial skill for explaining performance.
Today, we shift our focus from explaining change to assessing the overall state of a company's financial health. We will tackle this by addressing the learning outcome for this lesson: Calculate and interpret liquidity, profitability, leverage, and efficiency ratios to assess company performance.
Financial ratios are the vital signs of a business. Just as a doctor uses metrics like blood pressure and heart rate to assess a patient's health, an FP&A analyst uses financial ratios to diagnose a company's performance, identify its strengths and weaknesses, and compare it to its peers.
In this lesson, you will learn about the four main categories of financial ratios and, more importantly, how to interpret them to tell a meaningful story about a company's operations and financial standing.
1. The Analyst's Toolkit: An Overview of Financial Ratios
Before we dive into calculations, it's essential to have a reliable reference. The world of financial ratios is vast, and having a go-to guide is invaluable for any analyst.
The 'Financial Ratios eBook' from the Corporate Finance Institute (CFI) is an excellent, comprehensive guide that you should download and keep for future reference. It clearly defines the most common ratios, their formulas, and their interpretation.
Please download this eBook. Skim through it now to familiarize yourself with the structure. Notice how the ratios are grouped into logical categories. We will refer to the concepts in these categories throughout the lesson.
As you saw in the eBook, ratios are typically grouped into four key categories. Here’s a high-level overview of what each category tells us:
-
Liquidity Ratios: Do we have enough cash or near-cash assets to pay our bills in the short term?
- Key Question: Can the company survive a short-term cash crunch?
- Example: Current Ratio = Current Assets / Current Liabilities
-
Leverage (or Solvency) Ratios: How is the company financed? How much of our capital comes from debt, and can we handle that debt load?
- Key Question: What is the company's long-term financial risk?
- Example: Debt-to-Equity Ratio = Total Debt / Shareholders' Equity
-
Efficiency (or Turnover) Ratios: How well are we using our assets (like inventory and receivables) to generate sales?
- Key Question: Are our operations lean and effective?
- Example: Inventory Turnover = Cost of Goods Sold / Average Inventory
-
Profitability Ratios: Are we making money? How much profit are we generating from our sales and assets?
- Key Question: How successful is the business at generating profit?
- Example: Net Profit Margin = Net Income / Revenue
Now that we have a map, let's explore how practitioners use these ratios to gain real insight.
2. Practitioner Insights: What the Ratios Really Mean
Simply knowing the formulas is not enough. A top-tier analyst understands the context, the nuances, and which ratios matter most in different situations. The following webinar provides these practical insights directly from experienced finance professionals.
Essential Financial Ratios You Need to Know (Webinar)
This video, 'Essential Financial Ratios You Need to Know' from the Corporate Finance Institute, moves beyond textbook definitions to discuss how ratios are used in practice for valuation, lending, and performance management.
Watch the following segments to understand the 'why' behind the key ratios in profitability, efficiency, and leverage: Profitability (21:01 - 29:50): Pay close attention to the discussion of Return on Invested Capital (ROIC) vs. Return on Equity (ROE). Understand why ROIC is preferred for capital-intensive businesses and why ROE is the key metric for banks. Efficiency (29:50 - 35:26): Focus on the 'days' ratios for working capital (Receivable Days, Inventory Days). Note how tangible this approach is for understanding cash flow and negotiating with suppliers and customers. Leverage (35:26 - 42:57): Listen for the explanation of Debt-to-EBITDA. The key idea here is thinking about debt as a multiple of cash flow, not just a nominal amount, and its connection to debt covenants.
The key takeaway from this video is that ratios are not just calculations; they are lenses through which we can understand a business's strategy and operational effectiveness. For example, ROIC is deeply connected to a company's Enterprise Value, which is a core concept in corporate finance and valuation. This link between operational metrics and valuation is central to the FP&A role.
3. Hands-On: Calculating Ratios in Excel
Now, let's get practical and move to Excel. Seeing how these ratios are calculated step-by-step from raw financial statements solidifies the concepts and demystifies the process.
The following masterclass walks through building a ratio analysis file from scratch. Given your foundational Excel knowledge, this is a great opportunity to see a standard workflow in action.
Ratio Analysis - 30 minutes masterclass - A Step by Step Guide - using Excel
The video 'Ratio Analysis - 30 minutes masterclass' from FinShiksha provides a fantastic step-by-step guide to calculating a full suite of ratios in Excel, using data from a real company's annual report.
Watch the following sections where the instructor calculates the four main categories of ratios. You can follow along with a blank Excel sheet if you wish, or simply observe the process: Profitability Ratios (08:08 - 12:30): Observe how Operating, EBIT, and Net Profit margins are calculated. Return Ratios (12:30 - 14:21): See the calculation of ROE and ROCE. Leverage/Debt Ratios (14:21 - 15:34): Note the calculation of Debt/Equity and Interest Coverage. Efficiency/Turnover Ratios (15:34 - 19:01): Watch how turnover ratios for assets, inventory, and receivables are computed.
4. From Calculation to Interpretation
Ratios in isolation are meaningless. Their power comes from comparison:
- Trend Analysis: Comparing a company's ratios over several periods to see if performance is improving, deteriorating, or stable.
- Peer Analysis: Comparing a company's ratios to those of its direct competitors or the industry average to gauge its relative performance.
The final step in our process is to analyze the numbers we've calculated to ask intelligent questions.
Let's return to the FinShiksha video and see how the presenter analyzes the trends in the ratios he just calculated.
Ratio Analysis - 30 minutes masterclass - A Step by Step Guide - using Excel
This is the most important part of the process. Watch how the numbers are used to generate questions about the business.
Watch the 'Analysis and Interpretation' section from 20:59 to 29:09. Pay attention to how the presenter notices a spike in margins in 2022 and immediately asks 'Why?' He then forms a hypothesis (higher steel prices) and identifies how to verify it. This investigative mindset is the essence of a great financial analyst.
Test your understanding!
The image below provides simplified financial data for a company. Using the formulas from the CFI eBook and the methods shown in the videos, calculate the following for 2016:
- Current Ratio
- Net Profit Margin
Based on the data, what was the general trend in liquidity from 2015 to 2016?
Show answer
1. Current Ratio for 2016:
- Formula: Current Assets / Current Liabilities (Current Liabilities not given, but we can infer it is not needed for the trend question).
- Calculation for 2016: Current Assets = 8,828 Cr.
- Calculation for 2015: Current Assets = 9,332 Cr.
2. Net Profit Margin for 2016:
- Formula: Net Income / Revenue
- Calculation: 1,510 / 12,042 = 12.5%
Trend in Liquidity:
To assess liquidity, we can look at the components of Current Assets. From 2015 to 2016:
- Total Current Assets decreased from 9,332 to 8,828.
- Cash, the most liquid asset, decreased significantly from 2,342 to 1,589.
- Inventory increased from 2,130 to 2,560.
This indicates a negative trend in liquidity. The company has less cash and more of its current assets are tied up in inventory, which is generally less liquid.
Conclusion
In this lesson, you've learned to calculate and, more importantly, interpret the four primary categories of financial ratios. This is a foundational skill for any FP&A professional, enabling you to quickly assess a company's financial health and performance.
Key Takeaways:
- Financial ratio analysis is a systematic way to evaluate a company's liquidity, leverage, efficiency, and profitability.
- The true power of ratios lies in comparison—against the company's own history (trend analysis) and against its competitors (peer analysis).
- Ratios are the starting point of analysis, not the end. They help you ask the right questions ("Why did our receivable days increase?") that lead to deeper business insights.
- For practitioners, certain ratios like ROIC and Debt-to-EBITDA are particularly important as they are closely linked to valuation and credit analysis.
In our next lesson, we will apply these analytical skills to a more specific, decision-oriented problem. We will move from analyzing the entire company to evaluating a single project or product, learning how to perform break-even analysis for new products or initiatives.