Introductory Corporate Finance: Financial Statement Analysis - Trend Analysis Common-Size Statements

What This Is

Trend analysis and common-size statements are essential tools in corporate finance for evaluating a company's financial performance over time and comparing it to industry peers. By analyzing trends in financial ratios and common-size statements, investors and analysts can identify areas of strength and weakness, make informed investment decisions, and assess a company's ability to sustain its growth. For example, let's consider Tesla's financial performance over the past three years:

Key Formulas & Models

• Trend Analysis Formula: (Current Year Value - Previous Year Value) / Previous Year Value – measures the percentage change in a financial metric over time.
  • Symbol: Current Year Value, Previous Year Value
  • Interpretation: Positive trend indicates improvement, negative trend indicates decline.
• Common-Size Statement Formula: (Current Year Value / Total Assets) x 100 – expresses each financial metric as a percentage of total assets.
  • Symbol: Current Year Value, Total Assets
  • Interpretation: Helps compare financial performance across different companies and industries.
• DuPont Analysis Formula: ROE = (Net Income / Sales) x (Sales / Total Assets) x (Total Assets / Equity)
  • Symbol: ROE, Net Income, Sales, Total Assets, Equity
  • Interpretation: Breaks down return on equity (ROE) into three components: profit margin, asset turnover, and leverage.
• Debt-to-Equity Ratio Formula: Debt / Equity
  • Symbol: Debt, Equity
  • Interpretation: Measures a company's financial leverage and risk.
• Interest Coverage Ratio Formula: EBIT / Interest Expenses
  • Symbol: EBIT, Interest Expenses
  • Interpretation: Evaluates a company's ability to meet its interest payments.
• Current Ratio Formula: Current Assets / Current Liabilities
  • Symbol: Current Assets, Current Liabilities
  • Interpretation: Measures a company's short-term liquidity and solvency.
• Quick Ratio Formula: (Current Assets - Inventory) / Current Liabilities
  • Symbol: Current Assets, Inventory, Current Liabilities
  • Interpretation: A more conservative measure of liquidity, excluding inventory.

Step-by-Step Calculation

1. Calculate the trend in revenue over the past three years using the trend analysis formula:
   • 2021 revenue trend = (53.77 - 24.57) / 24.57 = 118.3%
   • 2022 revenue trend = (81.46 - 53.77) / 53.77 = 51.3%
2. Prepare a common-size statement for Tesla in 2022:
   • Total Assets = $103.19B
   • Current Assets = $63.45B
   • Current Liabilities = $24.15B
   • Inventory = $10.23B
   • Debt = $25.56B
   • Equity = $77.63B
3. Calculate the DuPont analysis components:
   • Profit Margin = Net Income / Sales = $12.62B / $81.46B = 15.5%
   • Asset Turnover = Sales / Total Assets = $81.46B / $103.19B = 0.79
   • Leverage = Total Assets / Equity = $103.19B / $77.63B = 1.33
4. Calculate the debt-to-equity ratio:
   • Debt / Equity = $25.56B / $77.63B = 0.33
5. Calculate the interest coverage ratio:
   • EBIT = $10.23B
   • Interest Expenses = $1.23B
   • EBIT / Interest Expenses = $10.23B / $1.23B = 8.31

Common Mistakes

• Mistake: Using book value instead of market value for WACC calculation.
  • Correction: Use market value of debt and equity to calculate WACC, as it reflects the current market conditions.
• Mistake: Ignoring flotation costs when calculating WACC.
  • Correction: Include flotation costs in the WACC calculation to reflect the true cost of capital.
• Mistake: Confusing sunk cost with opportunity cost.
  • Correction: Sunk cost is a past investment, while opportunity cost is the potential benefit of an alternative investment.

Exam / CFA Tips

• Tip: Be prepared to calculate trend analysis and common-size statements for a given company or industry.
• Tip: Understand the DuPont analysis and its components, and be able to apply it to a case study.
• Tip: Be able to calculate and interpret key financial ratios, such as debt-to-equity ratio, interest coverage ratio, and current ratio.

Quick Practice Problem

A company has EBIT of $10M, interest $2M, tax 25% – compute DFL (debt-free leverage).

Answer: DFL = (EBIT - Interest) / (EBIT - Interest - Tax) = ($10M - $2M) / ($10M - $2M - $2.5M) = 1.67

Last-Minute Cram Sheet

• Trend analysis measures the percentage change in a financial metric over time.
• Common-size statement expresses each financial metric as a percentage of total assets.
• DuPont analysis breaks down ROE into three components: profit margin, asset turnover, and leverage.
• Debt-to-equity ratio measures a company's financial leverage and risk.
• Interest coverage ratio evaluates a company's ability to meet its interest payments.
• Current ratio measures a company's short-term liquidity and solvency.
• Quick ratio is a more conservative measure of liquidity, excluding inventory.
• Sunk cost is a past investment, while opportunity cost is the potential benefit of an alternative investment.
• In M&M Proposition I (no taxes), firm value is independent of capital structure – but with taxes, value increases with debt due to the interest tax shield.
• WACC is the weighted average cost of capital, used as the discount rate for cash flows.
• DOL (degree of operating leverage) measures EBIT sensitivity to sales.