Reading 20: Financial Analysis Techniques

50 questions available

Module 20.1: Introduction to Financial Ratios and Techniques10 min
This module introduces the fundamental tools of financial analysis. Ratio analysis expresses relationships between data points to evaluate performance, though it is noted that ratios should not be viewed in isolation. Limitations include differences in accounting methods and the difficulty of finding comparable peers for conglomerates. Common-size analysis allows for comparison across firms of different sizes. Vertical analysis uses a percentage of sales (income statement) or assets (balance sheet), while horizontal analysis tracks percentage changes from a base year. Graphical tools like stacked column graphs and line graphs help visualize trends, and regression analysis can identify relationships between variables for forecasting.

Key Points

  • Ratios are useful for internal and cross-sectional comparisons.
  • Vertical common-size income statements express items as a percentage of sales.
  • Vertical common-size balance sheets express items as a percentage of total assets.
  • Horizontal analysis standardizes data to a base year value of 1.0 or 100 percent.
  • Ratio analysis is limited by accounting differences and the need for judgment in selecting benchmarks.
Module 20.2: Activity and Liquidity Ratios15 min
Activity ratios measure how efficiently a firm uses its assets. Key metrics include receivables turnover, days of sales outstanding (DSO), inventory turnover, days of inventory on hand, and payables turnover. Total asset turnover measures the revenue generated per dollar of assets. Liquidity ratios assess the ability to pay short-term liabilities. The current ratio (current assets/current liabilities), quick ratio (excluding inventory), and cash ratio are standard measures. The cash conversion cycle measures the time required to convert cash outflows for inventory back into cash inflows from sales, calculated as DSO plus days of inventory minus days of payables.

Key Points

  • Activity ratios are also known as asset utilization or operating efficiency ratios.
  • Receivables turnover = Annual Sales / Average Receivables.
  • Days of Sales Outstanding (DSO) = 365 / Receivables Turnover.
  • Current Ratio = Current Assets / Current Liabilities.
  • Cash Conversion Cycle = Days Sales Outstanding + Days of Inventory on Hand - Number of Days of Payables.
  • Defensive Interval Ratio measures how long a firm can pay daily cash expenditures with liquid assets.
Module 20.3: Solvency and Profitability Ratios15 min
Solvency ratios evaluate financial leverage and long-term debt-servicing ability. Key ratios include debt-to-equity, debt-to-assets, and financial leverage (average total assets/average total equity). Coverage ratios like interest coverage (EBIT/interest payments) and fixed charge coverage measure the ability to meet fixed obligations. Profitability ratios assess performance relative to sales and investment. Margins (gross, operating, net) show the percentage of sales retained as profit. Return metrics (ROA, ROE, Return on Total Capital) measure returns generated on invested capital.

Key Points

  • Debt-to-equity = Total Debt / Total Shareholders' Equity.
  • Financial Leverage Ratio = Average Total Assets / Average Total Equity.
  • Interest Coverage = EBIT / Interest Payments.
  • Gross Profit Margin = Gross Profit / Revenue.
  • ROA = Net Income / Average Total Assets (sometimes adjusted for interest).
  • Return on Common Equity = (Net Income - Preferred Dividends) / Average Common Equity.
Module 20.4: DuPont Analysis15 min
DuPont analysis decomposes ROE to identify the sources of return. The original three-part equation breaks ROE into Net Profit Margin (profitability), Asset Turnover (efficiency), and Financial Leverage (solvency). The extended five-part equation further breaks down the Net Profit Margin into the Tax Burden (Net Income/EBT), Interest Burden (EBT/EBIT), and EBIT Margin (EBIT/Revenue). This detailed breakdown helps analysts pinpoint whether changes in ROE are driven by operational efficiency, pricing power, tax management, or financial leverage.

Key Points

  • Original DuPont: ROE = Net Profit Margin x Asset Turnover x Financial Leverage.
  • Financial Leverage (Equity Multiplier) = Average Total Assets / Average Total Equity.
  • Extended DuPont: ROE = Tax Burden x Interest Burden x EBIT Margin x Asset Turnover x Financial Leverage.
  • Tax Burden = Net Income / EBT (reflects tax retention rate).
  • Interest Burden = EBT / EBIT (reflects interest impact).
Module 20.5: Valuation, Growth, and Credit Analysis10 min
This section covers ratios used in equity and credit analysis. Valuation ratios include P/E, P/S, P/B, and P/CF. Basic and diluted EPS are key per-share measures. The sustainable growth rate (g) is calculated as the Retention Rate (1 - Dividend Payout Ratio) multiplied by ROE. Credit analysis utilizes coverage and leverage ratios to assess default risk (e.g., Altman Z-score). The module also discusses segment reporting requirements, noting that segments accounting for more than 10 percent of revenue, assets, or income must be reported separately, allowing for granular analysis.

Key Points

  • Basic EPS = (Net Income - Preferred Dividends) / Weighted Average Common Shares.
  • Diluted EPS accounts for convertible securities.
  • Sustainable Growth Rate (g) = Retention Rate (RR) x ROE.
  • Retention Rate = 1 - (Dividends Declared / Net Income Available to Common).
  • Business segments must be reported if they account for more than 10 percent of revenues, assets, or income.

