Term 1 · Module 8 of 8

Assessing Business Performance through Financial Statements

Financial Statements and Business Performance

Practise this module in Claude, ChatGPT or Gemini

Set it up free
Mind map

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.

Common size %=Line itemTotal assets×100\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)

Item Year 1 (%) Year 2 (%) Change
Equity 40 45 Increase
Current liabilities 25 20 Decline
Non‑current assets 60 55 Decline (except non‑current investments)
Current assets 40 45 Slight decline

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.

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

Example – Asian Paints Ltd

Item Margin change
Other income / total income Marginally increased
Material cost / total income ↓ 2.25%
Other expenses (each) Marginally increased
Profit before tax (PBT) / total income Marginally increased
Tax expense / total income ↓ 2.9%
Profit after tax (PAT) / total income ↑ 2.33%

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

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:

Indext=VtVbase×100\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

Item Trend over base (2011 = 100)
Share capital Constant (no new equity issued)
Reserves / Other equity ~5× increase
Borrowings Gradual decline
Trade payables Increased
Other liabilities Increased
  • 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

Item Trend
Fixed assets Increased (capacity added)
Cash & bank Decreased
Inventory & receivables Increased
  • 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

Item Multiplier over base
Sales 2.84×
Profit after tax (PAT) 3.42×
Total assets 4.69×
  • 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.

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.

ROTA=Profit Before Interest and Taxes (PBIT)Total Assets\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.

Worked example: Two-year comparison

Year Total Assets PBIT ROTA
1 150 16 16150=10.67%\frac{16}{150}=10.67\%
2 300 149 149300=49.67%\frac{149}{300}=49.67\%

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:

Profitability
  • Asset Management
  • Cost Management
  • Leverage Management
    • Payables Management
    • Debt Management
  • Tax Management
  • 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 managementManaging short-term obligations to suppliers.
    • Debt managementUsing 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.

Asset Turnover=SalesTotal 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)

Year Sales Total Assets Asset Turnover Interpretation
1 ₹180 ₹150 180/150=1.20180 / 150 = 1.20 ₹1 of assets generates ₹1.20 of sales
2 ₹600 ₹300 600/300=2.00600 / 300 = 2.00 ₹1 of assets generates ₹2.00 of sales

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

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

Year Sales Fixed Assets Fixed Asset Turnover
1 ₹180 ₹90 180/90=2.00180 / 90 = 2.00
2 ₹600 ₹210 600/210=2.86600 / 210 = 2.86

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.

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

Year Sales Current Assets Current Asset Turnover
1 ₹180 ₹60 180/60=3.00180 / 60 = 3.00
2 ₹600 ₹90 600/90=6.67600 / 90 = 6.67

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.

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

Worked example

Year Inventory Cost of Sales (annual) Daily Cost of Sales Inventory Days
1 ₹20 ₹164 164/365≈0.45164 / 365 \approx 0.45 20/0.45≈44.5120 / 0.45 \approx 44.51 days
2 ₹30 ₹451 451/365≈1.24451 / 365 \approx 1.24 30/1.24≈24.2830 / 1.24 \approx 24.28 days

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

Receivable Days (Collection Period)

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

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

Worked example

Year Receivables Sales (annual) Daily Sales Receivable Days
1 ₹30 ₹180 180/365≈0.49180 / 365 \approx 0.49 30/0.49≈61.2230 / 0.49 \approx 61.22 days
2 ₹50 ₹600 600/365≈1.64600 / 365 \approx 1.64 50/1.64≈30.4950 / 1.64 \approx 30.49 days

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

Cost Management: Expense Ratios

Cost management examines how much of each rupee of sales is absorbed by operating expenses. For each cost ratio, divide an expense head by sales; the lecture considers raw material, employee cost, other expenses, depreciation, and interest. Tax is excluded because it is paid on profit.

Cost ratio=Expense headSales×100\text{Cost ratio} = \frac{\text{Expense head}}{\text{Sales}} \times 100

