Tools for Financial Statement Analysis

In the previous chapter, "How to Read a Balance Sheet", we learned how to organize a company's assets, liabilities, and equity to understand its financial position on a specific date. We also know how to find the net profit from the income statement.

But here is a practical problem: if I tell you a company made a net profit of ₹50 lakh this year, is that a good performance or a bad one?

If you just look at that single raw number, you might think, "₹50 lakh is a lot of money, so it must be good!" But what if I then tell you that last year, the same company made ₹200 lakh in profit? Suddenly, that ₹50 lakh looks like a disaster. What if I tell you that their biggest competitor made ₹500 lakh this year using the exact same amount of factory equipment?

Raw numbers in financial statements are like puzzle pieces scattered on a table. They do not tell you the full story until you connect them. To truly understand a business's health, profitability, and efficiency, we cannot just read financial statements; we have to analyze them.

This chapter will teach you the two most powerful foundational tools for doing exactly that: Comparative Statements and Common-Size Statements.

Why Raw Numbers Are Not Enough

Financial statement analysis is the process of breaking down complex financial data into simple, meaningful pieces to understand a company's operational and financial health.

When we look at a standalone Balance Sheet or Statement of Profit and Loss, we are looking at absolute figures. Absolute figures are the actual rupee amounts (like ₹10,00,000 in sales). While absolute figures are necessary for accounting, they are terrible for decision-making because they lack context.

To get context, we need relative figures. Relative figures are usually expressed as percentages, ratios, or proportions. They allow us to compare things fairly.

When we analyze financial statements, we are usually trying to do one of two things:

1. 1Intra-firm Comparison: Comparing the company's current performance with its own past performance (e.g., 2023 vs. 2024). This tells us the trend. Is the company growing or shrinking?
2. 2Inter-firm Comparison: Comparing the company's performance with a competitor's performance in the same year. This tells us our market position. Are we doing better or worse than the industry average?

To achieve these comparisons, accountants use two primary approaches: Horizontal Analysis and Vertical Analysis.

The Two Approaches: Horizontal vs. Vertical Analysis

Before we build the actual statements, you need to understand the difference between the horizontal and vertical approaches. Imagine a spreadsheet where years are columns (left to right) and financial items like Sales, Expenses, and Profit are rows (top to bottom).

Horizontal Analysis (Time-Series Analysis)

Horizontal analysis looks at financial data across time. Your eyes move horizontally from left to right across multiple years. You are asking: "How much did our sales grow from 2022 to 2023 to 2024?"

Because it tracks changes over a period of time, it is highly useful for spotting trends. The main tool we use for horizontal analysis is the Comparative Statement.

Vertical Analysis (Cross-Sectional Analysis)

Vertical analysis looks at financial data within a single year. Your eyes move vertically from top to bottom down a single column. Instead of comparing this year to last year, you compare every item in the statement to one "base" item in that same statement. You are asking: "Out of our total sales this year, what percentage went to paying salaries?"

Because it looks at the relationship of parts to a whole on a specific date, it is highly useful for understanding the structure of a business. The main tool we use for vertical analysis is the Common-Size Statement.

Horizontal Analysis: Comparative Statements

A comparative statement places the financial figures of two or more years side-by-side. But it doesn't stop there. It adds two crucial new columns:

1. 1The Absolute Change (increase or decrease in rupees).
2. 2The Percentage Change (increase or decrease as a %).

You can create a Comparative Balance Sheet or a Comparative Statement of Profit and Loss. The mathematical rules are exactly the same for both.

The Golden Rules of Comparative Statements

To build a comparative statement, you need a Base Year and a Current Year.

• Base Year: The earlier year (e.g., 2023).
• Current Year: The later year (e.g., 2024).

Interpreting a Comparative Income Statement

Let's look at why this is so powerful. Suppose a company's absolute numbers show that Net Profit increased from ₹1,00,000 to ₹1,20,000. That is a ₹20,000 increase. Sounds great, right?

But a comparative statement might reveal the following percentage changes:

• Revenue from Operations (Sales) increased by 50%.
• Cost of Materials Consumed increased by 80%.
• Net Profit increased by only 20%.

Now the story changes completely. Yes, the company sold a lot more goods (sales up 50%), but their raw material costs skyrocketed (up 80%). Because costs grew much faster than sales, their profit only grew by 20%. The comparative statement acts as an early warning system: if they don't control their material costs, they might start losing money next year despite high sales.

Worked Example: Building a Comparative Statement

Let's build a simplified Comparative Statement of Profit and Loss for "Himalaya Traders Ltd." for the years ending March 31, 2023, and March 31, 2024.

The Raw Data:

• Revenue from Operations: ₹10,00,000 (in 2023) and ₹15,00,000 (in 2024)
• Total Expenses: ₹6,00,000 (in 2023) and ₹10,50,000 (in 2024)

Step-by-Step Calculation:

1. Revenue from Operations:

• Base Year (2023): ₹10,00,000
• Current Year (2024): ₹15,00,000
• Absolute Change: ₹15,00,000 - ₹10,00,000 = +₹5,00,000
• Percentage Change: (5,00,000 / 10,00,000) × 100 = +50%

2. Total Expenses:

• Base Year (2023): ₹6,00,000
• Current Year (2024): ₹10,50,000
• Absolute Change: ₹10,50,000 - ₹6,00,000 = +₹4,50,000
• Percentage Change: (4,50,000 / 6,00,000) × 100 = +75%

3. Profit Before Tax (Revenue minus Expenses):

• Base Year (2023): ₹10,00,000 - ₹6,00,000 = ₹4,00,000
• Current Year (2024): ₹15,00,000 - ₹10,50,000 = ₹4,50,000
• Absolute Change: ₹4,50,000 - ₹4,00,000 = +₹50,000
• Percentage Change: (50,000 / 4,00,000) × 100 = +12.5%

The Analysis: By looking at the percentages, a finance manager can instantly see a problem. Sales grew by a very healthy 50%, but expenses grew by a massive 75%. As a result, the profit only grew by a sluggish 12.5%. The company is becoming less efficient at converting sales into profit.

Vertical Analysis: Common-Size Statements

While comparative statements are great for looking at history, they aren't always helpful for comparing two different companies.

Imagine comparing a local startup with ₹10 lakh in sales to a massive corporation like Reliance with thousands of crores in sales. The absolute numbers are so vastly different that comparing their absolute changes is meaningless.

This is where Common-Size Statements come in. A common-size statement converts every single rupee amount in the financial statement into a percentage of a common "Base" figure.

By converting everything to percentages, we shrink the massive corporation and the tiny startup down to the exact same scale (where the base equals 100%). Now, we can easily compare their structures.

Choosing the Base Figure

The most critical part of vertical analysis is knowing what the "Base" is. The base is always set to 100%, and every other item is divided by it.

1. For a Common-Size Statement of Profit and Loss: The base is always Revenue from Operations (Net Sales). Why? Because a business exists to generate revenue. We want to know: for every ₹100 of sales we make, how many rupees go to raw materials? How many to salaries? How many are left as profit?

2. For a Common-Size Balance Sheet: The base is always Total Assets (which is mathematically identical to Total Equity and Liabilities). Why? Because we want to know the structure of the company's wealth. Out of total assets, what percentage is tied up in fixed machinery versus liquid cash? Out of total liabilities, what percentage is funded by the owners' equity versus outside bank loans?

Worked Example: Building a Common-Size Statement

Let's build a Common-Size Statement of Profit and Loss for "Chenab Industries" for the year ending March 31, 2024.

The Raw Data:

• Revenue from Operations: ₹20,00,000
• Cost of Materials Consumed: ₹12,00,000
• Employee Benefit Expenses (Salaries): ₹3,00,000
• Other Expenses: ₹1,00,000
• Net Profit: ₹4,00,000

Step-by-Step Calculation:

