Chapter 3 Notes: Financial Ratio Analysis

Overview: context and practical workflow

• Access to financial ratios via online tools (e.g., Msmmoney.com, Google Finance, voyages.com) and relevance for non-finance majors working in financial services.
• Real-world scenario: system downtime at a brokerage/financial services firm. If tools are unavailable, you can still:
  • Calculate key ratios by hand to engage with customers.
  • Use ratio analysis as a demonstration of understanding and to potentially impress clients.
• Personal anecdote: the instructor’s past experience at a mutual fund company in South Korea. As a rookie, consulting with customers and introducing financial instruments; when the system failed, improvising with ratio knowledge helped save money for a client.
• Core lesson: even with abundant data today, understand how information is obtained and interpreted; ratios alone do not tell the complete story.
• Emphasis on the importance of calculating, then benchmarking and time-trend analysis to form meaningful conclusions.

Key concepts and study approach

• Two main analyses when evaluating a company’s ratios:
  • Time-trend (time-series) analysis: compare the company’s data across multiple years (minimum five years recommended, but for practice two-year data is allowed).
  • Peer-group benchmarking: compare against competitors and/or industry averages (peer group analysis).
• Benchmarks help determine whether a ratio tells the right story (e.g., same ratio could be ok in one industry and poor in another).
• Many free websites once provided broad benchmarking data; today, some information is behind subscriptions, so use available free sources and/or industry/peer comparisons.
• Practical note on sources: download balance sheet and income statement data from websites such as Financier, MSNMoney, Reuters, or Google Finance; always cite data sources in the report.
• For calculations, use Excel rather than manual word-processed numbers to ensure accuracy and speed; instructors may grade by checking formulas rather than retyping numbers.

Current and short-term solvency ratios (working capital focus)

• Current ratio formula: CR = rac{Current\ Assets}{Current\ Liabilities}
  • Rule of thumb: CR should be greater than 1, indicating sufficient current assets to cover short-term obligations.
  • Example discussion: Walmart’s current ratio was reported as below 1 (e.g., around 0.89), which is generally viewed as a warning sign.
  • Benchmarking: compare Walmart’s CR to industry/peer averages and to its own historical trend.
• Time-trend vs. benchmark interpretation:
  • Look at how Walmart’s CR has evolved since 2022; compare against the industry and Walmart’s peers to assess relative risk.
• Quick ratio (aka acid-test ratio) and cash ratio (briefly referenced):
  • Quick ratio excludes inventories from current assets to assess liquidity with most liquid assets.
  • Cash ratio focuses on cash and cash equivalents, the most conservative liquidity measure.
• Importance of context: ratio values need to be interpreted in light of the company’s operating cycle and seasonality; a single number does not provide the full picture.

Time-trend and benchmarking tasks in assignments

• Time-trend analysis:
  • Use at least five years of data as a minimum; for practice, two years may be acceptable to see direction (up/down/flat).
• Peer-group analysis:
  • Compare your company’s ratios to competitors and/or industry averages (peer group analysis).
  • Industry averages provide context, but industry can be broad; peers may be more relevant for comparability.
• Benchmark sources:
  • Some sites once offered free benchmarks; now much is behind paywalls.
  • Walmart’s industry/peer data example illustrates how benchmarks can inform interpretation.
• Interpretation approach:
  • If a ratio is strong in isolation, check against benchmarks and time trends to determine if it truly reflects strong performance or if issues exist elsewhere.

Long-term solvency and financial leverage (debt capacity and risk)

