Comprehensive Financial Statement Analysis Study Notes

Principles of Financial Statement Analysis

• Financial statement analysis utilizes a firm's financial statements to extract critical insights regarding operational performance, financial stability, and strategic positioning.

• Key managerial and financial questions answered through financial statement analysis include:

  • Can the firm meet its financial obligations and repay creditors?

  • What underlying trends exist within the firm's revenues, expenses, and profitability over time?

  • How effectively does the firm perform relative to industry competitors?

  • Which operational segments of the business are functioning with the highest or lowest level of efficiency?

Cash Flow Dynamics and Financial Statements

• At its most fundamental operational level, a business entity engages in two primary activities:

  • Generating cash through operations, asset disposals, or financing.

  • Spending cash on investments, operating activities, debt service, or distributions.

• Cash flows can be formally summarized by the fundamental cash flow identity: $\text{Cash Flow from Assets} = \text{Cash Flow to Creditors} + \text{Cash Flow to Stockholders}$

• Tracking cash movement requires classifying line item changes between balance sheet periods into sources and uses of cash:

  • Sources of Cash: Activities that bring cash into the firm.

  • A decrease in a left-side (asset) account: Indicates that the firm, on a net basis, sold off assets (e.g., liquidating inventory or collecting accounts receivable).

  • An increase in a right-side (liability or equity) account: Indicates that the firm raised funds through borrowing or equity issuance (e.g., issuing common stock or incurring trade payable debt).

  • Uses of Cash: Activities that involve spending cash.

  • An increase in a left-side (asset) account: Indicates that the firm, on a net basis, purchased assets (e.g., acquiring plant and equipment or accumulating inventory).

  • A decrease in a right-side (liability or equity) account: Indicates that the firm paid off obligations or reduced equity (e.g., retiring long-term debt or repurchasing shares).

Primary Financial Statements: Case Study of Prufrock Corporation

• Prufrock Corporation Balance Sheet Analysis (2020 vs. 2021 in $ millions):

  • Assets:

  • Cash: Changed from $\$84$ in 2020 to $\$146$ in 2021 ($+\$62$ change).

  • Accounts receivable: Changed from $\$165$ in 2020 to $\$188$ in 2021 ($+\$23$ change).

  • Inventory: Changed from $\$393$ in 2020 to $\$422$ in 2021 ($+\$29$ change).

  • Total Current Assets: Changed from $\$642$ in 2020 to $\$756$ in 2021 ($+\$114$ change).

  • Net plant and equipment: Changed from $\$2,731$ in 2020 to $\$2,880$ in 2021 ($+\$149$ change).

  • Total Assets: Changed from $\$3,373$ in 2020 to $\$3,636$ in 2021 ($+\$263$ change).

  • Liabilities and Owners' Equity:

  • Accounts payable: Changed from $\$312$ in 2020 to $\$344$ in 2021 ($+\$32$ change).

  • Notes payable: Changed from $\$231$ in 2020 to $\$196$ in 2021 ($-\$35$ change).

  • Total Current Liabilities: Changed from $\$543$ in 2020 to $\$540$ in 2021 ($-\$3$ change).

  • Long-term debt: Changed from $\$531$ in 2020 to $\$457$ in 2021 ($-\$74$ change).

  • Common stock and paid-in surplus: Changed from $\$500$ in 2020 to $\$550$ in 2021 ($+\$50$ change).

  • Retained earnings: Changed from $\$1,799$ in 2020 to $\$2,089$ in 2021 ($+\$290$ change).

  • Total Owners' Equity: Changed from $\$2,299$ in 2020 to $\$2,639$ in 2021 ($+\$340$ change).

  • Total Liabilities and Owners' Equity: Changed from $\$3,373$ in 2020 to $\$3,636$ in 2021 ($+\$263$ change).

