Dean's Office Official Model Question Paper

Financial Statement Analysis

Financial statement analysis is the critical evaluation and interpretation of an enterprise’s financial statements to assess its profitability, liquidity, solvency, and operational efficiency.

Two Techniques: Ratio Analysis and Cash Flow Analysis.

DuPont Three-Factor Decomposition

$$\text{ROE} = \left( \frac{\text{Net Income}}{\text{Sales}} \right) \times \left( \frac{\text{Sales}}{\text{Total Assets}} \right) \times \left( \frac{\text{Total Assets}}{\text{Equity}} \right)$$

$$\text{ROE} = \text{Net Profit Margin} \times \text{Asset Turnover} \times \text{Equity Multiplier (Financial Leverage)}$$

OCF vs. FCFF

• Operating Cash Flow (OCF): Cash generated from core operating business activities before capital investments.
• Free Cash Flow to Firm (FCFF): Cash generated from operations minus capital expenditures (CapEx):
  $$\text{FCFF} = \text{OCF} - \text{Capital Expenditures (CapEx)}$$
  It represents cash available to all providers of capital (debt and equity).

Economic Value Added (EVA)

$$\text{EVA} = \text{NOPAT} - (\text{Invested Capital} \times \text{WACC})$$

Where NOPAT is Net Operating Profit After Tax and WACC is Weighted Average Cost of Capital. A positive EVA indicates the firm generated wealth above its total cost of capital.

Altman Z-Score

The Altman Z-Score is a multivariate financial formula combining five financial ratios to predict the probability that a manufacturing company will enter bankruptcy within two years ($Z < 1.81$ denotes high distress zone).

DuPont ROE Analysis for Surya Industrial Corp.

a. Direct ROE Computation

$$\text{ROE} = \frac{\text{Net Profit After Tax}}{\text{Total Equity}} \times 100 = \frac{1{,}600{,}000}{8{,}000{,}000} \times 100 = \mathbf{20.0\%}$$

b. DuPont Three-Factor Decomposition

$$\text{ROE} = \text{Net Profit Margin (NPM)} \times \text{Total Asset Turnover (TAT)} \times \text{Equity Multiplier (EM)}$$

1. Net Profit Margin (Profitability):
   $$\text{NPM} = \frac{\text{Net Income}}{\text{Sales}} = \frac{1{,}600{,}000}{20{,}000{,}000} = \mathbf{8.0\%}$$
2. Total Asset Turnover (Efficiency):
   $$\text{TAT} = \frac{\text{Sales}}{\text{Total Assets}} = \frac{20{,}000{,}000}{16{,}000{,}000} = \mathbf{1.25 \times}$$
3. Equity Multiplier (Financial Leverage):
   $$\text{EM} = \frac{\text{Total Assets}}{\text{Total Equity}} = \frac{16{,}000{,}000}{8{,}000{,}000} = \mathbf{2.00 \times}$$

Verification:

$$\text{ROE} = 0.08 \times 1.25 \times 2.00 = 0.20 = \mathbf{20.0\%}$$

c. Managerial Interpretation

• The 20% ROE is driven by healthy profit margins (8%) and moderate leverage (assets are twice equity).
• Improvement Pathways: Management can boost ROE without taking on hazardous debt leverage by improving operational efficiency—accelerating asset turnover from 1.25x to 1.50x through leaner inventory and faster receivables collection.

Cash Conversion Cycle (CCC) Computation

$$\text{CCC} = \text{Days Inventory Outstanding (DIO)} + \text{Days Sales Outstanding (DSO)} - \text{Days Payable Outstanding (DPO)}$$

1. Intermediate Computations

• Days Inventory Outstanding (DIO):
  $$\text{DIO} = \left( \frac{\text{Inventory}}{\text{COGS}} \right) \times 360 = \left( \frac{3{,}000{,}000}{12{,}000{,}000} \right) \times 360 = \mathbf{90 \text{ Days}}$$