• Category overview: long-term solvency/financial leverage ratios focus on debt and the ability to service debt over time.
• Three key ratios (historic convention):
  • Total debt ratio:
    ext{Total debt ratio} = rac{ ext{Total Liabilities}}{ ext{Total Assets}} = 1 - rac{ ext{Total Equity}}{ ext{Total Assets}}
  • Interpretation: proportion of assets financed by debt.
  • Example interpretation: if ext{Total debt ratio} = 0.28, then 28% of assets are financed with debt and 72% with equity.
  • Debt to equity ratio:
    ext{Debt to Equity} = rac{ ext{Total Debt}}{ ext{Total Equity}}
  • Higher debt to equity implies higher leverage; compare to peers to assess risk of bankruptcy and financial flexibility.
  • Equity multiplier:
    ext{Equity Multiplier} = rac{ ext{Total Assets}}{ ext{Total Equity}} = 1 + rac{ ext{Total Debt}}{ ext{Total Equity}}
  • Indicates how assets are financed relative to equity.
• Relationship among the three:
  • ext{Equity Multiplier} = rac{ ext{Total Assets}}{ ext{Total Equity}} = rac{ ext{Total Debt} + ext{Total Equity}}{ ext{Total Equity}} = 1 + rac{ ext{Total Debt}}{ ext{Total Equity}}
  • If you know any two of these, you can derive the third (e.g., Total Assets = Total Debt + Total Equity).
• Data sources for these ratios:
  • Calculations generally use balance sheet data (assets, liabilities, equity) from the balance sheet; times interest earned and other ratios use income statement data as needed.
• Times interest earned (TIE) and cash coverage (debt service) ratios:
  • Times interest earned:
    ext{TIE} = rac{EBIT}{Interest}
  • Higher is better: indicates stronger ability to cover interest payments.
  • Cash coverage ratio (a conservative variant):
    ext{Cash Coverage} = rac{EBIT + ext{Depreciation}}{Interest}
  • Adds back non-cash depreciation to reflect cash-generating capacity for debt service.
• Practical interpretation notes:
  • In theory, higher leverage could be favorable if the tax shield and return on assets exceed the cost of debt, but bankruptcy risk and regime realities constrain the ideal point.
  • In practice, use multiple solvency ratios together rather than relying on a single metric.

Asset management and turnover ratios (efficiency of using assets)

• Asset management ratios focus on how efficiently a firm uses its assets to generate sales and manage working capital.
• Inventory turnover ratio: ext{Inventory Turnover} = rac{COGS}{ ext{Inventory}}
  • Data sources: Cost of goods sold (COGS) from the income statement; Inventory from the balance sheet.
  • Higher turnover generally indicates inventory is sold and replenished quickly.
  • Interpretation depends on benchmarking against industry/peers and historical trend.
• Day sales in inventory (DSI): ext{DSI} = rac{365}{ ext{Inventory Turnover}}
  • Higher turnover yields a lower DSI, which is typically favorable (faster inventory turnover).
• Receivable turnover ratio:
  • Definition: usually ext{Receivable Turnover} = rac{Net Credit Sales}{Average Accounts Receivable}
  • Higher turnover indicates quicker collection of receivables.
• Payable turnover ratio:
  • Definition: usually computed as ext{Payable Turnover} = rac{Purchases}{Average Accounts Payable} or using COGS depending on data availability.
  • Higher turnover means faster payment to suppliers (shorter payable period).
• Total asset turnover: ext{Total Asset Turnover} = rac{ ext{Sales}}{ ext{Total Assets}}
  • Measures how efficiently assets generate sales.
• Capital intensity ratio: ext{Capital Intensity} = rac{ ext{Total Assets}}{ ext{Sales}} = rac{1}{ ext{Asset Turnover}}
  • Higher capital intensity means more assets are required per unit of sales.
• Data considerations for asset management:
  • These ratios use a mix of income statement and balance sheet data.
  • Different sources may present slightly different definitions; always state the exact formula used.

Inventory nuances and seasonality considerations

• Inventory valuation timing and seasonality can distort ratios if using ending inventory data alone.
• Recommendations:
  • Consider using average inventory over the period instead of ending inventory to smooth seasonal effects.
  • If seasonality is strong, use quarterly data and average across quarters to compute annualized metrics.
  • If only annual data is available, explicitly acknowledge seasonality and justify any adjustments or caveats.
  • For companies with pronounced seasonality (e.g., retailers, energy-related firms), consider describing the seasonal pattern in the report and justify method choices.
