Assessing Business Performance through Financial Statements

Methods of Financial Statement Analysis

Financial statements (Balance Sheet, Profit & Loss Account, Cash Flow Statement) are raw data. To extract actionable insight into a business’s performance, three standard analytic tools are used: common‑size (percentage) analysis, trend analysis, and ratio analysis.

1. Common‑Size (Percentage) Analysis

Intuition: Convert every line item into a percentage of a common base. This strips out size differences and lets you compare firms of different scale, or a single firm’s composition over time.

• Balance Sheet: Each item is expressed as a percentage of total assets (or total liabilities + equity).
• Profit & Loss Account: Each item is expressed as a percentage of net sales (revenue).

Why it matters: Reveals what drives the business (e.g., inventory is 40% of assets → the firm is asset‑heavy in stock; R&D is 15% of sales → a high‑innovation company).

2. Trend Analysis

Intuition: Look at the same line item across multiple periods (e.g., 3–5 years) to spot direction, speed, and consistency. Also called horizontal analysis.

• Compute the year‑over‑year percentage change for each item.
• Alternatively, pick a base year (=100) and index subsequent years.

Why it matters: A single year’s profit might mislead. Trend analysis shows whether revenue is steadily growing, margins are eroding, or debt is piling up.

3. Ratio Analysis

Intuition: Combine related numbers from different statements into ratios that measure efficiency, profitability, liquidity, leverage, and market performance. The most comprehensive tool.

• Ratios are grouped into categories (e.g., liquidity ratios, profitability ratios, solvency ratios).
• No single ratio tells the whole story – ratios must be compared to industry benchmarks or the firm’s own history.

Why it matters: Transforms absolute numbers into meaningful, comparable metrics. For example, two firms may have the same net profit, but one uses twice the assets – ratio analysis (Return on Assets) reveals the difference.

---

Key takeaways

• Common‑size analysis normalises statements to percentages – ideal for structural comparison.
• Trend analysis tracks changes over time – reveals growth or decay.
• Ratio analysis links items across statements – the most powerful diagnostic tool.
• All three methods require interpretation within the context of the company’s industry and strategy.
• No single method is sufficient; analysts combine them for a complete performance picture.

Common Size Analysis (Percentage Analysis)

Common size analysis is a technique that removes the effect of company size, making it possible to compare firms of different scales. Every line item on a financial statement is expressed as a percentage of a common base figure — total assets for the balance sheet and total income for the profit and loss account.

The intuition: instead of comparing absolute rupees (which are meaningless when one company is ten times larger), compare the composition of assets, liabilities, revenues, and costs. This reveals how efficiently a company uses its resources and where its money comes from and goes.

Balance Sheet

Set total assets = 100%; express every asset and liability as a percentage of that total.

$\text{Common size \%} = \frac{\text{Line item}}{\text{Total assets}} \times 100$

The same percentages on the liabilities side show the funding mix. Changes over time or across competitors highlight strategic shifts.

Example – Asian Paints Ltd (illustrated)

Interpretation: The company is reducing debt (equity rising, current liabilities falling) and not investing in new capacity (non‑current assets declining except for investment holdings).

Profit & Loss Account

Set total income (net sales + other income) = 100%; each expense, tax, and profit figure becomes a percentage of that base.

$\text{Common size \%} = \frac{\text{Line item}}{\text{Total income}} \times 100$

Example – Asian Paints Ltd

Interpretation: Cost control on materials and lower taxes boosted net profitability, even though operating expenses crept up.

Exam tip: Common size analysis is the go‑to tool for inter‑firm comparison and trend analysis over time. Always check which base is used — total assets for the balance sheet, total income for the P&L. A common error is mixing the two bases.

Key takeaways

• Common size statements (percentage analysis) normalise financial data by a common base, enabling size‑agnostic comparisons.
• Balance sheet base = total assets; P&L base = total income.
• Changes in composition reveal shifts in financing (e.g., deleveraging) and cost structure (e.g., material cost improvements).
• The technique is especially useful for comparing companies of vastly different sizes within the same industry.
• It does not capture absolute scale — only relative proportions.

Trend Analysis

Trend analysis measures a company’s growth over time. It requires choosing a base year (typically year 1 of the period), setting each line item in that year to 100, and expressing all subsequent years’ values as a percentage of the base year value:

$\text{Index}_t = \frac{V_t}{V_{\text{base}}} \times 100$

This allows quick identification of relative changes—whether an item grew, shrank, or stayed flat—across the entire window.

Observations from a 10‑year trend (Base year: 2011)

Capital side of the balance sheet

• Reserves grew roughly five‑fold → retained earnings accumulation.
• Borrowings decreased → possible deleveraging or substitution with internal funds.
• Trade payables rose as the business expanded (more raw material procurement → higher payables).
• Other liabilities also increased, consistent with expansion.

Asset side of the balance sheet

• Fixed assets grew → additional production capacity.
• Cash & bank fell (the only item that declined).
• Inventory and receivables rose alongside higher sales (more credit sales and stock).

Profit & loss account

• Sales grew 2.84 times, but PAT grew faster (3.42×), indicating improved profitability or margin expansion.
• Total assets expanded 4.69 times, far more than sales. Fixed assets doubled in 2019, suggesting the company added capacity before sales caught up. Full capacity utilisation may take additional time.

Connection to other analysis methods