Cost head (% of sales) Year 1 Year 2 Change
Raw material 55.56% 50.00% Decreased by 5.56 percentage points
Employee cost 22.22% 15.00% Decreased by about 7 percentage points
Other expenses 8.33% 6.67% Decreased
Depreciation 5.00% 3.50% Decreased
Interest 2.78% 3.33% Increased with higher borrowing

Depreciation remained 10% of asset value, while depreciation as a share of sales fell from 5% to 3.5% as asset productivity improved. Overall, the company managed the major costs efficiently; together with improved asset productivity, this contributed to ROTA rising from 10.67% to 49.67%.

Relationships Between the Ratios

The asset management ratios form a natural hierarchy:

Asset TurnoverSales / Total Assets
  • Fixed Asset TurnoverSales / Fixed Assets
  • Current Asset TurnoverSales / Current Assets
    • Inventory Days (Inventory / Daily Cost of Sales)
    • Receivable Days (Receivables / Daily Sales)

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 measured asset components improved, and cost ratios also fell except for interest, 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) ROTA=PBITTotal Assets\text{ROTA} = \frac{\text{PBIT}}{\text{Total Assets}}
  • Return on Capital Employed (ROCE) ROCE=PBITTotal Assets - Payables\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

Item Year 1 Year 2
Total Assets 150 300
Payables 10 20
Capital Employed 140 280
PBIT 16 149

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

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

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) Interest Rate=Interest ExpenseLoan Value\text{Interest Rate} = \frac{\text{Interest Expense}}{\text{Loan Value}}
  • Debt-to-Equity Ratio D/E=LoanEquity\text{D/E} = \frac{\text{Loan}}{\text{Equity}}

Computed values from the example

Period Interest Expense Loan Value Interest Rate Equity D/E
Year 1 5 40 12.50% 100 0.4
Year 2 20 180 11.11% 100 1.8

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.

Period ROCE Interest Rate Spread D/E Debt Impact
Year 1 11.43% 12.50% –1.07% 0.4 –0.43%
Year 2 53.21% 11.11% +42.10% 1.8 +75.79%

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.

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

Example:

Period PBIT Interest PBT Equity Pre-tax ROE ROCE Debt Impact ROE (reconciled)
Year 1 16 5 11 100 11% 11.43% –0.43% 11.43% – 0.43% = 11%
Year 2 149 20 129 100 129% 53.21% +75.79% 53.21% + 75.79% = 129%

4. Post-Tax Return on Equity

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

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

Example:

Period PBT Tax (assumed) PAT Equity Post-tax ROE
Year 1 11 2 (implicit) 9 100 9%
Year 2 129 25 (implicit) 104 100 104%

(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:

Actual tax rate=Income tax paidPre-tax profit\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:

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

Worked Example

Year Pre‑tax profit Tax paid Profit after tax Actual tax rate Tax saving (pp)
1 11 2 9 211≈18.18%\frac{2}{11} \approx 18.18\% 30%−18.18%=11.82%30\% - 18.18\% = 11.82\%
2 129 25 104 25129≈19.38%\frac{25}{129} \approx 19.38\% 30%−19.38%=10.62%30\% - 19.38\% = 10.62\%

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).

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:

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

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

Example

Year Current Assets Current Liabilities Current Ratio
1 60 10 6.0
2 90 20 4.5

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: Probability of collection required=1Current Ratio\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.

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

Debt-to-Equity=Total DebtEquity\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.

DSCR=PBDIT−TaxInterest+Loan Installment due\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

Year PBDIT Tax PBDIT – Tax Interest Loan Amt Installment (Loan/5) Denominator DSCR
1 16 2 14 5 40 8 5+8 = 13 1.77
2 149 25 124 20 180 36 20+36 = 56 2.59

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:

Ratio Definition Year 1 Value Year 2 Value
1. Working Capital / Total Assets (Current Assets − Current Liabilities) / Total Assets (from data) (from data)
2. Retained Earnings / Total Assets Retained Earnings / Total Assets
3. Profit Before Interest & Taxes / Total Assets PBIT / Total Assets
4. Equity / Total Debt Equity / Total Debt
5. Sales / Total Assets Sales / Total Assets

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.

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.

Financial Statements and Business Performance – Asian Paints (2019‑2020)

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.

Profitability Decomposition – The DuPont Framework

Return on Total Assets (ROTA)

ROTA=Profit Before Interest and Tax (PBIT)Total Assets\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:

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

Component Formula 2018‑19 2019‑20 Change
Asset Turnover Revenue ÷ Total Assets 1.22 1.29 +0.07
Profit Margin PBIT ÷ Revenue 19.48% 20.08% +0.60 pp

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)
Cost Item (% of Revenue) 2018‑19 2019‑20 Change
Raw material cost 59.59% 57.07% –2.52 pp
Employee benefits 5.55% 5.79% +0.24 pp
Other expenses 15.89% 16.71% +0.82 pp
Depreciation (implicit) (increased) +
Finance cost (approx. same) (approx. same) 0

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)

ROCE=PBITTotal Assets−Current Liabilities\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.

ROTA ROCE Difference (supplier contribution)
2018‑19 23.74% 29.84% +6.10 pp
2019‑20 25.94% 31.39% +5.45 pp

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

Debt Leverage: Impact on Return on Equity (ROE)

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

Cost of Debt = Interest ÷ Total Borrowings.

Ratio 2018‑19 2019‑20
Debt/Equity 0.23 0.19
Cost of Debt 3.84% 4.41%
ROCE 29.84% 31.39%
Spread (ROCE – Cost of Debt) 26.00 pp 26.98 pp
Loan Effect = Spread × D/E 5.98% 5.13%
ROE (before tax) = ROCE + Loan Effect 35.82% 36.52%

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

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

2018‑19 2019‑20
1.58 1.82

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.2X1+1.4X2+3.3X3+0.6X4+1.0X5Z = 1.2X_1 + 1.4X_2 + 3.3X_3 + 0.6X_4 + 1.0X_5

Where:

  • X1X_1 = Working Capital / Total Assets
  • X2X_2 = Retained Earnings (Other Equity) / Total Assets
  • X3X_3 = EBIT / Total Assets
  • X4X_4 = Equity / Total Debt
  • X5X_5 = Sales / Total Assets

Asian Paints 2019‑20:

Component Ratio Coefficient Contribution
X1X_1 0.19 1.2 0.228
X2X_2 0.69 1.4 0.966
X3X_3 0.26 3.3 0.858
X4X_4 (Equity/Debt) 0.6 —
X5X_5 1.29 1.0 1.29
Z‑Score 6.51

Cut‑off: Z>2.675Z > 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.

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

ROA=Profit Before Interest & Taxes (PBIT)Total Assets\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.

Company ROA
Asian Paints 27.41%
Kansai Nerolac 12.96%

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

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

Driver Asian Paints Kansai Nerolac Interpretation
Asset Turnover (Sales / TA) 1.22 1.04 Asian generates ₹122 revenue per ₹100 assets vs. ₹104. Marginal advantage.
Profit Margin (PBIT / Sales) 22.48% 12.50% Huge gap: Asian keeps ₹22.48 profit per ₹100 sales vs. ₹12.50.

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

Cost Item (% of Sales) Asian Paints Kansai Nerolac Difference
Raw material 54.88% 64.54% –9.66 pp
Employee cost ~2% higher – ~2 pp
Other expenses Slightly lower – –
Depreciation Similar Similar –
Finance cost Slightly higher – –

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?

Revenue:Asian Paints Rs. 30,635 cr    vs.    Kansai Nerolac Rs. 7,393 cr\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

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

Company Ratio Meaning
Asian Paints 5.76 ₹576 revenue per ₹100 fixed assets
Kansai Nerolac 3.57 ₹357 revenue per ₹100 fixed assets

