Elective Advanced Financial Accounting

Advanced Financial AccountingUnit 515 min read

Financial Statement Analysis & Performance Evaluation: Ratios, Trends & Strategic Insights

Unit 5 of Advanced Financial Accounting explores how to dissect financial statements (balance sheets, income statements, cash flow statements) to evaluate a company’s financial health, operational efficiency, and strategic performance using ratios, trend analysis, and benchmarking—with real-world Nepali case studies.

TAKEAWAYS:

  • Ratios reveal hidden truths: Liquidity, profitability, leverage, and efficiency ratios transform raw numbers into actionable insights (e.g., a Kathmandu retail shop’s inventory turnover tells you if stock is moving too slowly).
  • Trends beat snapshots: Comparing ratios year-over-year (e.g., NEPSE-listed companies’ ROE) exposes growth, decline, or fraud patterns before they hit headlines.
  • DuPont analysis breaks down ROE: A tool to diagnose whether a company’s profitability comes from smart operations (high asset turnover) or risky debt (high leverage).
  • Benchmarking is relative: A Daraz seller’s gross margin of 30% looks great until you compare it to Amazon’s 40%—context is everything.
  • Limitations matter: Ratios can lie if accounting policies differ (e.g., FIFO vs. LIFO inventory) or if the business model is unique (e.g., Pathao’s asset-light model skews traditional asset ratios).
  • Strategic decisions follow: Weak cash flow coverage? Cut capex. High receivables turnover? Tighten credit terms. The analysis drives the fix.

Core Concepts: What Financial Statements Tell Us

Financial statements are the "language" of business. To evaluate performance, we ask:

  1. Can the company pay its bills? (Liquidity)
  2. Is it making money? (Profitability)
  3. How efficiently is it using resources? (Efficiency)
  4. How risky is its capital structure? (Leverage)
  5. Is it growing or shrinking? (Trend analysis)
Journal Entry: Kathmandu Retail Shop (Fashion Kendra) – PurcDr.Cr.To Inventory A/c5,00,000To Cash Discount Received A/c5,000By Supplier A/c (Nepal Trading Co.)5,05,000
T-account showing the double-entry for inventory purchase (NPR 500,000) with a 1% cash discount (NPR 5,000).
flowchart TD
    A["Financial Statements"] --> B["Balance Sheet"]
    A --> C["Income Statement"]
    A --> D["Cash Flow Statement"]
    B --> E["Liquidity Ratios\n(Current, Quick)"]
    B --> F["Leverage Ratios\n(Debt/Equity)"]
    C --> G["Profitability Ratios\n(ROE, ROA, Gross Margin)"]
    C --> H["Efficiency Ratios\n(Inventory Turnover, Receivables Turnover)"]
    D --> I["Cash Flow Ratios\n(Cash Flow to Sales)"]
    E --> J["Short-term Survival"]
    F --> K["Long-term Risk"]
    G --> L["Profit Generation"]
    H --> M["Operational Efficiency"]
    J --> N["Creditor Confidence"]
    K --> O["Investor Risk Assessment"]
    L --> P["Shareholder Value"]
    M --> Q["Cost Control"]

1. Liquidity Ratios: Can the Company Pay Its Short-Term Debts?

Definitions:

  • Current Ratio = Current Assets / Current Liabilities Measures ability to pay short-term obligations with short-term assets.
  • Quick Ratio (Acid-Test) = (Current Assets – Inventory) / Current Liabilities Stricter test: excludes inventory (harder to liquidate).
00.380.751.131.5Current Ratio (NTC)1.25Quick Ratio (NTC)0.85Industry Avg (Retail)1.5Ratio Value
NTC’s liquidity ratios vs. industry benchmark (retail: Current Ratio >1.5, Quick Ratio >1.0).
00.380.751.131.5Current Ratio1.5Quick Ratio0.8Ratio Value
Example: Industry benchmarks (Current Ratio >1.0, Quick Ratio >0.5)

