17.3 Financial Statement Analysis & Ratio Analysis

Financial Statement Analysis & Ratio Analysis

Financial statement analysis encompasses the quantitative and qualitative evaluation of an entity's financial position, operating efficiency, profitability, and growth potential. Internal management, credit grantors, and equity investors rely on analytical techniques to diagnose performance trends and identify operational inefficiencies. In the Philippine CPA Licensure Examination, ratio analysis and DuPont system breakdowns are core calculation topics.

---

1. Financial Management: Objectives and the Financial Manager's Decisions

Objective. The goal of financial management is to maximize shareholder wealth, measured by the market value of the firm's shares. This is preferred over maximizing accounting profit because profit ignores the timing of cash flows, risk, and the cash actually generated. Firms pursue this goal while meeting obligations to other stakeholders, such as employees, creditors, customers, government, and the community, and increasingly under ESG expectations.

Agency problem. Managers (agents) may act in their own interest rather than the shareholders' (principals). Agency costs are reduced through performance-based compensation, board and audit committee oversight, the threat of takeover, and external audits.

The financial manager's three decisions:

Controller versus treasurer. The controller handles accounting and reporting, budgeting, internal control, cost accounting, and tax compliance; the treasurer handles cash management, credit and collections, banking relationships, financing, investments, and risk management (insurance and hedging).

---

2. Objectives and Structural Techniques of Financial Analysis

Analytical Objectives

• Management: Evaluate operational productivity, cost control, divisional asset utilization, and working capital sufficiency.
• Trade Creditors and Banks: Gauge short-term liquidity, working capital coverage, and cash flow adequacy to honor maturing obligations.
• Long-Term Bondholders and Lenders: Assess capital structure leverage, debt service coverage, and default risk over extended debt tenors.
• Equity Investors: Measure earnings quality, Return on Equity ($ROE$), dividend stability, and sustainable earnings growth.

Horizontal and Trend Analysis

Horizontal analysis evaluates financial statement line items across two or more consecutive accounting periods:

$\text{Peso Change} = \text{Current Year Amount} - \text{Base Year Amount}$

$\text{Percentage Change} = \frac{\text{Current Year Amount} - \text{Base Year Amount}}{\text{Base Year Amount}} \times 100$

Trend Analysis sets a designated historical baseline period equal to $100\%$ to assess long-term trajectory:

$\text{Trend Percentage} = \frac{\text{Any Year Amount}}{\text{Base Year Amount}} \times 100$

Vertical (Common-Size) Analysis

Vertical analysis expresses each individual financial statement item as a percentage of a defined total base figure within the same reporting period:

• Statement of Financial Position: Every asset, liability, and equity item is stated as a percentage of Total Assets ($100\%$).
• Statement of Comprehensive Income: Every revenue, cost, and expense line is stated as a percentage of Net Sales ($100\%$).

Common-size statements standardize comparisons across companies of disparate asset size or within a single firm across inflationary cycles.

---

3. Liquidity Ratios

Liquidity ratios measure a firm's operational capacity to meet maturing short-term financial obligations without liquidating productive non-current assets.

                                The Liquidity Hierarchy

     Current Ratio           [ Cash + Marketable Sec + Net AR + Inventory + Prepaids ]
                             ─────────────────────────────────────────────────────────
                                                Current Liabilities
                                                          │
     Quick / Acid-Test Ratio [ Cash + Marketable Sec + Net AR ]   (Excludes Inv & Prepaids)
                             ──────────────────────────────────
                                    Current Liabilities
                                              │
     Cash Ratio              [ Cash + Marketable Securities ]     (Strict Cash Assets)
                             ────────────────────────────────
                                   Current Liabilities

Note: Daily operating expenditures = $(\text{Cash Operating Expenses}) / 360 = (\text{COGS} + \text{Operating Expenses} - \text{Depreciation}) / 360$.

---

4. Solvency and Financial Leverage Ratios

Solvency ratios examine an enterprise's long-term financial viability, financial leverage structure, and debt service coverage.

Capital Structure Ratios