Common size analysis (previous module) shows the composition of financial statements in a single period. Trend analysis adds the time dimension—revealing direction and pace of change. The next step is ratio analysis, which combines data from both balance sheet and income statement to evaluate efficiency, liquidity, and profitability.

Exam tip: When total asset growth far exceeds sales growth, suspect recent capacity additions that are not yet fully utilised. This can depress asset‑turnover ratios temporarily—a key trap in ratio analysis.

Key takeaways

• Trend analysis expresses all years relative to a base year ( = 100).
• It reveals growth patterns: constant share capital (no new equity), reserves up ~5×, borrowings down.
• Asset growth (4.69×) outpaced sales growth (2.84×) → likely capacity expansion with lagging production.
• PAT grew faster than sales → improving net profit margin.
• Trend analysis is a bridge between common size and ratio analysis, providing the longitudinal view.

Ratio Analysis: Return on Total Assets and Profitability Drivers

Return on total assets (ROTA) measures how efficiently a company uses its assets to generate operating profit. Intuitively: for every rupee invested in total assets, how much profit before interest and tax does the company earn? ROTA captures the core earning power of the business, independent of how it is financed.

$\text{ROTA} = \frac{\text{Profit Before Interest and Taxes (PBIT)}}{\text{Total Assets}}$

Why PBIT? — Numerator–denominator consistency

Total assets are funded by both equity holders and lenders (debt holders). Both groups have a claim on the earnings generated by those assets. Using PBIT in the numerator reflects the return available to all capital providers. Using profit after tax (PAT) would only reflect the portion available to equity holders, creating an inconsistency.

Exam tip: Always ensure numerator and denominator represent the same stakeholder group. For ROTA, the numerator is PBIT, not PAT.

Worked example: Two-year comparison

ROTA improved from 10.67% to 49.67% — a dramatic increase. The question is: what drove this superior performance?

Four drivers of profitability

Profitability does not arise from one factor alone. Four key drivers are:

• Asset management — Measures how productively assets generate revenue. A business invests in assets to run operations; those assets must be used efficiently.
• Cost management — Controls the costs incurred while performing operations. Producing and selling effectively requires keeping costs in check.
• Leverage management — Uses external financing to amplify returns. Subdivided into:
  • Payables management — Managing short-term obligations to suppliers.
  • Debt management — Using borrowed capital responsibly.
• Tax management — Reduces tax liability through legitimate tax planning provisions.

These drivers form a framework for dissecting the sources of ROTA improvement.

Key takeaways

• ROTA = PBIT / Total Assets; it measures operating profit per unit of total assets.
• Numerator must match the denominator’s stakeholder claim: PBIT for all capital providers.
• In the example, ROTA jumped from 10.67% to 49.67% as assets doubled and PBIT rose sharply.
• Profitability is driven by asset management, cost management, leverage management (including payables and debt), and tax management.
• Understanding each driver helps identify the real cause behind a change in ROTA.

Asset Management

Asset management ratios measure how efficiently a company uses its assets to generate revenue. The core idea: every rupee tied up in an asset should produce as much sales as possible. Sluggish assets drag down profitability.

Asset Turnover Ratio

The asset turnover ratio captures the overall productivity of total assets.

$\text{Asset Turnover} = \frac{\text{Sales}}{\text{Total Assets}}$

Intuition: for every ₹1 invested in assets, how much revenue does the company produce?

Worked example (two years)

The ratio improved from 1.20 to 2.00, indicating significantly higher asset productivity in Year 2.

Fixed and Current Asset Turnover

To understand which assets drove the improvement, we decompose total assets into fixed assets and current assets.

Fixed Asset Turnover

$\text{Fixed Asset Turnover} = \frac{\text{Sales}}{\text{Fixed Assets}}$

Productivity rose from 2.00 to 2.86 — each rupee in fixed assets produced more sales.

Current Asset Turnover

Current assets = Inventory + Receivables + Cash & Bank. For Year 1: ₹60; Year 2: ₹90.

$\text{Current Asset Turnover} = \frac{\text{Sales}}{\text{Current Assets}}$

A sharp improvement from 3.00 to 6.67 — current assets are being used far more efficiently.

Drill-Down: Inventory and Receivables

Two key components of current assets deserve separate attention: inventory management (how fast stock sells) and receivables management (how fast customers pay).

Inventory Days

Inventory days tell us how many days on average it takes to convert raw materials into sales. Lower is better — cash is freed up sooner.

$\text{Inventory Days} = \frac{\text{Inventory}}{\text{Average Daily Cost of Sales}}$

Worked example

Inventory days dropped from ~45 to ~24 — a dramatic acceleration in stock turnover.

Exam tip: Inventory days falling means the company is selling goods faster (or holding less excess stock), which typically boosts cash flow and reduces storage costs.

Receivable Days (Collection Period)

Receivable days measure how quickly the company collects cash from credit sales. Again, fewer days is better.

$\text{Receivable Days} = \frac{\text{Receivables}}{\text{Average Daily Sales}}$

Worked example

Collection period halved from ~61 days to ~30 days — a sign of tighter credit control or faster payment terms.

Relationships Between the Ratios

The asset management ratios form a natural hierarchy:

Improvements in any sub‑ratio (fixed, inventory, receivables) flow upward to boost the overall asset turnover.

Key Takeaways