• Prufrock Corporation Summary of Sources and Uses of Cash (2021 in $ millions):

  • Sources of cash:

  • Increase in accounts payable: $\$32$

  • Increase in common stock: $\$50$

  • Increase in retained earnings: $\$290$

  • Total sources: $\$372$

  • Uses of cash:

  • Increase in accounts receivable: $\$23$

  • Increase in inventory: $\$29$

  • Decrease in notes payable: $\$35$

  • Decrease in long-term debt: $\$74$

  • Net fixed asset acquisitions: $\$149$

  • Total uses: $\$310$

  • Net addition to cash: $\$372 - \$310 = \$62$

• Prufrock Corporation Income Statement (2021 in $ millions):

  • Sales: $\$2,311$

  • Cost of goods sold: $\$1,344$

  • Depreciation: $\$276$

  • Earnings before interest and taxes (EBIT): $\$691$

  • Interest paid: $\$141$

  • Taxable income: $\$550$

  • Taxes (at a corporate rate of $21\%$): $\$116$

  • Net income: $\$435$

  • Dividends paid: $\$145$

  • Addition to retained earnings: $\$290$

• Prufrock Corporation Statement of Cash Flows (2021 in $ millions):

  • Beginning Cash Balance: $\$84$

  • Operating Activity:

  • Net income: $\$435$

  • Plus depreciation expense: $\$276$

  • Plus increase in accounts payable: $\$32$

  • Less increase in accounts receivable: $\$-\$23$

  • Less increase in inventory: $\$-\$29$

  • Net cash generated from operating activity: $\$691$

  • Investment Activity:

  • Gross fixed asset acquisitions: $\$-\$425$

  • Net cash used in investment activity: $\$-\$425$

  • Financing Activity:

  • Decrease in notes payable: $\$-\$35$

  • Decrease in long-term debt: $\$-\$74$

  • Dividends paid: $\$-\$145$

  • Increase in common stock: $\$50$

  • Net cash used in financing activity: $\$-\$204$

  • Net Increase in Cash: $\$691 - \$425 - \$204 = \$62$

  • Ending Cash Balance: $\$84 + \$62 = \$146$

• Detailed Breakdown of Sources and Uses Statement (2021 in $ millions):

  • Cash at beginning of year: $\$84$

  • Total Sources of Cash ($\$793$ total):

  • Operations: Net income $\$435$ + Depreciation $\$276$ = $\$711$

  • Working capital: Increase in accounts payable $\$32$

  • Long-term financing: Increase in common stock $\$50$

  • Total Uses of Cash ($\$731$ total):

  • Working capital: Increase in accounts receivable $\$23$ + Increase in inventory $\$29$ + Decrease in notes payable $\$35$

  • Long-term financing: Decrease in long-term debt $\$74$

  • Fixed asset acquisitions: $\$425$

  • Dividends paid: $\$145$

  • Net addition to cash: $\$793 - \$731 = \$62$

  • Cash at end of year: $\$146$

Standardized Financial Statements

• Direct comparison of raw financial numbers between companies is virtually impossible due to variations in size and scale.

• Comparing historical statements across different time periods for the same firm is equally challenging if substantial enterprise growth or contraction has occurred.

• Financial statements must be standardized to establish valid benchmarks:

  • Common-Size Statements: Scale line items into percentages.

  • Common-Size Balance Sheet: Expresses all asset, liability, and equity entries as a percentage of Total Assets.

  • Common-Size Income Statement: Expresses all revenue, cost, and income items as a percentage of Total Sales (or Net Revenue).

  • Common-Size Statement of Cash Flows: Expresses items as a percentage of total sources (or total uses).

  • Common-Base Year Statements (Trend Analysis): Expresses all figures relative to a designated base-year base amount to isolate structural growth patterns.