Questions

Question 1

Which of the following is a specific purpose for which financial ratios are used in financial analysis?

View answer and explanation
Question 2

In a vertical common-size income statement, each item is expressed as a percentage of:

View answer and explanation
Question 3

Which of the following best describes horizontal common-size analysis?

View answer and explanation
Question 4

A limitation of financial ratios is that:

View answer and explanation
Question 5

Which graphical tool shows changes in the composition of financial statement items over time, such as components of liabilities?

View answer and explanation
Question 6

If a company has annual sales of 500,000 and average receivables of 50,000, what is its receivables turnover?

View answer and explanation
Question 7

A processing period (days of inventory on hand) that is too high might indicate:

View answer and explanation
Question 8

Calculate the payables turnover given purchases of 800,000 and average trade payables of 100,000.

View answer and explanation
Question 9

Which ratio measures the effectiveness of a firm's use of its total assets to create revenue?

View answer and explanation
Question 10

If a company has a fixed asset turnover ratio that is significantly lower than the industry norm, it might imply:

View answer and explanation
Question 11

Working capital is defined as:

View answer and explanation
Question 12

Given: Sales = 1,000,000; Average Working Capital = 200,000. Calculate the working capital turnover.

View answer and explanation
Question 13

To calculate the days of inventory on hand, one must multiply 365 by:

View answer and explanation
Question 14

If purchases are not directly reported, they can be calculated using:

View answer and explanation
Question 15

Using a 365-day year, if the payables turnover ratio is 10, what is the payables payment period?

View answer and explanation
Question 16

Which ratio provides the most stringent measure of liquidity by excluding inventories and receivables?

View answer and explanation
Question 17

If a company has a current ratio of less than one, it implies:

View answer and explanation
Question 18

Given: Cash = 100, Marketable Securities = 50, Receivables = 150, Inventory = 200, Current Liabilities = 400. Calculate the Quick Ratio.

View answer and explanation
Question 19

The cash conversion cycle is calculated as:

View answer and explanation
Question 20

The defensive interval ratio measures:

View answer and explanation
Question 21

Which ratio is a measure of the firm's use of fixed-cost financing sources?

View answer and explanation
Question 22

If a firm has Total Debt of 500 and Total Shareholders' Equity of 1,000, what is the Debt-to-Capital ratio?

View answer and explanation
Question 23

Which solvency ratio is calculated as Average Total Assets divided by Average Total Equity?

View answer and explanation
Question 24

A lower interest coverage ratio indicates:

View answer and explanation
Question 25

The Fixed Charge Coverage ratio includes which of the following in the numerator and denominator?

View answer and explanation
Question 26

Which profitability ratio is calculated as (Net Income / Revenue)?

View answer and explanation
Question 27

Gross profit is defined as:

View answer and explanation
Question 28

Return on Assets (ROA) calculated using net income can be misleading because:

View answer and explanation
Question 29

Return on Total Capital (ROTC) is the ratio of:

View answer and explanation
Question 30

Return on Common Equity differs from Return on Total Equity because:

View answer and explanation
Question 31

According to the original three-part DuPont equation, ROE is equal to:

View answer and explanation
Question 32

If a company has a Net Profit Margin of 5 percent, Asset Turnover of 1.5, and a Leverage Ratio of 2.0, what is its ROE?

View answer and explanation
Question 33

In the extended (5-way) DuPont equation, the Tax Burden is calculated as:

View answer and explanation
Question 34

In the extended DuPont model, a lower Interest Burden ratio (EBT/EBIT) implies:

View answer and explanation
Question 35

If a company increases its financial leverage while keeping profit margins and asset turnover constant, what will happen to ROE (assuming positive earnings)?

View answer and explanation
Question 36

Which of the following is an example of a per-share valuation measure?

View answer and explanation
Question 37

Diluted EPS is calculated to reflect:

View answer and explanation
Question 38

The retention rate (RR) is defined as:

View answer and explanation
Question 39

Calculate the sustainable growth rate (g) for a firm with an ROE of 15 percent and a dividend payout ratio of 40 percent.

View answer and explanation
Question 40

The coefficient of variation for a variable is defined as:

View answer and explanation
Question 41

Which metric is commonly used in the retail industry?

View answer and explanation
Question 42

Capital adequacy typically refers to ratios used in which industry?

View answer and explanation
Question 43

According to Altman (2000), a low Z-score indicates:

View answer and explanation
Question 44

A business segment must be reported separately if it accounts for more than what percentage of the company's revenues, assets, or income?

View answer and explanation
Question 45

Which of the following is NOT a required disclosure for a reportable segment?

View answer and explanation
Question 46

To model and forecast earnings, analysts often use common-size income statements to estimate:

View answer and explanation
Question 47

Sensitivity analysis in forecasting involves:

View answer and explanation
Question 48

Simulation is a technique in which:

View answer and explanation
Question 49

Scenario analysis differs from sensitivity analysis because:

View answer and explanation
Question 50

When forecasting future net income, if a company has historically had a stable net profit margin, an analyst might:

View answer and explanation