• Asset Turnover = Sales ÷ Total Assets; higher means more revenue per rupee invested.
• Decompose into Fixed Asset Turnover and Current Asset Turnover to pinpoint drivers.
• Inventory Days = Inventory ÷ Daily Cost of Sales — lower is faster stock movement.
• Receivable Days = Receivables ÷ Daily Sales — lower means faster cash collection.
• In the worked example, all components improved between Year 1 and Year 2, contributing to better profitability.

Leverage Management

Leverage management examines how a company uses external funds – primarily supplier credit and debt – to magnify returns for shareholders. The core insight: borrowing can boost equity returns when the return on the borrowed funds exceeds the cost of those funds, but it can also destroy value when the opposite holds.

1. Supplier Credit and Return on Capital Employed (ROCE)

Suppliers provide goods on credit without explicit interest, though an implicit interest may be embedded in the price. This “free” financing reduces the capital a company must tie up.

• Return on Total Assets (ROTA) $\text{ROTA} = \frac{\text{PBIT}}{\text{Total Assets}}$
• Return on Capital Employed (ROCE) $\text{ROCE} = \frac{\text{PBIT}}{\text{Total Assets - Payables}}$ Capital employed = Total assets minus payables.

When payables exist, ROCE > ROTA because the denominator is smaller. The difference measures the contribution of payables to profitability.

Worked Example

$\text{ROCE Year 1} = \frac{16}{140} = 11.43\%$ $\text{ROTA Year 1} = \frac{16}{150} = 10.67\%$ Payables contribution = 11.43% – 10.67% = 0.76%

$\text{ROCE Year 2} = \frac{149}{280} = 53.21\%$ $\text{ROTA Year 2} = \frac{149}{300} = 49.67\%$ Payables contribution = 53.21% – 49.67% = 3.55%

Exam tip: ROCE is a more conservative measure of operating return because it excludes the “free” financing from payables. A widening gap between ROCE and ROTA signals increased reliance on supplier credit.

2. Debt Leverage — The Leverage Effect

Debt financing creates a leverage effect when the return on borrowed funds exceeds the interest cost. The effect is magnified by the proportion of debt in the capital structure.

Key Inputs

• Cost of Debt (interest rate) $\text{Interest Rate} = \frac{\text{Interest Expense}}{\text{Loan Value}}$
• Debt-to-Equity Ratio $\text{D/E} = \frac{\text{Loan}}{\text{Equity}}$

Computed values from the example

Spread and Leverage

Spread = ROCE – Interest Rate (cost of debt).

• Positive spread → debt adds value.
• Negative spread → debt destroys value.

Impact of debt = Spread × Debt-to-Equity ratio.

Interpretation: In Year 1 the spread was negative, but the small D/E ratio limited the damage. In Year 2, a large positive spread combined with high leverage produced a massive positive contribution.

3. Pre-Tax Return on Equity (ROE)

The pre-tax ROE reveals the combined effect of operating performance (ROCE) and debt leverage.

$\text{Pre-tax ROE} = \frac{\text{Profit Before Tax}}{\text{Equity}}$ And equivalently: $\text{Pre-tax ROE} = \text{ROCE} + \text{Leverage Effect (debt contribution)}$

Example:

Exam tip: The leverage effect is the difference between pre-tax ROE and ROCE. A high positive difference means shareholders benefit from debt; a negative difference signals financial distress risk.

4. Post-Tax Return on Equity

Governments claim a share of profit via taxes, reducing returns to equity.

$\text{Post-tax ROE} = \frac{\text{Profit After Tax}}{\text{Equity}}$

Example:

(With PAT of 9 in Year 1 and 104 in Year 2, the implied tax amounts are 2 and 25 respectively.)

5. Diagram — How Leverage Flows to Equity

Key Takeaways

• ROCE excludes supplier credit from capital employed; it is always ≥ ROTA when payables exist.
• Leverage effect = (ROCE – Interest rate) × Debt-to-Equity ratio. Positive when ROCE > cost of debt.
• Pre-tax ROE = ROCE + leverage effect. Debt can multiply returns (or losses).
• Post-tax ROE is the bottom-line return to equity holders after government’s share.
• First lesson: Do not borrow when fundamental operating profitability is weak – a negative spread, even small, is amplified by debt.

Tax Management as a Profitability Driver

Tax management is the last profitability driver. Unlike the other drivers (which assess efficiency or margin generation), tax management measures how much tax was saved relative to the statutory rate.

The statutory corporate tax rate is 30% (plus surcharges; simplified to 30% here). The actual tax rate paid is:

$\text{Actual tax rate} = \frac{\text{Income tax paid}}{\text{Pre-tax profit}}$

The tax saving (in percentage points) is the difference between the statutory rate and the actual rate:

$\text{Tax saving} = \text{Statutory rate} - \text{Actual tax rate}$

Worked Example

Interpretation:

• In Year 1, the firm paid only 18.18% tax, saving 11.82 percentage points (pp) compared to the 30% rate.
• In Year 2, the firm paid 19.38% tax, saving 10.62 pp — a smaller saving in percentage terms, but on a much larger pre‑tax profit (129 vs. 11).

Exam tip: Tax management is assessed by the actual tax rate relative to the statutory rate. A lower actual rate means more tax saved. However, a smaller saving in percentage points may still represent a large absolute saving if the profit base is large.

Key takeaways

• Tax management driver: measures tax saved, not tax paid.
• Actual tax rate = tax paid ÷ pre‑tax profit.
• Tax saving = statutory rate − actual rate.
• Lower actual rate → better tax management.
• Even a slightly lower saving rate can be valuable on a large profit base.