• Prufrock Corporation Common-Size Balance Sheets (2023 vs. 2024):

  • Assets (% of Total Assets):

  • Cash: $2.5\%$ in 2023, $4.0\%$ in 2024 ($+1.5\%$ change).

  • Accounts receivable: $4.9\%$ in 2023, $5.2\%$ in 2024 ($+0.3\%$ change).

  • Inventory: $11.7\%$ in 2023, $11.6\%$ in 2024 ($+0.0\%$ change).

  • Total Current Assets: $19.0\%$ in 2023, $20.8\%$ in 2024 ($+1.8\%$ change).

  • Net plant and equipment: $81.0\%$ in 2023, $79.2\%$ in 2024 ($-1.8\%$ change).

  • Total Assets: $100.0\%$ in 2023 and 2024.

  • Liabilities and Owners' Equity (% of Total Assets):

  • Accounts payable: $9.2\%$ in 2023, $9.5\%$ in 2024 ($+0.2\%$ change).

  • Notes payable: $6.8\%$ in 2023, $5.4\%$ in 2024 ($-1.5\%$ change).

  • Total Current Liabilities: $16.1\%$ in 2023, $14.9\%$ in 2024 ($-1.2\%$ change).

  • Long-term debt: $15.7\%$ in 2023, $12.6\%$ in 2024 ($-3.2\%$ change).

  • Common stock and paid-in surplus: $14.8\%$ in 2023, $15.1\%$ in 2024 ($+0.3\%$ change).

  • Retained earnings: $53.3\%$ in 2023, $57.5\%$ in 2024 ($+4.1\%$ change).

  • Total Owners' Equity: $68.2\%$ in 2023, $72.6\%$ in 2024 ($+4.4\%$ change).

  • Total Liabilities and Owners' Equity: $100.0\%$ in 2023 and 2024.

• Company ABC Income Statement Common-Size Analysis (2018 - 2020):

  • Net Revenue: $\$34,934,998$ (2018), $\$56,302,067$ (2019), $\$112,209,172$ (2020) — Common-size: $100\%$ across all years.

  • Direct Costs: $\$27,046,450$ (2018), $\$43,728,157$ (2019), $\$89,365,467$ (2020) — Common-size: $77\%$ (2018), $78\%$ (2019), $80\%$ (2020).

  • Gross Profit: $\$7,888,548$ (2018), $\$12,573,909$ (2019), $\$22,843,705$ (2020) — Common-size: $23\%$ (2018), $22\%$ (2019), $20\%$ (2020).

  • Operating Costs (Detailed breakdown):

  • Sales & Marketing: $\$200,000$ ($1\%$ in 2018), $\$415,500$ ($1\%$ in 2019), $\$454,000$ ($0\%$ in 2020).

  • General & Admin: $\$626,000$ ($2\%$ in 2018), $\$782,000$ ($1\%$ in 2019), $\$992,000$ ($1\%$ in 2020).

  • Research & Development: $\$50,000$ ($0\%$ in 2018), $\$55,000$ ($0\%$ in 2019), $\$110,000$ ($0\%$ in 2020).

  • Other Operating Costs: $\$50,000$ ($0\%$ in 2018), $\$50,200$ ($0\%$ in 2019), $\$52,400$ ($0\%$ in 2020).

  • Depreciation: $\$217,500$ ($1\%$ in 2018), $\$525,487$ ($1\%$ in 2019), $\$1,199,008$ ($1\%$ in 2020).

  • Total Operating Costs: $\$1,143,500$ ($3\%$ in 2018), $\$1,828,187$ ($3\%$ in 2019), $\$2,807,408$ ($3\%$ in 2020).

  • Earnings Before Interest and Taxes (EBIT): $\$6,745,048$ ($19\%$ in 2018), $\$10,745,723$ ($19\%$ in 2019), $\$20,036,296$ ($18\%$ in 2020).

  • Interest Expense: $\$99,515$ ($0\%$ in 2018), $\$73,237$ ($0\%$ in 2019), $\$104,649$ ($0\%$ in 2020).

  • Tax Charge: $\$1,395,562$ ($4\%$ in 2018), $\$2,241,222$ ($4\%$ in 2019), $\$4,185,646$ ($4\%$ in 2020).

  • Net Profit: $\$5,249,971$ ($15\%$ in 2018), $\$8,431,264$ ($15\%$ in 2019), $\$15,746,001$ ($14\%$ in 2020).

Categorization of Financial Ratios