Asian Paints uses its plant and equipment far more efficiently.

Working Capital Efficiency

Metric Asian Paints Kansai Nerolac Better?
Current Asset Turnover 2.12 1.61 Asian
Inventory Days 78 days 93 days Asian (faster conversion)
Collection Days 43 days 60 days Asian (faster cash collection)

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

ROCE=PBITTotal Assets−Current Liabilities\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.

Company ROA ROCE Increase from supplier credit
Asian Paints 27.41% 32.60% +5.19 pp
Kansai Nerolac 12.96% 15.90% +2.94 pp

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:

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

Component Asian Paints Kansai Nerolac
ROCE 32.60% 15.90%
Cost of debt 3.38% 5.32%
Spread (ROCE – Kd) 29.22% 10.58%
Debt / Equity 0.19 0.04
Leverage effect 29.22% × 0.19 = +5.41% 10.58% × 0.04 = +0.44%
ROE (approx.) 38.02% 16.34%

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.


7. Tax Management Impact

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

Compare the actual tax paid to a 30% baseline:

Company Effective tax rate Impact on ROE
Asian Paints 24.69% Positive +5.31%
Kansai Nerolac 39.72% Negative –9.72%

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

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

Company Current Ratio Norm Verdict
Asian Paints 2.34 ≥ 2 Good
Kansai Nerolac 3.48 ≥ 2 Good (excessively high? Not problematic)

Both assure suppliers of timely payment.

Debt Service Coverage Ratio (DSCR)

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

Company DSCR Interpretation
Asian Paints 61.69 Very high – no debt stress
Kansai Nerolac 75.12 Extremely high – almost no debt

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


9. Altman Z‑Score – Predicting Bankruptcy

Z=1.2X1+1.4X2+3.3X3+0.6X4+1.0X5Z = 1.2X_1 + 1.4X_2 + 3.3X_3 + 0.6X_4 + 1.0X_5

Where: X1X_1 = Working Capital / Total Assets X2X_2 = Retained Earnings / Total Assets X3X_3 = PBIT / Total Assets X4X_4 = Market Value of Equity / Book Value of Debt X5X_5 = Sales / Total Assets

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

Asian Paints – Components

Component Value Weight Weighted score
X1X_1 (WC/TA) 0.32 1.2 0.38
X2X_2 (RE/TA) 0.71 1.4 0.99
X3X_3 (PBIT/TA) 0.27 3.3 0.89
X4X_4 (Equity/Debt) 5.4 0.6 3.24
X5X_5 (Sales/TA) 1.19 1.0 1.19
Total Z 6.70

Kansai Nerolac – Key Driver

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

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:

Lower raw material cost→Higher profit margin→Higher ROA→ROE improvement\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:

Item (₹ crore) Infosys TCS
Shareholders’ funds 72,120 81,176
Non-current liabilities ~6,000 6,688
Current liabilities 21,786 43,061
Total capital & liabilities 1,14,950 1,21,148
Fixed assets 14,604 16,403
Current assets (inventory = 0) (inventory = 0)
Revenue 1,36,350 2,09,632
Employee expenses 83,777 –
Other expenses 6,508 40,026
EBIT – –
Finance cost very low very low
Profit after tax – –

Profitability Analysis – Return on Total Assets (ROTA)

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

ROTA=PBITTotal Assets\text{ROTA} = \frac{\text{PBIT}}{\text{Total Assets}}
Company ROTA (%)
Infosys 31.52
TCS 48.89

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

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

Profit Margin (= EBIT / Revenue)

Company Profit Margin (%)
Infosys 26.57
TCS 28.26

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

Asset Turnover (= Revenue / Total Assets)

Company Asset Turnover (₹ revenue per ₹ asset)
Infosys 1.19
TCS 1.73

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:

Metric Infosys TCS
Debtors collection period (days) 71 83

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.