Short-Term Solvency Risk (Liquidity Risk)

Profitability rewards the business, but risk must be assessed. The first risk dimension is short-term solvency (liquidity) – the ability to pay dues in the near term. A supplier offering 30-day credit wants confidence the customer can pay promptly; poor liquidity means delayed or missed payment.

Current Ratio

The primary liquidity measure is the current ratio:

$\text{Current Ratio} = \frac{\text{Current Assets}}{\text{Current Liabilities}}$

where current assets = inventory + receivables + cash & bank.

Example

A current ratio of 2 or above is considered good. The decline from 6.0 to 4.5 is not a concern – both years are well above the threshold.

Why 2? – The Intuition

The "magic number 2" comes from the probability of collection required to meet liabilities.

Consider a simple trading business:

• Buy 2 units at ₹100 each → ₹200 total. Seller gives 5‑day credit for one unit only (₹100 credit), the other unit paid from own capital.
• Sell both units at ₹110 each (₹220 total) on 5‑day credit to two customers.
• End of day 1: current assets = ₹220, current liabilities = ₹100 (only the credit from one supplier). Current ratio = 2.2.
• The business repeats daily. On day 6, supplier of day 1 must be paid ₹100. Two customers from day 1 must pay ₹110 each.
• To pay ₹100, only one customer needs to pay. The probability of collection required = 1 out of 2 = 50%.

General rule: $\text{Probability of collection required} = \frac{1}{\text{Current Ratio}}$.

A current ratio of 2 implies a 50% collection probability – reasonable. Lower ratios require higher collection certainty; higher ratios imply a safety cushion.

Exam tip: The 2‑threshold is a rule of thumb, not a law. If receivables are highly certain, a lower ratio (e.g., 1.1 in the all‑credit variant of the example) can be acceptable. Always interpret the ratio in context.

Key Takeaways — Short-Term Solvency

• Current ratio = current assets ÷ current liabilities.
• A ratio ≥ 2 is conventionally good; values > 2 imply very high liquidity.
• The ratio can be interpreted as 1 / required collection probability – the higher the ratio, the lower the collection risk needed.
• Context matters: stable, certain receivables can justify lower ratios.

---

Long-Term Solvency Risk

Long-term solvency assesses the ability to meet obligations over multiple periods. Three measures are discussed: debt‑to‑equity ratio, Debt Service Coverage Ratio (DSCR), and Altman Z‑Score.

Debt‑to‑Equity Ratio

$\text{Debt-to-Equity} = \frac{\text{Total Debt}}{\text{Equity}}$

• Historically, 2:1 was considered acceptable; today investors prefer ≤ 1:1.
• But the ratio is industry‑dependent: infrastructure firms typically carry higher debt.
• No universal prescription – capital structure decisions are covered in corporate finance.

Debt Service Coverage Ratio (DSCR)

Lenders use DSCR to check if earnings can cover loan payments.

$\text{DSCR} = \frac{\text{PBDIT} - \text{Tax}}{\text{Interest} + \text{Loan Installment due}}$

where PBDIT = Profit Before Depreciation, Interest, and Taxes. Loan installment = total loan ÷ loan period (assume 5‑year repayment → 20% per year).

Worked example

A DSCR > 1 is considered adequate and good. Both years are above this threshold.

Altman Z‑Score

A credit‑scoring model that predicts the probability of corporate sickness (bankruptcy) within the near future. The Z‑score is a weighted sum of five ratios:

Each ratio is multiplied by a coefficient (fixed by Altman’s model). The sum is the Z‑score:

• Year 1 Z = 4.39
• Year 2 Z = 4.72

A Z‑score > 2.675 indicates low probability of sickness. Both years are well above this cutoff → long‑term solvency is good.

Exam tip: Remember the Z‑score threshold: 2.675. Below that signals risk; above is safe. The exact coefficients are not needed for this module – just the logic and the components.

Key Takeaways — Long-Term Solvency

• Debt‑to‑equity: ≤ 1 is current conventional guideline; industry context matters.
• DSCR: (PBDIT − tax) ÷ (interest + loan installment). Value > 1 is adequate.
• Altman Z‑Score: composite of 5 ratios; > 2.675 → healthy.
• All three measures confirm that liquidity and long‑term solvency were good in both years.

Analysis Approach: Horizontal & Trend Analysis

Two complementary methods are used to assess performance over time:

1. Horizontal (percentage) analysis – compares line items across years as percentage changes.
2. Trend analysis – examines ratios over multiple periods to detect direction.

A pre‑built template automates ratio computation: enter balance sheet and P&L data once; all ratios are generated instantly and presented in charts. This lets analysts focus on interpretation rather than calculation.

Data Entry Points (summary for comprehension – not a manual):

• Balance sheet: equity, non‑current liabilities, current liabilities, non‑current assets (tangible, intangible, financial), current assets (inventories, receivables, investments, cash).
• Income statement: revenue, other income, cost of materials, purchases, employee benefits, other expenses, depreciation, finance cost, exceptional items, taxes.
• Template automatically checks: total assets = total equity + liabilities.

Exam tip: Data entry errors are caught by verifying that total assets equal total liabilities + equity. In the worked example, 13,587.22 cr. equalled 13,587.62 cr. – a minor rounding acceptable.

---

Profitability Decomposition – The DuPont Framework

Return on Total Assets (ROTA)

$\text{ROTA} = \frac{\text{Profit Before Interest and Tax (PBIT)}}{\text{Total Assets}}$

Asian Paints ROTA improved from 23.74% (2018‑19) to 25.94% (2019‑20).

ROTA is driven by two components:

$\text{ROTA} = \text{Asset Turnover} \times \text{Profit Margin}$

Verification: 1.22 × 19.48% = 23.74%; 1.29 × 20.08% = 25.94%.

Drill‑down: Asset Turnover

Two sub‑components:

• Fixed Asset Turnover = Revenue ÷ Net Fixed Assets (excl. financial assets, capital WIP). Improved from 3.14 to 3.47 → better utilisation of plant, property, equipment.
• Current Asset Turnover = Revenue ÷ Current Assets. Improved from 2.71 to 2.95.

Within current assets, focus on:

• Inventory Days: how many days to convert inventory to sales.
  • 2018‑19: 73 days → 2019‑20: 77 days (worsening – takes 4 more days).
• Receivables (Collection) Days: how many days to collect from customers.
  • 2018‑19: 28 days → 2019‑20: 24 days (improvement).

Inventory days increase is a warning sign – the company should investigate root causes (e.g., slow‑moving stock, forecasting issues).

Drill‑down: Profit Margin (Cost Management)

The raw material saving of ~2.5 pp was partly offset by increased employee and other costs, yielding a net margin improvement of only 0.6 pp.

From ROTA to ROE: Leverage Effects

Payables Leverage: Return on Capital Employed (ROCE)

$\text{ROCE} = \frac{\text{PBIT}}{\text{Total Assets} - \text{Current Liabilities}}$

Because current liabilities (especially trade payables) reduce the denominator, ROCE is higher than ROTA. The suppliers’ credit effectively boosts returns.

The suppliers continue to contribute ~6 percentage points to profitability.

Debt Leverage: Impact on Return on Equity (ROE)

$\text{ROE} = \text{ROCE} + (\text{ROCE} - \text{Cost of Debt}) \times \frac{\text{Debt}}{\text{Equity}}$

Cost of Debt = Interest ÷ Total Borrowings.

The company borrows at a low rate (<5%) and invests in a business earning >29%, generating a positive spread. The loan effect decreased slightly because debt/equity fell.

Tax Planning Effect

Tax reduces ROE. Two ways to assess:

1. Normal tax assumption: If the company paid 30% tax on ROE (pre‑tax) of 36.46%, post‑tax ROE would be 36.46% × 0.7 = 25.52%. Actual post‑tax ROE is 28.07% → a 2.55 pp saving due to effective tax planning (probably via deferred tax).
2. Deferred tax as interest‑free loan: Deferred tax liabilities (₹282.68 cr.) as a proportion of total capital (₹13,587 cr.) = 2.08% – this is capital provided by the government without interest.

---

Risk Assessment

Liquidity: Current Ratio

$\text{Current Ratio} = \frac{\text{Current Assets}}{\text{Current Liabilities}}$

A value below 2 is normally risky, but for Asian Paints the low collection days (24 days) mean cash conversion is fast, so even 1.58 is acceptable.

Long‑Term Solvency: Debt Service Coverage Ratio (DSCR)

Very high because the company carries minimal debt (short‑term borrowing = 0 in 2019‑20). Indicates low default risk.

Integrated Risk: Altman Z‑Score

$Z = 1.2X_1 + 1.4X_2 + 3.3X_3 + 0.6X_4 + 1.0X_5$

Where:

• $X_1$ = Working Capital / Total Assets
• $X_2$ = Retained Earnings (Other Equity) / Total Assets
• $X_3$ = EBIT / Total Assets
• $X_4$ = Equity / Total Debt
• $X_5$ = Sales / Total Assets

Asian Paints 2019‑20:

Cut‑off: $Z > 2.675$ → low bankruptcy risk. 6.51 is very high → excellent long‑term solvency.

---

Key Takeaways – Profitability

• ROTA improved from 23.74% to 25.94% – driven by both better asset turnover (1.22 → 1.29) and higher profit margin (19.48% → 20.08%).
• Inventory days worsened (73 → 77); collection days improved (28 → 24). The inventory issue needs root‑cause analysis.
• Payables (supplier credit) added ~6 pp to returns (ROCE > ROTA).
• Debt leverage added ~5–6 pp to ROE; company is moving toward zero debt.
• Effective tax planning saved ~2.5 pp on post‑tax ROE.

Key Takeaways – Risk

• Current ratio improved to 1.82, acceptable given fast collection.
• DSCR very high – minimal debt.
• Z‑Score 6.51 (>>2.675) indicates robust financial health and low bankruptcy risk.

Exam tip: The Z‑score formula and its components are frequently tested. Remember the coefficients (1.2, 1.4, 3.3, 0.6, 1.0) and the interpretation: above 2.675 is safe, below 1.81 is distressed.

Inter‑Firm Comparison: Asian Paints vs. Kansai Nerolac

Why compare? A single company’s ratios over time tell part of the story. The rest comes from benchmarking against a direct competitor. This section compares Asian Paints (FY2024) with Kansai Nerolac using a standardised financial template that automatically computes ratios after data entry.

---

1. Return on Total Assets (ROA) – First Glance

