Financial Statement Analysis (COM3MN204) — Module 2: Ratio Analysis

• Module II: Ratio Analysis CURRICULAR SCOPE & ANALYTICAL BLUEPRINT COM3MN204 • Module II
• Core Competency Focus: This module delivers an advanced, rigorous examination of Financial Ratio Analysis as the primary diagnostic tool in managerial accounting and financial appraisal. It examines the theoretical foundations, definitive objectives, utility, and inherent constraints of ratio analysis; details the functional classification across Liquidity, Profitability, Turnover (Activity/Efficiency), and Leverage (Solvency) ratios; and provides extensive mathematical formulations, industry normative benchmarks,

DuPont decomposition models, and comprehensive numerical case studies.

1. Conceptual: Foundation of Financial Ratio Analysis 1.1 Meaning and Definitive Scope A financial ratio is a mathematical expression that quantifies the relationship between two interrelated accounting figures or items extracted from the balance sheet, the statement of profit and loss, or both. Ratio analysis is the technique of calculating, analyzing, and interpreting these numerical relationships to evaluate the operational performance, financial health, earning capacity, and risk profile of an enterprise.

An isolated accounting figure in a financial statement (such as a Net Profit of Rs. 50 Lakhs or Current Assets of Rs. 100 Lakhs) conveys limited managerial insight unless evaluated in relation to associated dimensions (such as the total capital employed, sales volume, or current liabilities). By establishing a proportional relationship, ratio analysis converts raw accounting metrics into relative indicators that facilitate meaningful comparison across time (intra-firm) and across different corporate entities (inter-firm).

According to J. Batty: "Ratio analysis is a technique of analysis and interpretation of financial statements to bring out the strengths and weaknesses of a firm, its historical performance, and current financial condition." In the words of Kennedy and McMullen: "The relationship of one item to another expressed in simple mathematical terms is known as a ratio. The analysis of these relationships is an indispensable tool for interpreting financial statements." 1.2 Modes of Expressing Financial Ratios Financial ratios are mathematically expressed in three distinct forms depending on the underlying analytical convention:

1. Pure: Ratio / Proportion Expressed as a simple quotient showing the direct relationship between two numbers, conventionally reduced to a base of 1.

• Example: Current Ratio = 2:1, Debt-to-Equity Ratio = 1.5:1,

Quick Ratio = 1.2:1.

1. Rate /: Turnover (Times) Expressed as the number of times a certain financial flow occurs relative to a specific asset or liability base during an accounting period.

• Example: Inventory Turnover = 6 Times, Debtors Turnover = 8 Times, Interest Coverage = 4.5 Times.

3. Percentage (%) Expressed as parts per hundred by multiplying the resulting fraction by 100, widely used for measuring margins and investment returns.

• Example: Gross Profit Margin = 25%, Net Profit Margin = 12%,

Return on Capital Employed = 18%. 1.3 Core Objectives of Ratio Analysis Ratio analysis serves multiple analytical and managerial objectives across the corporate decision-making hierarchy:

• Diagnostic Evaluation of Liquidity: Assessing whether the firm maintains sufficient liquid resources to settle short-term maturing obligations as they fall due, thereby preventing technical insolvency.

Measurement of Long-Term Solvency & Financial Risk: Examining the capital structure gearing and the enterprise's ability to service long-term debt commitments and contractual interest charges over extended horizons.

• Appraisal of Operational Efficiency: Determining how effectively and productively corporate resources, plant assets, inventories, and receivables are being deployed to generate revenue.

Assessment of Profitability & Value Creation: Measuring the ultimate earning power of the business relative to sales, total assets, and shareholders' equity investment.

Inter-Firm and Intra-Firm Comparative Benchmarking: Normalizing financial data to eliminate scale disparities, enabling objective comparisons between competing firms of unequal size or tracking historical trends within a single firm.

Financial Forecasting and Budgetary Planning: Providing empirical baselines that enable management to construct pro-forma financial statements, cash budgets, and strategic capital expenditure plans. 1.4 Utility to Diverse Stakeholder Groups Different economic constituents focus on specific clusters of financial ratios based on their contractual relationship with the firm:

• Management: Relies on Activity Ratios (inventory velocity, collection periods) and Profitability Ratios (ROCE, operating margins) to identify cost leakages, optimize asset allocation, and implement corrective operational controls.
• Commercial Banks and Short-Term Creditors: Scrutinize Liquidity Ratios (Current Ratio, Quick Ratio,

Cash Ratio) to assess working capital adequacy and default risk on short-term trade credit or credit facilities.

• Long-Term Lenders and Debenture Trustees: Emphasize Leverage and Coverage Ratios (Debt-Equity,

Interest Coverage, DSCR) to ensure capital protection and interest service stability.

• Equity Investors and Market Analysts: Scrutinize Return on Equity (ROE), Earnings Per Share (EPS), Priceto-Earnings (P/E), Dividend Yield, and DuPont decomposition to project future earnings growth and equity returns. 1.5 Inherent Limitations and Analytical Pitfalls of Ratio Analysis While ratio analysis is an indispensable tool, an uncritical or mechanical reliance on ratios without qualitative context can lead to misleading conclusions due to several inherent constraints:

