Comprehensive Study Notes on Financial Statement Analysis, Ratio Analysis, DuPont Identity, and Time Value of Money
Standardized Financial Statements
Definition and Purpose:
- Standardized financial statements (also called common-size statements) restate financial statement line items as percentages of a single benchmark base value.
- They allow financial analysts to compare financial statements across:
- Two or more companies of vastly different sizes.
- The same company across multiple time periods (time-trend analysis).
Standardization Benchmark Base Items:
- Balance Sheet: Every item is expressed as a percentage of Total Assets ().
- Income Statement: Every item is expressed as a percentage of Total Revenue or Sales ().
Case Study: Prufrock Corporation Summary of Standardized Balance Sheets (Asset Side Only):

- Cash:
- : ( of Total Assets)
- : ( of Total Assets)
- Accounts Receivable:
- : ( of Total Assets)
- : ( of Total Assets)
- Inventory:
- : ( of Total Assets)
- : ( of Total Assets)
- Total Current Assets:
- : ( of Total Assets)
- : ( of Total Assets)
- Fixed Assets (Net Plant and Equipment):
- : ( of Total Assets)
- : ( of Total Assets)
- Total Assets:
- : ()
- : ()
Financial Ratio Analysis and Short-Term Solvency
Overview of Financial Ratio Categories:
- Ratio analysis is used to establish standardized relationships across financial statement items. Financial ratios are grouped into five traditional categories:
- Short-term solvency, or liquidity, ratios.
- Long-term solvency, or financial leverage, ratios.
- Asset management, or turnover, ratios.
- Profitability ratios.
- Market value ratios.
Short-Term Solvency (Liquidity) Ratios:
- Current Ratio:
- Quick Ratio (Acid-Test Ratio):
- Cash Ratio:
- Net Working Capital to Total Assets Ratio:
Worked Example: SDJ, Incorporated:
- Given Data:
- Net Working Capital (NWC) =
- Current Liabilities (CL) =
- Inventory =
- Step 1: Calculate Current Assets (CA): \2{,}630 = \text{Current assets} - \
- Step 2: Calculate Current Ratio:
- Step 3: Calculate Quick Ratio: \text{Quick ratio} = \frac{\$8{,}600 - \$3{,}860}{\5{,}970} = \frac{\4{,}740}{\$5{,}970} = 0.79
Long-Term Solvency and Financial Leverage Ratios
Long-Term Solvency (Financial Leverage) Ratios:
- Total Debt Ratio:
- Debt-Equity Ratio:
- Equity Multiplier:
- Long-Term Debt Ratio:
- Times Interest Earned (TIE) Ratio:
- Cash Coverage Ratio:
Worked Example: Mobius, Incorporated:
- Given Data:
- Total Debt Ratio =
- Step 1: Determine Total Equity Fraction:
- Step 2: Calculate Debt-Equity Ratio:
- Step 3: Calculate Equity Multiplier:
Asset Management and Turnover Ratios
Asset Management (Turnover) Ratios:
- Inventory Turnover:
- Days' Sales in Inventory:
- Receivables Turnover:
- Days' Sales in Receivables:
- Net Working Capital (NWC) Turnover:
- Fixed Asset Turnover:
- Total Asset Turnover:
Worked Example: Dahlia Corporation:
- Given Data:
- Current Accounts Receivable =
- Sales for Year Just Ended =
- Step 1: Calculate Receivables Turnover:
- Step 2: Calculate Days' Sales in Receivables:
- Interpretation:
- On average, it took customers to pay off their accounts during the past year.
Profitability Ratios
Profitability Ratios:
- Profit Margin:
- Return on Assets (ROA):
- Return on Equity (ROE):
Worked Example: Denver, Incorporated:
- Given Data:
- Sales = ()
- Total Assets = ()
- Total Debt = ()
- Profit Margin = ()
- Step 1: Calculate Net Income: \text{Net income} = \14{,}200{,}000 \times 0.05 = \
- Step 2: Calculate Return on Assets (ROA):
- Step 3: Calculate Return on Equity (ROE):
Market Value Ratios
Market Value Ratios:
- Price-Earnings (P/E) Ratio:
- PEG Ratio:
- Price-Sales Ratio:
- Market-to-Book Ratio:
Worked Example: Bolton Corporation:
- Given Data:
- Additions to Retained Earnings =
- Cash Dividends Paid =
- Ending Total Equity = ()
- Common Stock Outstanding =
- Current Stock Price = per share
- Step 1: Calculate Earnings Per Share (EPS):
- Step 2: Calculate Dividends Per Share (DPS):
- Step 3: Calculate Book Value Per Share (BVPS):
- Step 4: Calculate Market-to-Book Ratio:
- Step 5: Calculate Price-Earnings Ratio:
The DuPont Identity
Decomposition of Return on Equity (ROE):
- ROE is expressed by expanding the equation into three product components:
- Return on Assets (ROA) is embedded as:
Three Key Performance Drivers:
- Operating Efficiency: Measured by Profit Margin.
- Asset Use Efficiency: Measured by Total Asset Turnover.
- Financial Leverage: Measured by Equity Multiplier.
Worked Example: Rogers, Incorporated:
- Given Data:
- Equity Multiplier =
- Total Asset Turnover =
- Profit Margin = ()
- Step 1: Calculate ROE:
- Step 2: Calculate Debt-Equity Ratio:
Comparative Case Study: DuPont Breakdown of Amazon and Alibaba:

- Amazon:
- :
- :
- :
- Alibaba:
- :
- :
- :
Practical Application and Benchmarking of Financial Statements
Uses of Financial Statement Information:
- Internal Uses:
- Performance evaluation (across divisions, management, or products).
- Planning for the future (budgeting, capital investment, forecasting).
- External Uses:
- Creditors (evaluating debt service ability).
- Potential investors (evaluating equity return targets).
- Suppliers and large customers (evaluating business sustainability and counterparty risk).
- Credit rating agencies (assigning bond/debt credit ratings).
- Competitors (evaluating market performance and structure).
- Potential targets for mergers and acquisition (M&A valuations).
Benchmarking Standards:
- Time Trend Analysis: Uses a firm's historical performance as the baseline to identify structural changes over time.
- Peer Group Analysis: Compares a firm against competitors in the same market with similar assets and operations.
Standard Industrial Classification (SIC) Codes:
Standardized four-digit codes used to categorize firms by industry.

Selected Two-Digit SIC Categories:
Agriculture, Forestry, and Fishing:
- Agriculture production—crops
- Forestry
- Fishing, hunting, and trapping
Mining:
- Metal mining
- Bituminous coal and lignite mining
- Oil and gas extraction
Construction:
- Building construction
- Construction other than building
- Construction—special trade contractors
Manufacturing:
- Chemicals and allied products
- Petroleum refining and related industries
- Transportation equipment
Transportation, Communication, Electric, Gas, and Sanitary Service:
- Railroad transportation
- Transportation by air
- Electric, gas, and sanitary services
Retail Trade:
- Food stores
- Automobile dealers and gas stations
- Eating and drinking places
Finance, Insurance, and Real Estate:
- Banking
- Insurance
- Real estate
Services:
- Motion pictures
- Health services
- Educational services
Problems with Financial Statement Analysis:
- Lack of underlying economic theory to determine optimal ratio levels.
- Difficulty in benchmarking multi-segment conglomerates.
- Global competitors operating under different accounting frameworks.
- Usage of differing accounting procedures (e.g., LIFO vs. FIFO, depreciation schedule differences).
- Differing fiscal year-end dates across peer firms.
- Distortion from one-off, unusual, or extraordinary events.
Time Value of Money Concepts and Compound Interest
Core Concept:
- Time value of money establishes that a dollar in hand today is worth more than a dollar promised in the future.
- This fundamental concept holds true as long as interest/inflation rates are greater than zero ().
Simple Interest vs. Compound Interest:
- Simple Interest: Interest is earned strictly on the principal amount. Interest earned in prior periods is not reinvested and does not earn interest.
- Compound Interest: Interest earned in prior periods is reinvested to generate additional interest ("interest on interest").
- Demonstration Example ( at for two years):
- Simple Interest Total:
- Compound Interest Total:
- Year 1: \1{,}000 \times 1.05 = \
- Year 2: \1{,}050 \times 1.05 = \
Time Value of Money Formulas:
- Where:
- = Future Value
- = Present Value
- = required rate of return, discount rate, or cost of capital
- = number of compounding periods
Worked Example: Compound vs. Simple Interest Over 7 Years:
- Given Data:
- Investment () =
- Interest Rate = () per year
- Time Horizon () =
- Compound Interest Calculation: \text{FV} = \400 \times (1 + 0.12)^7 = \400 \times (1.12)^7 = \400 \times 2.21068 = \
- Simple Interest Calculation: \text{Annual simple interest} = \400 \times 0.12 = \
- Compounding Gain:
Non-Annual Compounding Periods
Compounding Frequency Impact:
- Many financial assets settle cash flows semi-annually, quarterly, monthly, or daily.
- Formula adjusted for compounding frequency :
Worked Example 1: Future Value with Monthly Compounding:
- Given Data:
- Principal () =
- APR () = ()
- Compounding frequency () = (monthly)
- Duration () =
- Calculations: \text{FV} = \5{,}000 \times \left(1 + 0.005\right)^{48} = \
Worked Example 2: Present Value with Daily Compounding:
- Given Data:
- Target Future Amount () =
- APR () = ()
- Compounding frequency () = (daily)
- Duration () =
- Calculations: \text{PV} = \frac{\15{,}000}{\left(1 + \frac{0.055}{365}\right)^{1095}} = \
Solving for Discount Rates and Time Periods
Solving for Rate of Return ():
- Formula Rearrangement:
- Worked Example (Quarterly Compounding):
- Given Data: Initial Investment () = , Future Cash Flow () = , Time Horizon = , Compounding = Quarterly.
- Step 1: Determine Total Quarterly Periods:
- Step 2: Calculate Quarterly Rate ():
- Step 3: Calculate Annualized Interest Rate ():
Solving for Number of Periods ():
- Formula Rearrangement:
- Worked Example (Semi-Annual Compounding):
- Given Data: Target Amount () = , Current Balance () = , Annual Interest Rate = (), Compounding = Semi-Annual.
- Step 1: Calculate Semi-Annual Rate:
- Step 2: Calculate Semi-Annual Periods:
- Step 3: Convert to Years: