Benchmarking involves comparing a firm’s financial ratios against specific targets to give context to performance metrics.

Analytical Perspectives

  • Cross-Sectional Analysis: Comparing the firm directly against its closest peer competitors or industry averages at a single point in time.

 

  • Time-Series (Trend) Analysis: Evaluating a company’s internal ratio trends over multiple consecutive years to trace performance paths.

 

 

  • Common-Size Standardization: Converting financial statements into percentages to easily compare companies of vastly different sizes.

 

Advanced Performance Measurement Formulas (Units 5.4 – 5.8)

Efficiency and Turnover Formulas

  • Receivables Turnover = Credit Sales / Average Accounts Receivable

 

  • Days Sales Outstanding (DSO) = (Average Accounts Receivable / Total Credit Sales) * 365
  • Inventory Turnover = Cost of Goods Sold / Average Inventory
  •  
  • Days Inventory Outstanding (DIO) = (Average Inventory / Cost of Goods Sold) * 365

 

  • Accounts Payable Turnover = Cost of Goods Sold / Average Accounts Payable

 

  • Days Payable Outstanding (DPO) = (Average Accounts Payable / Cost of Goods Sold) * 365

 

  • Total Asset Turnover = Revenue / Average Total Assets

 

  • Working Capital Turnover = Revenue / Average Working Capital

 

Return and Market Value Formulas

  • Return on Assets (ROA) = Net Income / Average Total Assets

 

  • Return on Equity (ROE) = Net Income / Average Total Equity

 

  • Return on Invested Capital (ROIC) = (Operating Income * (1 – Tax Rate)) / (Total Debt + Total Equity – Excess Cash)

                                                     

  • Price-to-Earnings (P/E) Ratio = Market Price Per Share / Earnings Per Share

 

  • Price-to-Book (P/B) Ratio = Market Price Per Share / Book Value Per Share

 

  • Price-to-Sales (P/S) Ratio = Market Price Per Share / Revenue Per Share

 

  • Dividend Yield = Dividend Per Share / Market Price Per Share

 

DuPont Breakdown Formulas

  • Three-Step DuPont ROE = Net Profit Margin * Total Asset Turnover * Equity Multiplier

 

  • Expanded Three-Step = (Net Income / Revenue) * (Revenue / Average Total Assets) * (Average Total Assets / Average Total Equity)

 

  • Five-Step DuPont ROE = Tax Burden * Interest Burden * Operating Profit Margin * Total Asset Turnover * Equity Multiplier

 

  • Expanded Five-Step = (Net Income / EBT) * (EBT / EBIT) * (EBIT / Revenue) *
  • (Revenue / Average Total Assets) * (Average Total Assets / Average Total Equity)

 

 

PreviousNext