Inherent Defects of Underlying Financial Records: Ratios are derived mathematical calculations; they cannot be more reliable than the financial statements from which they originate. If base statements reflect historical cost distortions or aggressive accounting choices, the calculated ratios will reflect those same distortions.

Vulnerability to Price-Level Changes (Inflation): Ratios that combine historical balance sheet figures (recorded at acquisition costs years earlier) with current statement of profit and loss figures (measured in present purchasing power) produce distorted efficiency and profitability metrics (e.g., Return on Capital Employed appears artificially inflated during periods of high inflation).

• Vulnerability to Window Dressing: Corporate management can artificially improve balance sheet ratios immediately prior to the fiscal year-end through cosmetic adjustments, such as delaying inventory purchases, holding the cash book open, or taking temporary short-term loans to inflate liquid assets.
• Differences in Accounting Policies: Inter-firm ratio comparisons are often compromised by divergent accounting treatments, such as Straight-Line Method vs. Written-Down Value for depreciation, or FIFO vs.

Weighted Average for inventory valuation. Absence of Universal Normative Standards: Aside from general rules of thumb (e.g., 2:1 for Current Ratio or 1:1 for Quick Ratio), there are no universally valid standards. What constitutes an optimal ratio varies significantly depending on industry structure, capital intensity, and business models.

• Symptoms Rather than Root Causes: Ratios are diagnostic indicators rather than definitive explanations.

A declining inventory turnover highlights an operational issue, but it does not specify whether the root cause is poor product quality, pricing misalignments, distribution bottlenecks, or weak customer demand.

1. Classification: Framework of Financial Ratios Financial ratios are traditionally classified based on the source statements from which data is drawn, and functionally classified based on the underlying economic dimension being analyzed.

Traditional (Statement-Based) Classification

• Balance Sheet Ratios: Relationships between two items appearing exclusively on the balance sheet (e.g., Current Ratio, DebtEquity Ratio, Proprietary Ratio).
• Revenue / P&L Ratios: Relationships between two items appearing exclusively in the statement of profit and loss (e.g., Gross Profit Ratio, Operating Ratio, Net Profit Ratio).
• Composite / Inter-Statement Ratios: Relationships linking an item from the statement of profit and loss with an item from the balance sheet (e.g., Inventory Turnover, Return on Capital Employed,

Debtors Turnover). Functional (Modern Analytical) Classification

1. Liquidity: Ratios: Evaluate short-term solvency and immediate debt-paying ability.
2. Leverage /: Solvency Ratios: Evaluate capital structure health, long-term solvency, and debt servicing.
3. Activity /: Turnover Ratios: Measure the operational velocity and efficiency of asset utilization.
4. Profitability: Ratios: Measure earnings performance relative to sales, capital, and equity.
5. Liquidity: Ratios: Short-Term Solvency Assessment Liquidity ratios measure the enterprise's capacity to settle its current maturing obligations (maturing within one year or one operating cycle) without liquidating productive fixed capital or interrupting routine commercial operations. 3.1 Current Ratio (Working Capital Ratio) The Current Ratio measures the proportion of current assets available to satisfy each rupee of current liabilities. It serves as the primary general test of short-term financial strength.

• Current Ratio Formula: Current Ratio = Current Assets ÷ Current Liabilities Where:
• Current Assets = Cash & Bank Balances + Short-Term Marketable Investments + Trade Receivables (Debtors − Provision for Bad Debts + Bills Receivable) + Inventories (Raw Materials, WIP, Finished Goods,

Stores) + Short-Term Loans & Advances + Prepaid Expenses + Accrued Incomes.

• Current Liabilities = Trade Payables (Creditors + Bills Payable) + Short-Term Borrowings (Bank Overdraft,

Cash Credit) + Outstanding / Accrued Expenses + Unearned Incomes + Short-Term Provisions (Tax,

Dividends) + Current Maturities of Long-Term Debt. Normative Benchmark & Managerial Interpretation:

The widely accepted normative rule-of-thumb benchmark is 2:1 (i.e., Rs. 2.00 of current assets for every Rs. 1.00 of current liabilities). This provides a 50% margin of safety against potential shrinkages in the liquidation value of current assets (such as slow-moving inventories or bad debt write-offs).

A very high current ratio (e.g., 4:1 or 5:1) is not necessarily a sign of optimal management; it often indicates inefficient asset deployment, such as excessive idle cash, bloated inventories, or lax credit collection policies.

A low current ratio (e.g., below 1.2:1) signals potential liquidity constraints, vulnerability to cash shortages, and risk of defaulting on vendor payments. 3.2 Quick Ratio / Acid-Test Ratio / Liquid Ratio The Quick Ratio provides a more rigorous test of immediate liquidity by excluding assets that cannot be converted into cash rapidly without substantial loss of value.