• Financial ratios create quantitative relationships derived from balance sheets and income statements, enabling comparisons across entities regardless of scale.

• Ratio computation methods vary across different financial textbooks and analytics software, leading to minor variations in definitions.

• Financial ratios are categorized into five distinct functional categories:

  • Short-term solvency, or liquidity, ratios

  • Long-term solvency, or financial leverage, ratios

  • Asset management, or turnover, ratios

  • Profitability ratios

  • Market value ratios

1. Short-Term Solvency (Liquidity) Ratios

• Solvency measures assess the ability of a business to cover short-term liabilities with short-term assets without suffering financial distress.

• Current Ratio: $\text{Current ratio} = \frac{\text{Current assets}}{\text{Current liabilities}}$

  • Evaluates immediate operational liquidity.

  • Creditors prefer higher ratios as a margin of safety against default.

  • A very high ratio can signal inefficient cash management or excessive inventory holding.

  • Baseline expectations generally require a current ratio of at least $1.0$

• Quick Ratio (Acid-Test Ratio): $\text{Quick ratio} = \frac{\text{Current assets} - \text{Inventory}}{\text{Current liabilities}}$

  • Excludes inventory from liquid assets because inventory is typically the least liquid current asset.

  • Disproportionately large inventory piles can disguise insolvency if relying strictly on the current ratio.

• Cash Ratio: $\text{Cash ratio} = \frac{\text{Cash}}{\text{Current liabilities}}$

  • Evaluates immediate cash availability relative to short-term liabilities, used primarily by short-term creditors.

• Net Working Capital (NWC) to Total Assets: $\text{Net working capital to total assets} = \frac{\text{Net working capital}}{\text{Total assets}}$

  • Quantifies liquid capital as a percentage of total enterprise assets. Low values suggest low liquidity reserves.

• Interval Measure: $\text{Interval measure} = \frac{\text{Current assets}}{\text{Average daily operating costs}}$

  • Estimates how many days the business can continue operating without requiring additional current asset inflows.

2. Long-Term Solvency (Financial Leverage) Ratios

• Leverage ratios determine how heavily a company relies on debt to finance operations and measure long-term repayment capacity.

• Total Debt Ratio: $\text{Total debt ratio} = \frac{\text{Total assets} - \text{Total equity}}{\text{Total assets}}$

  • Captures obligations of all maturities owed to all classes of creditors.

• Debt-Equity Ratio: $\text{Debt-equity ratio} = \frac{\text{Total debt}}{\text{Total equity}}$

• Equity Multiplier: $\text{Equity multiplier} = \frac{\text{Total assets}}{\text{Total equity}}$

• Long-Term Debt Ratio: $\text{Long-term debt ratio} = \frac{\text{Long-term debt}}{\text{Long-term debt} + \text{Total equity}}$

• Times Interest Earned (TIE) Ratio (also called Interest Coverage Ratio): $\text{Times interest earned ratio} = \frac{\text{EBIT}}{\text{Interest}}$

  • Evaluates how comfortably operating cash generation covers recurring interest payments.

• Cash Coverage Ratio: $\text{Cash coverage ratio} = \frac{\text{EBIT} + \text{Depreciation}}{\text{Interest}}$

  • Assesses cash available to satisfy debt service obligations by adding non-cash depreciation expenses back to EBIT (yielding EBITD in the numerator).

3. Asset Management (Turnover) Ratios

• Asset management measures assess how efficiently management deploys company resources to generate revenues.

• Inventory Turnover: $\text{Inventory turnover} = \frac{\text{Cost of goods sold}}{\text{Inventory}}$

  • Measures how many times a firm completely turns over or sells off its total inventory inventory stock over a period.

• Days' Sales in Inventory: $\text{Days' sales in inventory} = \frac{365\,\text{days}}{\text{Inventory turnover}}$

  • Quantifies the average number of days inventory sits before being sold.

• Receivables Turnover: $\text{Receivables turnover} = \frac{\text{Sales}}{\text{Accounts receivable}}$

  • Measures the speed with which credit sales are collected and re-loaned.

