📖 比率分析综合案例

Financial Statement Analysis

I. Lesson Focus

This lesson integrates all major categories of financial ratios—liquidity, solvency, profitability, efficiency, DuPont decomposition, and market-based valuation ratios—into a cohesive analytical framework. Candidates must be able to compute ratios, interpret trends, identify quality-of-earnings issues, and reach an investment recommendation using real financial statement data.

II. The Problem

You are a fund analyst given three years of financial statements for a listed manufacturing company. The firm reports steadily rising net income, yet operating cash flow has turned negative, inventory and receivables have ballooned, and leverage ratios keep climbing. Using a complete ratio-analysis toolkit, you must determine whether the company is experiencing genuine profitable growth or manufacturing an illusion of prosperity through aggressive accounting and excessive leverage, then issue a “buy, hold, or sell” recommendation. This mirrors the most common integrated case-study format on the CFA Level I exam.

III. The Complete Ratio-Analysis Framework

Ratio analysis must never be performed in isolation. Liquidity, solvency, profitability, operating efficiency, DuPont analysis, and market multiples must be linked into a single logical chain.

1. Liquidity Analysis
   Core ratios:
2. Current Ratio = Current Assets / Current Liabilities
3. Quick Ratio = (Current Assets – Inventory) / Current Liabilities
4. Cash Ratio = (Cash + Cash Equivalents) / Current Liabilities

For manufacturers, reasonable ranges are Current Ratio ≈ 1.5–2.5 and Quick Ratio ≈ 0.8–1.5. Excessively high ratios may signal idle resources; low ratios signal short-term default risk.

1. Solvency Analysis
2. Debt-to-Assets = Total Liabilities / Total Assets
3. Equity Multiplier = Total Assets / Shareholders’ Equity = 1 + Debt-to-Equity
4. Interest Coverage = EBIT / Interest Expense

Rising Debt-to-Assets combined with falling Interest Coverage is a clear warning of increasing financial risk.

1. Profitability Analysis
2. Gross Margin = (Revenue – Cost of Goods Sold) / Revenue
3. Net Profit Margin = Net Income / Revenue
4. Return on Assets (ROA) = Net Income / Average Total Assets

5. Return on Equity (ROE) = Net Income / Average Shareholders’ Equity

6. Operating Efficiency (Turnover) Analysis

7. Inventory Turnover = Cost of Goods Sold / Average Inventory
8. Receivables Turnover = Revenue / Average Receivables
9. Asset Turnover = Revenue / Average Total Assets
10. Payables Turnover = Cost of Goods Sold / Average Payables

Declining turnover ratios usually indicate inventory buildup or overly loose credit policies and may hide revenue-recognition manipulation.

1. DuPont Analysis
   Three-factor DuPont:
   $$ ROE = \text{Net Profit Margin} \times \text{Asset Turnover} \times \text{Equity Multiplier} $$

The five-factor expansion decomposes Net Profit Margin into:
Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Equity Multiplier.

DuPont analysis immediately reveals whether ROE growth is driven by margin improvement, better turnover, or simply higher leverage.

1. Equity Valuation and Market Ratios
2. Price-to-Earnings (P/E) = Price per Share / EPS
3. Price-to-Book (P/B) = Price per Share / Book Value per Share
4. Price-to-Sales (P/S) = Price per Share / Sales per Share
5. Dividend Payout Ratio = Dividends / Net Income
6. Sustainable Growth Rate = ROE × (1 – Dividend Payout Ratio)

IV. Interrelationships and Red-Flag Patterns

• Rapidly growing net income accompanied by persistently negative operating cash flow often indicates premature revenue recognition or capitalization of expenses.
• Simultaneous sharp declines in both inventory and receivables turnover suggest channel stuffing or fictitious sales.
• Rising leverage ratios together with falling interest coverage signal acute increases in financial risk.
• ROE growth driven mainly by the Equity Multiplier (leverage) rather than margin or turnover is usually unsustainable.

Worked Cases

Case 1: Comprehensive Ratio Diagnosis – Manufacturing Company (Amounts in millions)

XYZ Corp. three-year selected data:

2023 Ratios:
Net Margin = 142 / 1,680 ≈ 8.45% (was 8.00% in 2021)
Asset Turnover = 1,680 / 1,520 ≈ 1.105 (was 1.143 in 2021)
Equity Multiplier = 1,520 / 780 ≈ 1.949 (was 1.694 in 2021)
ROE = 8.45% × 1.105 × 1.949 ≈ 18.21% (was 13.8% in 2021)

DuPont decomposition shows the ROE increase is driven overwhelmingly by higher leverage, while asset turnover actually deteriorated. Inventory days rose from 54 to 74 and receivables days from 64 to 80. Operating cash flow turned sharply negative. Conclusion: poor earnings quality—recommend sell.