• Quick Ratio Formula: Quick Ratio = Quick Assets (Liquid Assets) ÷ Current Liabilities (or Liquid Liabilities) Where:
• Quick Assets = Current Assets − Inventories − Prepaid Expenses − Advance Tax.
• Rationale for Deductions: Inventories require time to be sold and collected as cash, and may suffer price discounts upon forced liquidation. Prepaid expenses represent future cost absorptions that cannot be converted into liquid cash to pay creditors.
• Normative Benchmark: The standard rule-of-thumb benchmark for the Quick Ratio is 1:1. A ratio of 1:1 indicates that the firm possesses Rs. 1.00 of liquid assets for every Rs. 1.00 of current obligations, providing immediate solvency protection. 3.3 Absolute Cash Ratio / Super-Quick Ratio The Absolute Cash Ratio evaluates the enterprise's immediate cash solvency by examining only cash and near-cash balances, excluding receivables that require collection efforts.
• Absolute Cash Ratio Formula: Absolute Cash Ratio = [ Cash in Hand + Cash at Bank + Short-Term Marketable Securities ] ÷ Current Liabilities
• Normative Benchmark: An absolute cash ratio of 0.5:1 (or 50%) is generally considered sound, indicating that the firm can satisfy 50% of its current obligations immediately from readily available funds.

1. Profitability: Ratios: Operational & Investment Yield Profitability ratios assess the ultimate economic efficiency of the enterprise. They evaluate the firm's capacity to generate operating margins from sales and provide adequate returns on capital deployed. 4.1 Sales-Related Profitability Ratios Ratio Name Mathematical Formula Managerial Significance & Interpretation Gross Profit Ratio (Gross Margin) [ Gross Profit ÷ Net Revenue from Operations ] × 100 Where Gross Profit = Net Sales − COGS Measures the basic margin between production cost and selling price.

Indicates pricing power, manufacturing efficiency, and capacity to absorb operating overheads.

Operating Ratio [ (COGS + Operating Expenses) ÷ Net Revenue ] × 100 Where Operating Expenses = Admin + Selling Overheads Measures the percentage of revenue absorbed by core operating costs. A lower operating ratio indicates higher operational efficiency and wider operating margins.

Operating Profit Ratio [ Operating Profit (EBIT) ÷ Net Revenue ] × 100

• Note: Operating Ratio + Operating Profit Ratio = 100% Measures pure operational profitability before financing costs, tax liabilities, and non-operating windfalls.

Net Profit Ratio (Net Margin) [ Net Profit After Tax (PAT) ÷ Net Revenue ] × 100 Measures the final bottom-line profitability available to owners per rupee of revenue generated, after accounting for all expenses, interest, and taxes. 4.2 Capital-Related Profitability & Investment Return Ratios

1. Return on: Capital Employed (ROCE) / Return on Investment (ROI):

ROCE = [ Earnings Before Interest and Taxes (EBIT) ÷ Capital Employed ] × 100 Where:

• Capital Employed (Liabilities Approach) = Equity Share Capital + Preference Share Capital + Reserves & Surplus + Long-Term Debts − Fictitious Assets.
• Capital Employed (Assets Approach) = Net Fixed Assets + Long-Term Investments + Net Working Capital (Current Assets − Current Liabilities).
• Managerial Note: ROCE measures overall business productivity independent of capital structure financing choices.

1. Return on: Equity (ROE) / Return on Net Worth (RONW):

