Introductory Finance: Financial-Statements - Common-Size Financial Statements, Vertical and Horizontal Analysis

What This Is and Why It Matters

Common-size financial statements are a powerful tool for analyzing a company's financial health. They standardize financial data, making it easier to compare performance over time or against industry benchmarks. Mastering vertical and horizontal analysis is crucial for exam candidates and professionals. Misinterpreting these analyses can lead to poor investment decisions or missed financial red flags. For instance, overlooking a declining trend in profit margins could result in investing in a struggling company.

Core Knowledge (What You Must Internalize)

• Common-size financial statements: Standardized financial statements where each line item is expressed as a percentage of a base figure (Why this matters: It allows for easy comparison across different periods or companies).
• Vertical analysis: Expresses each item on the financial statement as a percentage of a base figure within the same period (Why this matters: It helps identify the composition of financial statements).
• Horizontal analysis: Expresses each item on the financial statement as a percentage of the same item from a base year (Why this matters: It helps identify trends over time).
• Base figure for vertical analysis: Typically total revenue for the income statement and total assets for the balance sheet (Why this matters: It provides a consistent reference point).
• Base year for horizontal analysis: Usually the earliest year in the data set (Why this matters: It sets a starting point for trend analysis).
• Key formulas:
• Vertical analysis formula: (Line item / Base figure) * 100
• Horizontal analysis formula: (Current year item / Base year item) * 100

Step?by?Step Deep Dive

1. Choose the Financial Statement: Decide whether you are analyzing the income statement, balance sheet, or cash flow statement.
2. Underlying principle: Different statements provide different insights.
3. Example: Analyzing the income statement to understand profitability trends.

4. Common pitfall: Mixing up statements can lead to incorrect interpretations.

5. Select the Base Figure for Vertical Analysis: For the income statement, use total revenue. For the balance sheet, use total assets.

6. Underlying principle: A consistent base figure allows for meaningful comparisons.
7. Example: If total revenue is $100,000, express cost of goods sold as a percentage of $100,000.

8. Common pitfall: Using inconsistent base figures can distort the analysis.

9. Calculate Vertical Analysis Percentages:

10. Action: Divide each line item by the base figure and multiply by 100.
11. Underlying principle: This standardizes the data for comparison.
12. Example: Cost of goods sold is $60,000. (60,000 / 100,000) * 100 = 60%.

13. Common pitfall: Forgetting to multiply by 100 can lead to incorrect percentages.

14. Select the Base Year for Horizontal Analysis: Choose the earliest year in your data set.

15. Underlying principle: This sets a starting point for trend analysis.
16. Example: If analyzing data from 2020 to 2022, use 2020 as the base year.

17. Common pitfall: Using a different base year can confuse trend analysis.

18. Calculate Horizontal Analysis Percentages:

19. Action: Divide each current year item by the base year item and multiply by 100.
20. Underlying principle: This shows the change over time.
21. Example: Revenue in 2020 is $100,000, and in 2021 it is $120,000. (120,000 / 100,000) * 100 = 120%.

22. Common pitfall: Miscalculating the base year item can skew the results.

23. Interpret the Results:

24. Action: Analyze the percentages to identify trends and compositions.
25. Underlying principle: Percentages reveal relative changes and compositions.
26. Example: A declining trend in profit margins may indicate rising costs.
27. Common pitfall: Overlooking small percentage changes can miss important trends.

How Experts Think About This Topic

Experts view common-size financial statements as a lens through which to see the relative importance and trends of financial items. They focus on the percentages rather than the absolute values, allowing them to quickly spot anomalies and trends that might be hidden in raw data.

Common Mistakes (Even Smart People Make)

• The mistake: Using the wrong base figure for vertical analysis.
• Why it's wrong: Incorrect base figures distort the analysis.
• How to avoid: Always use total revenue for the income statement and total assets for the balance sheet.

• Exam trap: Questions that provide multiple base figures to confuse the candidate.

• The mistake: Forgetting to multiply by 100 in percentage calculations.

• Why it's wrong: Results in incorrect percentages.
• How to avoid: Always verify the calculation includes multiplication by 100.

• Exam trap: Questions that require precise percentage calculations.

• The mistake: Mixing up vertical and horizontal analysis.

• Why it's wrong: Leads to incorrect interpretations of financial health.
• How to avoid: Clearly distinguish between the two types of analysis.

• Exam trap: Questions that require both types of analysis.

• The mistake: Ignoring small percentage changes.

• Why it's wrong: Small changes can indicate significant trends.
• How to avoid: Pay attention to all percentage changes, no matter how small.
• Exam trap: Questions that highlight small but important trends.

Practice with Real Scenarios

Scenario: A company's income statement shows total revenue of $200,000 and cost of goods sold of $120,000. Question: Calculate the cost of goods sold as a percentage of total revenue using vertical analysis. Solution:
1. Identify the base figure: Total revenue = $200,000.
2. Calculate the percentage: (120,000 / 200,000) * 100 = 60%. Answer: 60%. Why it works: This percentage shows the relative cost of goods sold compared to total revenue.

Scenario: A company's revenue was $100,000 in 2020 and $150,000 in 2021. Question: Calculate the percentage change in revenue from 2020 to 2021 using horizontal analysis. Solution:
1. Identify the base year: 2020.
2. Calculate the percentage: (150,000 / 100,000) * 100 = 150%. Answer: 150%. Why it works: This percentage shows the growth in revenue over the period.

Scenario: A company's balance sheet shows total assets of $500,000 and total liabilities of $300,000. Question: Calculate the total liabilities as a percentage of total assets using vertical analysis. Solution:
1. Identify the base figure: Total assets = $500,000.
2. Calculate the percentage: (300,000 / 500,000) * 100 = 60%. Answer: 60%. Why it works: This percentage shows the relative size of liabilities compared to assets.

Quick Reference Card

• Core rule: Common-size financial statements express each line item as a percentage of a base figure.
• Key formula: (Line item / Base figure) * 100 for vertical analysis; (Current year item / Base year item) * 100 for horizontal analysis.
• Critical facts:
• Use total revenue for income statement vertical analysis.
• Use total assets for balance sheet vertical analysis.
• Use the earliest year for horizontal analysis.
• Dangerous pitfall: Using the wrong base figure or year.
• Mnemonic: "Vertical is within, horizontal is over time."

If You're Stuck (Exam or Real Life)

• Check first: Verify you are using the correct base figure or year.
• Reason from first principles: Remember the purpose of each analysis type.
• Use estimation: Round numbers to simplify calculations.
• Find the answer: Refer to financial statement examples or past analyses.

Related Topics

• Ratio Analysis: Provides additional insights into a company's financial health by comparing different financial metrics.
• Trend Analysis: Helps identify long-term patterns in financial data, complementing horizontal analysis.