3.3 Financial Statement Analysis and Ratios

Financial Statement Analysis and Ratios

Financial statement analysis involves evaluating relationships among financial statement items to assess an entity's financial health, operational performance, and cash-generating ability. Standard tools of analysis include vertical analysis (common-size financial statements where all items are presented as a percentage of a base figure, such as net sales on the income statement or total assets on the balance sheet) and horizontal analysis (trend analysis where financial statement line items are compared across multiple consecutive periods to observe growth rates).

---

Ratio Analysis Classifications

Ratios are divided into four primary groups based on the financial attributes they measure:

1. Liquidity Ratios

Liquidity ratios assess a company's ability to meet its short-term obligations as they fall due. Key liquidity ratios include:

• Current Ratio: Measures total current assets relative to total current liabilities. $\text{Current Ratio} = \frac{\text{Current Assets}}{\text{Current Liabilities}}$
• Quick (Acid-Test) Ratio: A more stringent metric that excludes inventory and prepaid expenses from the numerator because they are slower to convert to cash. $\text{Quick Ratio} = \frac{\text{Cash} + \text{Cash Equivalents} + \text{Marketable Securities} + \text{Net Accounts Receivable}}{\text{Current Liabilities}}$
• Cash Ratio: The most conservative liquidity metric, focusing solely on cash and cash equivalents and marketable securities. $\text{Cash Ratio} = \frac{\text{Cash} + \text{Cash Equivalents} + \text{Marketable Securities}}{\text{Current Liabilities}}$

2. Solvency (Leverage) Ratios

Solvency ratios evaluate a company's capital structure and its capacity to meet long-term obligations. Key metrics include:

• Debt-to-Equity Ratio: Measures the proportion of debt financing relative to equity financing. $\text{Debt-to-Equity} = \frac{\text{Total Liabilities}}{\text{Total Stockholders' Equity}}$
• Debt-to-Assets Ratio: Shows the percentage of assets financed by liabilities. $\text{Debt-to-Assets} = \frac{\text{Total Liabilities}}{\text{Total Assets}}$
• Times Interest Earned (TIE): Evaluates a company's ability to cover its annual interest expense using operating profit. $\text{Times Interest Earned} = \frac{\text{Earnings Before Interest and Taxes (EBIT)}}{\text{Interest Expense}}$

3. Activity (Efficiency) Ratios

Activity ratios measure how effectively a firm manages its operating assets. Ratios in this category typically pair an income statement item with an average balance sheet item:

• Accounts Receivable Turnover: Indicates how many times a company collects its average accounts receivable balance during the year. $\text{AR Turnover} = \frac{\text{Net Credit Sales}}{\text{Average Net Accounts Receivable}}$
• Days Sales Outstanding (DSO) / Collection Period: $\text{DSO} = \frac{365}{\text{AR Turnover}}$
• Inventory Turnover: Measures how quickly inventory is sold. $\text{Inventory Turnover} = \frac{\text{Cost of Goods Sold}}{\text{Average Inventory}}$
• Days Inventory Outstanding (DIO) / Days Sales in Inventory: $\text{DIO} = \frac{365}{\text{Inventory Turnover}}$
• Accounts Payable Turnover: Reflects the speed at which a firm pays off its suppliers. $\text{AP Turnover} = \frac{\text{Net Purchases (or COGS)}}{\text{Average Accounts Payable}}$
• Days Payable Outstanding (DPO): $\text{DPO} = \frac{365}{\text{AP Turnover}}$
• Asset Turnover: Measures how efficiently assets generate sales revenue. $\text{Asset Turnover} = \frac{\text{Net Sales}}{\text{Average Total Assets}}$
• Cash Conversion Cycle (CCC): The net time elapsed between purchasing inventory raw materials and collecting cash from customer sales. $\text{Operating Cycle} = \text{DIO} + \text{DSO}$ $\text{Cash Conversion Cycle} = \text{Operating Cycle} - \text{DPO} = \text{DIO} + \text{DSO} - \text{DPO}$

4. Profitability Ratios

Profitability ratios measure the company's earnings efficiency relative to sales, assets, or equity:

• Gross Profit Margin: $\frac{\text{Gross Profit}}{\text{Net Sales}}$
• Net Profit Margin: $\frac{\text{Net Income}}{\text{Net Sales}}$
• Return on Assets (ROA): $\frac{\text{Net Income}}{\text{Average Total Assets}}$
• Return on Equity (ROE): $\frac{\text{Net Income}}{\text{Average Common Stockholders' Equity}}$

---

DuPont Analysis: Deconstructing ROE

DuPont analysis decomposes ROE into three component ratios. This helps analysts identify whether a company's return is driven by profit efficiency, asset efficiency, or financial leverage.

$\text{Return on Equity (ROE)} = \text{Net Profit Margin} \times \text{Asset Turnover} \times \text{Equity Multiplier}$

$\text{ROE} = \left( \frac{\text{Net Income}}{\text{Net Sales}} \right) \times \left( \frac{\text{Net Sales}}{\text{Average Total Assets}} \right) \times \left( \frac{\text{Average Total Assets}}{\text{Average Common Equity}} \right)$

If ROE rises due to an increase in the Equity Multiplier, the company is utilizing more debt leverage, which increases risk. Conversely, if ROE rises due to improvements in Net Profit Margin or Asset Turnover, it signals stronger operational efficiency.

---

Impact of Transactions on Ratios: Conceptual FAR Traps

CPA FAR questions frequently test how specific transactions affect financial ratios. Understanding the underlying math is critical:

1. Settling Accounts Payable with Cash

When current liabilities are paid with cash, both current assets and current liabilities decrease by the same amount. The effect on the current ratio depends on the ratio's starting value:

• If Current Ratio > 1.0: The current ratio increases.
• If Current Ratio < 1.0: The current ratio decreases.
• If Current Ratio = 1.0: The current ratio remains unchanged.

Mathematical Proof

Let's assume two companies pay down $20,000 of Accounts Payable with Cash:

2. Writing off Accounts Receivable under the Allowance Method

When an individual account is written off as uncollectible under the allowance method (the standard GAAP approach for credit losses under ASC 326), the journal entry is:

Debit: Allowance for Doubtful Accounts                     $5,000
  Credit: Accounts Receivable                                $5,000

Because Accounts Receivable (a current asset) and Allowance for Doubtful Accounts (a contra-current asset) both decrease by the same amount, net accounts receivable remains unchanged. Therefore:

• Current Assets are unchanged.
• Current Ratio is unchanged.
• Working Capital is unchanged.

3. Purchasing Inventory on Account (Credit purchase)

This transaction increases inventory (current asset) and accounts payable (current liability) by the same amount.

• Current Ratio (if > 1.0): Decreases (because adding an equal amount to the numerator and denominator of a fraction greater than 1.0 pulls the fraction closer to 1.0).
• Quick Ratio: Decreases (because the denominator, current liabilities, increases, but the numerator, quick assets, is unaffected since inventory is excluded).