• Days Sales Outstanding (DSO):
  $$\text{DSO} = \left( \frac{\text{Debtors}}{\text{Sales}} \right) \times 360 = \left( \frac{2{,}500{,}000}{18{,}000{,}000} \right) \times 360 = \mathbf{50 \text{ Days}}$$
• Days Payable Outstanding (DPO):
  $$\text{DPO} = \left( \frac{\text{Creditors}}{\text{COGS}} \right) \times 360 = \left( \frac{1{,}800{,}000}{12{,}000{,}000} \right) \times 360 = \mathbf{54 \text{ Days}}$$

2. Cash Conversion Cycle

$$\text{CCC} = 90 + 50 - 54 = \mathbf{86 \text{ Days}}$$

• Interpretation: The company requires 86 days of working capital financing from the day it pays for raw materials until it collects cash from final customers.

Altman Z-Score Model for Manufacturing Firms

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

Constituent Ratios:

1. $X_1 = \frac{\text{Working Capital}}{\text{Total Assets}}$: Measures net short-term balance sheet liquidity relative to enterprise size.
2. $X_2 = \frac{\text{Retained Earnings}}{\text{Total Assets}}$: Measures cumulative historical profitability and company age.
3. $X_3 = \frac{\text{EBIT}}{\text{Total Assets}}$: Measures asset productivity and operational earning power before tax and leverage distortion.
4. $X_4 = \frac{\text{Market Value of Equity}}{\text{Total Liabilities}}$: Measures how much firm assets can decline in market value before liabilities exceed assets (solvency cushion).
5. $X_5 = \frac{\text{Sales}}{\text{Total Assets}}$: Measures asset turnover efficiency.

Z-Score Zones of Discrimination:

• $Z > 2.99$: Safe Zone (Low probability of insolvency)
• $1.81 \le Z \le 2.99$: Grey Zone (Financial vulnerability; close monitoring required)
• $Z < 1.81$: Distress Zone (High probability of bankruptcy within 24 months)

Quality of Earnings (QoE) Analysis

High quality earnings reflect sustainable, repeatable operational cash flows rather than accounting maneuvers.

Red Flags and Detection Techniques:

1. Divergence between Net Income and Cash Flow from Operations (CFO): If reported net profit grows steadily while CFO stagnates or turns negative, it signals aggressive revenue accruals or uncollectible receivables.
2. Aggressive Expense Capitalization: Capitalizing routine operating expenses (e.g., software maintenance or customer acquisition costs) into balance sheet intangible assets to artificially inflate current-year earnings.
3. Cookie-Jar Reserves: Over-provisioning restructuring or loan-loss reserves in exceptionally profitable years and reversing them into income during lean years to create artificial earnings smoothing.

Financial Analysis: Himalayan Electronics Ltd.

a. Comparative Ratio Analysis

---

b. Common-Size Income Statement Analysis (% of Sales)

Key Finding: Net profit fell from Rs 120M to Rs 90M because the company engaged in aggressive price-discounted volume growth (Gross margin contracted from 33.3% to 28.1%) combined with a 75% spike in interest expenses (Rs 70M vs Rs 40M) from heavy borrowing.

---

c. Cash Flow from Operating Activities (Indirect Method for FY 2079/80)

---

d. Executive Financial Advisory Evaluation

1. The ‘Profitable but Cash-Broke’ Trap: Despite reporting Rs 90M in net accounting profit, the company burned Rs 90M in cash from operations because capital was swallowed by uncontrolled inventory (+Rs 160M) and overdue receivables (+Rs 130M).
2. High Bankruptcy Vulnerability: The quick ratio collapsed to 0.74 while total debt surged to Rs 650M. If market interest rates rise or debtors default, the company faces immediate debt-service insolvency.
3. Corrective Action: Immediate freeze on new CapEx; aggressive collection of Rs 280M receivables; liquidate slow-moving inventory to pay down short-term bank borrowings.