Since this is an Income Statement, our Base is Revenue from Operations. We set it to 100%. We will divide every single other number by ₹20,00,000.

• Revenue from Operations: (20,00,000 / 20,00,000) × 100 = 100%
• Cost of Materials: (12,00,000 / 20,00,000) × 100 = 60%
• Employee Expenses: (3,00,000 / 20,00,000) × 100 = 15%
• Other Expenses: (1,00,000 / 20,00,000) × 100 = 5%
• Net Profit: (4,00,000 / 20,00,000) × 100 = 20%

The Analysis: Now we have a beautiful, clear picture of the company's cost structure. We can confidently say: "For every ₹100 Chenab Industries earns in sales, ₹60 goes to raw materials, ₹15 goes to staff, ₹5 goes to other bills, and they keep ₹20 as pure profit."

If a competitor's common-size statement shows they only spend 50% on materials, Chenab Industries knows exactly where they need to improve to catch up.

The Blind Spots: Limitations of Financial Analysis

As powerful as comparative and common-size statements are, they are not magic crystal balls. A good finance student must know the limitations of the tools they are using. If you rely blindly on these percentages without understanding the context, you can make terrible decisions.

Here are the major limitations of financial statement analysis:

1. It Ignores Price Level Changes (Inflation)

Financial statements are prepared on the "Historical Cost Concept"—meaning assets are recorded at the price they were bought for, and sales are recorded at the rupee value of that specific year. If a company's comparative statement shows that sales grew by 10% from 2022 to 2023, it looks like growth. But what if the national inflation rate was 12% that year? In real terms, the company actually sold fewer goods, but the inflated prices made the revenue number look bigger. Financial analysis tools do not automatically adjust for inflation.

2. It Suffers from "Window Dressing"

Window dressing refers to the legal (but slightly deceptive) manipulation of accounts right before the financial year ends to make the balance sheet look better than it is. For example, a company might delay paying its suppliers until April 5th, just so its cash balance looks artificially high on March 31st. Because financial analysis relies entirely on the data in the statements, if the statements are window-dressed, the analysis will give a false sense of security.

3. Differences in Accounting Policies

You can only compare two companies (inter-firm comparison) if they use the same accounting rules. Suppose Company A uses the Straight Line Method (SLM) for depreciation, which charges a fixed amount every year. Company B uses the Written Down Value (WDV) method, which charges heavy depreciation in the early years. If you compare their common-size net profits in year one, Company B will look much less profitable. But this isn't because Company B is a worse business; it is simply because they chose a different accounting policy.

4. It Ignores Qualitative Factors

Financial statements only record things that can be measured in money. Therefore, financial analysis completely ignores qualitative factors that might be crucial to the company's survival. A common-size statement will not tell you that the company's brilliant CEO just resigned, that their factory workers are planning a strike, or that a new competitor has invented a better product. It only shows the numbers, not the human or market realities behind them.

5. It is Purely Historical

Financial statements are essentially post-mortems. They tell you what happened in the past. While horizontal analysis helps identify trends, assuming that a past trend will automatically continue into the future is dangerous. A company that grew 20% every year for three years might suddenly crash in the fourth year due to a change in government regulations.

Quick Revision

• Financial Statement Analysis converts absolute raw numbers into relative percentages to make data meaningful for decision-making.
• Horizontal Analysis compares data across multiple years (time-series) to spot trends.
• Vertical Analysis compares data within a single year (cross-sectional) to understand the structure of the business.
• Comparative Statements (Horizontal) show absolute change and percentage change.
• Formula for % Change: (Absolute Change / Base Year Figure) × 100. Always divide by the base (earlier) year.
• Common-Size Statements (Vertical) convert all items into a percentage of a common base.
• Base for Income Statement: Revenue from Operations (Net Sales) is always taken as 100%.
• Base for Balance Sheet: Total Assets (or Total Liabilities) is always taken as 100%.
• Limitations: Analysis ignores inflation, can be fooled by window dressing, is useless if accounting policies differ, ignores qualitative factors (like management quality), and only looks at the past.