AFM 212: Financial Analysis and Planning
Haihao Lu
Estimated study time: 1 hr 36 min
Table of contents
Sources and References
Primary textbook — Easton, Peter D., Mary Lea McAnally, and Gregory A. Sommers. Financial Statement Analysis and Valuation, 7th ed. Cambridge Business Publishers, 2023. (ISBN: 978-1-61853-625-9) Supplementary — Penman, Stephen H. Financial Statement Analysis and Security Valuation, 5th ed. McGraw-Hill, 2013; Palepu, Krishna G., Paul M. Healy, and Victor L. Bernard. Business Analysis and Valuation: Using Financial Statements, 5th ed. South-Western Cengage, 2013. Online resources — CPA Canada Handbook (ASPE and IFRS standards); SEC/SEDAR filings for public company examples; CFA Institute curriculum materials on financial reporting quality.
Chapter 1: Overview of Business Analysis
The Purpose of Financial Statement Analysis
Financial statements — the balance sheet, income statement, statement of cash flows, and statement of changes in equity — are the primary vehicle through which a company communicates its economic performance and position to external parties. However, the statements are not self-interpreting. Converting them into decision-relevant information requires financial statement analysis: the process of evaluating, adjusting, and synthesizing financial data in the context of an understanding of the business.
Financial statement analysis serves many users with different objectives:
| User | Primary Question |
|---|---|
| Equity investor | What is the intrinsic value of the shares? |
| Credit analyst / lender | Can the borrower service its debt? |
| Management | How are we performing relative to targets and peers? |
| Auditor | Are the reported numbers consistent with business reality? |
| Regulator | Are disclosures complete and in compliance? |
The Business Analysis Framework
A comprehensive business analysis has four interconnected components:
- Business (strategy) analysis: Understanding the competitive environment, business model, and key value drivers — before opening any financial statement
- Accounting analysis: Assessing the quality and reliability of reported numbers; identifying distortions from accounting choices
- Financial analysis: Computing ratios, trends, and decompositions to evaluate performance, liquidity, and solvency
- Prospective analysis: Projecting future financial statements (forecasting) and estimating enterprise or equity value (valuation)
Porter’s Five Forces and Competitive Advantage
Before interpreting a firm’s financial ratios, the analyst must understand the industry context in which those ratios are generated. Michael Porter’s Five Forces framework identifies the structural drivers of industry profitability:
- Threat of new entrants: High barriers to entry (capital requirements, regulatory licenses, brand loyalty, economies of scale) protect incumbents’ margins
- Bargaining power of buyers: When customers are few and large, they can demand lower prices or better terms
- Bargaining power of suppliers: Concentrated suppliers can extract higher input costs
- Threat of substitute products: Substitutes cap pricing power
- Rivalry among existing competitors: Intense price competition erodes margins
A firm with durable competitive advantage — protected by patents, network effects, switching costs, or cost advantages — should generate returns on invested capital that persistently exceed the cost of that capital.
Common-Size Financial Statements
Before computing ratios or running models, analysts often restate financial statements in common-size format to facilitate comparison across time and across firms of different sizes.
Vertical common-size income statement: Every line item is expressed as a percentage of net revenue. This reveals margin structure and cost behaviour.
Vertical common-size balance sheet: Every line item is expressed as a percentage of total assets. This reveals asset composition and capital structure at a glance.
Horizontal (trend) analysis: Each line item for the current period is expressed as a percentage of the same item in a base year. A trend index of 120 means the item is 20% higher than in the base year.
| Line Item | Amount ($M) | % of Revenue |
|---|---|---|
| Revenue | 500 | 100.0% |
| Cost of Goods Sold | 310 | 62.0% |
| Gross Profit | 190 | 38.0% |
| SG&A Expense | 95 | 19.0% |
| EBIT | 95 | 19.0% |
| Interest Expense | 12 | 2.4% |
| Pre-Tax Income | 83 | 16.6% |
| Income Tax (25%) | 20.75 | 4.15% |
| Net Income | 62.25 | 12.45% |
The gross margin of 38% and operating margin of 19% are immediately visible, allowing direct comparison to industry peers without size distortion.
Trend Analysis
Trend analysis extends horizontal comparison across multiple periods to identify whether margins, turnover ratios, and leverage are improving or deteriorating. An analyst studying a retailer over five years might observe:
- Gross margin declining from 40% to 36%: possible pricing pressure or commodity input cost inflation
- SG&A ratio rising from 18% to 22%: possible fixed cost deleverage from slower revenue growth
- Days inventory rising from 42 to 58: possible inventory build-up signalling demand weakness
Trend analysis is most powerful when combined with peer benchmarking — comparing the trend of a focal firm to its direct competitors to distinguish industry-wide headwinds from firm-specific issues.
Chapter 2: Profit and Return Analysis
Profitability Ratios in Depth
Profitability analysis measures how effectively a firm converts revenue into profit at various stages of the income statement. Each margin ratio captures a different economic dimension.
Gross Profit Margin:
\[ \text{Gross Profit Margin} = \frac{\text{Revenue} - \text{Cost of Goods Sold}}{\text{Revenue}} \]Reflects the fundamental economics of the product or service — pricing power and direct production efficiency. A decline may signal commoditization, rising raw material costs, or a shift in product mix toward lower-margin items.
Operating Profit Margin (EBIT Margin):
\[ \text{Operating Margin} = \frac{\text{EBIT}}{\text{Revenue}} \]Captures the profitability of core operations before financing costs and taxes. The spread between gross and operating margin reflects the burden of selling, general and administrative expenses, research and development, and depreciation.
Net Profit Margin:
\[ \text{Net Profit Margin} = \frac{\text{Net Income}}{\text{Revenue}} \]Affected by capital structure (interest expense) and the tax rate, as well as operating performance. Two firms with identical operating margins can have very different net margins if their capital structures differ.
EBITDA Margin:
\[ \text{EBITDA Margin} = \frac{\text{EBIT} + \text{Depreciation} + \text{Amortization}}{\text{Revenue}} \]EBITDA is often used as a proxy for operating cash flow and is the basis of many valuation multiples. It strips out the effects of depreciation policy and amortization of acquired intangibles, making cross-company comparisons more meaningful.
Return on Equity — The DuPont Decomposition
Return on equity (ROE) is the most widely used single measure of shareholder value creation. The extended DuPont analysis decomposes ROE into three (or five) drivers:
Three-factor DuPont:
\[ \text{ROE} = \underbrace{\frac{\text{Net Income}}{\text{Revenue}}}_{\text{Net Margin}} \times \underbrace{\frac{\text{Revenue}}{\text{Total Assets}}}_{\text{Asset Turnover}} \times \underbrace{\frac{\text{Total Assets}}{\text{Equity}}}_{\text{Financial Leverage}} \]This decomposition reveals that ROE can be high for three very different reasons: high margins, high asset efficiency, or high leverage. Each driver has different risk implications.
Five-factor DuPont decomposes further:
\[ \text{ROE} = \underbrace{\frac{\text{Net Income}}{\text{Pre-Tax Income}}}_{\text{Tax Burden}} \times \underbrace{\frac{\text{Pre-Tax Income}}{\text{EBIT}}}_{\text{Interest Burden}} \times \underbrace{\frac{\text{EBIT}}{\text{Revenue}}}_{\text{EBIT Margin}} \times \underbrace{\frac{\text{Revenue}}{\text{Total Assets}}}_{\text{Asset Turnover}} \times \underbrace{\frac{\text{Total Assets}}{\text{Equity}}}_{\text{Leverage}} \]The five-factor version separates operating profitability (EBIT margin) from the effects of financing (interest burden) and taxation (tax burden).
Firm A and Firm B both report ROE = 18%. Decompose each:
| Driver | Firm A | Firm B |
|---|---|---|
| Net Margin | 15.0% | 3.0% |
| Asset Turnover | 1.20× | 6.00× |
| Financial Leverage | 1.00× | 1.00× |
| ROE = Margin × Turnover × Leverage | 18.0% | 18.0% |
Firm A is a high-margin, low-turnover business (luxury goods, pharmaceuticals). Firm B is a low-margin, high-turnover business (grocery retail, distribution). Despite identical ROEs, they face entirely different competitive dynamics. A margin compression of 2 percentage points would reduce Firm A’s ROE by roughly one-eighth, while the same absolute compression would nearly eliminate Firm B’s ROE.
Now apply the five-factor DuPont to Firm A assuming an effective tax rate of 25%, interest burden of 0.90, and EBIT margin of 20%:
- Tax burden = 1 − 0.25 = 0.75
- Interest burden = 0.90 (Pre-Tax Income / EBIT)
- EBIT margin = 20%
- Asset turnover = 1.20×
- Leverage = 1.00×
(Note: the slight difference from 18% arises because leverage = 1.0 in this simplified illustration; in practice, the equity multiplier and interest burden interact through the debt balance.)
Return on Assets and Return on Net Operating Assets
Return on Assets (ROA) measures the profitability of all assets, regardless of financing:
\[ \text{ROA} = \frac{\text{Net Income} + \text{Interest Expense} \times (1 - \text{Tax Rate})}{\text{Average Total Assets}} \]The after-tax interest add-back removes the effect of capital structure, making ROA comparable across firms with different leverage.
Return on Invested Capital (ROIC):
\[ \text{ROIC} = \frac{\text{NOPAT}}{\text{Invested Capital}} \]Where NOPAT = Net Operating Profit After Tax = EBIT × (1 − t), and Invested Capital = Total equity + Interest-bearing debt. ROIC is the most widely used metric in corporate performance management because it directly measures the return generated on capital provided by all financial stakeholders.
Return on Net Operating Assets (RNOA) is preferred in academic financial analysis because it separates the operating and financing activities of the firm:
\[ \text{RNOA} = \frac{\text{NOPAT}}{\text{Net Operating Assets (NOA)}} \]Where NOA = Operating assets − Operating liabilities. Operating liabilities (accounts payable, accrued expenses, deferred revenue) are spontaneous sources of financing that arise from operations; they reduce the net capital required.
Interpreting ROE vs. RNOA — The Spread and Leverage Effect
The relationship between ROE and RNOA reveals whether financial leverage is adding value:
\[ \text{ROE} = \text{RNOA} + (\text{RNOA} - \text{Cost of Debt After Tax}) \times \text{Financial Leverage Ratio} \]This formulation shows that leverage increases ROE only when RNOA exceeds the after-tax cost of debt — the so-called positive leverage spread. When RNOA falls below the after-tax cost of debt, leverage destroys equity value.
Chapter 3: Liquidity and Solvency Analysis
The Purpose of Credit Analysis
Credit analysis evaluates whether a borrower can service its financial obligations — paying interest and repaying principal — on time and in full. Lenders (banks, bondholders) use credit analysis to set loan terms, establish covenants, and price credit risk. The core concern is default risk: the probability that the borrower will fail to meet its obligations.
Liquidity Ratios
Liquidity measures the ability to meet short-term obligations as they come due. The intuition is: if all current liabilities had to be paid immediately, does the firm have sufficient liquid assets to cover them?
Current Ratio:
\[ \text{Current Ratio} = \frac{\text{Current Assets}}{\text{Current Liabilities}} \]A ratio above 1.0 means current assets exceed current liabilities. However, the composition of current assets matters greatly: a current ratio of 2.5 driven primarily by obsolete inventory is far less reassuring than one driven primarily by cash and receivables. Rule of thumb: above 1.5 is generally healthy for manufacturing; above 1.0 is often acceptable for retailers with negative cash conversion cycles.
Quick Ratio (Acid-Test):
\[ \text{Quick Ratio} = \frac{\text{Cash + Marketable Securities + Net Receivables}}{\text{Current Liabilities}} \]Excludes inventory and prepaid expenses, which may not be quickly convertible to cash. More conservative than the current ratio and preferred in industries where inventory is illiquid or subject to rapid obsolescence (e.g., fashion, technology hardware).
Cash Ratio:
\[ \text{Cash Ratio} = \frac{\text{Cash + Marketable Securities}}{\text{Current Liabilities}} \]The most conservative measure. Relevant in periods of market stress when credit markets freeze and firms cannot quickly convert receivables or inventory into cash. Very few companies maintain a cash ratio above 1.0 without attracting shareholder pressure to deploy the excess cash.
Operating Cash Flow Ratio:
\[ \text{Operating CF Ratio} = \frac{\text{Cash Flow from Operations}}{\text{Current Liabilities}} \]Captures the ability to generate cash from ongoing operations — often more meaningful than balance-sheet snapshot ratios because it reflects the firm’s actual cash-generation process over the period.
Acme Manufacturing Ltd. reports the following at December 31:
| Item | Amount |
|---|---|
| Cash | $25M |
| Marketable Securities | $10M |
| Accounts Receivable (net) | $60M |
| Inventory | $80M |
| Prepaid Expenses | $5M |
| Total Current Assets | $180M |
| Accounts Payable | $55M |
| Accrued Liabilities | $30M |
| Current Portion of LT Debt | $15M |
| Total Current Liabilities | $100M |
| Cash Flow from Operations (annual) | $85M |
Calculations:
- Current Ratio = 180 / 100 = 1.80×
- Quick Ratio = (25 + 10 + 60) / 100 = 0.95×
- Cash Ratio = (25 + 10) / 100 = 0.35×
- Operating CF Ratio = 85 / 100 = 0.85×
Interpretation: The current ratio of 1.80× appears healthy, but the quick ratio below 1.0 suggests heavy reliance on inventory. If inventory cannot be sold quickly (e.g., during a demand slowdown), short-term liquidity is tighter than the headline ratio implies. The strong operating cash flow ratio of 0.85× is reassuring — operations are generating significant cash relative to near-term obligations.
Solvency Ratios
Solvency measures the ability to meet long-term obligations — the overall financial structure of the firm. Solvency analysis examines the quantity of debt relative to equity and assets, and the firm’s ability to service that debt from operating earnings.
Debt-to-Equity Ratio:
\[ \text{D/E} = \frac{\text{Total Interest-Bearing Debt}}{\text{Total Equity}} \]Measures the financial risk taken on by shareholders. A D/E of 1.5× means $1.50 of debt for every $1.00 of equity. Capital-intensive industries (utilities, real estate) routinely operate at higher D/E than asset-light businesses (software, consumer brands).
Debt-to-Total Assets:
\[ \text{Debt Ratio} = \frac{\text{Total Debt}}{\text{Total Assets}} \]The fraction of assets financed by creditors. A ratio above 0.6 is often considered elevated in manufacturing; however, benchmarks vary significantly by industry.
Equity Multiplier (Financial Leverage Ratio):
\[ \text{Equity Multiplier} = \frac{\text{Total Assets}}{\text{Total Equity}} \]The inverse of (1 − Debt Ratio). Used directly in the DuPont decomposition.
Interest Coverage Ratio (Times Interest Earned):
\[ \text{TIE} = \frac{\text{EBIT}}{\text{Interest Expense}} \]Measures how many times operating income covers interest expense. A ratio below 1.5× is a warning sign; most investment-grade bond covenants require TIE well above 2×. During recessions, companies with TIE near 1.0× are highly vulnerable.
Debt Service Coverage Ratio (DSCR):
\[ \text{DSCR} = \frac{\text{Net Operating Income}}{\text{Annual Debt Service}} \]Where annual debt service = principal repayments + interest payments. Widely used in commercial real estate and project finance lending; lenders typically require DSCR ≥ 1.25×.
Net Debt-to-EBITDA:
\[ \text{Net Debt / EBITDA} = \frac{\text{Total Debt} - \text{Cash}}{\text{EBITDA}} \]One of the most common metrics in corporate credit analysis and leveraged buyout covenant packages. At 2× or below, generally considered conservative; above 4–5× is considered highly leveraged for non-capital-intensive businesses.
NovaTech Corp. reports: Total Debt = $480M; Cash = $60M; Total Equity = $320M; Total Assets = $800M; EBIT = $110M; Interest Expense = $32M; EBITDA = $145M; Annual principal repayments = $40M.
- D/E = 480 / 320 = 1.50×
- Debt Ratio = 480 / 800 = 60%
- TIE = 110 / 32 = 3.44× (reasonably comfortable)
- DSCR = 110 / (40 + 32) = 110 / 72 = 1.53× (above 1.25× minimum, but not by a large margin)
- Net Debt/EBITDA = (480 − 60) / 145 = 420 / 145 = 2.90× (moderate leverage)
Assessment: NovaTech carries meaningful leverage but appears capable of servicing its debt from current operations. A meaningful drop in EBIT (e.g., to $70M) would compress TIE to 2.2× and DSCR to 0.97× — a covenant-threatening level.
The Altman Z-Score
The Altman Z-Score (1968, revised 1995 for private firms) is a multivariate discriminant model that combines five financial ratios to predict bankruptcy within two years:
\[ Z' = 0.717 X_1 + 0.847 X_2 + 3.107 X_3 + 0.420 X_4 + 0.998 X_5 \]Where:
- \( X_1 = \) Working Capital / Total Assets (liquidity)
- \( X_2 = \) Retained Earnings / Total Assets (cumulative profitability and reinvestment)
- \( X_3 = \) EBIT / Total Assets (operating productivity of assets)
- \( X_4 = \) Book Value of Equity / Book Value of Total Liabilities (leverage cushion)
- \( X_5 = \) Revenue / Total Assets (asset utilization efficiency)
Interpretation thresholds (revised model for non-publicly-traded firms):
- \( Z' > 2.9 \): Safe zone — low bankruptcy probability
- \( 1.23 < Z' < 2.9 \): Grey zone — elevated uncertainty
- \( Z' < 1.23 \): Distress zone — high bankruptcy probability
Titan Retail Ltd. balance sheet and income statement data:
| Variable | Value |
|---|---|
| Working Capital | $45M |
| Total Assets | $300M |
| Retained Earnings | $80M |
| EBIT | $36M |
| Book Value of Equity | $120M |
| Total Liabilities | $180M |
| Revenue | $450M |
\( X_1 = 45/300 = 0.150 \) \( X_2 = 80/300 = 0.267 \) \( X_3 = 36/300 = 0.120 \) \( X_4 = 120/180 = 0.667 \) \( X_5 = 450/300 = 1.500 \)
\[ Z' = 0.717(0.150) + 0.847(0.267) + 3.107(0.120) + 0.420(0.667) + 0.998(1.500) \]\[ Z' = 0.108 + 0.226 + 0.373 + 0.280 + 1.497 = \mathbf{2.484} \]Titan falls in the grey zone (1.23 < 2.484 < 2.9). The score warrants closer monitoring — particularly the relatively low retained earnings ratio (X2) suggesting limited accumulated profit cushion, and the moderate leverage indicated by X4.
Bank Lending Criteria — The Five Cs of Credit
Traditional bank credit analysis evaluates a borrower across five dimensions:
- Character: Management’s track record, integrity, and willingness to repay (credit history, references, governance quality)
- Capacity: The ability to generate sufficient cash flow to service the debt (DSCR, TIE, free cash flow)
- Capital: The financial strength of the borrower — equity cushion and net worth
- Collateral: Assets pledged as security; the lender’s recovery in the event of default
- Conditions: The macroeconomic and industry environment; the purpose and structure of the loan
Chapter 4: Revenue Analysis and Earnings Quality
Revenue Recognition Principles
Under IFRS 15 (Revenue from Contracts with Customers), revenue is recognized using a five-step model:
- Identify the contract(s) with the customer
- Identify the performance obligations (distinct promises to transfer goods or services)
- Determine the transaction price
- Allocate the transaction price to each performance obligation
- Recognize revenue when (or as) the entity satisfies a performance obligation
Revenue recognition timing is one of the most common areas of earnings management and fraud. The application of judgment under IFRS 15 — for example, determining whether bundled deliverables are distinct performance obligations, estimating variable consideration, or assessing whether control has transferred — creates significant room for management discretion.
Revenue Quality Indicators
Days Sales Outstanding (DSO):
\[ \text{DSO} = \frac{\text{Average Accounts Receivable}}{\text{Revenue / 365}} \]Rising DSO suggests collection problems or aggressive revenue recognition. If DSO rises while revenue grows, sales may be recorded before cash is actually earned — a classic early-warning signal.
Receivables Turnover:
\[ \text{Receivables Turnover} = \frac{\text{Net Revenue}}{\text{Average Net Accounts Receivable}} \]A declining turnover (rising DSO) in the context of flat or growing revenue may indicate that customers are struggling to pay, credit standards are being loosened, or revenue is being pulled forward prematurely.
Revenue per Unit / ARPU Trends: Declining average revenue per unit or per customer may indicate competitive pressure or mix shift toward lower-value products.
Deferred Revenue: Rising deferred revenue (a liability representing cash received before revenue is earned) is a positive quality indicator — it represents a backlog of future recognized revenue. Declining deferred revenue in a subscription business may foreshadow revenue deceleration.
Revenue-to-Cash-Collections Ratio: Comparing revenue to cash collected from customers (from the cash flow statement or notes) directly shows whether recognized revenue is being converted to cash. A growing gap is a red flag.
Common Revenue Manipulation Schemes
Earnings Quality — The Jones Model
The Jones Model (Jones, 1991) and its refinement, the Modified Jones Model (Dechow et al., 1995), are regression-based techniques for estimating the portion of a firm’s accruals that are unusual relative to what would be expected given the firm’s economic activity. The residual — discretionary accruals — serves as a proxy for potential earnings management.
The model estimates total accruals as a function of:
- The change in revenues (adjusted for the change in receivables in the modified version)
- Gross PP&E (driving expected non-cash charges like depreciation)
The estimated parameters are derived from the firm’s own historical data or an industry cross-section. The abnormal (discretionary) accrual is the difference between actual total accruals and the model’s prediction.
\[ \text{Total Accruals} = \alpha_0 + \alpha_1 (\Delta\text{Revenue} - \Delta\text{AR}) + \alpha_2 \text{PPE} + \varepsilon \]A large positive residual (\(\varepsilon\)) indicates the firm is recording accruals in excess of what its operating activity justifies — a signal of potential income inflation.
The Beneish M-Score
The Beneish M-Score (1999) is an eight-variable probit model that calculates the probability of earnings manipulation. An M-Score above −1.78 is associated with a higher likelihood of manipulation. The eight ratios capture changes in receivables, gross margins, asset quality, revenue growth, depreciation, SG&A expenses, leverage, and accruals.
Chapter 5: Asset Analysis and Efficiency Ratios
Asset Analysis
Assets are the economic resources controlled by the entity. Evaluating asset quality requires understanding whether assets are properly valued, whether they are generating adequate returns, and whether any are impaired.
Asset Turnover:
\[ \text{Asset Turnover} = \frac{\text{Revenue}}{\text{Average Total Assets}} \]Measures revenue generated per dollar of assets. Industry benchmarks vary enormously: a grocery chain might turn assets 3× per year while a capital-intensive utility turns them 0.3×. Asset-light business models (software-as-a-service) may generate turnover ratios exceeding 1.0× even at modest revenues.
Fixed Asset Turnover:
\[ \text{Fixed Asset Turnover} = \frac{\text{Revenue}}{\text{Average Net PP\&E}} \]Measures how efficiently the firm utilizes its long-lived physical assets. A declining fixed asset turnover combined with rising capital expenditures can indicate that new investments are not generating proportionate revenue growth.
Inventory Turnover:
\[ \text{Inventory Turnover} = \frac{\text{Cost of Goods Sold}}{\text{Average Inventory}} \]Days Inventory Outstanding (DIO):
\[ \text{DIO} = \frac{365}{\text{Inventory Turnover}} = \frac{\text{Average Inventory} \times 365}{\text{COGS}} \]Measures the average number of days inventory sits before being sold. Rising DIO may indicate: slowing demand, accumulation of obsolete stock, a deliberate build-up ahead of a seasonal peak, or an intentional shift to a higher-margin but slower-moving product mix.
Accounts Receivable Turnover:
\[ \text{AR Turnover} = \frac{\text{Net Credit Sales}}{\text{Average Net Accounts Receivable}} \]Days Sales Outstanding (DSO) = 365 / AR Turnover. Measures the average collection period.
Accounts Payable Turnover:
\[ \text{AP Turnover} = \frac{\text{COGS}}{\text{Average Accounts Payable}} \]Days Payable Outstanding (DPO) = 365 / AP Turnover. Measures how long the firm takes to pay its suppliers.
Meridian Distributors Ltd. — Year 2025:
| Item | Amount |
|---|---|
| Revenue | $800M |
| COGS | $560M |
| Average Accounts Receivable | $88M |
| Average Inventory | $70M |
| Average Accounts Payable | $56M |
| Average Total Assets | $640M |
Calculations:
- Asset Turnover = 800 / 640 = 1.25×
- AR Turnover = 800 / 88 = 9.09×; DSO = 365 / 9.09 = 40.2 days
- Inventory Turnover = 560 / 70 = 8.00×; DIO = 365 / 8.00 = 45.6 days
- AP Turnover = 560 / 56 = 10.00×; DPO = 365 / 10.00 = 36.5 days
- Cash Conversion Cycle = DIO + DSO − DPO = 45.6 + 40.2 − 36.5 = 49.3 days
Meridian takes roughly 49 days to convert its investment in inventory and receivables into cash after paying suppliers. If the industry average CCC is 35 days, Meridian has a working capital efficiency gap worth investigating.
PP&E Age and Capital Expenditure Analysis
The average age of property, plant, and equipment can be estimated as:
\[ \text{Average PP\&E Age (years)} = \frac{\text{Accumulated Depreciation}}{\text{Annual Depreciation Expense}} \]\[ \text{Average PP\&E Remaining Life} = \frac{\text{Net PP\&E}}{\text{Annual Depreciation Expense}} \]A company with aging assets relative to peers may face large near-term capital expenditure requirements. Analysts compare capital expenditures to depreciation:
- CapEx / Depreciation < 1.0: The firm is not fully replacing assets consumed — possible underinvestment
- CapEx / Depreciation > 1.0: The firm is growing its asset base
- CapEx / Depreciation ≈ 1.0: Maintenance-level investment
Free Cash Flow (Maintenance) = CFO − Maintenance CapEx. Separating growth capex from maintenance capex is important but often requires management disclosure or estimates.
Market-Based Ratios
Market ratios relate the market value of the firm to accounting measures of earnings, book value, or operating metrics.
Price-to-Earnings Ratio (P/E):
\[ \text{P/E} = \frac{\text{Market Price per Share}}{\text{Earnings per Share (EPS)}} \]The P/E reflects the market’s expectation of future growth and risk. A high P/E means the market is paying a premium for each dollar of current earnings, anticipating strong earnings growth. P/E ratios are meaningless when earnings are negative or near zero.
Enterprise Value to EBITDA (EV/EBITDA):
\[ \text{EV/EBITDA} = \frac{\text{Market Cap} + \text{Net Debt} + \text{Minority Interest} + \text{Preferred Stock} - \text{Cash}}{\text{EBITDA}} \]Enterprise value (EV) represents the value of the entire business (debt plus equity, net of cash). EV/EBITDA is capital-structure-neutral and less sensitive to depreciation policy differences than P/E, making it better suited to cross-company comparisons.
Price-to-Book Ratio (P/B):
\[ \text{P/B} = \frac{\text{Market Price per Share}}{\text{Book Value of Equity per Share}} \]A P/B > 1.0 indicates the market values the firm above the net book value of its assets — implying positive expected future excess returns (intangibles, brand, competitive moat). A P/B < 1.0 may suggest the firm is destroying value or that its assets are overvalued on the balance sheet.
Price-to-Sales (P/S):
\[ \text{P/S} = \frac{\text{Market Capitalization}}{\text{Annual Revenue}} \]Commonly used for early-stage or unprofitable companies where earnings-based ratios are not meaningful. The ratio compresses away margin differences and should be used with caution.
Chapter 6: Liability Analysis and Working Capital Management
Liability Analysis
Liabilities represent obligations to transfer resources in the future. Key analytical concerns:
- On-balance-sheet vs. off-balance-sheet obligations: Under IFRS 16, operating leases are now capitalized on the balance sheet. Before IFRS 16, significant lease obligations existed off-balance-sheet. Analysts must ensure all forms of debt — bank loans, bonds, capitalized leases, pension obligations, contingent liabilities — are included in leverage calculations.
- Maturity profile: The timing of debt repayments — a “maturity wall” of large near-term repayments may create refinancing risk, especially if credit markets are stressed or the firm’s creditworthiness has deteriorated.
- Covenant compliance: Debt agreements often contain financial covenants; covenant violations can trigger cross-default provisions that cascade across multiple debt instruments.
- Off-balance-sheet risks: Guarantees, letters of credit, factoring arrangements with recourse, and variable interest entity (VIE) consolidation all represent contingent claims that standard balance sheet analysis may miss.
The Cash Conversion Cycle in Depth
A shorter CCC means the firm ties up less working capital in its operations. A negative CCC (common in grocery retail, streaming subscriptions, and some e-commerce businesses) means the firm collects cash from customers before it must pay suppliers — a form of interest-free financing from customers and suppliers.
Working Capital = Current Assets − Current Liabilities. An increase in working capital (other than cash) represents a use of cash — it means the firm has more money tied up in the operating cycle. This appears as a cash outflow in the operating section of the cash flow statement under the indirect method.
Net Working Capital (NWC) sometimes excludes cash and current debt (restricting to operating working capital):
\[ \text{Operating NWC} = \text{(Receivables + Inventory)} - \text{Accounts Payable} \]Growth in operating NWC as a percentage of revenue signals declining working capital efficiency; a reduction (DPO lengthening, inventory turns improving) signals improving efficiency.
Working Capital Financing Strategies
Aggressive working capital policy: Hold minimal current assets (lean inventory, tight credit terms) and finance a portion of current assets with short-term, lower-cost debt. This maximizes expected return but increases liquidity risk — the firm is exposed if it cannot roll over short-term borrowings.
Conservative working capital policy: Hold substantial current asset cushions and finance almost entirely with long-term debt. Higher carrying cost but lower refinancing risk.
The matching principle: Finance permanent (long-term) assets with long-term capital, and seasonal or temporary working capital with short-term borrowing. This minimizes cost while aligning funding maturities with asset lives.
Chapter 7: Cash Flow Analysis
Why Cash Flow Matters
Accrual accounting allows revenues and expenses to be recorded in periods different from when cash actually flows. While this provides a more accurate picture of economic performance over time, it also creates opportunities for earnings management and can obscure a firm’s actual cash-generating ability. Cash flow analysis is therefore an essential complement to income statement analysis.
Structure of the Cash Flow Statement
The statement of cash flows classifies cash flows into three categories:
| Activity | Content | Analyst Focus |
|---|---|---|
| Operating (CFO) | Cash from core operations — collections from customers, payments to suppliers, employees, taxes | Core cash-generating ability; compare to net income |
| Investing (CFI) | Capital expenditures, acquisitions, proceeds from asset sales, purchases/sales of investments | Maintenance vs. growth investment; capex intensity |
| Financing (CFF) | Debt issuance/repayment, equity issuance/buybacks, dividends | Capital structure changes; return of capital to investors |
Key linkage: Net change in cash = CFO + CFI + CFF. Any discrepancy between reported net income and CFO flows through the working capital and non-cash charge adjustments in the operating section.
Free Cash Flow Definitions
Free Cash Flow to the Firm (FCFF):
\[ \text{FCFF} = \text{EBIT} \times (1-t) + \text{D\&A} - \Delta\text{Working Capital} - \text{Capital Expenditures} \]Alternatively:
\[ \text{FCFF} = \text{CFO} + \text{Interest Expense} \times (1-t) - \text{Capital Expenditures} \]FCFF is available to all capital providers (debt and equity holders). It is the appropriate numerator in a WACC-based DCF model.
Free Cash Flow to Equity (FCFE):
\[ \text{FCFE} = \text{CFO} - \text{Capital Expenditures} + \text{Net Borrowing} \]FCFE is the cash available to equity holders after all obligations have been met. It is the appropriate numerator in an equity cost-of-capital-based DCF model.
Levered Free Cash Flow (used in private equity and M&A):
\[ \text{LFCF} = \text{EBITDA} - \text{Cash Taxes} - \Delta\text{Working Capital} - \text{Capex} - \text{Debt Service} \]Operating Cash Flow Quality
The most fundamental question in cash flow analysis: Is CFO greater than or less than net income? When net income persistently exceeds CFO, accruals are building up — the firm is recording income it has not yet collected in cash.
Accruals Ratio (Balance Sheet Method):
\[ \text{Accruals Ratio}_{BS} = \frac{\text{NOA}_t - \text{NOA}_{t-1}}{\frac{NOA_t + NOA_{t-1}}{2}} \]Accruals Ratio (Cash Flow Method):
\[ \text{Accruals Ratio}_{CF} = \frac{\text{Net Income} - \text{CFO} - \text{CFI}}{\frac{NOA_t + NOA_{t-1}}{2}} \]Where NOA = Net Operating Assets (operating assets − operating liabilities). A high positive accruals ratio indicates that earnings are driven by accruals rather than cash — associated with weaker earnings persistence (Sloan, 1996; Richardson et al., 2005).
Summit Technologies Corp. reports:
| Item | Year 2025 |
|---|---|
| Net Income | $85M |
| Cash Flow from Operations | $52M |
| Capital Expenditures | $38M |
| Depreciation & Amortization | $25M |
| Average Net Operating Assets | $310M |
Analysis:
- CFO / Net Income = 52 / 85 = 0.61 — only 61 cents of cash for every $1 of reported income; a concern
- FCFF = CFO − CapEx = 52 − 38 = $14M — thin free cash flow generation
- Accruals = Net Income − CFO = 85 − 52 = $33M in income not backed by cash
- CapEx / D&A = 38 / 25 = 1.52× — growing the asset base, which partially explains capex exceeding CFO
- Accruals Ratio (simplified) = 33 / 310 = 10.6% — elevated; deserves investigation into what is driving the large positive accrual (e.g., rising receivables, capitalized software, deferred tax)
Cash Flow Pattern Analysis
Analysts use the pattern of signs across CFO, CFI, and CFF to characterize the stage and health of a business:
| CFO | CFI | CFF | Interpretation |
|---|---|---|---|
| + | − | − | Mature, profitable business: generates cash, invests for maintenance/growth, repays debt or buys back shares |
| + | − | + | Growing business: strong operations but also raising external capital for expansion |
| − | − | + | Early-stage or turnaround: burning cash from operations, investing heavily, funded by external capital |
| + | + | − | Harvesting: selling assets to fund distributions; may signal strategic restructuring |
| − | + | − | Crisis: selling assets to fund operations and repay debt — a red flag |
Chapter 8: Short-Term Financial Planning — Cash Budgeting
The Role of Short-Term Planning
Short-term financial planning covers the next 12 months and focuses on ensuring the firm has sufficient cash to meet operating obligations while not holding excess idle liquidity. Its primary output is the cash budget: a month-by-month (or week-by-week) projection of cash inflows and outflows.
Components of the Cash Budget
Step 1 — Cash Receipts
Cash receipts are primarily driven by collections from accounts receivable, which depend on the revenue forecast and the collection pattern:
\[ \text{Cash Collections}_t = \text{Revenue}_{t} \times (\text{Cash Sales \%}) + \text{AR}_{t-1} \times (\text{Collection \%}) + \text{AR}_{t-2} \times (\text{Remaining Collection \%}) \]If 60% of sales are collected in the month of sale, 35% in the following month, and 5% are uncollectable, the collection pattern is applied to the revenue forecast to derive monthly cash inflows.
Step 2 — Cash Disbursements
- Inventory payments: Based on the production/purchasing plan and the DPO. If DPO = 30 days, last month’s purchases are paid this month.
- Labour and overhead: Usually paid within the month incurred.
- SG&A and other operating costs: Per the operating expense schedule.
- Capital expenditures: Per the capex budget.
- Debt service: Interest and principal per the debt schedule.
- Tax payments: Quarterly installment payments.
- Dividends: Per the dividend policy.
Step 3 — Net Cash Flow and Minimum Cash Balance
\[ \text{Net Cash Flow}_t = \text{Receipts}_t - \text{Disbursements}_t \]\[ \text{Ending Cash Balance}_t = \text{Beginning Cash}_t + \text{Net Cash Flow}_t \]Management maintains a minimum cash balance (a precautionary buffer). If the projected ending balance falls below the minimum, additional short-term borrowing is required. If it exceeds the minimum by a large margin, the surplus can be invested in short-term securities.
Apex Consumer Products Inc. has a minimum cash balance requirement of $10M. Revenue forecast: Jan $80M, Feb $90M, Mar $100M. Collection pattern: 50% same month, 45% next month, 5% bad debt. Cost of goods sold is 60% of revenue, paid the following month. Other disbursements: $15M/month. Beginning January cash: $12M.
| January | February | March | |
|---|---|---|---|
| Cash Receipts | |||
| Current month collections (50%) | $40.0M | $45.0M | $50.0M |
| Prior month collections (45%) | $36.0M* | $36.0M | $40.5M |
| Total Receipts | $76.0M | $81.0M | $90.5M |
| Disbursements | |||
| Inventory (prior month COGS) | $42.0M* | $48.0M | $54.0M |
| Other operating | $15.0M | $15.0M | $15.0M |
| Total Disbursements | $57.0M | $63.0M | $69.0M |
| Net Cash Flow | $19.0M | $18.0M | $21.5M |
| Beginning Cash | $12.0M | $31.0M | $49.0M |
| Ending Cash | $31.0M | $49.0M | $70.5M |
| Minimum Cash | $10.0M | $10.0M | $10.0M |
| Surplus / (Deficit) | $21.0M | $39.0M | $60.5M |
*December actuals used for prior-month collections and prior-month inventory payment.
Conclusion: Apex will accumulate significant cash surpluses in Q1. Management should consider investing the surplus in short-term money market instruments or pre-paying portions of revolving credit facility balances.
Chapter 9: Long-Term Financial Planning — Pro Forma Statements and EFN
The Role of Long-Term Financial Planning
Long-term financial planning (typically a 3–5 year horizon) projects future financial statements under specific assumptions about growth, margins, and investment needs. The primary outputs are:
- Pro forma income statement: Projected revenues, expenses, and net income
- Pro forma balance sheet: Projected assets, liabilities, and equity
- Pro forma cash flow statement: Projected sources and uses of cash
- External Financing Needed (EFN): The additional external capital required to support projected growth
Percentage-of-Sales Forecasting
The most widely used long-term planning approach is percentage-of-sales (POS) forecasting, which assumes that most balance sheet and income statement items scale proportionally with revenue.
Step 1 — Forecast Revenue
\[ \text{Forecast Revenue} = \text{Current Revenue} \times (1 + g) \]The growth rate \(g\) is based on historical trends, market research, industry growth rates, and management guidance.
Step 2 — Forecast Income Statement Items
Each operating line item is expressed as a percentage of revenue (using historical averages or analyst estimates of future efficiency):
\[ \text{Forecast Line Item} = \text{Forecast Revenue} \times \text{Historical Ratio} \]Items not proportional to revenue (e.g., interest expense, which depends on debt levels; depreciation, which depends on PP&E) require separate calculation.
Step 3 — Forecast Asset-Side Balance Sheet
Operational assets scale with revenue via turnover ratios:
\[ \text{Forecast AR} = \frac{\text{Forecast Revenue}}{\text{AR Turnover}} \]\[ \text{Forecast Inventory} = \frac{\text{Forecast COGS}}{\text{Inventory Turnover}} \]\[ \text{Forecast PP\&E (net)} = \text{Current Net PP\&E} + \text{Forecast CapEx} - \text{Forecast Depreciation} \]Step 4 — Forecast Liability-Side and Equity
Spontaneous liabilities (accounts payable, accrued liabilities) scale with revenue:
\[ \text{Forecast AP} = \frac{\text{Forecast COGS}}{\text{AP Turnover}} \]Retained earnings increases by forecast net income minus forecast dividends. Long-term debt and new equity issuance are the “plug” — the external financing needed.
The External Financing Needed (EFN) Model
EFN is the additional external capital (debt or equity) required to support a given growth rate, given the firm’s internal cash generation.
Where:
- \( A^* \) = assets that vary spontaneously with sales
- \( L^* \) = liabilities that vary spontaneously with sales
- \( S_0 \) = current sales; \( S_1 = S_0 \times (1+g) \) = projected sales; \( \Delta S = S_1 - S_0 \)
- \( p \) = net profit margin; \( d \) = dividend payout ratio
Intuition: The numerator of assets (\(A^*/S_0 \times \Delta S\)) is the additional investment required to support higher revenue. The firm partly finances this through spontaneous liabilities (which also grow with sales) and partly through retained earnings (profit that is not paid out as dividends). The remainder — EFN — must come from external sources.
Horizon Manufacturing Ltd. — Current Year:
| Item | Value |
|---|---|
| Current Revenue (\(S_0\)) | $600M |
| Projected Revenue Growth | 15% |
| Spontaneous Assets (\(A^*\)) | $480M |
| Spontaneous Liabilities (\(L^*\)) | $180M |
| Net Profit Margin (\(p\)) | 8% |
| Dividend Payout Ratio (\(d\)) | 40% |
Step 1: Projected revenue: \( S_1 = 600 \times 1.15 = \$690\text{M} \); \( \Delta S = \$90\text{M} \)
Step 2: Required asset increase:
\[ \frac{A^*}{S_0} \times \Delta S = \frac{480}{600} \times 90 = 0.80 \times 90 = \$72\text{M} \]Step 3: Spontaneous liability increase:
\[ \frac{L^*}{S_0} \times \Delta S = \frac{180}{600} \times 90 = 0.30 \times 90 = \$27\text{M} \]Step 4: Addition to retained earnings:
\[ p \times S_1 \times (1-d) = 0.08 \times 690 \times (1 - 0.40) = 0.08 \times 690 \times 0.60 = \$33.12\text{M} \]Step 5: EFN:
\[ \text{EFN} = 72 - 27 - 33.12 = \mathbf{\$11.88\text{M}} \]Interpretation: Horizon needs approximately $11.9M of external financing to support 15% revenue growth while maintaining its current operational efficiency, margin, and dividend policy. This could be raised through additional bank borrowing, bond issuance, or equity. If management is unwilling to issue external capital, growth must be moderated or the dividend payout reduced.
The Sustainable Growth Rate
The sustainable growth rate (SGR) is the maximum rate at which the firm can grow revenue while maintaining its current ratios (profit margin, asset turnover, financial leverage, and dividend payout) without raising external equity.
\[ g^* = \frac{ROE \times b}{1 - ROE \times b} \]Where \( b = (1 - d) \) is the retention ratio (plowback ratio).
Alternative equivalent formula:
\[ g^* = \frac{p \times \frac{S}{A} \times \frac{A}{E} \times b}{1 - p \times \frac{S}{A} \times \frac{A}{E} \times b} \]Using Horizon Manufacturing data: ROE = Net Income / Equity = (0.08 × $600M) / $240M. Wait — we need equity. Suppose equity = $240M.
ROE = 48 / 240 = 20%; b = 1 − 0.40 = 0.60
\[ g^* = \frac{0.20 \times 0.60}{1 - 0.20 \times 0.60} = \frac{0.12}{1 - 0.12} = \frac{0.12}{0.88} = \mathbf{13.6\%} \]Horizon is targeting 15% growth but can sustain only 13.6% internally. The difference (about 1.4 percentage points) is the source of the EFN — it confirms that some external financing is required.
Policy implications of the SGR formula: A firm can increase its sustainable growth rate by:
- Increasing its net profit margin \(p\) (improving operational efficiency or pricing power)
- Increasing asset turnover (generating more revenue per dollar of assets)
- Increasing financial leverage (using more debt relative to equity)
- Reducing the dividend payout ratio \(d\) (retaining more earnings)
Chapter 10: Scenario Analysis, Sensitivity Analysis, and Integrated Financial Modeling
The Need for Scenario and Sensitivity Analysis
A financial model with a single set of assumptions produces a single point estimate — a false precision that obscures the fundamental uncertainty in any projection. Professional financial planning always supplements the base case with alternative scenarios and sensitivity tests.
Scenario analysis involves changing multiple assumptions simultaneously to represent coherent alternative states of the world (e.g., recession, base case, expansion scenario). Each scenario is internally consistent: in a recession scenario, revenue declines, margins compress, and working capital needs change — these effects are correlated and should be modeled together.
Sensitivity analysis (one-way or tornado analysis) varies one assumption at a time while holding all others fixed. It identifies which input assumptions have the greatest impact on the output variable of interest (e.g., EFN, free cash flow, or equity value).
Building a Scenario Analysis
| Assumption | Bear Case | Base Case | Bull Case |
|---|---|---|---|
| Revenue Growth | 5% | 15% | 25% |
| Net Profit Margin | 5% | 8% | 10% |
| Dividend Payout | 40% | 40% | 40% |
| Spontaneous Asset Ratio (A*/S) | 80% | 80% | 80% |
| Spontaneous Liability Ratio (L*/S) | 30% | 30% | 30% |
Bear Case: ΔS = $30M; Required assets = 0.80 × 30 = $24M; Spontaneous liabilities = 0.30 × 30 = $9M; Retained earnings = 0.05 × $630M × 0.60 = $18.9M; EFN = 24 − 9 − 18.9 = −$3.9M (surplus — no external financing needed; firm can actually retire debt or buy back shares)
Base Case: EFN = $11.9M (as calculated above)
Bull Case: ΔS = $150M; Required assets = 0.80 × 150 = $120M; Spontaneous liabilities = 0.30 × 150 = $45M; Retained earnings = 0.10 × $750M × 0.60 = $45M; EFN = 120 − 45 − 45 = $30M (significant external financing need)
Key insight: The financing need is most acute precisely when the business is growing fastest — a “good problem to have,” but one that requires advance planning.
Sensitivity (Tornado) Analysis
A tornado chart ranks assumptions by their impact on EFN (or another output variable):
| Input Variable | Low Value | High Value | EFN Range |
|---|---|---|---|
| Revenue Growth Rate | 5% | 25% | −$3.9M to +$30M |
| Net Profit Margin | 5% | 10% | +$16M to +$8M |
| Dividend Payout Ratio | 20% | 60% | +$7.5M to +$16M |
| Spontaneous Asset Ratio | 70% | 90% | +$3M to +$21M |
The widest bar (revenue growth) represents the variable with the most leverage over the outcome. Management should focus risk management and planning efforts most intensely on the highest-sensitivity variables.
Integrated Financial Modeling Best Practices
A fully integrated three-statement model links the income statement, balance sheet, and cash flow statement in a mathematically consistent way:
- Income statement produces net income, which flows to retained earnings on the balance sheet
- Balance sheet changes in working capital, PP&E, and debt feed into the cash flow statement
- Cash flow statement produces ending cash, which flows back to the balance sheet cash line
- The model must balance: Assets = Liabilities + Equity at all times
The plug variable: In a forecasting model, one item is typically the “plug” — the balancing variable. Common choices are:
- Revolving credit facility (revolver): If the firm needs cash, the revolver draws up; if cash is in surplus, the revolver pays down
- Cash: The cash balance absorbs any imbalance — but this is less useful for planning because it doesn’t show explicitly whether the firm needs external capital
Circularity: Interest expense depends on debt balances, which depend on the plug, which depends on the income statement, which depends on interest expense — a circular reference. Models resolve this by iterating to convergence or by using beginning-period debt balances for the interest calculation.
Chapter 11: Financial Statement Forecasting — Articulated Pro Forma Model
Forecasting the Income Statement
Revenue: Base-year revenue multiplied by (1 + growth rate). Segment-level forecasting is preferred when the business has multiple distinct divisions with different growth profiles.
Cost of Goods Sold: Revenue × COGS ratio. The COGS ratio is estimated from historical data, adjusted for expected changes in input costs, pricing power, or product mix.
Gross Profit = Revenue − COGS.
SG&A and R&D: These may scale with revenue (variable portion) or be relatively fixed. For large fixed components, model them separately as a fixed amount plus a variable component as % of revenue.
Depreciation: Prior-period net PP&E plus capex less disposals, divided by estimated useful life. Or: prior-period gross PP&E times the historical depreciation rate.
EBIT = Gross Profit − SG&A − R&D − D&A.
Interest Expense: Prior-period (or average) long-term debt balance × the weighted average interest rate on debt.
EBT = EBIT − Interest Expense + Interest Income on cash.
Income Tax: EBT × effective tax rate.
Net Income = EBT − Taxes.
EPS = Net Income / Weighted Average Diluted Shares Outstanding.
Dividends = DPS × shares outstanding (or net income × payout ratio).
Addition to Retained Earnings = Net Income − Dividends.
Forecasting the Balance Sheet
Cash: Typically the plug (minimum cash balance plus any free cash available, or draws/repayments on revolver).
Accounts Receivable: Revenue / AR Turnover.
Inventory: COGS / Inventory Turnover.
Prepaid and Other Current Assets: Often as % of revenue or grown at inflation.
Gross PP&E: Prior gross PP&E + CapEx − Disposals (at cost).
Accumulated Depreciation: Prior accumulated D&A + current D&A − Accumulated D&A on disposed assets.
Net PP&E: Gross PP&E − Accumulated Depreciation.
Goodwill and Intangibles: Typically held constant (no future acquisitions assumed) unless amortization is expected; flag any impairment risk.
Accounts Payable: COGS / AP Turnover.
Accrued Liabilities: Often as % of revenue or operating expenses.
Long-term Debt: Prior balance + new borrowings − repayments.
Common Equity: Prior balance + net income − dividends + new equity issuance.
Retained Earnings: Prior retained earnings + addition to retained earnings.
Forecasting the Cash Flow Statement (Indirect Method)
Operating Section:
- Start with net income
- Add back D&A (non-cash)
- Subtract (add) increases (decreases) in accounts receivable
- Subtract (add) increases (decreases) in inventory
- Add (subtract) increases (decreases) in accounts payable
- Add (subtract) other working capital changes
Investing Section:
- Subtract capital expenditures
- Add proceeds from asset sales or investments
Financing Section:
- Add proceeds from new debt issuance
- Subtract debt repayments
- Add proceeds from new equity issuance
- Subtract share buybacks
- Subtract dividends paid
Net Change in Cash = CFO + CFI + CFF.
Verification: Beginning cash + net change in cash = ending cash on balance sheet. If these do not reconcile, there is an error in the model.
Assumptions: Revenue growth = 15%; COGS / Revenue = 65%; SG&A / Revenue = 12%; D&A = $18M; CapEx = $25M; Tax rate = 25%; Payout ratio = 40%.
Current-year balance sheet (selected): Cash = $20M; AR = $75M (AR turnover = 8×); Inventory = $60M (inventory turns = 7×); Net PP&E = $160M; Total Assets = $380M; AP = $45M (AP turnover = 8.7×); LT Debt = $120M (interest rate = 5%); Equity = $215M.
Pro Forma Income Statement:
| Line | Calculation | Amount |
|---|---|---|
| Revenue | 600 × 1.15 | $690M |
| COGS | 690 × 0.65 | $448.5M |
| Gross Profit | $241.5M | |
| SG&A | 690 × 0.12 | $82.8M |
| EBITDA | $158.7M | |
| D&A | given | $18.0M |
| EBIT | $140.7M | |
| Interest Expense | 120 × 0.05 | $6.0M |
| EBT | $134.7M | |
| Tax (25%) | $33.7M | |
| Net Income | $101.0M | |
| Dividends (40%) | $40.4M | |
| Addition to RE | $60.6M |
Pro Forma Balance Sheet (selected items):
| Line | Calculation | Amount |
|---|---|---|
| AR | 690 / 8 | $86.3M |
| Inventory | 448.5 / 7 | $64.1M |
| Net PP&E | 160 + 25 − 18 | $167.0M |
| AP | 448.5 / 8.7 | $51.6M |
| Equity | 215 + 60.6 | $275.6M |
| Required Total Assets | (approx. scaling) | ~$437M |
| Available Financing | Liabilities + Equity | ~$425M |
| EFN | Gap | ~$12M |
The EFN of approximately $12M confirms our earlier calculation. Management would arrange a new term loan or draw on the revolving credit facility to cover this gap.
Chapter 12: Comprehensive Ratio Analysis and Financial Assessment
Integrated Ratio Analysis Framework
Effective financial analysis does not compute ratios in isolation — it weaves together profitability, liquidity, solvency, and efficiency metrics into a coherent narrative about the firm’s financial health and competitive position.
Step 1 — Profitability: Is the firm generating adequate returns on capital? Compare gross, operating, and net margins to historical trends and peer benchmarks.
Step 2 — Efficiency: Is the firm deploying its assets productively? Analyze asset turnover, inventory turnover, DSO, and DPO relative to peers.
Step 3 — Liquidity: Can the firm meet its near-term obligations? Compute current, quick, and cash ratios; examine the CCC.
Step 4 — Solvency: Is the capital structure sustainable? Examine D/E, TIE, DSCR, and net debt/EBITDA.
Step 5 — Quality: Are the reported numbers trustworthy? Examine CFO vs. net income, the accruals ratio, and revenue recognition policies.
Step 6 — Growth and Valuation: What is the market paying for the firm’s earnings and assets? Examine P/E, EV/EBITDA, and P/B relative to fundamentals.
Comprehensive Worked Example — Integrated Analysis
Income Statement:
| Item | Year 2025 | Year 2024 |
|---|---|---|
| Revenue | $1,200M | $1,050M |
| COGS | $780M | $672M |
| Gross Profit | $420M | $378M |
| SG&A | $240M | $210M |
| EBITDA | $180M | $168M |
| D&A | $45M | $40M |
| EBIT | $135M | $128M |
| Interest Expense | $28M | $25M |
| EBT | $107M | $103M |
| Taxes (27%) | $28.9M | $27.8M |
| Net Income | $78.1M | $75.2M |
Balance Sheet (selected):
| Item | 2025 | 2024 |
|---|---|---|
| Cash | $55M | $40M |
| Accounts Receivable | $120M | $105M |
| Inventory | $175M | $160M |
| Total Current Assets | $360M | $310M |
| Net PP&E | $420M | $410M |
| Total Assets | $820M | $760M |
| Accounts Payable | $130M | $115M |
| Total Current Liabilities | $220M | $200M |
| Long-Term Debt | $280M | $260M |
| Total Equity | $290M | $275M |
Cash Flow:
| Item | 2025 |
|---|---|
| CFO | $95M |
| CapEx | $55M |
| CFF | −$22M (net debt repayment and dividends) |
Ratio Analysis:
| Category | Ratio | 2025 | 2024 | Change |
|---|---|---|---|---|
| Profitability | Gross Margin | 35.0% | 36.0% | −1.0pp |
| Operating Margin | 11.25% | 12.2% | −1.0pp | |
| Net Margin | 6.51% | 7.16% | −0.7pp | |
| ROA (approx.) | 9.8% | 9.7% | +0.1pp | |
| ROE | 26.9% | 27.3% | −0.4pp | |
| Efficiency | Asset Turnover | 1.52× | 1.46× | +0.06 |
| Inventory Turns | 4.46× | 4.20× | +0.26 | |
| DIO | 81.9 days | 86.9 days | −5.0 days | |
| DSO | 36.5 days | 36.5 days | flat | |
| DPO | 60.8 days | 62.5 days | −1.7 days | |
| CCC | 57.6 days | 60.9 days | −3.3 days | |
| Liquidity | Current Ratio | 1.64× | 1.55× | +0.09 |
| Quick Ratio | 0.84× | 0.75× | +0.09 | |
| CFO / CL | 0.43× | — | — | |
| Solvency | D/E | 0.97× | 0.95× | +0.02 |
| Net Debt/EBITDA | 2.50× | 2.38× | +0.12 | |
| TIE | 4.82× | 5.12× | −0.30 | |
| Quality | CFO / Net Income | 1.22× | — | — |
Narrative:
CrestLine shows improving operational efficiency (CCC down 3.3 days, asset turnover up) but declining margin quality. The 100 bp decline in gross margin from 36% to 35% requires explanation — likely reflecting commodity cost pressures or competitive pricing. The 100 bp decline in operating margin suggests SG&A has not been reduced to offset gross margin compression.
The leverage picture is stable: TIE of 4.82× provides adequate coverage, and Net Debt/EBITDA of 2.50× is moderate for retail. CFO of $95M vs. net income of $78M gives a CFO/NI ratio of 1.22× — healthy; earnings are backed by cash.
DuPont decomposition: ROE = Net Margin × Asset Turnover × Equity Multiplier = 6.51% × 1.52 × 2.83 = 28.0% (the slight difference from the direct calculation reflects rounding and the use of ending vs. average equity).
Overall: CrestLine is a fundamentally solid retailer with one yellow flag — margin compression. An analyst would probe the Q4 investor call for commentary on gross margin trajectory and pricing strategy.
Chapter 13: Earnings Quality, Governance, and Reporting Analysis
The Spectrum of Earnings Quality
Earnings quality exists on a spectrum. At one end are perfectly transparent, cash-backed, persistent earnings that faithfully represent the firm’s economic performance. At the other end is outright fraud — fabricated transactions, falsified documents, and deliberate misrepresentation. Between these extremes lies a broad territory of aggressive-but-legal accounting choices.
Accrual Manipulation — Mechanics and Detection
Revenue-side accrual manipulation:
- Recognizing revenue too early (before performance obligations are satisfied)
- Understating the allowance for doubtful accounts (inflating net receivables and revenues)
- Classifying non-recurring income (gains on asset sales) as operating revenue
Expense-side accrual manipulation:
- Capitalizing costs that should be expensed (e.g., WorldCom capitalized ordinary line costs as capital assets)
- Understating warranty reserves, litigation reserves, or restructuring charges
- Extending useful lives of depreciable assets to reduce annual depreciation
Cookie jar reserves: In good years, management records excessive provisions (restructuring charges, asset write-downs, warranty accruals). In bad years, it reverses these provisions into income — smoothing reported earnings at the cost of interperiod distortion.
The Jones Model — Formal Specification
The Modified Jones Model estimates non-discretionary accruals (NDA) — the accruals that would be expected given the firm’s economic activity — and identifies the residual (discretionary accruals, DA) as the manipulation signal.
Total Accruals (TA):
\[ \text{TA}_t = \text{Net Income}_t - \text{CFO}_t \]Or equivalently (balance sheet approach):
\[ \text{TA}_t = \Delta\text{CA}_t - \Delta\text{Cash}_t - \Delta\text{CL}_t + \Delta\text{CPLTD}_t - \text{D\&A}_t \]Modified Jones Model Regression (estimated on a firm time-series or industry cross-section):
\[ \frac{\text{TA}_t}{A_{t-1}} = \alpha_0 \frac{1}{A_{t-1}} + \alpha_1 \frac{\Delta\text{Rev}_t - \Delta\text{AR}_t}{A_{t-1}} + \alpha_2 \frac{\text{PPE}_t}{A_{t-1}} + \varepsilon_t \]Where:
- \( A_{t-1} \) = total assets at start of period (deflator)
- \( \Delta\text{Rev}_t - \Delta\text{AR}_t \) = change in revenues minus change in receivables (the receivables adjustment removes a potential manipulation avenue)
- \( \text{PPE}_t \) = gross PP&E (controls for non-discretionary depreciation charges)
- \( \varepsilon_t \) = discretionary accruals (the residual)
A large positive DA suggests income-increasing manipulation; a large negative DA suggests income-decreasing manipulation (e.g., “taking a big bath”).
Corporate Governance and Reporting Quality
Governance refers to the system of rules, practices, and processes by which a company is directed and controlled. Strong governance reduces management’s ability and incentive to manipulate reported earnings.
Board of directors:
- Independence of the audit committee (should consist entirely of independent directors with financial expertise)
- Separation of CEO and board chair roles reduces concentration of power
- Board size: large boards are often less effective (more difficult to achieve consensus)
External audit quality:
- Auditor size and independence: Big Four auditors have stronger reputations at stake, providing greater deterrence against collusion with management
- Audit committee pre-approval of all audit and non-audit services
- Frequent auditor changes may signal disputes over accounting choices
Executive compensation design:
- Heavy reliance on short-term stock price performance creates incentives to inflate current earnings
- Clawback provisions (requiring return of bonuses if earnings are restated) partially mitigate this
- Long vesting periods for equity awards align management incentives with long-term value creation
Insider ownership:
- Aligned interests when management owns significant equity
- But concentrated insider ownership combined with controlling voting rights can shield management from shareholder discipline
Chapter 14: Market-Based Valuation and the Link to Financial Analysis
From Financial Analysis to Valuation
Financial statement analysis does not exist in isolation — it ultimately serves prospective analysis: forecasting future performance and estimating the value of the enterprise or equity. The two primary approaches that integrate financial analysis and valuation are:
- Fundamental valuation: Constructing a discounted cash flow (DCF) model based on pro forma financial statements
- Relative valuation: Applying market multiples derived from comparable companies to the subject firm’s financial metrics
Both approaches require the inputs generated by financial analysis: normalized earnings, sustainable margins, working capital requirements, reinvestment rates, and growth expectations.
Key Valuation Multiples — Drivers and Interpretation
P/E Ratio:
The Gordon Growth Model provides a theoretical foundation for the P/E:
\[ \frac{P_0}{E_1} = \frac{(1-b)}{r - g} = \frac{\text{Payout Ratio}}{\text{Cost of Equity} - \text{Sustainable Growth Rate}} \]This shows that a higher P/E is justified by: (a) lower required return / lower risk; (b) higher sustainable growth rate; or (c) higher payout ratio (less retention needed because investment opportunities are limited). Paying a high P/E for a low-growth firm is only justified if profitability is extremely stable and the required return is very low.
EV/EBITDA:
Commonly used in leveraged buyout (LBO) modeling because it is capital-structure-neutral and approximates the multiple of operating cash flow being paid. Lower EV/EBITDA means the firm is cheaper relative to its cash generation — but must be interpreted relative to industry and growth expectations. A company growing EBITDA at 25% per year may deserve a 15× multiple while a declining business may deserve 5×.
PEG Ratio (P/E to Growth):
\[ \text{PEG} = \frac{\text{P/E Ratio}}{\text{Annual EPS Growth Rate (\%)}} \]A PEG below 1.0 is sometimes considered undervalued relative to growth; above 2.0 may indicate overvaluation. The PEG ratio adjusts the P/E for expected growth, making it useful when comparing firms with very different growth profiles.
Price-to-Book (P/B) and Residual Income:
The residual income valuation model connects P/B to ROE and cost of equity:
\[ \frac{P_0}{B_0} = 1 + \frac{\text{ROE} - r_e}{r_e - g} \]This shows that P/B > 1 is justified only if ROE > cost of equity (\(r_e\)). Firms earning returns below their cost of equity should trade below book value — the market reflects the destruction of economic value.
EV/EBITDA Multiple Expansion and Contraction
CrestLine Retail Corp. EBITDA = $180M. Comparable peer group trades at EV/EBITDA of 9.0× (median).
Estimated Enterprise Value = 180 × 9.0 = $1,620M
Less: Net Debt = LTD + Current Portion − Cash = $280M + $20M − $55M = $245M
Implied Equity Value = $1,620M − $245M = $1,375M
If CrestLine has 50 million diluted shares outstanding:
Implied Share Price = $1,375M / 50M = $27.50 per share
If the current market price is $25.00, the stock appears undervalued by approximately 10% relative to the peer group multiple — assuming the peer group multiple is the appropriate benchmark and CrestLine’s EBITDA is normalized.
Chapter 15: Special Topics — Lease Accounting, Pension Obligations, and Off-Balance-Sheet Items
Lease Accounting Under IFRS 16
IFRS 16 (Leases, effective January 1, 2019) requires lessees to recognize a right-of-use (ROU) asset and a lease liability on the balance sheet for virtually all leases with a term exceeding 12 months. This eliminated the distinction between operating and finance leases for lessees.
Impact on financial statements:
- Balance sheet: Assets and liabilities both increase (higher leverage ratios, lower asset turnover)
- Income statement: Lease expense is replaced by depreciation of the ROU asset plus interest on the lease liability — total expense is similar but front-loaded
- Cash flow statement: Lease payments that were previously classified as operating outflows are now split between operating (interest component) and financing (principal component)
Analytical implications:
- Debt-to-equity ratios increase for firms with significant operating leases
- EBITDA increases (lease expense is below EBITDA; depreciation and interest are below EBITDA)
- EV/EBITDA multiples should be compared carefully between pre- and post-IFRS 16 periods
- Lease-adjusted EBIT and debt are useful for historical comparisons
Pension Obligations
Defined benefit (DB) pension plans create a complex liability for the sponsoring company: the obligation to pay specified future benefits to retirees, regardless of fund performance.
Net pension liability (deficit):
\[ \text{Net Pension Liability} = \text{Present Value of Defined Benefit Obligation (DBO)} - \text{Fair Value of Plan Assets} \]A deficit (DBO > plan assets) means the firm has a net obligation. Under IAS 19 (Employee Benefits), this net liability is recognized on the balance sheet.
Pension expense components:
- Current service cost: The increase in DBO from employees earning one more year of benefits
- Net interest cost: Interest on the net pension liability (discount rate × net liability)
- Remeasurements: Actuarial gains/losses from changes in assumptions (mortality rates, salary growth, discount rates) — recognized in OCI, not the income statement
Analytical treatment: The discount rate is management’s choice (typically the yield on high-quality corporate bonds). A higher discount rate reduces the DBO — a source of management discretion. Analysts compare discount rate assumptions to market rates and to peer companies.
Off-Balance-Sheet Financing
Despite IFRS improvements (IFRS 16 for leases, IFRS 10 for consolidation), some obligations may still reside off-balance-sheet:
- Contingent liabilities: Legal disputes, environmental remediation obligations — disclosed in footnotes but not recognized unless probable and estimable
- Factoring with recourse: When receivables are sold but the seller retains credit risk, the economic liability remains even if the receivable is derecognized
- Variable interest entities (VIEs): Special-purpose entities that may be controlled by the firm but structured to avoid consolidation
- Operating leases of associates: If a firm accounts for a joint venture using the equity method, the JV’s debt is not consolidated — but the firm may have guaranteed the JV’s debt
Analysts must read footnotes carefully and construct adjusted leverage ratios that incorporate off-balance-sheet obligations for a complete picture of financial risk.