Tools for Financial Analysis: Comparative, Common Size & Trend
Financial statements (the Balance Sheet and Profit & Loss Statement) contain massive amounts of raw financial data. However, raw figures alone cannot tell a manager whether the firm’s health is improving or deteriorating. To diagnose business performance, financial managers use structured analytical tools.
1. What is Financial Statement Analysis?
Financial Statement Analysis is the process of critically examining, reorganizing, and interpreting accounting figures to assess the profitability, liquidity, solvency, and operational efficiency of an enterprise.
Major Stakeholders Interested in Financial Analysis:
- Management: To plan future expansions, control operating costs, and budget resources.
- Creditors & Suppliers: To verify whether the firm can pay for credit purchases within 30-90 days.
- Commercial Banks & Lenders: To determine long-term repayment ability and debt-servicing capacity before issuing loans.
- Investors & Shareholders: To judge safety of capital, dividend prospects, and stock price appreciation.
2. Major Tools of Financial Analysis
The most widely tested tools in DAVV BBA examinations include:
- Comparative Financial Statements (Horizontal Analysis)
- Common-Size Financial Statements (Vertical Analysis)
- Trend Analysis / Trend Percentages
- Ratio Analysis
- Cash Flow & Funds Flow Statements
Let us examine each in detail with clear examples.
3. Comparative Financial Statements (Horizontal Analysis)
A Comparative Financial Statement places figures of two or more consecutive accounting years side-by-side to highlight the absolute monetary increase/decrease and percentage changes over time.
Because it looks across columns over time, it is called Horizontal Analysis.
Standard Columns in Comparative Statements:
- Column A: Particulars (Financial Line Items)
- Column B: Base Year Amount (Year 1)
- Column C: Current Year Amount (Year 2)
- Column D: Absolute Change = Current Year (C) - Base Year (B)
- Column E: Percentage Change (%) = (Absolute Change in D / Base Year in B) × 100
Practical Illustrative Example (Comparative Income Statement):
| Particulars | 2025 (₹) | 2026 (₹) | Absolute Change (₹) | % Change |
|---|---|---|---|---|
| Revenue from Operations (Sales) | 10,00,000 | 12,50,000 | +2,50,000 | +25.0% |
| Less: Cost of Goods Sold | 6,00,000 | 7,20,000 | +1,20,000 | +20.0% |
| Gross Profit | 4,00,000 | 5,30,000 | +1,30,000 | +32.5% |
| Less: Operating Expenses | 1,50,000 | 1,80,000 | +30,000 | +20.0% |
| Operating Profit (EBIT) | 2,50,000 | 3,50,000 | +1,00,000 | +40.0% |
| Less: Tax at 30% | 75,000 | 1,05,000 | +30,000 | +40.0% |
| Net Profit After Tax | 1,75,000 | 2,45,000 | +70,000 | +40.0% |
Managerial Insight: While revenue grew by 25%, Net Profit jumped by 40% because operating expenses grew at a slower rate (20%), proving operating efficiency!
4. Common-Size Financial Statements (Vertical Analysis)
A Common-Size Financial Statement converts all items of a statement into percentages of a single common base figure (taken as 100%).
Because it analyzes items down a single accounting period’s column, it is called Vertical Analysis.
How Base Figures are Chosen:
- In Common-Size Income Statement: Net Sales (Revenue from Operations) is taken as 100%. All expenses and profits are expressed as a percentage of Net Sales.
- In Common-Size Balance Sheet: Total Assets (or Total Equities & Liabilities) is taken as 100%. Every asset and liability is expressed as a percentage of that total.
Practical Example (Common-Size Balance Sheet):
| Liabilities & Assets | Amount (₹) | % of Total Balance Sheet |
|---|---|---|
| Shareholders’ Funds (Equity) | 12,00,000 | 60.0% |
| Long-Term Debt (Bank Loans) | 5,00,000 | 25.0% |
| Current Liabilities (Creditors) | 3,00,000 | 15.0% |
| Total Equity & Liabilities | 20,00,000 | 100.0% |
| Fixed Assets (Plant & Machinery) | 11,00,000 | 55.0% |
| Inventories (Stock) | 4,00,000 | 20.0% |
| Trade Receivables (Debtors) | 3,40,000 | 17.0% |
| Cash & Bank Balance | 1,60,000 | 8.0% |
| Total Assets | 20,00,000 | 100.0% |
Benefit: Common-size statements allow easy comparison between two companies of completely different sizes (e.g., a local bakery vs a large FMCG brand).
5. Trend Analysis (Trend Percentages)
Trend Analysis is used to evaluate financial performance across a longer time horizon (e.g., 5 to 10 years).
Steps to Compute Trend Percentages:
- Select an earliest normal business year as the Base Year and assign its figures an index value of 100%.
- Express every subsequent year’s figure as a percentage of that base year figure:
Trend Percentage = (Current Year Figure / Base Year Figure) × 100
Example:
- Sales in 2022 (Base Year): ₹10,00,000 → Trend = 100%
- Sales in 2023: ₹12,50,000 → Trend = (12,50,000 / 10,00,000) × 100 = 125%
- Sales in 2024: ₹16,00,000 → Trend = (16,00,000 / 10,00,000) × 100 = 160%
- Sales in 2025: ₹21,00,000 → Trend = (21,00,000 / 10,00,000) × 100 = 210%
6. Comparison: Horizontal vs Vertical Analysis
| Feature | Horizontal Analysis | Vertical Analysis |
|---|---|---|
| Time Dimension | Compares figures across several years | Focuses on items within a single accounting period |
| Technique | Comparative Statements & Trend Ratios | Common-Size Statements & Single-period Ratios |
| Primary Use | Identifies growth rates and direction of progress | Highlights structural composition of assets, liabilities, and cost proportions |
| Base Item | Previous/Base year figure of the same line item | Total Sales (for P&L) or Total Assets (for Balance Sheet) |
7. Summary & Quick Revision Checklist
- Comparative Statements: Show absolute and percentage changes over consecutive years (Horizontal Analysis).
- Common-Size Statements: Express each item as a percentage of Total Sales or Total Assets (Vertical Analysis).
- Trend Percentages: Track long-term business trajectories by fixing a base year at 100%.
- Usefulness: Enables intra-firm comparison (year-on-year) and inter-firm comparison (against industry benchmarks).