• Days' Sales in Receivables: $\text{Days' sales in receivables} = \frac{365\,\text{days}}{\text{Receivables turnover}}$

  • Represents the average collection period required to turn credit sales into cash.

• NWC Turnover: $\text{NWC turnover} = \frac{\text{Sales}}{\text{NWC}}$

  • Measures the output generated per unit of net working capital.

• Fixed Asset Turnover: $\text{Fixed asset turnover} = \frac{\text{Sales}}{\text{Net fixed assets}}$

  • Measures sales generated per dollar invested in fixed assets.

• Total Asset Turnover: $\text{Total asset turnover} = \frac{\text{Sales}}{\text{Total assets}}$

  • Measures overall asset utilization efficiency.

4. Profitability Ratios

• Profitability ratios measure operational efficiency and how effectively top-line revenues convert into net earnings.

• Profit Margin: $\text{Profit margin} = \frac{\text{Net income}}{\text{Sales}}$

  • Measures net profit generated per dollar of sales revenue.

  • Shows substantial variation depending on industry sector economics.

• Return on Assets (ROA): $\text{Return on assets (ROA)} = \frac{\text{Net income}}{\text{Total assets}}$

  • An accounting rate of return measuring profit generated per dollar of assets. Technically termed return on book assets.

• Return on Equity (ROE): $\text{Return on equity (ROE)} = \frac{\text{Net income}}{\text{Total equity}}$

  • An accounting rate of return measuring shareholder return per dollar of equity capital. Technically termed return on book equity.

5. Market Value Ratios

• Market value ratios combine public stock market price data with accounting numbers to evaluate investor perceptions of firm value.

• Price-Earnings (PE) Ratio: $\text{Price-earnings ratio} = \frac{\text{Price per share}}{\text{Earnings per share}}$

  • Indicates how much investors pay per dollar of current earnings.

  • Typical large U.S. corporations traded within a PE range of $15\text{ to }20$ in 2020.

  • High PE ratios signal expected future growth or, alternatively, temporarily depressed earnings.

• PEG Ratio: $\text{PEG ratio} = \frac{\text{Price-earnings ratio}}{\text{Earnings growth rate (\%)}}$

• Price-Sales Ratio: $\text{Price-sales ratio} = \frac{\text{Price per share}}{\text{Sales per share}}$

  • Particularly useful when earnings are zero or negative, making the PE ratio undefined or meaningless.

• Market-to-Book Ratio: $\text{Market-to-book ratio} = \frac{\text{Market value per share}}{\text{Book value per share}}$

  • Compares total market valuation against historical accounting costs. Values below $1.0$ indicate potential destruction of shareholder capital.

• Tobin's Q Ratio: $\text{Tobin's Q ratio} = \frac{\text{Market value of assets}}{\text{Replacement cost of assets}}$

• Enterprise Value-EBITDA Ratio: $\text{Enterprise value-EBITDA ratio} = \frac{\text{Enterprise value}}{\text{EBITDA}}$

Limitations and Analytical Challenges

• Lack of Underlying Theory: No single comprehensive economic framework dictates which specific financial metrics must be selected or defines universal normative benchmarks.

• Conglomerate Complexity: Multinational conglomerates operate across diverse, unrelated business sectors, producing consolidated accounting statements that do not conform neatly to any single industry classification.

• Global Dispersion: Direct peer group competitors are frequently domiciled in foreign jurisdictions, complicating comparability.

• Accounting Standard Disparities: International firms operate under distinct accounting rules that do not conform strictly to U.S. Generally Accepted Accounting Principles (GAAP).

• Procedural Differences: Firms within the same industry sector often choose divergent inventory valuation techniques (e.g., LIFO vs. FIFO) or depreciation schedules.

• Fiscal Year Timing: Non-standard fiscal year-end dates alter seasonal revenue and asset balances across peer group comparisons.

• One-Time Distortions: Transient, extraordinary, or non-recurring events can distort financial performance numbers in a single accounting period.