Why It Matters: A Kathmandu-based electronics retailer might have a current ratio of 1.5:1, but if inventory sits unsold for 6 months, the quick ratio (e.g., 0.8:1) reveals a liquidity crisis.

Worked Example: NTC’s Liquidity (Hypothetical) Assume NTC’s latest balance sheet (in Rs. crore):

Assets Liabilities
Cash & Bank: 50 Current Liabilities: 200
Receivables: 120
Inventory: 80
Total Current Assets: 250
  • Current Ratio = 250 / 200 = 1.25:1 (⚠️ Below ideal 2:1)
  • Quick Ratio = (250 – 80) / 200 = 0.85:1 (❌ Critical if NTC needs urgent cash)

Real-World Tie-In:

  • Pathao’s Quick Ratio: Pathao’s asset-light model (minimal inventory, high cash flow from rides) keeps its quick ratio above 1.5, unlike traditional taxi companies.
  • Daraz Sellers: A Daraz seller with a current ratio <1.2 risks penalties for delayed order fulfillment.

2. Profitability Ratios: Is the Business Actually Making Money?

Key Ratios:

Ratio Formula Interpretation
Gross Profit Margin (Revenue – COGS) / Revenue Shows core profitability before overheads.
Net Profit Margin Net Income / Revenue Bottom-line efficiency.
ROE (Return on Equity) Net Income / Shareholders’ Equity How well equity generates profits.
ROA (Return on Assets) Net Income / Total Assets Efficiency of all assets (not just equity).
Revenue (38%)COGS (15%)Gross Profit (23%)Operating Expenses (19%)Net Income (4%)
Khalti’s income statement breakdown (NPR crore). Net income (50) is 10% of revenue (500).

Worked Example: Khalti’s Profitability (Simplified) Assume Khalti’s income statement (Rs. crore):

Revenue 500
COGS 200
Gross Profit 300
Operating Expenses 250
Net Income 50
  • Gross Profit Margin = 300 / 500 = 60% (High, but digital payment companies like Khalti have low COGS).
  • Net Profit Margin = 50 / 500 = 10% (Industry average for fintechs).
  • ROE: Assume equity = Rs. 100 crore → 50% ROE (✅ Exceptional for a Nepalese fintech).

Real-World Tie-In:

  • NEPSE Stocks: A company like Global IME (construction) might show a 15% ROE, while Nabil Bank (finance) boasts 20%+ due to lower asset turnover needs.
  • eSewa’s Net Margin: eSewa’s ~8% net margin reflects high customer acquisition costs (marketing, subsidies).

3. Efficiency Ratios: How Well Is the Company Using Its Resources?

Key Ratios:

Ratio Formula Interpretation
Inventory Turnover COGS / Average Inventory How quickly inventory sells.
Receivables Turnover Revenue / Average Receivables How fast customers pay.
Asset Turnover Revenue / Total Assets Revenue generated per rupee of assets.
Quantity (Units Sold)NPR (₹)ORevenueTotal Cost (FC + VC)Break-even PointQ*P*
Fashion Kendra’s break-even analysis: Fixed costs (₹1,000,000) + variable costs (₹100/unit) vs. revenue (₹300/unit). Break-even at 5,000 units.

Worked Example: A Kathmandu Retail Shop (Fashion Kendra) Assume:

  • COGS = Rs. 2,000,000

  • Average Inventory = Rs. 500,000

  • Revenue = Rs. 3,000,000

  • Average Receivables = Rs. 200,000

  • Inventory Turnover = 2,000,000 / 500,000 = 4 times/year (✅ Good; industry avg = 3–5).

  • Receivables Turnover = 3,000,000 / 200,000 = 15 times/year (❌ Slow; should be >20).

  • Asset Turnover = 3,000,000 / 10,000,000 = 0.3 (⚠️ Low; needs more sales per asset).

Real-World Tie-In:

  • Daraz’s Inventory Turnover: Daraz’s sellers with turnover <2 (inventory sits >6 months) face storage fees.
  • Ncell’s Asset Turnover: Ncell’s high asset turnover (~1.8) reflects its capital-intensive telecom infrastructure.

