Study guide
17.3 Financial Statement Analysis & Ratio Analysis
CPA Licensure Examination Philippines, CPALE
Track your progress as you read
Finished sections get a check mark.
1 Introduction & Overview of the CPALE
0.1 CPALE Structure, Qualification, and Examination Mechanics 0.2 Study Strategy, Subject Balance, and Time Management for the Three-Day Board Exam
2 FAR: Standard Setting, Conceptual Framework, Accounting Process & Financial Statements
1.1 Standard-Setting Bodies and Regulation of the Accountancy Profession 1.2 The Conceptual Framework for Financial Reporting 1.3 The Accounting Process: Journals, Worksheet, Adjusting, Closing, and Reversing Entries 1.4 Presentation of Financial Statements
3 FAR: Cash, Receivables & Financial Asset Investments
2.1 Cash, Cash Equivalents, Petty Cash, and Bank Reconciliation 2.2 Trade and Notes Receivables: Measurement, Expected Credit Losses, and Receivable Financing 2.3 Financial Asset Investments: FVPL, FVOCI, and Amortized Cost under PFRS 9
4 FAR: Inventories, Property, Plant & Equipment, and Investment Property
3.1 Inventories & Cost of Sales 3.2 Property, Plant and Equipment, Borrowing Costs, and Impairment 3.3 Investment Property and Agriculture (PAS 40 and PAS 41)
5 FAR: Intangibles, Held for Sale, Financial Liabilities & Provisions
4.1 Intangible Assets, Research and Development, and Goodwill 4.2 Non-Current Assets Held for Sale and Discontinued Operations (PFRS 5) 4.3 Financial Liabilities: Bonds Payable, Effective Interest, and Debt Restructuring 4.4 Provisions, Contingencies, Loyalty Programs, Warranties, and Unearned Revenue
6 FAR: Equity, Share-Based Payment, Leases, Income Taxes & Employee Benefits
5.1 Shareholders' Equity & Share-Based Payments 5.2 Leases under PFRS 16: Lessee, Lessor, and Sale-and-Leaseback 5.3 Income Taxes (PAS 12) and Employee Benefits (PAS 19)
7 FAR: EPS, Cash Flows, SMEs & Small Entities, and Interim Reporting
6.1 Earnings per Share and the Statement of Cash Flows 6.2 PFRS for SMEs, PFRS for Small Entities, and Micro Entities 6.3 Interim Financial Reporting (PAS 34) and Operating Segments (PFRS 8)
8 AFAR: Partnership Formation, Operations, Changes & Liquidation
7.1 Partnership Formation, Operations & Profit/Loss Allocation 7.2 Changes in Partnership Ownership: Admission, Retirement, Death, and Incorporation 7.3 Partnership Liquidation: Lump-Sum and Installment Methods
9 AFAR: Corporate Liquidation, Home Office & Branch, and Business Combinations
8.1 Corporate Liquidation & Statement of Affairs 8.2 Home Office, Branch & Agency Accounting 8.3 Business Combinations under PFRS 3
10 AFAR: Consolidation, Joint Arrangements & Associates
9.1 Consolidated Financial Statements under PFRS 10 & PAS 27 9.2 Joint Arrangements (PFRS 11): Joint Control, Joint Operations, and Joint Ventures 9.3 Investments in Associates and Joint Ventures: The Equity Method (PAS 28)
11 AFAR: Revenue Recognition and Construction Contracts
10.1 Revenue from Contracts with Customers: The Five-Step Model (PFRS 15) 10.2 Long-Term Construction Contracts: Measuring Progress, Contract Balances, and Losses 10.3 Special Revenue Issues under PFRS 15
12 AFAR: Franchises, Consignment, Foreign Currency & Derivatives
11.1 Franchise Operations and Consignment Sales 11.2 Foreign Currency Transactions and Translation (PAS 21 and PAS 29) 11.3 Derivatives and Hedge Accounting (PFRS 9)
13 AFAR: Government, Not-for-Profit, Insurance Contracts & Service Concessions
12.1 Government Accounting: The GAM for National Government Agencies 12.2 Not-for-Profit Organizations: Net Assets, Contributions, and Sector Types 12.3 Insurance Contracts (PFRS 17) and Service Concession Arrangements
14 AFAR: Cost Accounting Systems
13.1 Cost Accumulation Systems and Job Order Costing 13.2 Process Costing and Backflush Costing 13.3 Activity-Based Costing, Joint and By-Products, and Service Department Cost Allocation
15 MS: Management Accounting, Cost Behavior & CVP Analysis
14.1 The Role of Management Accounting, Professional Ethics, and Global Trends 14.2 Cost Classifications, Cost Behavior, and Cost Estimation 14.3 Cost-Volume-Profit (CVP) Analysis
16 MS: Variable Costing, Standard Costing & Budgeting
15.1 Variable Costing versus Absorption Costing 15.2 Standard Costing & Variance Analysis 15.3 Master Budgeting, Cash Budgets, and Flexible Budgets
17 MS: Performance Measurement and Relevant Costing
16.1 Responsibility Accounting, Segment Reporting, and Transfer Pricing 16.2 Balanced Scorecard, Operational Performance, and Emerging Trends 16.3 Relevant Costing & Short-Term Tactical Decisions
18 MS: Pricing, Quantitative Techniques & Financial Statement Analysis
17.1 Pricing Decisions & Profitability Analysis 17.2 Quantitative Techniques for Decision Making 17.3 Financial Statement Analysis & Ratio Analysis
19 MS: Working Capital Management and Capital Budgeting
18.1 Working Capital: Policies, Cash Conversion Cycle, and Cash Management 18.2 Working Capital: Receivables, Inventory, and Short-Term Financing 18.3 Capital Budgeting & Investment Decisions
20 MS: Risk, Cost of Capital, Financial Markets & Economics
19.1 Risk and Return, Leverage, and Cost of Capital 19.2 Financial Markets, Long-Term Financing, and Valuation 19.3 Microeconomics, Macroeconomics, and International Trade
21 AUD: Nature of Auditing, Regulation of the Profession & Code of Ethics
20.1 Nature of Auditing, Assurance, and Information Risk 20.2 The Regulatory Framework of the Accountancy Profession 20.3 Code of Ethics: Fundamental Principles, Conceptual Framework, and Threats
22 AUD: Independence, Quality Management & Engagement Planning
21.1 Independence: Financial Interests, Relationships, Rotation, Services, and Fees 21.2 Philippine Standards on Quality Management 21.3 Pre-Engagement Activities, Client Acceptance & Audit Planning
23 AUD: Audit Risk, Fraud, Materiality & Internal Control
22.1 Audit Risk Model and Fraud Risk 22.2 Materiality: Overall, Performance, and Clearly Trivial Thresholds 22.3 Understanding the Entity & Internal Control Evaluation
24 AUD: IT Environment, Audit Evidence & Sampling
23.1 Auditing in a Computer Information Systems (CIS) Environment 23.2 Audit Evidence, Assertions, Procedures, and Documentation 23.3 Audit Sampling: Attribute, Variable, and Monetary Unit Sampling
25 AUD: Business Process Audits and Auditing Practice Problems
24.1 Substantive Testing of Business Cycles 24.2 Auditing Practice: Cash and Receivables 24.3 Auditing Practice: Inventory, Property, and Liabilities
26 AUD: Completing the Audit, Reporting & Other Assurance Services
25.1 Completing the Audit, Subsequent Events & Going Concern 25.2 The Auditor's Report: Opinions, KAM, EOM, and Comparatives 25.3 Other Assurance and Related Services Engagements
27 TAX: Principles of Taxation and Assessment Remedies
26.1 Taxation: Nature, Inherent Powers, and Limitations 26.2 The Tax System: Canons, Double Taxation, Evasion, and Sources of Tax Law 26.3 Tax Remedies: Assessment, Protest, and Appeal
28 TAX: Refunds, Collection & Prescription, Gross Income, and Fringe Benefits
27.1 Tax Remedies: Refunds, Collection, and Prescription 27.2 Gross Income: Inclusions and Exclusions 27.3 De Minimis Benefits and the Fringe Benefits Tax
29 TAX: Individual and Corporate Income Taxation
28.1 Individual Income Tax: Classification, Rates, and the 8% Option 28.2 Individual Income Tax: Deductions, Passive Income, and Capital Gains 28.3 Corporate Income Taxation under the CREATE Law
30 TAX: Estate Tax, Donor's Tax, Withholding & Special Tax Laws
29.1 Estate Tax under the NIRC as Amended by the TRAIN Law 29.2 Donor's Tax under the NIRC as Amended by the TRAIN Law 29.3 Withholding Taxes, EOPT Compliance, and Special Tax Laws
31 TAX: Value-Added Tax and Percentage Taxes
30.1 Value-Added Tax: Nature, Registration, Output Tax, and Exemptions 30.2 Value-Added Tax: Input Tax, Allocation, Withholding, and Filing 30.3 Percentage Taxes & Other Business Taxes
32 TAX: Local Taxes, DST & Excise, and Incentives & Treaties
31.1 Local Taxation and Real Property Tax 31.2 Documentary Stamp Tax and Excise Taxes 31.3 Tax Incentives under CREATE MORE and Tax Treaties
33 RFBT: Law on Obligations
32.1 Obligations: Nature, Sources, and Effects 32.2 Kinds of Obligations 32.3 Extinguishment of Obligations
34 RFBT: Contracts, Defective Contracts & Sales
33.1 Law on Contracts: Essential Requisites & Performance 33.2 Defective Contracts 33.3 Sales: Nature, Object and Price, Delivery, and Double Sales
35 RFBT: Installment Sales, Credit Transactions & Partnerships
34.1 Sales: Warranties, Installment Sales, and Redemption 34.2 Credit Transactions & Security Mechanisms 34.3 Law on Partnerships
36 RFBT: Corporations - Nature, Incorporation & Board of Directors
35.1 Corporations: Nature, Separate Personality, Classes, and Nationality 35.2 Corporations: Incorporation, Articles and Bylaws, and Corporate Powers 35.3 Corporations: Board of Directors, Officers, and Fiduciary Duties
37 RFBT: Corporations - Stockholders, Capital & Corporate Changes
36.1 Corporations: Stockholders, Meetings, and One Person Corporations 36.2 Corporations: Capital Stock, Shares, and Subscriptions 36.3 Corporations: Mergers, Dissolution, Foreign Corporations, and SEC Powers
38 RFBT: Securities Regulation, Insurance & Cooperatives
37.1 Securities Regulation, Corporate Governance, and SRC Rule 68 37.2 Insurance Law 37.3 Cooperatives under the Philippine Cooperative Code (RA 9520)
39 RFBT: Banking Laws, AMLA & Bouncing Checks
38.1 Banking Laws, Bank Secrecy & PDIC 38.2 Anti-Money Laundering Act (AMLA) 38.3 Bouncing Checks Law (BP 22)
40 RFBT: Insolvency, Competition, Data Privacy & Labor Laws
39.1 Financial Rehabilitation and Insolvency Act (FRIA) 39.2 Competition, Consumer Protection, and Government Procurement 39.3 Data Privacy, Intellectual Property, and Electronic Commerce 39.4 Ease of Doing Business, Labor Standards, and Social Security
17.3 Financial Statement Analysis & Ratio Analysis
Key Takeaways Explain This Topic AI
Horizontal analysis evaluates financial trends across consecutive reporting periods using absolute and percentage changes or base-year trend percentages, whereas vertical analysis converts financial statements into common-size formats (percentages of total assets for the balance sheet and net sales for the income statement).
Liquidity ratios assess short-term debt-paying capability; the quick (acid-test) ratio strictly isolates monetary liquid assets (cash, short-term marketable securities, and net accounts receivable) from current liabilities, excluding less liquid inventories and prepaids.
Solvency ratios measure long-term financial leverage and capital structure risk, highlighted by the times interest earned ratio ( T I E = E B I T Interest Expense TIE = \frac{EBIT}{\text{Interest Expense}} T I E = Interest Expense EB I T ) and the equity multiplier ( Total Assets Total Equity = 1 + Debt-to-Equity \frac{\text{Total Assets}}{\text{Total Equity}} = 1 + \text{Debt-to-Equity} Total Equity Total Assets = 1 + Debt-to-Equity ).
The 3-step DuPont system decomposes Return on Equity ( R O E ROE ROE ) into operating efficiency (Net Profit Margin), asset utilization efficiency (Total Asset Turnover), and financial leverage (Equity Multiplier): R O E = Net Income Sales × Sales Assets × Assets Equity ROE = \frac{\text{Net Income}}{\text{Sales}} \times \frac{\text{Sales}}{\text{Assets}} \times \frac{\text{Assets}}{\text{Equity}} ROE = Sales Net Income × Assets Sales × Equity Assets .
The 5-step DuPont model expands decomposition to isolate tax burden, interest burden, operating margin (EBIT margin), asset turnover, and financial leverage, isolating operational from financial and fiscal drivers of shareholder return.
Last updated: September 2026
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:
Decision Key questions Tools covered in this guide
Investment Which long-term assets and projects to acquire, and how much to invest in current assets Capital budgeting; working capital management
Financing How to fund assets: debt versus equity, short-term versus long-term Cost of capital, leverage, capital structure, financial markets
Operating (and dividend) How to manage day-to-day cash flows and how much profit to retain or distribute Budgeting, cash management, dividend policy, financial analysis
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 ( R O E ROE 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:
Peso Change = Current Year Amount − Base Year Amount \text{Peso Change} = \text{Current Year Amount} - \text{Base Year Amount} Peso Change = Current Year Amount − Base Year Amount
Percentage Change = Current Year Amount − Base Year Amount Base Year Amount × 100 \text{Percentage Change} = \frac{\text{Current Year Amount} - \text{Base Year Amount}}{\text{Base Year Amount}} \times 100 Percentage Change = Base Year Amount Current Year Amount − Base Year Amount × 100
Trend Analysis sets a designated historical baseline period equal to 100 % 100\% 100% to assess long-term trajectory:
Trend Percentage = Any Year Amount Base Year Amount × 100 \text{Trend Percentage} = \frac{\text{Any Year Amount}}{\text{Base Year Amount}} \times 100 Trend Percentage = Base Year Amount Any Year Amount × 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 % 100\% 100% ).
Statement of Comprehensive Income : Every revenue, cost, and expense line is stated as a percentage of Net Sales ( 100 % 100\% 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
Ratio Mathematical Formula Analytical Significance
Current Ratio Current Assets Current Liabilities \frac{\text{Current Assets}}{\text{Current Liabilities}} Current Liabilities Current Assets General measure of working capital coverage; benchmark of 2.0 : 1 2.0:1 2.0 : 1 is historically common, though modern lean firms frequently operate safely below 1.5 : 1 1.5:1 1.5 : 1 .
Quick (Acid-Test) Ratio Cash + Marketable Securities + Net Trade Receivables Current Liabilities \frac{\text{Cash} + \text{Marketable Securities} + \text{Net Trade Receivables}}{\text{Current Liabilities}} Current Liabilities Cash + Marketable Securities + Net Trade Receivables Strict measure of immediate liquidity; rigorously excludes inventory (slow to monetize) and prepaids (unconvertible to cash). Benchmark: 1.0 : 1 1.0:1 1.0 : 1 .
Cash Ratio Cash + Cash Equivalents + Marketable Securities Current Liabilities \frac{\text{Cash} + \text{Cash Equivalents} + \text{Marketable Securities}}{\text{Current Liabilities}} Current Liabilities Cash + Cash Equivalents + Marketable Securities Ultra-conservative liquidity test reflecting immediate cash available to clear current liabilities without relying on trade collections.
Defensive Interval Ratio Quick Assets Projected Daily Operating Expenditures \frac{\text{Quick Assets}}{\text{Projected Daily Operating Expenditures}} Projected Daily Operating Expenditures Quick Assets Measures the number of days a firm can sustain operational disbursements using only existing quick assets without generating new revenues.
Note : Daily operating expenditures = ( Cash Operating Expenses ) / 360 = ( COGS + Operating Expenses − Depreciation ) / 360 (\text{Cash Operating Expenses}) / 360 = (\text{COGS} + \text{Operating Expenses} - \text{Depreciation}) / 360 ( Cash Operating Expenses ) /360 = ( COGS + Operating Expenses − 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 D/E D / E ) : Total Liabilities Total Shareholders’ Equity \frac{\text{Total Liabilities}}{\text{Total Shareholders' Equity}} Total Shareholders’ Equity Total Liabilities Measures the relative proportion of creditor capital to shareholder capital.
Debt-to-Total Assets Ratio : Total Liabilities Total Assets \frac{\text{Total Liabilities}}{\text{Total Assets}} Total Assets Total Liabilities Represents the percentage of total corporate assets financed by creditors.
Equity Multiplier : Total Assets Total Shareholders’ Equity = 1 + Debt-to-Equity Ratio \frac{\text{Total Assets}}{\text{Total Shareholders' Equity}} = 1 + \text{Debt-to-Equity Ratio} Total Shareholders’ Equity Total Assets = 1 + 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 ( T I E TIE T I E ) : T I E = EBIT Interest Expense TIE = \frac{\text{EBIT}}{\text{Interest Expense}} T I E = Interest Expense EBIT Where E B I T EBIT EB I T is Earnings Before Interest and Taxes. Measures the margin of safety for interest coverage before operating income drops below interest expense.
Fixed Charge Coverage : EBIT + Lease Payments Interest Expense + Lease Payments + ( Preferred Dividends 1 − T ) \frac{\text{EBIT} + \text{Lease Payments}}{\text{Interest Expense} + \text{Lease Payments} + \left(\frac{\text{Preferred Dividends}}{1 - T}\right)} Interest Expense + Lease Payments + ( 1 − T Preferred Dividends ) EBIT + Lease Payments Broadens interest coverage to include mandatory lease payments and pre-tax equivalent preferred share dividend obligations ( T T 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.
Operational Ratio Formula Interpretation & Standard Rules
Accounts Receivable Turnover ( A R T ART A RT ) Net Credit Sales Average Net Accounts Receivable \frac{\text{Net Credit Sales}}{\text{Average Net Accounts Receivable}} Average Net Accounts Receivable Net Credit Sales Frequency with which the receivables portfolio is billed and collected annually.
Average Collection Period ( D S O DSO D SO ) 360 Accounts Receivable Turnover \frac{360}{\text{Accounts Receivable Turnover}} Accounts Receivable Turnover 360 Average number of days required to collect customer receivables. Compare against stated credit terms.
Inventory Turnover ( I T IT I T ) Cost of Goods Sold Average Inventory \frac{\text{Cost of Goods Sold}}{\text{Average Inventory}} Average Inventory Cost of Goods Sold Number of times inventory is replenished and sold per year. Use C O G S COGS COGS rather than Sales to avoid gross margin distortion.
Days to Sell Inventory ( D I O DIO D I O ) 360 Inventory Turnover \frac{360}{\text{Inventory Turnover}} Inventory Turnover 360 Average days required to convert raw materials and finished goods into sales.
Accounts Payable Turnover ( A P T APT A PT ) Net Credit Purchases Average Accounts Payable \frac{\text{Net Credit Purchases}}{\text{Average Accounts Payable}} Average Accounts Payable Net Credit Purchases Velocity of vendor liability settlement. (Use C O G S COGS COGS if credit purchases are not provided).
Days to Pay Payables ( D P O DPO D PO ) 360 Accounts Payable Turnover \frac{360}{\text{Accounts Payable Turnover}} Accounts Payable Turnover 360 Average days the company takes to honor supplier trade invoices.
Total Asset Turnover ( T A T O TATO T A TO ) Net Sales Average Total Assets \frac{\text{Net Sales}}{\text{Average Total Assets}} Average Total Assets Net Sales Overall capital productivity: pesos of revenue generated per peso of total asset investment.
Fixed Asset Turnover Net Sales Average Net Plant, Property & Equipment \frac{\text{Net Sales}}{\text{Average Net Plant, Property \& Equipment}} Average Net Plant, Property & Equipment Net Sales Capacity utilization and efficiency of physical plant and production machinery.
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 = Gross Profit Net Sales \frac{\text{Gross Profit}}{\text{Net Sales}} Net Sales Gross Profit
- Operating Profit Margin = EBIT Net Sales \frac{\text{EBIT}}{\text{Net Sales}} Net Sales EBIT
- Net Profit Margin = Net Income Net Sales \frac{\text{Net Income}}{\text{Net Sales}} Net Sales Net Income
Return on Assets ( R O A ROA RO A ) = Net Income Average Total Assets \frac{\text{Net Income}}{\text{Average Total Assets}} Average Total Assets Net Income (Alternatively: Net Income + Interest ( 1 − T ) Average Total Assets \frac{\text{Net Income} + \text{Interest}(1 - T)}{\text{Average Total Assets}} Average Total Assets Net Income + Interest ( 1 − T ) )
Return on Equity ( R O E ROE ROE ) = Net Income − Preferred Dividends Average Common Shareholders’ Equity \frac{\text{Net Income} - \text{Preferred Dividends}}{\text{Average Common Shareholders' Equity}} Average Common Shareholders’ Equity Net Income − Preferred Dividends
The 3-Step DuPont Analysis System
The classical DuPont model disaggregates Return on Equity into three distinct operational and financial drivers:
R O E = Net Profit Margin × Total Asset Turnover × Equity Multiplier ROE = \text{Net Profit Margin} \times \text{Total Asset Turnover} \times \text{Equity Multiplier} ROE = Net Profit Margin × Total Asset Turnover × Equity Multiplier
R O E = ( Net Income Sales ) × ( Sales Assets ) × ( Assets Equity ) 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) ROE = ( Sales Net Income ) × ( Assets Sales ) × ( Equity Assets ) 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 :
Shows whether high R O E ROE 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).
If a company raises R O E ROE 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:
R O E = ( Net Income EBT ) × ( EBT EBIT ) × ( EBIT Sales ) × ( Sales Assets ) × ( Assets Equity ) 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 = ( EBT Net Income ) × ( EBIT EBT ) × ( Sales EBIT ) × ( Assets Sales ) × ( Equity Assets )
R O E = Tax Burden × Interest Burden × Operating Margin × Asset Turnover × Equity Multiplier ROE = \text{Tax Burden} \times \text{Interest Burden} \times \text{Operating Margin} \times \text{Asset Turnover} \times \text{Equity Multiplier} ROE = Tax Burden × Interest Burden × Operating Margin × Asset Turnover × Equity Multiplier
Tax Burden Ratio ( Net Income EBT \frac{\text{Net Income}}{\text{EBT}} EBT Net Income ): Reflects the percentage of pre-tax earnings retained after income taxes. Equals ( 1 − Effective Tax Rate ) (1 - \text{Effective Tax Rate}) ( 1 − Effective Tax Rate ) .
Interest Burden Ratio ( EBT EBIT \frac{\text{EBT}}{\text{EBIT}} EBIT EBT ): Reflects the proportion of operating profits remaining after servicing interest expenses. A ratio close to 1.0 1.0 1.0 indicates negligible debt service burden.
Operating Margin ( EBIT Sales \frac{\text{EBIT}}{\text{Sales}} Sales EBIT ): Measures fundamental operating profitability per sales peso before capital structure and taxation effects.
Total Asset Turnover ( Sales Assets \frac{\text{Sales}}{\text{Assets}} Assets Sales ): Gauges operational efficiency in generating sales from total assets.
Equity Multiplier ( Assets Equity \frac{\text{Assets}}{\text{Equity}} Equity Assets ): 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 ( E P S EPS EPS ) : E P S = Net Income − Preferred Dividends Weighted Average Common Shares Outstanding EPS = \frac{\text{Net Income} - \text{Preferred Dividends}}{\text{Weighted Average Common Shares Outstanding}} EPS = Weighted Average Common Shares Outstanding Net Income − Preferred Dividends
Price-to-Earnings Ratio ( P / E P/E P / E ) : P / E = Market Price per Share E P S P/E = \frac{\text{Market Price per Share}}{EPS} P / E = EPS Market Price per Share Measures the price investors are willing to pay per peso of current earnings. High P / E P/E P / E multiples reflect strong expected future earnings growth.
Book Value per Share ( B V P S BVPS B V PS ) : B V P S = Total Common Shareholders’ Equity Common Shares Outstanding BVPS = \frac{\text{Total Common Shareholders' Equity}}{\text{Common Shares Outstanding}} B V PS = Common Shares Outstanding Total Common Shareholders’ Equity
Market-to-Book Ratio ( M / B M/B M / B ) : M / B = Market Price per Share B V P S M/B = \frac{\text{Market Price per Share}}{BVPS} M / B = B V PS Market Price per Share
Dividend Yield : Dividend Yield = Annual Cash Dividend per Share Market Price per Share \text{Dividend Yield} = \frac{\text{Annual Cash Dividend per Share}}{\text{Market Price per Share}} Dividend Yield = Market Price per Share Annual Cash Dividend per Share
Dividend Payout Ratio : Payout Ratio = Dividends per Share E P S = Total Common Cash Dividends Net Income Available to Common \text{Payout Ratio} = \frac{\text{Dividends per Share}}{EPS} = \frac{\text{Total Common Cash Dividends}}{\text{Net Income Available to Common}} Payout Ratio = EPS Dividends per Share = Net Income Available to Common Total Common Cash Dividends
Retention Ratio ( b b b ) : b = 1 − Dividend Payout Ratio b = 1 - \text{Dividend Payout Ratio} b = 1 − Dividend Payout Ratio
Sustainable Growth Rate ( S G R SGR SGR ) :
The maximum growth rate a firm can achieve without issuing new external equity and while maintaining constant financial leverage and operating policies: S G R = R O E × b = R O E × ( 1 − Dividend Payout Ratio ) SGR = ROE \times b = ROE \times (1 - \text{Dividend Payout Ratio}) SGR = ROE × b = ROE × ( 1 − 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:
Measure Formula What it shows
Operating cash flow ratio Cash flow from operations / Current liabilities Ability to pay current debts from operating cash
Cash flow to net income (quality of earnings) Cash flow from operations / Net income A ratio well below 1 over several years suggests aggressive accruals
Cash debt coverage Cash flow from operations / Average total liabilities Ability to repay debt from operations
Cash flow adequacy Cash flow from operations / (Capital expenditures + Debt repayments + Dividends) Whether operations fund the firm's recurring cash needs
Free cash flow (FCF) Cash flow from operations - Capital expenditures (some definitions also deduct dividends) Cash available for expansion, debt reduction, or distributions
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.
- Factor Computation Variance (PHP)
- Sales price variance (21 - 20) x 110,000 current units 110,000 F
- Cost price variance (15 - 14) x 110,000 current units 110,000 U
- Sales volume variance (110,000 - 100,000) x PHP 20 prior price 200,000 F
- Cost volume variance (110,000 - 100,000) x PHP 14 prior cost 140,000 U
- Net change in gross profit 60,000 F
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: PHP 50,000,000 \text{PHP }50{,}000{,}000 PHP 50 , 000 , 000
- Cost of Goods Sold: PHP 30,000,000 \text{PHP }30{,}000{,}000 PHP 30 , 000 , 000
- Operating Expenses (Selling and Administrative): PHP 10,000,000 \text{PHP }10{,}000{,}000 PHP 10 , 000 , 000
- Operating Income ( E B I T EBIT EB I T ): PHP 10,000,000 \text{PHP }10{,}000{,}000 PHP 10 , 000 , 000
- Interest Expense: PHP 2,000,000 \text{PHP }2{,}000{,}000 PHP 2 , 000 , 000
- Earnings Before Taxes ( E B T EBT EBT ): PHP 8,000,000 \text{PHP }8{,}000{,}000 PHP 8 , 000 , 000
- Income Tax Expense ( 25 % 25\% 25% corporate rate): PHP 2,000,000 \text{PHP }2{,}000{,}000 PHP 2 , 000 , 000
- Net Income: PHP 6,000,000 \text{PHP }6{,}000{,}000 PHP 6 , 000 , 000
Statement of Financial Position :
Current Assets: PHP 15,000,000 \text{PHP }15{,}000{,}000 PHP 15 , 000 , 000 (Cash: PHP 3,000,000 \text{PHP }3{,}000{,}000 PHP 3 , 000 , 000 ; Net Accounts Receivable: PHP 5,000,000 \text{PHP }5{,}000{,}000 PHP 5 , 000 , 000 ; Inventories: PHP 6,000,000 \text{PHP }6{,}000{,}000 PHP 6 , 000 , 000 ; Prepaid Expenses: PHP 1,000,000 \text{PHP }1{,}000{,}000 PHP 1 , 000 , 000 )
Non-Current Assets (Net Property, Plant & Equipment): PHP 25,000,000 \text{PHP }25{,}000{,}000 PHP 25 , 000 , 000
- Total Assets : PHP 40,000,000 \text{PHP }40{,}000{,}000 PHP 40 , 000 , 000
- Current Liabilities: PHP 10,000,000 \text{PHP }10{,}000{,}000 PHP 10 , 000 , 000
- Long-Term Debt: PHP 10,000,000 \text{PHP }10{,}000{,}000 PHP 10 , 000 , 000
- Total Liabilities : PHP 20,000,000 \text{PHP }20{,}000{,}000 PHP 20 , 000 , 000
Common Stock ( 1,000,000 1{,}000{,}000 1 , 000 , 000 shares outstanding): PHP 10,000,000 \text{PHP }10{,}000{,}000 PHP 10 , 000 , 000
- Retained Earnings: PHP 10,000,000 \text{PHP }10{,}000{,}000 PHP 10 , 000 , 000
- Total Equity : PHP 20,000,000 \text{PHP }20{,}000{,}000 PHP 20 , 000 , 000
Additional Information :
- Total common cash dividends paid: PHP 2,400,000 \text{PHP }2{,}400{,}000 PHP 2 , 400 , 000
- Current market price per common share: PHP 72.00 \text{PHP }72.00 PHP 72.00
- Step-by-Step Multi-Ratio Analysis
- 1. Liquidity Ratios
Current Ratio : PHP 15,000,000 PHP 10,000,000 = 1.50 : 1 \frac{\text{PHP }15{,}000{,}000}{\text{PHP }10{,}000{,}000} = 1.50:1 PHP 10 , 000 , 000 PHP 15 , 000 , 000 = 1.50 : 1
Quick Ratio : Quick Assets = Cash ( PHP 3 M ) + AR ( PHP 5 M ) = PHP 8,000,000 \text{Quick Assets} = \text{Cash } (\text{PHP }3M) + \text{AR } (\text{PHP }5M) = \text{PHP }8{,}000{,}000 Quick Assets = Cash ( PHP 3 M ) + AR ( PHP 5 M ) = PHP 8 , 000 , 000 Quick Ratio = PHP 8,000,000 PHP 10,000,000 = 0.80 : 1 \text{Quick Ratio} = \frac{\text{PHP }8{,}000{,}000}{\text{PHP }10{,}000{,}000} = 0.80:1 Quick Ratio = PHP 10 , 000 , 000 PHP 8 , 000 , 000 = 0.80 : 1
2. Solvency Ratios
Debt-to-Equity Ratio : PHP 20,000,000 PHP 20,000,000 = 1.00 : 1 \frac{\text{PHP }20{,}000{,}000}{\text{PHP }20{,}000{,}000} = 1.00:1 PHP 20 , 000 , 000 PHP 20 , 000 , 000 = 1.00 : 1
Debt-to-Total Assets Ratio : PHP 20,000,000 PHP 40,000,000 = 0.50 or 50 % \frac{\text{PHP }20{,}000{,}000}{\text{PHP }40{,}000{,}000} = 0.50\text{ or } 50\% PHP 40 , 000 , 000 PHP 20 , 000 , 000 = 0.50 or 50%
Equity Multiplier : PHP 40,000,000 PHP 20,000,000 = 2.00 \frac{\text{PHP }40{,}000{,}000}{\text{PHP }20{,}000{,}000} = 2.00 PHP 20 , 000 , 000 PHP 40 , 000 , 000 = 2.00
Times Interest Earned ( T I E TIE T I E ) : PHP 10,000,000 PHP 2,000,000 = 5.00 × \frac{\text{PHP }10{,}000{,}000}{\text{PHP }2{,}000{,}000} = 5.00\times PHP 2 , 000 , 000 PHP 10 , 000 , 000 = 5.00 ×
3. 3-Step DuPont Analysis of Return on Equity ( R O E ROE ROE )
Net Profit Margin : PHP 6,000,000 PHP 50,000,000 = 0.12 or 12.0 % \frac{\text{PHP }6{,}000{,}000}{\text{PHP }50{,}000{,}000} = 0.12\text{ or } 12.0\% PHP 50 , 000 , 000 PHP 6 , 000 , 000 = 0.12 or 12.0%
Total Asset Turnover : PHP 50,000,000 PHP 40,000,000 = 1.25 × \frac{\text{PHP }50{,}000{,}000}{\text{PHP }40{,}000{,}000} = 1.25\times PHP 40 , 000 , 000 PHP 50 , 000 , 000 = 1.25 ×
Equity Multiplier : 2.00 2.00 2.00
DuPont R O E ROE ROE Product : R O E = 0.12 × 1.25 × 2.00 = 0.15 × 2.00 = 0.30 or 30.0 % ROE = 0.12 \times 1.25 \times 2.00 = 0.15 \times 2.00 = 0.30\text{ or } 30.0\% ROE = 0.12 × 1.25 × 2.00 = 0.15 × 2.00 = 0.30 or 30.0%
Direct Verification : R O E = PHP 6,000,000 PHP 20,000,000 = 30.0 % ROE = \frac{\text{PHP }6{,}000{,}000}{\text{PHP }20{,}000{,}000} = 30.0\% ROE = PHP 20 , 000 , 000 PHP 6 , 000 , 000 = 30.0% . (Matches DuPont decomposition).
4. 5-Step DuPont Extended Decomposition
Tax Burden Ratio : Net Income EBT = PHP 6,000,000 PHP 8,000,000 = 0.75 \frac{\text{Net Income}}{\text{EBT}} = \frac{\text{PHP }6{,}000{,}000}{\text{PHP }8{,}000{,}000} = 0.75 EBT Net Income = PHP 8 , 000 , 000 PHP 6 , 000 , 000 = 0.75
Interest Burden Ratio : EBT EBIT = PHP 8,000,000 PHP 10,000,000 = 0.80 \frac{\text{EBT}}{\text{EBIT}} = \frac{\text{PHP }8{,}000{,}000}{\text{PHP }10{,}000{,}000} = 0.80 EBIT EBT = PHP 10 , 000 , 000 PHP 8 , 000 , 000 = 0.80
Operating Margin : EBIT Sales = PHP 10,000,000 PHP 50,000,000 = 0.20 \frac{\text{EBIT}}{\text{Sales}} = \frac{\text{PHP }10{,}000{,}000}{\text{PHP }50{,}000{,}000} = 0.20 Sales EBIT = PHP 50 , 000 , 000 PHP 10 , 000 , 000 = 0.20
Total Asset Turnover : Sales Assets = PHP 50,000,000 PHP 40,000,000 = 1.25 \frac{\text{Sales}}{\text{Assets}} = \frac{\text{PHP }50{,}000{,}000}{\text{PHP }40{,}000{,}000} = 1.25 Assets Sales = PHP 40 , 000 , 000 PHP 50 , 000 , 000 = 1.25
Equity Multiplier : Assets Equity = 2.00 \frac{\text{Assets}}{\text{Equity}} = 2.00 Equity Assets = 2.00
Product Check : 0.75 × 0.80 × 0.20 × 1.25 × 2.00 = 0.60 × 0.20 × 1.25 × 2.00 = 0.12 × 1.25 × 2.00 = 30.0 % 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\% 0.75 × 0.80 × 0.20 × 1.25 × 2.00 = 0.60 × 0.20 × 1.25 × 2.00 = 0.12 × 1.25 × 2.00 = 30.0% .
5. Market Valuation & Sustainable Growth
E P S EPS EPS : PHP 6,000,000 1,000,000 shares = PHP 6.00 \frac{\text{PHP }6{,}000{,}000}{1{,}000{,}000\text{ shares}} = \text{PHP }6.00 1 , 000 , 000 shares PHP 6 , 000 , 000 = PHP 6.00
P / E P/E P / E Ratio : PHP 72.00 PHP 6.00 = 12.0 × \frac{\text{PHP }72.00}{\text{PHP }6.00} = 12.0\times PHP 6.00 PHP 72.00 = 12.0 ×
Dividend Payout Ratio : PHP 2,400,000 PHP 6,000,000 = 0.40 or 40 % \frac{\text{PHP }2{,}400{,}000}{\text{PHP }6{,}000{,}000} = 0.40\text{ or } 40\% PHP 6 , 000 , 000 PHP 2 , 400 , 000 = 0.40 or 40%
Retention Ratio ( b b b ) : 1 − 0.40 = 0.60 or 60 % 1 - 0.40 = 0.60\text{ or } 60\% 1 − 0.40 = 0.60 or 60%
Sustainable Growth Rate ( S G R SGR SGR ) : R O E × b = 30.0 % × 0.60 = 18.0 % ROE \times b = 30.0\% \times 0.60 = 18.0\% ROE × b = 30.0% × 0.60 = 18.0%