$\text{ROA} = \frac{\text{Profit Before Interest \& Taxes (PBIT)}}{\text{Total Assets}}$

ROA measures how much profit the firm earns for every ₹100 invested in total assets.

Asian Paints earns more than double the return per rupee of assets. The question: where does this superior performance come from?

---

2. Decomposing ROA – The DuPont Drivers

$\text{ROA} = \frac{\text{Sales}}{\text{Total Assets}} \times \frac{\text{PBIT}}{\text{Sales}} = \text{Asset Turnover} \times \text{Profit Margin}$

The primary source of Asian Paints’ superior ROA is its much higher profit margin, not asset turnover.

---

3. Why the Profit Margin is Higher – Cost Structure

The raw material cost advantage (≈10% of sales) is the single largest driver of the profit margin gap.

Why can Asian Paints source more cheaply?

$\text{Revenue}: \text{Asian Paints } \text{Rs. }30,635 \text{ cr} \;\; \text{vs.}\;\; \text{Kansai Nerolac } \text{Rs. }7,393 \text{ cr}$

Asian Paints is ≈4× larger, giving it economies of scale in procurement – better bargaining power with suppliers.

---

4. Asset Efficiency – Going Deeper

Fixed Asset Turnover

$\text{Fixed Asset Turnover} = \frac{\text{Sales}}{\text{Fixed Assets}}$

Asian Paints uses its plant and equipment far more efficiently.

Working Capital Efficiency

Faster inventory turnover and quicker collections reduce the cash conversion cycle and improve returns on current assets.

---

5. From ROA to ROCE – The Effect of Supplier Credit

$\text{ROCE} = \frac{\text{PBIT}}{\text{Total Assets} - \text{Current Liabilities}}$

By excluding current liabilities (trade credit), ROCE shows the return on capital employed – a measure that captures the benefit of supplier financing.

Both companies benefit, but Asian Paints gets a larger boost, partly because it uses more trade credit relative to assets.

---

6. Leverage Effect – Using Debt to Boost ROE

The return on equity (ROE) can be decomposed as:

$\text{ROE} = \text{ROCE} + \underbrace{(\text{ROCE} - \text{Cost of Debt}) \times \frac{\text{Debt}}{\text{Equity}}}_{\text{Financial leverage effect}}$

Kansai Nerolac is nearly debt‑free; its leverage effect is tiny. Asian Paints uses a modest debt level (still low) to add ~5.4% to ROE.

Exam tip: The contribution of leverage depends on spread and proportion of debt. A large spread with little debt yields a small effect. Always check both.

---

7. Tax Management Impact

$\text{Tax impact} = (\text{Normal tax rate} - \text{Effective tax rate}) \times \text{whatever base?}$

Compare the actual tax paid to a 30% baseline:

Asian Paints pays a lower effective tax rate, improving after‑tax returns. Kansai’s effective rate >30% hurts profitability.

Deferred tax contributions are small for both (0.72% and 1.62% of total capital) and not material.

---

8. Liquidity & Solvency

Current Ratio

$\text{Current Ratio} = \frac{\text{Current Assets}}{\text{Current Liabilities}}$

Both assure suppliers of timely payment.

Debt Service Coverage Ratio (DSCR)

$\text{DSCR} = \frac{\text{PBDIT} - \text{Tax}}{\text{Debt service obligations}}$

Both companies are virtually debt‑free; DSCR is not a concern.

---

9. Altman Z‑Score – Predicting Bankruptcy

$Z = 1.2X_1 + 1.4X_2 + 3.3X_3 + 0.6X_4 + 1.0X_5$

Where: $X_1$ = Working Capital / Total Assets $X_2$ = Retained Earnings / Total Assets $X_3$ = PBIT / Total Assets $X_4$ = Market Value of Equity / Book Value of Debt $X_5$ = Sales / Total Assets

Cut‑off: $Z > 2.675$ → healthy, very low bankruptcy risk.

Asian Paints – Components

Kansai Nerolac – Key Driver

$Z = 17.57$ – far above cutoff. The main contributor is $X_4$: Equity/Debt ratio = 24.16, giving a weighted contribution of $24.16 \times 0.6 = 14.50$.

Why is Kansai’s Z so high? Because it has almost zero debt, the equity/debt ratio explodes, artificially inflating the Z‑score. Always compare Z against the cutoff (2.675), not against another firm’s Z when debt levels differ sharply.

Both companies are financially very healthy.

---

10. Strategic Lessons for Kansai Nerolac

If Kansai wants to benchmark itself against Asian Paints, the single most critical area is:

• Raw material cost (64.54% vs 54.88% of sales). Reducing this by ≈10 percentage points would:
  • Boost profit margin → higher ROA.
  • Cascade through leverage and tax effects → higher ROE.

Actions required:

• Purchase department: Renegotiate with suppliers.
• Operations department: Improve material usage and reduce waste.

The improvement chain:

$\text{Lower raw material cost} \rightarrow \text{Higher profit margin} \rightarrow \text{Higher ROA} \rightarrow \text{ROE improvement}$

---

Key takeaways

• Asian Paints outperforms Kansai Nerolac primarily through a higher profit margin (22.5% vs 12.5%), driven by raw material cost savings from economies of scale.
• Asset turnover differences are small; the real gap is on the cost side.
• Leverage is low for both, but Asian Paints adds ~5.4% to ROE via moderate debt (0.19 D/E).
• Both firms are highly liquid, debt‑serviced well, and far above the Altman Z‑score distress threshold.
• For Kansai Nerolac, the raw material cost is the key lever for improvement.