4. Leverage Ratios: How Risky Is the Company’s Debt?

Key Ratios:

Ratio Formula Interpretation
Debt-to-Equity Total Debt / Shareholders’ Equity Higher = riskier (more debt).
Interest Coverage EBIT / Interest Expense Can the company pay interest?

Worked Example: Nabil Bank’s Leverage (Hypothetical) Assume:

  • Total Debt = Rs. 800 crore

  • Equity = Rs. 200 crore

  • EBIT = Rs. 150 crore

  • Interest Expense = Rs. 30 crore

  • Debt-to-Equity = 800 / 200 = 4:1 (⚠️ High for a bank; industry avg = 2–3).

  • Interest Coverage = 150 / 30 = 5x (✅ Safe; >1.5 is ideal).

Real-World Tie-In:

  • Nepal’s Microfinance Crisis (2000s): High debt-to-equity ratios (>5:1) led to defaults when interest rates spiked.
  • Pathao’s Leverage: Pathao’s debt-to-equity is near 0 (asset-light model), but its interest coverage is irrelevant (no debt).

5. Trend Analysis: Is the Company Getting Better or Worse?

How It Works: Compare ratios over 3–5 years to spot:

  • Improving: Rising gross margins, higher asset turnover.
  • Declining: Falling ROE, increasing debt ratios.
  • Red Flags: Sudden drops in liquidity (e.g., NTC’s current ratio fell from 1.8 to 1.2 in 2022).

Example: NEPSE’s Top Gainers (2019–2023)

Company ROE 2019 ROE 2023 Trend
Global IME 12% 18% ✅ Strong growth
Nabil Bank 15% 10% ❌ Declining efficiency
Himalayan Bank 20% 25% ✅ Outperforming peers

6. DuPont Analysis: Breaking Down ROE

ROE = Net Profit Margin × Asset Turnover × Leverage (Net Income / Sales) × (Sales / Assets) × (Assets / Equity)

