📖 财务报表分析技术：趋势分析

Financial Statement Analysis

I. Lesson Focus

II. The Problem

You are reviewing a listed company’s annual reports from 2020–2024 and notice that revenue has grown steadily while net profit has declined sharply after 2023, with both gross and net profit margins trending downward each year. How can you systematically quantify these changes? How do you determine whether the pattern reflects a temporary industry cycle or a persistent deterioration in the firm’s competitive position? Trend analysis is the primary tool that converts multi-year financial data into indexed percentages, allowing analysts to quickly spot anomalies and form investment conclusions.

III. Core Concepts and Methodology of Trend Analysis

Trend analysis, also known as horizontal analysis, compares a company’s financial statement items over several consecutive periods (typically 3–5 years or more) against a chosen base year. Each line item is expressed as a percentage of the base-year amount, revealing the direction, magnitude, and patterns of change in financial position and performance.

Key Steps: 1. Select a base year (usually the earliest comparable year or the most stable operating period); 2. Divide each subsequent period’s amount by the base-year amount and multiply by 100 to obtain the trend percentage; 3. Analyze the direction and magnitude of the trend percentages in conjunction with economic cycles, industry conditions, and corporate strategy.

Trend analysis can be performed on absolute currency amounts, on common-size statements, or in combination with ratio analysis to create an integrated “trend + ratio” framework.

IV. Calculation Formulas

Trend Percentage = (Current Period Amount / Base Period Amount) × 100%

Percentage Change = [(Current Period Amount − Base Period Amount) / Base Period Amount] × 100%

In practice, analysts prepare a trend analysis table that displays absolute amounts, trend percentages, and year-over-year changes side by side.

V. Application of Trend Analysis to the Three Financial Statements

1. Income Statement Trend Analysis

Focus on whether the trends in revenue, gross profit, operating profit, and net profit are consistent. When revenue trends upward while net profit trends downward, it usually signals weakening cost control or rising impact of non-operating items.

2. Balance Sheet Trend Analysis

Examine whether growth in assets, liabilities, and equity is balanced. If assets grow significantly faster than revenue, there may be overcapacity or declining asset turnover. If liabilities grow much faster than equity, financial leverage risk is increasing.

3. Cash Flow Statement Trend Analysis

Compare the trend in net cash from operating activities with the net profit trend. When net profit grows but operating cash flow trends downward or lags, it may indicate aggressive revenue recognition, rising receivables, or inventory build-up.

VI. Indexed Trend Analysis

To remove scale differences across statement items, analysts may set the base year index to 100 and restate all subsequent periods relative to that index. This produces indexed trends that facilitate side-by-side comparison of multiple items.

Worked Cases

Case 1: Revenue versus Profit Trend Analysis

XYZ Company simplified income statement data 2019–2023 (in millions):

Trend percentages (2019 = 100%): - 2023 Revenue trend = (1,650 / 1,000) × 100% = 165% - 2023 Net profit trend = (135 / 120) × 100% = 112.5%

Interpretation: Revenue grew 65% from the base year, but net profit grew only 12.5%. Gross margin declined from 38% in 2020 to 29% in 2023, primarily due to rising raw-material costs and reduced pricing power.

Case 2: Balance Sheet Trend Analysis and Leverage Risk

ABC Company selected balance sheet items 2019–2023 (in millions, 2019 = 100):

Analysis: Total assets grew 84%, liabilities grew 130%, and equity grew only 38%. The debt-to-assets ratio rose from 50% to 62.5%, indicating materially higher financial risk. With revenue growth of only about 55%, the firm shows declining capacity utilization and rising repayment pressure.

Case 3: Cash Flow Trend and Earnings Quality

DEF Company net profit and operating cash flow trends 2019–2023 (2019 = 100):

Interpretation: Net profit trend consistently exceeds operating cash flow trend, with the gap widening each year. This suggests increasing investment in receivables and inventory and possible premature revenue recognition or inventory obsolescence risk. Analysts should scrutinize trends in receivables days and inventory turnover.

Traps

Key Formulas

• Trend Percentage = (Current Amount / Base Amount) × 100%
• Percentage Change = [(Current Amount − Base Amount) / Base Amount] × 100%
• Indexed Trend = (Current Trend % / Base Trend %) × 100 (base usually set at 100)
• Revenue trend > Cost trend > Expense trend → improving profitability
• Asset trend >> Revenue trend → declining asset turnover risk
• Net profit trend >> Operating cash flow trend → deteriorating earnings quality signal
• Trend analysis must be used together with common-size analysis and ratio analysis

Practice Questions

Q1. In trend analysis, the base year should normally be:
A. The most recent year
B. The earliest comparable year with stable operations
C. The year with the highest net profit
D. A loss-making year to magnify changes

Q2. A company reports revenue of CNY 24 million in 2023 and CNY 15 million in 2019 (base year). The 2023 revenue trend percentage is:
A. 60%
B. 160%
C. 37.5%
D. 62.5%

Q3. Trend analysis is most useful for:
A. Single-year structural analysis
B. Longitudinal comparison of multiple periods of financial data
C. Cross-sectional comparison with peer companies
D. Cash flow statement analysis only

Q4. If a company’s revenue trend percentage rises steadily but its net profit trend percentage declines each year, the most likely explanation is:
A. Fixed costs have fallen sharply
B. Costs and expenses are growing faster than revenue
C. The income tax rate has decreased
D. Non-operating income has increased substantially

Q5. Which of the following trend patterns is generally viewed as a signal of deteriorating earnings quality?
A. Operating cash flow trend percentage significantly above net profit trend
B. Operating cash flow trend percentage significantly below net profit trend
C. Declining trend in receivables collection period
D. Rising trend in inventory turnover

Q6. A firm’s total assets were CNY 50 million in 2019 and CNY 90 million in 2023 (2019 base). The total assets trend percentage in 2023 is:
A. 44.4%
B. 180%
C. 80%
D. 55.6%

Q7. When performing trend analysis in a high-inflation environment, an analyst should primarily:
A. Compare nominal amounts directly
B. Adjust using inflation-adjusted (real) amounts or industry indices
C. Analyze only the income statement
D. Ignore foreign-exchange effects

Q8. The main reason a trend analysis table shows both absolute amounts and trend percentages is to:
A. Facilitate common-size calculations
B. Observe both scale and relative changes simultaneously to identify anomalies
C. Replace ratio analysis
D. Forecast only the next year’s data

Answers

Takeaways

• Trend analysis expresses each period as a fixed-base-year percentage to reveal long-term patterns
• Core formula: Trend % = (Current / Base) × 100%
• Income statement, balance sheet, and cash flow trends must be read together
• Divergence between revenue and profit trends is a major risk flag
• Net profit trending well ahead of operating cash flow usually signals declining earnings quality
• Trend analysis is most powerful when combined with common-size analysis, ratio analysis, and industry benchmarking; mechanical reading must be avoided