ROE = [ (Net Profit After Tax − Preference Dividends) ÷ Shareholders' Equity (Net Worth) ] × 100

• Where: Net Worth = Equity Share Capital + Reserves & Surplus − Accumulated Losses & Fictitious Assets.
• Significance: Measures the rate of return earned on the funds provided by equity shareholders.

1. Earnings: Per Share (EPS): EPS = [ Net Profit After Tax − Preference Share Dividends ] ÷ Number of Outstanding Equity Shares
2. Price-Earnings (P/E): Ratio: P/E Ratio = Market Price Per Share (MPS) ÷ Earnings Per Share (EPS)
3. Dividend: Payout Ratio (DPR) & Dividend Yield:

• Dividend Payout Ratio = [ Dividend Per Share (DPS) ÷ EPS ] × 100
• Dividend Yield = [ Dividend Per Share (DPS) ÷ Market Price Per Share (MPS) ] × 100 4.3 The DuPont Analysis System (Three-Stage Model) The DuPont model decomposes Return on Equity (ROE) into three distinct drivers, isolating whether equity returns stem from operating profitability, asset efficiency, or financial leverage:

Return on Equity (ROE) = [ Net Profit Margin ] × [ Asset Turnover ] × [ Equity Multiplier ] Where:

1. Net: Profit Margin = Net Profit After Tax ÷ Net Sales (Operating Efficiency)
2. Asset: Turnover = Net Sales ÷ Total Assets (Asset Use Efficiency)
3. Equity: Multiplier = Total Assets ÷ Shareholders' Equity (Financial Leverage)
4. Activity &: Turnover Ratios: Operational Efficiency Assessment Activity ratios measure the speed and efficiency with which an enterprise converts its balance sheet asset investments into cash or sales revenue. They indicate whether capital is actively productive or tied up in idle inventories and uncollected receivables. 5.1 Inventory Turnover Ratio (Stock Turnover Ratio) The Inventory Turnover Ratio measures how many times inventory is sold and replaced during an accounting period.

• Inventory Turnover Ratio Formula: Inventory Turnover Ratio = Cost of Goods Sold (COGS) ÷ Average Inventory Where:
• Cost of Goods Sold = Opening Stock + Net Purchases + Direct Expenses − Closing Stock (or Net Sales − Gross Profit).
• Average Inventory = [ Opening Stock + Closing Stock ] ÷ 2.
• Inventory Holding Period (Days/Months): Inventory Holding Period = [ 365 Days (or 12 Months) ] ÷ Inventory Turnover Ratio
• Managerial Interpretation: A high inventory turnover ratio indicates brisk sales velocity, efficient inventory control, and reduced holding costs. A low inventory turnover ratio signals overstocking, sluggish sales demand, product obsolescence, and increased carrying costs. 5.2 Trade Receivables Turnover Ratio (Debtors Turnover Ratio) This ratio measures the efficiency with which a firm collects cash from customers on credit sales.
• Receivables Turnover Ratio Formula: Receivables Turnover Ratio = Net Credit Sales ÷ Average Trade Receivables Where:
• Net Credit Sales = Total Gross Sales − Cash Sales − Sales Returns.
• Average Trade Receivables = [ (Opening Debtors + Opening Bills Receivable) + (Closing Debtors + Closing Bills Receivable) ] ÷ 2.

Average Collection Period (ACP / Days Sales Outstanding - DSO):

Average Collection Period = [ 365 Days ÷ Receivables Turnover Ratio ] or: [ Average Trade Receivables ÷ Net Credit Sales ] × 365 Days

• Managerial Interpretation: The Average Collection Period reflects the average number of days it takes for credit customers to pay their invoices. If a firm offers 30-day credit terms but the calculated collection period is 75 days, it indicates lax credit appraisal, inefficient collection procedures, or customer disputes. 5.3 Trade Payables Turnover Ratio (Creditors Turnover Ratio) This ratio measures the speed with which the firm settles its accounts with trade suppliers.
• Payables Turnover Ratio Formula: Payables Turnover Ratio = Net Credit Purchases ÷ Average Trade Payables Where:
• Average Trade Payables = [ (Opening Creditors + Opening Bills Payable) + (Closing Creditors + Closing Bills Payable) ] ÷ 2.

Average Payment Period (APP / Days Payables Outstanding - DPO):

Average Payment Period = [ 365 Days ÷ Payables Turnover Ratio ]

• Managerial Interpretation: An extended payment period allows the firm to use trade credit as a source of interest-free working capital. However, excessive delays can damage supplier relationships, forfeit earlypayment cash discounts, and risk restricted credit terms. 5.4 Working Capital Turnover and Fixed Assets Turnover

1. Working: Capital Turnover Ratio: Working Capital Turnover = Net Revenue from Operations ÷ Net Working Capital (Current Assets − Current Liabilities)
2. Fixed: Assets Turnover Ratio: Fixed Assets Turnover = Net Revenue from Operations ÷ Net Fixed Assets (PPE less Depreciation)
3. Total: Capital Turnover Ratio: Total Capital Turnover = Net Revenue from Operations ÷ Capital Employed
4. Leverage &: Solvency Ratios: Capital Structure Assessment Leverage (capital structure) ratios evaluate the long-term financial stability of the enterprise. They measure the proportion of debt financing relative to equity, as well as the firm's capacity to service interest payments and repay principal obligations. 6.1 Debt-to-Equity Ratio The Debt-to-Equity Ratio quantifies the relative proportions of capital provided by external creditors and long-term lenders compared to that provided by equity shareholders.

• Debt-to-Equity Ratio Formula: Debt-to-Equity Ratio = Total Long-Term Debt ÷ Shareholders' Funds (Net Worth) Where:
• Long-Term Debt (External Borrowed Funds) = Debentures, Long-Term Bank Loans, Mortgages, Bonds.
• Shareholders' Funds (Net Worth) = Equity Share Capital + Preference Share Capital + Reserves & Surplus − Accumulated Losses / Fictitious Assets.

Normative Benchmark & Financial Implications: The standard normative benchmark in manufacturing and industrial sectors is 2:1 (or in certain contexts 1:1). A ratio of 2:1 indicates that creditors provide Rs. 2.00 of debt capital for every Rs. 1.00 of internal equity capital.

A high debt-to-equity ratio (high financial gearing) amplifies equity returns during periods of economic expansion because borrowed funds generate higher returns than the fixed interest cost (trading on equity). However, during economic downturns, fixed interest charges can strain liquidity and increase financial distress risk.

A low debt-to-equity ratio (conservative gearing) provides safety against insolvency and affords greater borrowing flexibility, but may indicate under-utilized borrowing capacity. 6.2 Proprietary Ratio and Debt-to-Total-Assets Ratio

1. Proprietary: Ratio: Proprietary Ratio = Shareholders' Funds (Net Worth) ÷ Total Tangible Assets

• Significance: Measures the proportion of total enterprise assets funded by internal equity. A higher ratio indicates stronger long-term financial independence from external lenders.

1. Debt to: Total Assets Ratio: Debt to Total Assets = Total External Debt (Long-Term + Short-Term) ÷ Total Tangible Assets 6.3 Capital Gearing Ratio The Capital Gearing Ratio evaluates the relationship between fixed-cost capital (debt and preference capital) and variable-cost capital (equity funds).

• Capital Gearing Ratio Formula: Capital Gearing Ratio = [ Long-Term Debt + Debentures + Preference Share Capital ] ÷ [ Equity Share Capital + Reserves & Surplus − Accumulated Losses ]
• Highly Geared: If fixed-cost funds exceed equity funds (ratio > 1:1).
• Low Geared: If equity funds exceed fixed-cost funds (ratio < 1:1). 6.4 Coverage Ratios: Debt-Servicing Capacity

1. Interest: Coverage Ratio (Times Interest Earned - TIE):

Interest Coverage Ratio = Earnings Before Interest and Taxes (EBIT) ÷ Fixed Annual Interest Charges

• Normative Standard: A benchmark of 6 to 7 times is generally considered healthy. A coverage below 2 times indicates vulnerability to operating downturns and higher default risk.

1. Debt: Service Coverage Ratio (DSCR): DSCR = [ Net Profit After Tax + Depreciation + Non-Cash Write-offs + Annual Interest ] ÷ [ Annual Interest Charges + Annual Principal Debt Installment ]

• Banking Standard: Commercial banks and financial institutions evaluate DSCR when appraising project finance term loans; a benchmark of 1.5 to 2.0 times is typically required.

1. Exhaustive: Numerical Demonstrations & Worked Practical Case Studies PRACTICAL CASE 1: Comprehensive Liquidity & Working Capital Audit

• Context: Bharat Engineering Ltd. extracts the following balances from its accounting ledgers as of 31st March 2025:
• Inventories: Rs. 2,40,000; Trade Receivables (Debtors): Rs. 1,60,000; Bills Receivable: Rs. 40,000; Cash in Hand: Rs. 35,000; Cash at Bank: Rs. 65,000; Marketable Current Investments: Rs. 50,000; Prepaid Insurance: Rs. 10,000;
• Advance Tax: Rs. 20,000; Trade Payables (Sundry Creditors): Rs. 1,50,000; Bills Payable: Rs. 50,000; Bank
• Overdraft: Rs. 40,000; Outstanding Salaries: Rs. 20,000; Short-Term Provision for Tax: Rs. 40,000.
• Required: Compute (a) Current Ratio, (b) Quick Ratio, (c) Absolute Cash Ratio, (d) Net Working Capital, and provide an analytical commentary on short-term liquidity.

Classification of Assets Classification of Liabilities Current Assets:

• Inventories: Rs. 2,40,000
• Trade Receivables (1,60,000 + 40,000): Rs. 2,00,000
• Cash & Bank Balances (35,000 + 65,000): Rs. 1,00,000
• Marketable Current Investments: Rs. 50,000
• Prepaid Insurance & Advance Tax: Rs. 30,000 Total Current Assets = Rs. 6,20,000 Current Liabilities:
• Trade Payables (1,50,000 + 50,000): Rs. 2,00,000
• Bank Overdraft: Rs. 40,000
• Outstanding Salaries: Rs. 20,000
• Provision for Tax: Rs. 40,000 Total Current Liabilities = Rs. 3,00,000 Step-by-Step Mathematical Calculations:

1. Current: Ratio: Current Ratio = Current Assets ÷ Current Liabilities = Rs. 6,20,000 ÷ Rs. 3,00,000 = 2.07 : 1
2. Quick: Ratio: Quick Assets = Total Current Assets − Inventories − Prepaid Insurance − Advance Tax Quick Assets = Rs. 6,20,000 − Rs. 2,40,000 − Rs. 10,000 − Rs. 20,000 = Rs. 3,50,000 Quick Ratio = Quick Assets ÷ Current Liabilities = Rs. 3,50,000 ÷ Rs. 3,00,000 = 1.17 : 1
3. Absolute: Cash Ratio: Absolute Cash Assets = Cash + Bank + Marketable Investments = Rs. 1,00,000 + Rs. 50,000 = Rs. 1,50,000 Absolute Cash Ratio = Rs. 1,50,000 ÷ Rs. 3,00,000 = 0.50 : 1
4. Net: Working Capital: Net Working Capital = Current Assets − Current Liabilities = Rs. 6,20,000 − Rs. 3,00,000 = Rs. 3,20,000

• MANAGERIAL DIAGNOSIS: BHARAT ENGINEERING LTD. Liquidity Appraisal The company exhibits sound short-term liquidity across all three tests:

The Current Ratio of 2.07:1 meets the standard 2:1 benchmark, providing an adequate safety buffer.

The Quick Ratio of 1.17:1 exceeds the 1:1 threshold, confirming that the firm can meet immediate commitments even without liquidating inventory.

The Absolute Cash Ratio of 0.50:1 meets standard liquidity norms, with 50% of current obligations covered by readily available cash and marketable securities.

PRACTICAL CASE 2: Operational Efficiency, Working Capital Turnover & Cash Conversion Cycle

• Context: Pioneer Manufacturing Ltd. provides the following operating data for the year ended 31st March 2025:
• Total Sales (Revenue): Rs. 24,00,000 (of which 20% is cash sales); Gross Profit Margin: 25% on Sales; Opening
• Inventory: Rs. 2,80,000; Closing Inventory: Rs. 3,20,000; Opening Trade Receivables: Rs. 2,10,000; Closing Trade
• Receivables: Rs. 2,70,000; Total Purchases: Rs. 18,40,000 (of which Rs. 2,40,000 is cash purchases); Opening
• Trade Payables: Rs. 1,80,000; Closing Trade Payables: Rs. 2,20,000. Take 1 Year = 360 Days.
• Required: Compute (a) Inventory Turnover Ratio & Holding Period, (b) Receivables Turnover Ratio & Average Collection Period, (c) Payables Turnover Ratio & Average Payment Period, and (d) Cash Conversion Cycle (Operating Cycle).

Step-by-Step Computational Process:

1. Cost of: Goods Sold (COGS) & Inventory Metrics:

• Gross Profit = 25% of Rs. 24,00,000 = Rs. 6,00,000
• COGS = Sales − Gross Profit = Rs. 24,00,000 − Rs. 6,00,000 = Rs. 18,00,000
• Average Inventory = [ Rs. 2,80,000 + Rs. 3,20,000 ] ÷ 2 = Rs. 3,00,000
• Inventory Turnover Ratio = COGS ÷ Average Inventory = Rs. 18,00,000 ÷ Rs. 3,00,000 = 6.00 Times
• Inventory Holding Period = 360 Days ÷ 6.00 = 60 Days

1. Receivables: Turnover & Collection Velocity:

• Net Credit Sales = Total Sales − Cash Sales (20%) = Rs. 24,00,000 − Rs. 4,80,000 = Rs. 19,20,000
• Average Trade Receivables = [ Rs. 2,10,000 + Rs. 2,70,000 ] ÷ 2 = Rs. 2,40,000
• Receivables Turnover Ratio = Credit Sales ÷ Average Receivables = Rs. 19,20,000 ÷ Rs. 2,40,000 = 8.00 Times
• Average Collection Period (DSO) = 360 Days ÷ 8.00 = 45 Days

1. Payables: Turnover & Payment Velocity:

• Net Credit Purchases = Total Purchases − Cash Purchases = Rs. 18,40,000 − Rs. 2,40,000 = Rs. 16,00,000
• Average Trade Payables = [ Rs. 1,80,000 + Rs. 2,20,000 ] ÷ 2 = Rs. 2,00,000
• Payables Turnover Ratio = Credit Purchases ÷ Average Payables = Rs. 16,00,000 ÷ Rs. 2,00,000 = 8.00 Times
• Average Payment Period (DPO) = 360 Days ÷ 8.00 = 45 Days

1. Cash: Conversion Cycle (Operating Working Capital Cycle):

Gross Operating Cycle = Inventory Holding Period + Average Collection Period = 60 Days + 45 Days = 105 Days Net Cash Conversion Cycle = Gross Operating Cycle − Average Payment Period = 105 Days − 45 Days = 60 Days

• OPERATIONAL DIAGNOSTIC FINDINGS: PIONEER MANUFACTURING LTD.

Turnover Audit The enterprise converts raw inputs into finished sales in 60 days and collects credit receivables in 45 days, creating a Gross Operating Cycle of 105 days. Suppliers finance 45 days of this cycle through trade credit terms, leaving a Net Cash Conversion Cycle of 60 days that requires internal working capital or shortterm bank financing.

PRACTICAL CASE 3: Capital Structure Gearing, Long-Term Solvency & Debt Service Coverage

• Context: National Heavy Industries Ltd. presents the following condensed financial profile:

Equity Share Capital (Rs. 10 per share): Rs. 8,00,000; 10% Preference Share Capital: Rs. 2,00,000; Reserves and

• Surplus: Rs. 6,00,000; 12% Secured Debentures: Rs. 10,00,000; 11% Term Loan from IDBI: Rs. 6,00,000; Current
• Liabilities: Rs. 4,00,000; Tangible Fixed Assets (Net): Rs. 22,00,000; Current Assets: Rs. 14,00,000.

The company earned Earnings Before Interest and Tax (EBIT) of Rs. 6,86,000 for the year. Annual principal debt installment payable on term loan is Rs. 1,00,000. Corporate income tax rate is 30%. Depreciation charged is Rs. 1,50,000.

• Required: Compute (a) Debt-to-Equity Ratio, (b) Proprietary Ratio, (c) Capital Gearing Ratio, (d) Interest Coverage Ratio, and (e) Debt Service Coverage Ratio (DSCR).

Step-by-Step Computational Process:

1. Grouping: Capital Structure Components:

• Equity Shareholders' Funds = Equity Capital + Reserves = Rs. 8,00,000 + Rs. 6,00,000 = Rs. 14,00,000
• Total Shareholders' Funds (Net Worth) = Equity Funds + Preference Capital = Rs. 14,00,000 + Rs. 2,00,000 = Rs. 16,00,000
• Long-Term Debt = 12% Debentures + 11% Term Loan = Rs. 10,00,000 + Rs. 6,00,000 = Rs. 16,00,000
• Total Tangible Assets = Fixed Assets + Current Assets = Rs. 22,00,000 + Rs. 14,00,000 = Rs. 36,00,000
• Fixed Annual Interest Charges = (12% of 10,00,000) + (11% of 6,00,000) = Rs. 1,20,000 + Rs. 66,00,00 = Rs. 1,86,000

1. Debt-to-Equity: Ratio: Debt-to-Equity = Long-Term Debt ÷ Shareholders' Funds = Rs. 16,00,000 ÷ Rs. 16,00,000 = 1.00 : 1
2. Proprietary: Ratio: Proprietary Ratio = Shareholders' Funds ÷ Total Assets = Rs. 16,00,000 ÷ Rs. 36,00,000 = 0.444 (44.44%)
3. Capital: Gearing Ratio: Fixed-Cost Capital = Long-Term Debt + Preference Capital = Rs. 16,00,000 + Rs. 2,00,000 = Rs. 18,00,000 Variable-Cost Equity Funds = Equity Capital + Reserves = Rs. 14,00,000 Capital Gearing Ratio = Rs. 18,00,000 ÷ Rs. 14,00,000 = 1.29 : 1 (Highly Geared)
4. Interest: Coverage Ratio: Interest Coverage Ratio = EBIT ÷ Fixed Interest = Rs. 6,86,000 ÷ Rs. 1,86,000 = 3.69 Times
5. Debt: Service Coverage Ratio (DSCR):

• Earnings Before Tax (EBT) = EBIT − Interest = Rs. 6,86,000 − Rs. 1,86,000 = Rs. 5,00,000
• Tax Expense (@ 30%) = 30% of Rs. 5,00,000 = Rs. 1,50,000
• Profit After Tax (PAT) = Rs. 5,00,000 − Rs. 1,50,000 = Rs. 3,50,000
• Cash Accruals Available for Debt Service = PAT + Depreciation + Interest Cash Available = Rs. 3,50,000 + Rs. 1,50,000 + Rs. 1,86,000 = Rs. 6,86,000
• Total Debt Service Commitment = Interest + Principal Repayment = Rs. 1,86,000 + Rs. 1,00,000 = Rs. 2,86,000 DSCR = Rs. 6,86,000 ÷ Rs. 2,86,000 = 2.40 Times
• SOLVENCY & COVERAGE COMMENTARY: NATIONAL HEAVY INDUSTRIES LTD.

Solvency Audit The Debt-to-Equity ratio of 1:1 reflects balanced leverage, well within the conservative industrial norm of 2:1.

The Capital Gearing Ratio of 1.29:1 indicates high gearing (fixed-cost funds exceed equity funds), which enhances equity returns when operational earnings are strong.

The Interest Coverage Ratio of 3.69 Times and DSCR of 2.40 Times (well above the institutional lending benchmark of 1.50) confirm healthy cash flow generation and debt-servicing stability.

PRACTICAL CASE 4: Integrated Master Problem Across All 4 Functional Ratio Classes

• Context: Supreme Consumer Products Ltd. presents its audited financial statements for the fiscal year ended 31st March 2025:

Balance Sheet as at 31-03-2025 Statement of Profit & Loss for Year Ended 31-03-2025 Equity & Liabilities:

• Equity Share Capital (Rs. 10 face value): Rs. 10,00,000
• General Reserves: Rs. 4,00,000
• Retained Earnings (P&L Balance): Rs. 2,00,000
• 10% Debentures: Rs. 8,00,000
• Trade Payables (Creditors): Rs. 3,20,000
• Bank Overdraft: Rs. 80,00,0 Total Equity & Liabilities = Rs. 28,00,000 Assets:
• Net Fixed Assets (PPE): Rs. 16,00,000
• Inventories: Rs. 4,80,000
• Trade Receivables (Debtors): Rs. 4,00,000
• Cash and Bank Balances: Rs. 2,40,000
• Prepaid Expenses: Rs. 80,000 Total Assets = Rs. 28,00,000
• Gross Sales: Rs. 42,00,000
• Less: Sales Returns: Rs. 2,00,000 Net Revenue from Operations = Rs. 40,00,000
• Less: Cost of Goods Sold (COGS): Rs. 24,00,000 Gross Profit = Rs. 16,00,000
• Less: Operating Expenses (Admin & Selling): Rs. 8,00,000 Operating Profit (EBIT) = Rs. 8,00,000
• Less: Interest on Debentures (10% on 8L): Rs. 80,000 Profit Before Tax (PBT) = Rs. 7,20,000
• Less: Corporate Tax Provision (@ 25%): Rs. 1,80,000 Profit After Tax (PAT) = Rs. 5,40,000
• Additional Market Info: Equity Dividend declared is 20% on face value; Current Market Price per Equity Share is Rs. 45.00.

Master Analytical Computation Across Functional Classes:

• CLASS A: LIQUIDITY RATIOS
• Total Current Assets = 4,80,000 + 4,00,000 + 2,40,000 + 80,000 = Rs. 12,00,000
• Total Current Liabilities = 3,20,000 + 80,000 = Rs. 4,00,000
• 1. Current Ratio = Rs. 12,00,000 ÷ Rs. 4,00,000 = 3.00 : 1
• Quick Assets = Current Assets − Inventories − Prepaid = 12,00,000 − 4,80,000 − 80,000 = Rs. 6,40,000
• 2. Quick Ratio = Rs. 6,40,000 ÷ Rs. 4,00,000 = 1.60 : 1
• CLASS B: ACTIVITY / EFFICIENCY RATIOS
• 3. Inventory Turnover Ratio = COGS ÷ Closing Inventory = Rs. 24,00,000 ÷ Rs. 4,80,000 = 5.00 Times
• 4. Debtors Turnover Ratio = Net Sales ÷ Debtors = Rs. 40,00,000 ÷ Rs. 4,00,000 = 10.00 Times (Collection Period = 36.5 Days)
• Net Working Capital = Current Assets − Current Liabilities = 12,00,000 − 4,00,000 = Rs. 8,00,000
• 5. Working Capital Turnover = Net Sales ÷ Net WC = Rs. 40,00,000 ÷ Rs. 8,00,000 = 5.00 Times
• 6. Fixed Assets Turnover = Net Sales ÷ Fixed Assets = Rs. 40,00,000 ÷ Rs. 16,00,000 = 2.50 Times
• CLASS C: LEVERAGE & SOLVENCY RATIOS
• Shareholders' Net Worth = Equity Capital + Reserves + Retained Earnings = 10,00,000 + 4,00,000 + 2,00,000 = Rs. 16,00,000
• 7. Debt-to-Equity Ratio = Long-Term Debt ÷ Net Worth = Rs. 8,00,000 ÷ Rs. 16,00,000 = 0.50 : 1
• 8. Proprietary Ratio = Net Worth ÷ Total Assets = Rs. 16,00,000 ÷ Rs. 28,00,000 = 0.571 (57.14%)
• 9. Interest Coverage Ratio = EBIT ÷ Interest = Rs. 8,00,000 ÷ Rs. 80,000 = 10.00 Times
• CLASS D: PROFITABILITY & VALUATION RATIOS
• 10. Gross Profit Margin = [ Rs. 16,00,000 ÷ Rs. 40,00,000 ] × 100 = 40.00%
• 11. Operating Profit Margin = [ Rs. 8,00,000 ÷ Rs. 40,00,000 ] × 100 = 20.00%
• 12. Net Profit Margin = [ Rs. 5,40,000 ÷ Rs. 40,00,000 ] × 100 = 13.50%
• Capital Employed = Net Worth + Long-Term Debt = Rs. 16,00,000 + Rs. 8,00,000 = Rs. 24,00,000
• 13. Return on Capital Employed (ROCE) = [ Rs. 8,00,000 ÷ Rs. 24,00,000 ] × 100 = 33.33%
• 14. Return on Equity (ROE) = [ Rs. 5,40,000 ÷ Rs. 16,00,000 ] × 100 = 33.75%
• Number of Equity Shares = Rs. 10,00,000 ÷ Rs. 10 = 1,00,000 Shares
• 15. Earnings Per Share (EPS) = Rs. 5,40,000 ÷ 1,00,000 Shares = Rs. 5.40 Per Share
• 16. Price-to-Earnings (P/E) Ratio = MPS ÷ EPS = Rs. 45.00 ÷ Rs. 5.40 = 8.33 Times
• Equity Dividend declared = 20% on face value (Rs. 10) = Rs. 2.00 per share; Total Dividend = Rs. 2,00,000
• 17. Dividend Payout Ratio = [ Rs. 2.00 ÷ Rs. 5.40 ] × 100 = 37.04%
• 18. Dividend Yield = [ Rs. 2.00 ÷ Rs. 45.00 ] × 100 = 4.44%

1. Master: Financial Ratio Dashboard & Managerial Evaluation Analytical Category Calculated Metric Standard Benchmark Diagnostic Evaluation Short-Term Liquidity Current Ratio: 3.00:1 Quick Ratio: 1.60:1 2.00:1 1.00:1 Healthy liquidity. Both ratios exceed baseline benchmarks, ensuring low immediate payment default risk.

• Operating Efficiency Inventory Turnover: 5.0x Debtors Turnover: 10.0x Industry Mean: 4.0x Industry Mean: 8.0x Operating cycle is tight; credit collection period is approximately 36.5 days, reflecting strict receivables control.
• Capital Solvency Debt-Equity: 0.50:1 Interest Coverage: 10.0x 2.00:1 ≥ 6.00x Conservative capital structure with 2:1 equity-to-debt cushion. Interest is covered 10 times by operating profit.
• Investment Return ROCE: 33.33% ROE: 33.75% Cost of Capital: ~12% Cost of Equity: ~15% ROCE substantially exceeds the cost of debt (10%), generating a 33.75% return for equity shareholders.