Infosys vs TCS: Comparative Financial Performance (Service Industry)

This analysis applies the financial-statement framework to service companies (IT firms). Unlike manufacturing, there is no inventory; the current assets are dominated by receivables and cash, and the capital structure is equity-heavy. The comparison between Infosys and Tata Consultancy Services (TCS) reveals the drivers of profitability and leverage.

Data Setup

Both companies’ financials were entered into a common template:

Note: Because both firms are largely debt-free, finance costs are negligible. The difference in current liabilities (TCS has almost twice Infosys’s) is a critical observation.

---

Profitability Analysis – Return on Total Assets (ROTA)

ROTA measures the profit generated per ₹100 of total investment:

$$\text{ROTA} = \frac{\text{PBIT}}{\text{Total Assets}}$$

Intuition: TCS earns ₹48.89 for every ₹100 invested, against Infosys’s ₹31.52. The gap is explained by the DuPont decomposition:

$$\text{ROTA} = \text{Profit Margin} \times \text{Asset Turnover}$$

Profit Margin (= EBIT / Revenue)

The difference is small (< 2 p.p.) – not the primary cause.

Asset Turnover (= Revenue / Total Assets)

Key insight: TCS generates much more revenue per rupee of asset. The main driver is the fixed asset turnover ratio:

• Fixed asset turnover: TCS = 13.53, Infosys = 9.0
• Current asset turnover: TCS = 2.13, Infosys = 1.82

Receivables (Debtors) – A Surprising Detail

Despite TCS’s better current asset turnover, its debtors turnover is worse:

TCS takes longer to collect from customers, implying that other current asset components, such as cash or other receivables, must be more efficient and drive the overall advantage.

Exam tip: When analysing service firms, ignore inventory ratios. Focus on fixed asset turnover and receivables/payables management.

Profit Margin Details – Cost Structure

The difference in classification: TCS may outsource more staff, recording them under “other expenses” rather than employee costs. Adding employee + other expenses:

• Infosys: 61.4 + 4.8 ≈ 66.2%
• TCS: 49 + 19.1 ≈ 68.1% → still slightly higher.

Thus TCS’s profit margin edge comes from very low software expenses (1.6%) and lower depreciation/finance costs.

---

Leverage Analysis – Return on Capital Employed (ROCE)

ROCE measures returns on long-term capital (equity + non-current liabilities):

TCS’s ROCE is 21 percentage points higher than its ROTA, while Infosys’s ROCE is only 5 p.p. higher. The extra boost for TCS comes from greater reliance on payables (current liabilities).

• TCS current liabilities: ₹43,061 (vs. Infosys ₹21,786)
• Trade payables: TCS = ₹14,599; Infosys = ₹2,493

TCS uses supplier credit as a cheap source of funds, improving ROCE.

Loan Effect (Trading on Equity)

The loan effect quantifies the additional return to shareholders from using debt (or any interest-bearing liability). Formula:

$$\text{Loan effect} = (\text{ROCE} - \text{Cost of debt}) \times \frac{\text{Debt}}{\text{Equity}}$$

Worked Example – TCS

• ROCE = 69.80%
• Cost of debt = 5.28%
• Debt/Equity = 0.18
• Loan effect = (69.80 – 5.28) × 0.18 = 64.52 × 0.18 = 11.40%

Thus shareholders gain an extra 11.40% from financial leverage.

Worked Example – Infosys

• ROCE = 36.71%
• Cost of debt = 1.58%
• Debt/Equity = 0.22
• Loan effect = (36.71 – 1.58) × 0.22 = 35.13 × 0.22 = 7.58%

Although Infosys uses slightly more debt (D/E 0.22 vs. 0.18), its ROCE is lower, so the absolute boost is smaller.

Exam tip: The loan effect can be positive only when ROCE > cost of debt. High leverage magnifies returns in good times but increases risk.

---

Liquidity & Solvency

Both companies have strong liquidity (current ratio > 2). The large difference in payable days (50 vs. 11) reflects TCS’s aggressive use of supplier credit.

Z-Score (Altman)

Although designed for manufacturing, computed for completeness:

• Infosys: 6.36
• TCS: 8.02

Both are well above the threshold of 2.675, indicating very low bankruptcy risk.

---

Summary of Drivers

Key Takeaways

• ROTA decomposition: TCS outperforms mainly on asset turnover (especially fixed assets), not profit margin.
• Cost structure: TCS outsources more, shifting employee costs to “other expenses” – overall cost ratio similar.
• Leverage: TCS uses payables aggressively, boosting ROCE by 21 p.p. (vs. 5 p.p. for Infosys).
• Loan effect: Both firms have positive leverage (ROCE > cost of debt), but TCS gains more absolute percentage points.
• Liquidity: Strong for both; payable days differ greatly.
• Z-score: Well above danger zone for both – long-term solvency solid.
• Framework universal for non-banking firms (manufacturing, service, trading) – but inventory ratios are replaced by receivable/payable analysis for service companies.

Scale and Data Overview

Balance sheet data (₹ crores, 2024):

Apollo is ≈4× larger in total assets but only ≈2.1× larger in revenue — early sign of asset utilisation weakness.

Return on Total Assets (ROTA)