Profit Margin Details – Cost Structure

Expense ratio (% of revenue) Infosys TCS
Employee expenses ~61.4% ~49%
Software/outsourcing – ~1.6%
Other expenses ~4.8% ~19.1%

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):

Company ROCE (%)
Infosys 36.71
TCS 69.80

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:

Loan effect=(ROCE−Cost of debt)×DebtEquity\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.


Liquidity & Solvency

Metric Infosys TCS
Current ratio 2.62 2.2
Debt service coverage very high very high
Payable days 11 days 50 days

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.

Hospital Industry: Apollo vs Narayana Hrudyalaya

Scale and Data Overview

Balance sheet data (₹ crores, 2024):

Metric Apollo Hospital Narayana Hrudyalaya
Total funds employed 13,702 6,664
Total non-current assets 87,301 27,145
Total current assets 36,751 7,781
Total assets 1,24,052 34,927
Revenue ~2.1× Narayana’s revenue –

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)

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

Company ROTA
Apollo 12.72%
Narayana 15.97%

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

ROTA=Asset Turnover×Profit Margin\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)
Ratio Apollo Narayana
Fixed asset turnover 1.21 2.21
Current asset turnover ~2.0 ~4.2
Inventory days 8 days 8 days
Collection days (receivables) 41 days 21 days

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.

Cost Management (Profit Margin Side)

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

Cost component Apollo Narayana Difference
Raw materials (consumables) 27.48% 24.18% Apollo spends 3.3% more
Employee costs ~20% ~21% ±1%
Other expenses 28.21% ~39% Δ ≈ 11%
Depreciation (savings) – slightly lower –
  • 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

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

Metric Apollo Narayana
Debt-equity ratio 0.43 0.56
Cost of borrowing 7.46% 5.26%
ROTA 12.72% 15.97%
Pre-tax ROE 17.23% ~27%
Post-tax ROE 13.1% 23.07%

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

  • Apollo: (14.27%−7.46%)×0.43=2.96%(14.27\% - 7.46\%) \times 0.43 = 2.96\% (approx)
  • Narayana: ( 19.43%−5.26%)×0.56= 8%(~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.

Financial Statement Analysis Summary: Assessing Business Performance (Module 8)

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 managementhow productively assets are used (measured by asset turnover).
  • Cost managementhow 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 (PBIT ÷ sales) rose from 8.89% to 24.83%, driven by significant cost reductions.

Metric Year 1 Year 2 Improvement
Return on total assets 10.67% 49.70% +39.03 pp
Asset turnover 1.20 2.00 +0.80
Profit margin 8.89% 24.83% +15.94 pp

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.

Year ROCE Interest rate Spread Impact on shareholders
1 Negative spread > ROCE Negative Little contribution
2 Increased Fixed Positive and large 76% incremental return to shareholders

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.
Revise before your examAll 16 exam tips from this module in one list
  1. 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.
  2. 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.
  3. Always ensure numerator and denominator represent the same stakeholder group. For ROTA, the numerator is PBIT, not PAT.
  4. Inventory days falling means the company is selling goods faster (or holding less excess stock), which typically boosts cash flow and reduces storage costs.
  5. 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.
  6. 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.
  7. 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.
  8. 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.
  9. 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.
  10. 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.
  11. 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.
  12. The contribution of leverage depends on spread and proportion of debt. A large spread with little debt yields a small effect. Always check both.
  13. When analysing service firms, ignore inventory ratios. Focus on fixed asset turnover and receivables/payables management.
  14. The loan effect can be positive only when ROCE > cost of debt. High leverage magnifies returns in good times but increases risk.
  15. 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.
  16. A positive spread (ROCE > interest rate) means debt amplifies shareholder returns. A negative spread destroys value. Always compute the spread before judging leverage.

Test yourself on this module

Questions from these notes, one at a time, with feedback. Your weak topics are saved.

Set it up free Takes about a minute. Free plans work.