Case 2: Five-Factor DuPont to Identify Margin Drivers

ABC Corp. 2023 data (CNY thousands): Revenue 50,000, COGS 31,000, SG&A 8,500, Interest 1,800, Pretax Income 8,700, Tax rate 25%, Avg. Assets 42,000, Avg. Equity 21,000.

EBIT Margin = (50,000 – 31,000 – 8,500) / 50,000 = 21%
Interest Burden = 8,700 / (8,700 + 1,800) ≈ 0.829
Tax Burden = 1 – 0.25 = 0.75
Asset Turnover = 50,000 / 42,000 ≈ 1.190
Equity Multiplier = 42,000 / 21,000 = 2.0

ROE = 0.75 × 0.829 × 0.21 × 1.190 × 2.0 ≈ 19.6%.

The analysis shows acceptable tax and interest burdens and a solid EBIT margin; any historical decline in EBIT Margin would warrant scrutiny of rising costs.

Case 3: Combined Liquidity and Leverage Pressure Scenario

DEF Corp.: Current assets = 12 m (inventory 4.5 m), Current liabilities = 8 m, Total assets = 25 m, Total liabilities = 16.5 m, EBIT = 3.2 m, Interest = 0.95 m.

• Current Ratio = 12 / 8 = 1.5
• Quick Ratio = (12 – 4.5) / 8 = 0.94
• Debt-to-Assets = 16.5 / 25 = 66%
• Interest Coverage = 3.2 / 0.95 ≈ 3.37

If next year inventory rises another 2 m financed entirely by short-term debt, Current Ratio falls to 1.33, Quick Ratio to 0.69, Debt-to-Assets rises to 71%, and Interest Coverage drops below 2.8. The firm would simultaneously face a liquidity squeeze and sharply higher solvency risk.

Traps

Key Formulas

• ROE = Net Income / Average Shareholders’ Equity
• ROE = Net Profit Margin × Asset Turnover × Equity Multiplier (3-factor DuPont)
• Quick Ratio = (Current Assets – Inventory) / Current Liabilities
• Interest Coverage = EBIT / Interest Expense
• Sustainable Growth Rate = ROE × (1 – Dividend Payout Ratio)
• Cash Conversion Cycle = Inventory Days + Receivables Days – Payables Days
• Equity Multiplier = Total Assets / Equity

Practice Questions

Q1. A company reports a net profit margin of 8%, asset turnover of 1.25, and equity multiplier of 2.0. Its ROE is closest to:
A. 15%　B. 20%　C. 25%　D. 10%

Q2. Which situation most strongly suggests revenue-recognition manipulation?
A. Net income and operating cash flow both rising
B. Net income rising sharply while receivables turnover falls significantly
C. Inventory turnover rising with stable gross margin
D. Interest coverage rising

Q3. If a firm’s equity multiplier increases from 1.6 to 2.2 while net margin and asset turnover remain unchanged, ROE will:
A. Decrease　B. Stay the same　C. Increase by 37.5%　D. Increase by 25%

Q4. Current ratio = 2.0, quick ratio = 0.8. Inventory constitutes approximately what percentage of current assets?
A. 20%　B. 40%　C. 60%　D. Cannot be determined

Q5. A company reports ROE of 18% driven mainly by a large increase in leverage, yet operating cash flow has been negative for two consecutive years. The most likely conclusion is:
A. High earnings quality
B. Leverage has boosted shareholder returns, but sustainability is questionable
C. The firm should increase dividends immediately
D. The stock is undervalued

Q6. The minimum acceptable interest-coverage ratio is generally considered to be no lower than:
A. 1.0　B. 2.0　C. 0.5　D. 8.0

Q7. In the five-factor DuPont analysis, “Interest Burden” equals:
A. EBIT / Pretax Income　B. Pretax Income / EBIT　C. Net Income / Pretax Income　D. EBIT / Revenue

Q8. A firm’s sustainable growth rate is 12% and its ROE is 15%. Its dividend payout ratio is closest to:
A. 20%　B. 80%　C. 12%　D. 25%

Answers

Takeaways

• Ratio analysis must be trend-based, peer-relative, and cross-checked against the cash-flow statement; never rely on a single metric.
• DuPont decomposition is the most powerful tool for uncovering what truly drives ROE; leverage-driven growth is rarely sustainable.
• Profit growth accompanied by negative operating cash flow and falling inventory/receivables turnover is a classic red flag for low-quality earnings.
• Liquidity and solvency ratios must be examined together; a high current ratio with a very low quick ratio signals severe inventory overhang.
• Always use average balance-sheet figures for turnover, ROA, and ROE to avoid distortion from end-of-period data.
• Final investment decisions combine ratio diagnostics with industry outlook and business-model understanding rather than relying on a single high ROE.