$\text{ROTA} = \frac{\text{Net Profit}}{\text{Total Assets}}$

Narayana generates 3.25% higher return despite being smaller. Decompose into two levers:

$\text{ROTA} = \text{Asset Turnover} \times \text{Profit Margin}$

---

Asset Management (Turnover Side)

Overall Asset Turnover (Revenue / Total Assets)

• Apollo: 0.60 (₹1 asset → ₹0.60 revenue)
• Narayana: 0.97 (₹1 asset → ₹0.97 revenue)

Key insight: Apollo’s poor asset turnover is driven by:

• Low fixed asset utilisation (large asset base → insufficient revenue)
• Slow collection (41 days vs 21 days) – likely due to insurance claim processing delays.

Exam tip: Collection days are a major differentiator in hospital cash cycles. Narayana’s 21 days vs Apollo’s 41 days explains the current asset turnover gap.

---

Cost Management (Profit Margin Side)

Profit margin: Apollo higher than Narayana. Breakdown (% of revenue):

• Other expenses (repairs, electricity, insurance, rent, etc.) are the main drag on Narayana’s margin. Narayana must dissect these 20+ line items to control costs.
• Apollo’s cost management is superior overall, offsetting its asset turnover weakness.

---

Leverage Effect

$\text{ROE} = \text{ROTA} + \text{Leverage contribution (loan effect + payables effect)}$

Loan effect: $\text{Loan effect} = (\text{Return on capital} - \text{Cost of debt}) \times \text{Debt/Equity}$

• Apollo: $(14.27\% - 7.46\%) \times 0.43 = 2.96\%$ (approx)
• Narayana: $(~19.43\% - 5.26\%) \times 0.56 = ~8\%$

Narayana uses more debt at a lower cost and earns a larger spread → much higher leverage boost.

---

Tax Effect – Additional ROE Boost

Calculate hypothetical ROE if full 30% tax paid:

• Narayana: Pre-tax ROE = ~27.36% → 27.36% × 0.7 = 19.15%. Actual = 23.07%. Tax saving contributed 3.92%.
• Apollo: Pre-tax ROE = 17.23% → 17.23% × 0.7 = 12.06%. Actual = 13.1%. Tax saving contributed 1.04%.

Both benefit from tax planning; Narayana gains more.

---

Strengths and Benchmarking

• Apollo can benchmark its asset utilisation against Narayana’s 2.21× fixed asset turnover and 21-day collection.
• Narayana can benchmark its cost structure against Apollo’s 28.21% other expenses.

Key takeaways

• ROTA decomposition (asset turnover × profit margin) immediately pinpoints strategic differences.
• Collection days and fixed asset turnover are critical drivers in capital-intensive hospital industry.
• Leverage amplifies ROE when the return on capital exceeds cost of debt – Narayana exploits this better.
• Tax planning can add 1–4% to ROE; material for valuation.
• Both hospitals have room to improve by borrowing the other’s strength.

Return on Total Assets (ROTA) and Its Drivers

The return on total assets (ROTA) measures how efficiently a company generates profit from all its assets. A sharp increase from 10.67% to 49.70% between Year 1 and Year 2 signals a dramatic performance improvement.

Two profitability drivers feed into ROTA:

• Asset management – how productively assets are used (measured by asset turnover).
• Cost management – how well costs are controlled (measured by profit margin).

Asset Management: Turnover

The asset turnover ratio (revenue ÷ total assets) improved from 1.2 to 2.0. Every component of assets became more efficient:

• Inventory turnover increased (faster conversion of stock to sales).
• Receivables collection days halved (customers paid faster).

Cost Management: Profit Margin

Profit margin (net profit ÷ revenue) rose from 8.89% to 24.83%, driven by significant cost reductions.

Leverage Effects: Payables and Debt

Payables Leverage

The difference between return on capital employed (ROCE) and return on total assets captures the benefit of using suppliers’ credit (payables). An increase in payables improved overall profitability beyond what assets alone generated.

Debt Leverage (Loan Effect)

The company borrowed funds at a cost and invested them in the business to earn a higher return. The spread = ROCE – interest rate.

Exam tip: A positive spread (ROCE > interest rate) means debt amplifies shareholder returns. A negative spread destroys value. Always compute the spread before judging leverage.

Tax Management

The effective tax rate was 30% (statutory), but the company managed to reduce it to less than 20%, boosting net profit further.

Liquidity and Solvency

• Current ratio (current assets ÷ current liabilities) stayed above 2.0 in both years, indicating strong short-term liquidity.
• Debt service coverage ratio (DSCR) improved in Year 2 and exceeded the required minimum, meaning the company could comfortably meet interest and principal payments.
• Altman’s Z‑score (a bankruptcy predictor) remained above the cutoff in both years, signalling low bankruptcy risk and sound long‑term solvency.

The “Small Streams” Analogy

Most large rivers are small at the origin. When they flow through mountains, many little streams join and increase the flow. Profitability drivers are like those small streams — individually modest, but collectively they create a powerful river of performance.

Key takeaways

• ROTA = asset turnover × profit margin; both improved dramatically → 367% increase.
• Payables leverage adds to ROCE; debt leverage amplifies returns only if ROCE > interest rate.
• Effective tax management, strong liquidity (current ratio >2), and robust solvency (DSCR, Z‑score) supported the turnaround.
• The “little streams” metaphor reinforces that many small operational improvements aggregate into a giant performance leap.