• Practical workaround for assignments:
  • If seasonality is evident, supplement annual calculations with quarterly data where possible and report both results.
  • Alternatively, articulate that the annual result may be distorted and provide caveats and a note on limitations.

Benchmarking and interpretation strategies

• Two-tier benchmarking framework:
  • Time-trend analysis: compare a single company’s ratios over multiple years to identify trends (growth, stability, deterioration).
  • Peer-group/industry benchmarking: compare against competitors or industry averages to gauge relative performance.
• Benchmark limitations:
  • Industry averages can be too broad; peer groups provide more relevant comparability.
  • Free benchmarking data may be limited; some information is behind paywalls.
• Practical interpretation guidance:
  • Do not rely on a single ratio; analyze a suite of ratios together.
  • Even if a ratio looks strong, consider debt levels, liquidity, and solvency collectively to assess financial health.
• Example context: Walmart’s current ratio analysis showed a low ratio; cross-check with debt ratios and industry/peer benchmarks to determine overall risk position.

Data collection, tools, and assignment workflow

• Data sources and data gathering:
  • Use balance sheet and income statement data from financial data websites (e.g., Financier, MSNMONEY, Reuters, Google Finance).
  • Always cite data sources in the report.
• Calculation tools:
  • Use Excel to compute ratios with proper formulas; this speeds up grading and reduces arithmetic errors.
  • Instructors may verify by clicking into cells to check formulas.
• Assignment structure and expectations:
  • Students should download and import data from the chosen sources, compute all required ratios, and present results with references.
  • Provide both time-trend and peer-group analyses for each company study.

Practical notes on class logistics and upcoming topics

• The next topic will continue with the second set of financial metrics (continuing the five categories) and then move into different identity analyses.
• Students should prepare for an upcoming assignment (Chapter 2 review) and check Connect for keys and scheduling.
• Instructor reminders: attendance, grading considerations, and how to handle changes in company pairings for assignments.

Anecdotes and practical takeaways

• The value of ratio knowledge in real-world customer interactions and in crisis situations (system downtime).
• Always verify whether the calculated ratio aligns with the broader context (seasonality, industry norms, and historical trends).
• A well-rounded analysis combines multiple ratios and benchmarking to form a robust assessment of a company’s liquidity, solvency, and efficiency.

Quick reference: key formulas (summary)

• Current ratio: CR = rac{Current\ Assets}{Current\ Liabilities}
• Total debt ratio: ext{Total debt ratio} = rac{ ext{Total Liabilities}}{ ext{Total Assets}} = 1 - rac{ ext{Total Equity}}{ ext{Total Assets}}
• Debt to equity: ext{Debt to Equity} = rac{ ext{Total Debt}}{ ext{Total Equity}}
• Equity multiplier: ext{Equity Multiplier} = rac{ ext{Total Assets}}{ ext{Total Equity}} = 1 + rac{ ext{Total Debt}}{ ext{Total Equity}}
• Times interest earned: ext{TIE} = rac{EBIT}{Interest}
• Cash coverage: ext{Cash Coverage} = rac{EBIT + ext{Depreciation}}{Interest}
• Inventory turnover: ext{Inventory Turnover} = rac{COGS}{ ext{Inventory}}
• Days sales in inventory: ext{DSI} = rac{365}{ ext{Inventory Turnover}}
• Receivable turnover: ext{Receivable Turnover} = rac{Net\ Credit\ Sales}{Average\ Accounts\ Receivable}
• Payable turnover: ext{Payable Turnover} = rac{Purchases}{Average\ Accounts\ Payable}
• Total asset turnover: ext{Total Asset Turnover} = rac{ ext{Sales}}{ ext{Total Assets}}
• Capital intensity: ext{Capital Intensity} = rac{ ext{Total Assets}}{ ext{Sales}} = rac{1}{ ext{Asset Turnover}}