Sales (₹'000)RatioONet Profit MarginAsset TurnoverFinancial Leverage
DuPont components driving ROE (Example: Everest Foods)

Worked Example: A Kathmandu Hotel Assume:

  • Net Income = Rs. 50 lakhs
  • Sales = Rs. 500 lakhs
  • Total Assets = Rs. 1,000 lakhs
  • Equity = Rs. 400 lakhs
  1. Net Profit Margin = 50 / 500 = 10%
  2. Asset Turnover = 500 / 1,000 = 0.5
  3. Leverage = 1,000 / 400 = 2.5
  4. ROE = 10% × 0.5 × 2.5 = 12.5%

Diagnosis:

  • Low asset turnover (0.5) → Hotel isn’t generating enough revenue per asset.
  • High leverage (2.5) → Risky if interest rates rise.

Real-World Tie-In:

  • Nabil Bank’s ROE: If Nabil’s ROE drops from 20% to 15%, DuPont helps identify if it’s due to lower margins (competition) or higher costs (inefficiency).

7. Benchmarking: Comparing Against Peers

Steps:

  1. Identify industry peers (e.g., Nabil vs. Global IME vs. Standard Chartered Nepal).
  2. Compare ratios (e.g., average gross margin in banking = 40%).
  3. Identify gaps (e.g., if your ROA is 5% vs. industry 8%, investigate).

Example: Nepali Banks vs. Global Standards

Ratio Nepali Banks (Avg.) Global Banks (Avg.) Gap
Net Profit Margin 15% 25% ❌ Lagging
Asset Turnover 0.4 0.6 ❌ Underutilized assets
ROE 18% 12% ✅ Outperforming

8. Limitations of Financial Statement Analysis

Limitation Example
Accounting Policies FIFO vs. LIFO inventory affects COGS (and thus margins).
Inflation Historical cost accounting understates asset values in high-inflation Nepal.
Off-Balance-Sheet Items Leases (e.g., NTC’s tower leases) may not appear as debt.
Qualitative Factors Customer loyalty (e.g., Khalti’s brand trust) isn’t in financials.
Window Dressing Delaying payments to improve current ratio before year-end.

9. Strategic Decisions Based on Analysis

Finding Possible Action
Low current ratio (<1.5) Negotiate shorter payment terms with suppliers.
High receivables turnover (>30 days) Offer discounts for early payments.
Declining ROE Restructure debt or improve asset efficiency.
Low inventory turnover Liquidate slow-moving stock or adjust procurement.

Example: Kathmandu Traffic Routes (Efficiency) If a city’s asset turnover for roads is low (revenue per km of road is declining), the municipality might:

  • Increase tolls (but risks backlash).
  • Partner with private operators (like Pathao’s ride-hailing model for public transport).
  • Improve maintenance to reduce repair costs (higher upfront, but lower long-term COGS).

In the Real World

  1. Khalti’s Gross Margin vs. eSewa

    • Idea Used: Profitability Ratios (Gross Profit Margin)
    • How: Khalti’s gross margin (70%) is higher than eSewa’s (60%) because Khalti processes more high-value transactions (e.g., salary deposits) with lower per-transaction costs. Analysts compare these margins to decide which fintech to invest in.
  2. Daraz Sellers’ Inventory Turnover

    • Idea Used: Efficiency Ratios (Inventory Turnover)
    • How: Daraz penalizes sellers with inventory turnover <2 (stock sits >6 months). A seller in Kathmandu might see their turnover drop from 4 to 1.5 after listing low-demand electronics, triggering storage fees and lower rankings in search results.
  3. NEPSE’s Debt-to-Equity Screening

    • Idea Used: Leverage Ratios (Debt-to-Equity)
    • How: Investors use debt-to-equity to avoid stocks like Cement Australia Nepal (historically high debt) during interest rate hikes. In 2022, stocks with D/E >3:1 underperformed as the Federal Reserve raised rates.

Exam Tip

  1. Always Compare: Exams often ask, "Is Company X performing well?" Answer with benchmarks (industry averages or past years).
  2. DuPont is Your Friend: If ROE is given, break it down into margin, turnover, and leverage. This adds depth to your answer.
  3. Flag Limitations: Never present ratios as absolute truth. Always mention accounting policies, inflation, or qualitative factors.
  4. Use Real Numbers: If the exam gives a balance sheet, calculate ratios and interpret them (e.g., "A current ratio of 0.9 suggests liquidity risk").
  5. Link to Strategy: End with actions (e.g., "To improve ROE, the company should...").
  6. Memorize Key Averages:
    • Healthy Current Ratio: 1.5–2.0
    • Ideal Quick Ratio: >1.0
    • Good ROE: 15–20% (varies by industry)
    • High Debt-to-Equity: >3.0 (risky)

Practice Question (Solve Like an Exam)

Question: The following are the financials of Everest Foods Ltd. (a Kathmandu-based FMCG company):

  • Revenue: Rs. 200,000,000
  • COGS: Rs. 120,000,000
  • Current Assets: Rs. 60,000,000 (Cash: 20M, Receivables: 30M, Inventory: 10M)
  • Current Liabilities: Rs. 40,000,000
  • Total Assets: Rs. 300,000,000
  • Total Equity: Rs. 150,000,000
  • Net Income: Rs. 30,000,000

Tasks: a) Calculate 5 key ratios and interpret them. b) If Everest Foods’ competitor Himalayan Foods has a gross margin of 40% and ROE of 25%, how does Everest perform relative to its peer? c) Suggest one strategic action based on your analysis.

Solution Outline:

Everest Foods: Gross Profit CalculationDr.Cr.To Cost of Goods Sold (COGS)60,000To Operating Expenses20,000By Revenue1,00,000
Example: Revenue ₹100,000 → Gross Profit ₹40,000 (40% margin) vs. Everest’s 30%

Based on the TU BBS syllabus for Advanced Financial Accounting, unit 5.

Discussion

Loading…