Financial Analysis & Statement Interpretation

TAKEAWAYS:

• Financial statements (income statement, balance sheet, cash flow) are the "scorecards" of a business, revealing its financial health and decision-making triggers.
• Ratio analysis (liquidity, solvency, profitability, efficiency) turns raw numbers into actionable insights—e.g., a bank’s loan-to-deposit ratio or Daraz’s inventory turnover.
• Trend analysis and common-size statements reveal growth, decline, or inefficiencies over time, critical for investors and creditors like NEPSE or Ncell.
• DuPont analysis breaks down ROE into its drivers (profit margin × asset turnover × leverage), helping managers optimize operations or financing.
• Financial forecasting (pro forma statements) predicts future performance, used by Pathao to plan driver allocations or eSewa to manage liquidity.
• Comparative analysis (industry benchmarks) exposes gaps—e.g., why a Nepali bank’s interest coverage ratio lags behind ICICI Bank’s.

1. Introduction to Financial Statement Analysis

Financial statements are the language of business, translating transactions into structured reports that stakeholders use to evaluate performance. The three core statements are:

1.1 The Three Financial Statements

flowchart TD
    A["Income Statement"] -->|"Revenue - Expenses"| B["Net Profit/Loss"]
    C["Balance Sheet"] -->|"Assets = Liabilities + Equity"| D["Snapshot of Financial Position"]
    E["Cash Flow Statement"] -->|"Operating, Investing, Financing"| F["Cash Inflows/Outflows"]

Key Definitions:

• Income Statement (Profit & Loss Account): Shows revenues, expenses, and net income over a period (e.g., quarter/year). Example: A Kathmandu retail shop’s income statement would list sales (Rs. 5M), COGS (Rs. 3M), and net profit (Rs. 1M).

• Balance Sheet (Statement of Financial Position): A snapshot of assets, liabilities, and equity at a point in time. Example: The same shop’s balance sheet might show:

  • Assets: Cash (Rs. 200K), Inventory (Rs. 1.5M), Equipment (Rs. 800K)
  • Liabilities: Bank Loan (Rs. 300K), Trade Payables (Rs. 200K)
  • Equity: Owner’s Capital (Rs. 1.4M)

• Cash Flow Statement: Tracks actual cash movements from operations, investments, and financing. Example: Pathao’s cash flow might show Rs. 50M from driver fares (operating) but Rs. 10M spent on new bikes (investing).

Cash
|---------------------|
| Rs. 200,000 (Dr)    |
|---------------------|
| Rs. 50,000 (Cr)     |
|---------------------|
| Rs. 150,000 Balance |

1.2 Why Analyze Financial Statements?

2. Key Ratios for Financial Analysis

Ratios standardize financial data, allowing comparisons across firms or time. We classify them into four groups:

2.1 Liquidity Ratios: Can the Firm Pay Short-Term Debts?

Formula Table:

Worked Example: Kathmandu Retail Shop

• Current Assets: Rs. 2M (Rs. 1.5M inventory + Rs. 500K cash)
• Current Liabilities: Rs. 1M (trade payables + short-term loan)
• Current Ratio = 2M / 1M = 2.0 (Good; can cover debts 2× over).
• Quick Ratio = (2M – 1.5M) / 1M = 0.5 (Marginal; relies on selling inventory quickly).

2.2 Solvency Ratios: Can the Firm Meet Long-Term Obligations?

Formula Table:

Real-World Tie: Ncell’s Debt Strategy Ncell’s D/E ratio rose from 0.8 (2020) to 1.2 (2023) due to 5G expansion. Investors scrutinized its TIE ratio (EBIT/Interest) to ensure it could service Rs. 5B in debt.

2.3 Profitability Ratios: How Efficiently Does the Firm Generate Profits?

Formula Table:

Worked Example: Daraz’s Gross Margin

• Revenue: Rs. 10B
• COGS: Rs. 7B
• Gross Margin = (10B – 7B) / 10B = 30% (Comparable to Amazon’s 30–40%).

2.4 Efficiency Ratios: How Well Are Assets Utilized?

Formula Table:

Real-World Tie: Kathmandu Traffic (Inventory Turnover Analogy)

• Problem: Kathmandu’s "inventory" (cars) sits idle due to poor road planning (high average inventory days).
• Solution: Like Daraz optimizing warehouse locations, the city could use efficiency ratios to reduce congestion (lower "inventory turnover" = wasted assets).

3. Advanced Analysis Techniques

3.1 DuPont Analysis: Decomposing ROE

ROE = Profit Margin × Asset Turnover × Financial Leverage Why? It shows whether poor ROE stems from operations (margin) or asset use (turnover) or debt (leverage).

Example: Compare Two Nepali Banks

3.2 Trend Analysis: Spotting Patterns Over Time

Example: NEPSE’s P/E Ratio (2020–2023)

Visual:

3.3 Common-Size Statements: Percentage Breakdowns

Example: Kathmandu Retail Shop’s Income Statement (Common-Size)

Why? Helps compare cost structures across firms (e.g., Daraz’s 60% COGS vs. a local shop’s 70%).

4. Financial Forecasting and Pro Forma Statements

Definition: Pro forma statements project future performance based on past trends and assumptions.

flowchart TD
    A["Pro Forma Income Statement"]
    B["Projected Revenue: Rs. 6M"]
    C["Projected COGS: Rs. 3.6M"]
    D["Projected Expenses: Rs. 1.8M"]
    E["Forecasted Net Profit: Rs. 2.6M"]
    A --> B
    A --> C
    A --> D
    A --> E
    F["Pro Forma Balance Sheet"]
    G["Projected Assets: Rs. 3.2M"]
    H["Projected Liabilities: Rs. 600K"]
    I["Projected Equity: Rs. 1.6M"]
    F --> G
    F --> H
    F --> I
    J["Cash Flow Projection"]
    K["Operating Cash Flow: Rs. 3M"]
    L["Investing Cash Flow: -Rs. 500K"]
    M["Financing Cash Flow: Rs. 200K"]
    J --> K
    J --> L
    J --> M

Example: Pathao’s 3-Year Forecast

Assumptions:

• Rider growth: +30% annually (market expansion).
• Price per ride: Rs. 10 (fixed).
• Expenses: 70% of revenue (driver payouts, fuel, etc.).

Pro Forma Income Statement (2024):

5. Comparative Analysis: Benchmarking Against Industry

Example: Nepali Banks vs. Indian Banks (2023)

Why? Helps Nepali banks like Global IME identify best practices (e.g., Indian banks’ digital lending models).

6. Limitations of Financial Statement Analysis

In the Real World

1. NEPSE Stock Analysis:

   • Idea: P/E Ratio helps investors decide whether to buy NEPSE-listed stocks like Nepal Bank (P/E = 18) or Global IME (P/E = 12).
   • How? A low P/E (e.g., 12) suggests the stock is undervalued relative to earnings.

2. Daraz’s Inventory Management:

   • Idea: Inventory Turnover Ratio ensures fast-moving goods (e.g., electronics) don’t sit in warehouses.
   • How? Daraz targets a turnover of >12 times/year, unlike a local shop’s 4–6 times.

3. Pathao’s Driver Allocation:

   • Idea: Receivables Turnover ensures drivers are paid on time (e.g., 7-day cycle).
   • How? If turnover drops (e.g., to 10 days), Pathao may face cash flow crunches for payouts.

Exam Tip

1. Master the Formulas:

   • Memorize all 12 key ratios (liquidity, solvency, profitability, efficiency) and their formulas. Past exams often test Current Ratio, D/E, and ROE.

2. Show Work for Numerical Problems:

   • For questions like "Calculate the degree of financial leverage," always break it down:
     • DFL = 1 / (1 – (Interest / EBIT))
     • Given: EBIT = Rs. 200K, Interest = Rs. 20K
     • DFL = 1 / (1 – (20K / 200K)) = 1.25 (Answer).

3. Compare Real-World Scenarios:

   • If asked to compare Ncell vs. NTC, use a table like the one above. Examiners love structured comparisons.

4. Link Ratios to Business Decisions:

   • Example: "If a bank’s TIE ratio drops below 1.5, it should [reduce loans/raise interest rates] to avoid default risk."

5. Time Management:

   • Spend 20 minutes on ratio calculations and 30 minutes on essay questions (e.g., "How does financial analysis help investors?").
   • Avoid spending too long on one part—exams are time-bound.

Final Note: Financial analysis is not just numbers—it’s about telling a story. Use ratios to diagnose problems (e.g., "Why is Daraz’s gross margin declining?") and recommend solutions (e.g., "Increase dynamic pricing like Amazon"). Practice with real data (NEPSE annual reports, Ncell’s financials) to ace the exam!