• Debt-to-Equity Ratio ($D/E$): $\frac{\text{Total Liabilities}}{\text{Total Shareholders' Equity}}$ Measures the relative proportion of creditor capital to shareholder capital.
• Debt-to-Total Assets Ratio: $\frac{\text{Total Liabilities}}{\text{Total Assets}}$ Represents the percentage of total corporate assets financed by creditors.
• Equity Multiplier: $\frac{\text{Total Assets}}{\text{Total Shareholders' Equity}} = 1 + \text{Debt-to-Equity Ratio}$ Quantifies the total asset base supported per peso of shareholder equity. A higher multiplier signifies elevated financial leverage.

Debt Coverage Ratios

• Times Interest Earned ($TIE$): $TIE = \frac{\text{EBIT}}{\text{Interest Expense}}$ Where $EBIT$ is Earnings Before Interest and Taxes. Measures the margin of safety for interest coverage before operating income drops below interest expense.
• Fixed Charge Coverage: $\frac{\text{EBIT} + \text{Lease Payments}}{\text{Interest Expense} + \text{Lease Payments} + \left(\frac{\text{Preferred Dividends}}{1 - T}\right)}$ Broadens interest coverage to include mandatory lease payments and pre-tax equivalent preferred share dividend obligations ($T$ is the corporate income tax rate).

---

5. Activity and Asset Management Ratios

Activity ratios gauge how efficiently an enterprise manages its operating assets to generate sales revenues.

---

6. Profitability Ratios and the DuPont Analysis System

Profitability ratios evaluate management's overall effectiveness in converting revenue into operational earnings and net income.

Core Profitability Margins

• Gross Profit Margin = $\frac{\text{Gross Profit}}{\text{Net Sales}}$
• Operating Profit Margin = $\frac{\text{EBIT}}{\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}}$ (Alternatively: $\frac{\text{Net Income} + \text{Interest}(1 - T)}{\text{Average Total Assets}}$)
• Return on Equity ($ROE$) = $\frac{\text{Net Income} - \text{Preferred Dividends}}{\text{Average Common Shareholders' Equity}}$

The 3-Step DuPont Analysis System

The classical DuPont model disaggregates Return on Equity into three distinct operational and financial drivers:

$ROE = \text{Net Profit Margin} \times \text{Total Asset Turnover} \times \text{Equity Multiplier}$

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

                                  3-Step DuPont Breakdown

                                  Return on Equity (ROE)
                                             │
                    ┌────────────────────────┼────────────────────────┐
                    ▼                        ▼                        ▼
            Net Profit Margin        Total Asset Turnover     Equity Multiplier
             (Profitability)             (Efficiency)            (Leverage)
            Net Income / Sales          Sales / Assets         Assets / Equity

• Strategic Value of 3-Step DuPont:
  1. Shows whether high $ROE$ is generated through superior pricing power and cost control (high profit margin), aggressive asset utilization (high turnover), or elevated financial debt leverage (high equity multiplier).
  2. If a company raises $ROE$ solely by increasing its equity multiplier, risk rises without any true operational improvement.

The 5-Step Extended DuPont System

The extended 5-step model isolates tax impacts and debt financing costs from underlying operating earnings:

$ROE = \left(\frac{\text{Net Income}}{\text{EBT}}\right) \times \left(\frac{\text{EBT}}{\text{EBIT}}\right) \times \left(\frac{\text{EBIT}}{\text{Sales}}\right) \times \left(\frac{\text{Sales}}{\text{Assets}}\right) \times \left(\frac{\text{Assets}}{\text{Equity}}\right)$

$ROE = \text{Tax Burden} \times \text{Interest Burden} \times \text{Operating Margin} \times \text{Asset Turnover} \times \text{Equity Multiplier}$

1. Tax Burden Ratio ($\frac{\text{Net Income}}{\text{EBT}}$): Reflects the percentage of pre-tax earnings retained after income taxes. Equals $(1 - \text{Effective Tax Rate})$.
2. Interest Burden Ratio ($\frac{\text{EBT}}{\text{EBIT}}$): Reflects the proportion of operating profits remaining after servicing interest expenses. A ratio close to $1.0$ indicates negligible debt service burden.
3. Operating Margin ($\frac{\text{EBIT}}{\text{Sales}}$): Measures fundamental operating profitability per sales peso before capital structure and taxation effects.
4. Total Asset Turnover ($\frac{\text{Sales}}{\text{Assets}}$): Gauges operational efficiency in generating sales from total assets.
5. Equity Multiplier ($\frac{\text{Assets}}{\text{Equity}}$): Captures financial leverage.

---

7. Market Valuation and Dividend Ratios

Market-based ratios evaluate equity securities by comparing reported financial metrics against market trading prices.

• Earnings Per Share ($EPS$): $EPS = \frac{\text{Net Income} - \text{Preferred Dividends}}{\text{Weighted Average Common Shares Outstanding}}$
• Price-to-Earnings Ratio ($P/E$): $P/E = \frac{\text{Market Price per Share}}{EPS}$ Measures the price investors are willing to pay per peso of current earnings. High $P/E$ multiples reflect strong expected future earnings growth.
• Book Value per Share ($BVPS$): $BVPS = \frac{\text{Total Common Shareholders' Equity}}{\text{Common Shares Outstanding}}$
• Market-to-Book Ratio ($M/B$): $M/B = \frac{\text{Market Price per Share}}{BVPS}$
• Dividend Yield: $\text{Dividend Yield} = \frac{\text{Annual Cash Dividend per Share}}{\text{Market Price per Share}}$
• Dividend Payout Ratio: $\text{Payout Ratio} = \frac{\text{Dividends per Share}}{EPS} = \frac{\text{Total Common Cash Dividends}}{\text{Net Income Available to Common}}$
• Retention Ratio ($b$): $b = 1 - \text{Dividend Payout Ratio}$
• Sustainable Growth Rate ($SGR$): The maximum growth rate a firm can achieve without issuing new external equity and while maintaining constant financial leverage and operating policies: $SGR = ROE \times b = ROE \times (1 - \text{Dividend Payout Ratio})$

---

8. Cash Flow Analysis and Free Cash Flow

The statement of cash flows shows whether earnings turn into cash. Useful measures include:

Example: cash flow from operations of PHP 5,000,000 and capital expenditures of PHP 3,200,000 give free cash flow of PHP 1,800,000. In valuation, free cash flow to the firm is EBIT x (1 - t) + Depreciation - Capital expenditures - Increase in net working capital.

---

9. Gross Profit Variance Analysis

Gross profit variance analysis explains the change in gross profit between two periods (or between budget and actual) by sales price, cost price, and volume factors.

Example. Last year: 100,000 units sold at PHP 20 with a unit cost of PHP 14 (gross profit PHP 600,000). This year: 110,000 units sold at PHP 21 with a unit cost of PHP 15 (gross profit PHP 660,000). The increase in gross profit is PHP 60,000.

The two volume variances net to a gross profit volume variance of 10,000 x PHP 6 prior unit gross profit = PHP 60,000 F. Price and cost price factors use current quantities, and volume factors use prior (or budgeted) prices and costs. For multiple products, the volume factor is further split into a sales quantity variance and a sales mix variance, and a mix shift toward lower-margin products reduces gross profit even when total units rise.

---

10. Comprehensive Worked Computational Example

Scenario: Manila Precision Instruments Corp. reports the following financial figures for the fiscal year ended December 31, 2026:

Statement of Comprehensive Income:

• Net Sales: $\text{PHP }50{,}000{,}000$
• Cost of Goods Sold: $\text{PHP }30{,}000{,}000$
• Operating Expenses (Selling and Administrative): $\text{PHP }10{,}000{,}000$
• Operating Income ($EBIT$): $\text{PHP }10{,}000{,}000$
• Interest Expense: $\text{PHP }2{,}000{,}000$
• Earnings Before Taxes ($EBT$): $\text{PHP }8{,}000{,}000$
• Income Tax Expense ($25\%$ corporate rate): $\text{PHP }2{,}000{,}000$
• Net Income: $\text{PHP }6{,}000{,}000$

Statement of Financial Position:

• Current Assets: $\text{PHP }15{,}000{,}000$ (Cash: $\text{PHP }3{,}000{,}000$; Net Accounts Receivable: $\text{PHP }5{,}000{,}000$; Inventories: $\text{PHP }6{,}000{,}000$; Prepaid Expenses: $\text{PHP }1{,}000{,}000$)
• Non-Current Assets (Net Property, Plant & Equipment): $\text{PHP }25{,}000{,}000$
• Total Assets: $\text{PHP }40{,}000{,}000$
• Current Liabilities: $\text{PHP }10{,}000{,}000$
• Long-Term Debt: $\text{PHP }10{,}000{,}000$
• Total Liabilities: $\text{PHP }20{,}000{,}000$
• Common Stock ($1{,}000{,}000$ shares outstanding): $\text{PHP }10{,}000{,}000$
• Retained Earnings: $\text{PHP }10{,}000{,}000$
• Total Equity: $\text{PHP }20{,}000{,}000$

Additional Information:

• Total common cash dividends paid: $\text{PHP }2{,}400{,}000$
• Current market price per common share: $\text{PHP }72.00$

Step-by-Step Multi-Ratio Analysis

1. Liquidity Ratios

• Current Ratio: $\frac{\text{PHP }15{,}000{,}000}{\text{PHP }10{,}000{,}000} = 1.50:1$
• Quick Ratio: $\text{Quick Assets} = \text{Cash } (\text{PHP }3M) + \text{AR } (\text{PHP }5M) = \text{PHP }8{,}000{,}000$ $\text{Quick Ratio} = \frac{\text{PHP }8{,}000{,}000}{\text{PHP }10{,}000{,}000} = 0.80:1$

2. Solvency Ratios

• Debt-to-Equity Ratio: $\frac{\text{PHP }20{,}000{,}000}{\text{PHP }20{,}000{,}000} = 1.00:1$
• Debt-to-Total Assets Ratio: $\frac{\text{PHP }20{,}000{,}000}{\text{PHP }40{,}000{,}000} = 0.50\text{ or } 50\%$
• Equity Multiplier: $\frac{\text{PHP }40{,}000{,}000}{\text{PHP }20{,}000{,}000} = 2.00$
• Times Interest Earned ($TIE$): $\frac{\text{PHP }10{,}000{,}000}{\text{PHP }2{,}000{,}000} = 5.00\times$

3. 3-Step DuPont Analysis of Return on Equity ($ROE$)

• Net Profit Margin: $\frac{\text{PHP }6{,}000{,}000}{\text{PHP }50{,}000{,}000} = 0.12\text{ or } 12.0\%$
• Total Asset Turnover: $\frac{\text{PHP }50{,}000{,}000}{\text{PHP }40{,}000{,}000} = 1.25\times$
• Equity Multiplier: $2.00$
• DuPont $ROE$ Product: $ROE = 0.12 \times 1.25 \times 2.00 = 0.15 \times 2.00 = 0.30\text{ or } 30.0\%$
• Direct Verification: $ROE = \frac{\text{PHP }6{,}000{,}000}{\text{PHP }20{,}000{,}000} = 30.0\%$. (Matches DuPont decomposition).

4. 5-Step DuPont Extended Decomposition

• Tax Burden Ratio: $\frac{\text{Net Income}}{\text{EBT}} = \frac{\text{PHP }6{,}000{,}000}{\text{PHP }8{,}000{,}000} = 0.75$
• Interest Burden Ratio: $\frac{\text{EBT}}{\text{EBIT}} = \frac{\text{PHP }8{,}000{,}000}{\text{PHP }10{,}000{,}000} = 0.80$
• Operating Margin: $\frac{\text{EBIT}}{\text{Sales}} = \frac{\text{PHP }10{,}000{,}000}{\text{PHP }50{,}000{,}000} = 0.20$
• Total Asset Turnover: $\frac{\text{Sales}}{\text{Assets}} = \frac{\text{PHP }50{,}000{,}000}{\text{PHP }40{,}000{,}000} = 1.25$
• Equity Multiplier: $\frac{\text{Assets}}{\text{Equity}} = 2.00$
• Product Check: $0.75 \times 0.80 \times 0.20 \times 1.25 \times 2.00 = 0.60 \times 0.20 \times 1.25 \times 2.00 = 0.12 \times 1.25 \times 2.00 = 30.0\%$.

5. Market Valuation & Sustainable Growth

• $EPS$: $\frac{\text{PHP }6{,}000{,}000}{1{,}000{,}000\text{ shares}} = \text{PHP }6.00$
• $P/E$ Ratio: $\frac{\text{PHP }72.00}{\text{PHP }6.00} = 12.0\times$
• Dividend Payout Ratio: $\frac{\text{PHP }2{,}400{,}000}{\text{PHP }6{,}000{,}000} = 0.40\text{ or } 40\%$
• Retention Ratio ($b$): $1 - 0.40 = 0.60\text{ or } 60\%$
• Sustainable Growth Rate ($SGR$): $ROE \times b = 30.0\% \times 0.60 = 18.0\%$