Introduction

Why This Guide?

Connecting all the pieces into one coherent workflow

Across Sessions 4 through 8, you learned how to build each component of a three-statement financial model. This bonus guide ties everything together into one visual reference — the master flow, driver-based methodology, industry-specific IS drivers, and a build checklist.

💡How to Use This Guide

1. Start with the Master Flow Chart for the big picture.
2. Read the Driver-Based Methodology section to understand how professional models are built.
3. Study the IS Drivers by Industry for sector-specific forecasting logic.
4. Review the Linkage Diagrams to see how statements connect.
5. Print the Checklist and tick off steps as you build.

Foundation / Historical
Income Statement
Schedules (WC, CapEx, Debt)
Balance Sheet
Cash Flow Statement
Checks & Balancing
Master Flow Chart

The Complete Three-Statement Build Process

Follow the flow from top to bottom — each node represents a model component

1 PHASE 1 — Foundation & Historical Data
flowchart LR A1["📋 Chart of Accounts
Set up IS / BS / CF line items"] --> A2["📥 Input Historical Data
3–5 years of actuals"] A2 --> A3["📊 Common-Size & Ratios
% of revenue, growth rates"] style A1 fill:#F3F4F6,stroke:#6B7280,stroke-width:2px,color:#374151 style A2 fill:#F3F4F6,stroke:#6B7280,stroke-width:2px,color:#374151 style A3 fill:#F3F4F6,stroke:#6B7280,stroke-width:2px,color:#374151
Historical data feeds forecasts →
2 PHASE 2 — Income Statement Forecast
flowchart TD B1["Revenue Forecast
Growth rate × Prior OR Drivers × Price"] --> B2["COGS / Operating Expenses
Revenue × margin %"] B2 --> B3["EBITDA
Rev − COGS − OpEx"] B3 --> B4["EBIT
EBITDA − D&A"] B4 --> B5["EBT
EBIT − Interest"] B5 --> B6["NET INCOME
EBT × (1 − Tax Rate)"] style B1 fill:#DBEAFE,stroke:#2563EB,stroke-width:2px style B2 fill:#DBEAFE,stroke:#2563EB,stroke-width:2px style B3 fill:#DBEAFE,stroke:#2563EB,stroke-width:2px style B4 fill:#DBEAFE,stroke:#2563EB,stroke-width:2px style B5 fill:#DBEAFE,stroke:#2563EB,stroke-width:2px style B6 fill:#2563EB,stroke:#1D4ED8,stroke-width:2px,color:#fff
Revenue & margins drive schedules →
3a PHASE 3a — WC & CapEx Schedules
flowchart TD C1["WC Ratios
DSO, DIO, DPO"] --> C2["Forecast AR, Inv, AP
Ratio × Revenue or COGS"] C3["CapEx Forecast
% of Revenue"] --> C4["PP&E Roll-Forward
Beg + CapEx − Dep = End"] C4 -.->|"D&A feeds back to IS"| C5["IS: EBITDA − D&A = EBIT"] style C1 fill:#EDE9FE,stroke:#7C3AED,stroke-width:2px style C2 fill:#EDE9FE,stroke:#7C3AED,stroke-width:2px style C3 fill:#EDE9FE,stroke:#7C3AED,stroke-width:2px style C4 fill:#7C3AED,stroke:#6D28D9,stroke-width:2px,color:#fff style C5 fill:#DBEAFE,stroke:#2563EB,stroke-width:2px,stroke-dasharray:5
3b PHASE 3b — Debt Schedule
flowchart TD D1["Debt Tranches
Opening + Draws − Repay"] --> D2["Interest Calculation
Avg balance × Rate"] D2 -.->|"Interest feeds back to IS"| D3["IS: EBIT − Interest = EBT"] style D1 fill:#EDE9FE,stroke:#7C3AED,stroke-width:2px style D2 fill:#7C3AED,stroke:#6D28D9,stroke-width:2px,color:#fff style D3 fill:#DBEAFE,stroke:#2563EB,stroke-width:2px,stroke-dasharray:5
Schedule outputs → Balance Sheet →
4 PHASE 4 — Balance Sheet
flowchart TD E1["Current Assets
Cash, AR, Inventory"] --> E5["TOTAL ASSETS"] E2["Non-Current Assets
PP&E, Intangibles"] --> E5 E3["Current Liabilities
AP, Short-term debt"] --> E6["TOTAL LIAB + EQUITY"] E4["Equity & Retained Earnings
Beg RE + NI − Div"] --> E6 style E1 fill:#D1FAE5,stroke:#059669,stroke-width:2px style E2 fill:#D1FAE5,stroke:#059669,stroke-width:2px style E3 fill:#D1FAE5,stroke:#059669,stroke-width:2px style E4 fill:#D1FAE5,stroke:#059669,stroke-width:2px style E5 fill:#059669,stroke:#047857,stroke-width:2px,color:#fff style E6 fill:#059669,stroke:#047857,stroke-width:2px,color:#fff

Every BS line item is linked from a schedule or another statement — Assets MUST equal Liabilities + Equity

BS changes → Cash Flow Statement →
5 PHASE 5 — Cash Flow Statement
flowchart TD F1["CFO
NI + D&A + WC Changes"] --> F4["Net Change in Cash"] F2["CFI
− CapEx + Asset sales"] --> F4 F3["CFF
Debt draws/repays + Dividends"] --> F4 F4 --> F5["Ending Cash
Beg Cash + Net Change"] F5 -.->|"End Cash → BS Cash"| F6["BS: Cash & Equivalents"] style F1 fill:#FFEDD5,stroke:#EA580C,stroke-width:2px style F2 fill:#FFEDD5,stroke:#EA580C,stroke-width:2px style F3 fill:#FFEDD5,stroke:#EA580C,stroke-width:2px style F4 fill:#EA580C,stroke:#C2410C,stroke-width:2px,color:#fff style F5 fill:#EA580C,stroke:#C2410C,stroke-width:2px,color:#fff style F6 fill:#D1FAE5,stroke:#059669,stroke-width:2px,stroke-dasharray:5
Verify everything balances →
6 PHASE 6 — Checks & Balancing
flowchart LR G1["✅ BS Balance Check
Assets = Liab + Equity"] --> G2["✅ Cash Tie-Out
CF End Cash = BS Cash"] G2 --> G3["✅ Revolver / Circularity
Handle shortfalls"] style G1 fill:#FEE2E2,stroke:#DC2626,stroke-width:2px style G2 fill:#FEE2E2,stroke:#DC2626,stroke-width:2px style G3 fill:#DC2626,stroke:#B91C1C,stroke-width:2px,color:#fff
Methodology

Driver-Based Financial Modeling

How professional analysts build defensible, auditable models

🧠 What Is Driver-Based Modeling?

Driver-based modeling is the practice of forecasting financial statements by first identifying the operational metrics (drivers) that cause each line item to change, then projecting those drivers independently, and finally deriving the financial outputs from the drivers.

This is the opposite of the naive approach where you simply apply a growth rate to every line item. Driver-based models are more transparent, easier to defend to stakeholders, and far more useful for scenario analysis.

📐 The Driver Hierarchy

🌍 Macro Drivers
GDP, Inflation, Rates
→
🏭 Industry Drivers
Market size, Pricing, Capacity
→
🏢 Company Drivers
Headcount, Utilization, Mix
→
💰 Financial Outputs
Revenue, EBITDA, NI

⚖️ Growth Rate vs. Driver-Based — Side by Side

Aspect Growth Rate Approach Driver-Based Approach
Revenue Forecast Revenuet = Revenuet-1 × (1 + g%) Revenue = Volume × Price per unit (or Headcount × Rate, etc.)
COGS Forecast COGS = Revenue × historical COGS% COGS = Raw Material + Labor + Overhead (each driven by volume/mix)
Transparency Low — hard to explain "why 10% growth" High — can show volume and price separately
Scenario Analysis Weak — just change the growth rate Powerful — change volume, price, mix independently
Industry Sensitivity Ignores industry dynamics Captures sector-specific cycles
When to Use Quick back-of-envelope; stable, mature companies Professional models; equity research; M&A; any model that will be reviewed

🌳 Generic IS Driver Tree

flowchart TD REV["REVENUE
Volume × Price OR Headcount × Rate"] REV --> COGS["COGS
Raw Materials + Direct Labor + Manufacturing OH"] REV --> GROSS["GROSS PROFIT
Revenue − COGS"] GROSS --> SGA["SG&A
Sales team + Marketing + Admin"] GROSS --> RD["R&D
Scientists + Labs + Trials"] GROSS --> OTHER["Other OpEx
Rent, Utilities, IT"] SGA --> EBITDA["EBITDA
Gross Profit − All OpEx"] RD --> EBITDA OTHER --> EBITDA EBITDA --> DA["− D&A
From PP&E Schedule"] DA --> EBIT["EBIT"] EBIT --> INT["− Interest
From Debt Schedule"] INT --> EBT["EBT"] EBT --> TAX["− Tax
EBT × Effective Tax Rate"] TAX --> NI["NET INCOME"] style REV fill:#DBEAFE,stroke:#2563EB,stroke-width:2px style COGS fill:#FEE2E2,stroke:#DC2626,stroke-width:2px style GROSS fill:#D1FAE5,stroke:#059669,stroke-width:2px style EBITDA fill:#D1FAE5,stroke:#059669,stroke-width:2px style NI fill:#059669,stroke:#047857,stroke-width:2px,color:#fff
IS Drivers by Industry

Income Statement Drivers — Industry Deep Dive

Click each industry tab to explore its specific IS forecasting drivers

IT Services
Manufacturing
Retail
Pharma
Banking

💻 IT Services — Key Business Model

IT services companies (TCS, Infosys, Wipro, HCL) sell people's time. Revenue is driven by headcount × billing rate × utilization. The primary cost is employee compensation. Margins depend on the mix of onsite vs. offshore, the pyramidal structure (junior to senior ratio), and pricing model (T&M vs. fixed-price).

Revenue Drivers
Headcount Total employees — the #1 revenue driver. Track additions by quarter. Formula: Revenue = Headcount × Utilization × Billing Rate × 12 months
Utilization % Billable hours / Total available hours. Typical range: 75–85%. Higher utilization → higher revenue but risk of attrition and quality issues.
Billing Rate ($/hr) Average hourly rate charged to clients. Onsite: $60–100/hr; Offshore: $20–40/hr. Rate increases with digital/cloud/AI skills.
Onsite/Offshore Mix % of work done at client site vs. delivery center. 20:80 mix is typical. Shifting more offshore increases margins but may face client pushback.
Pyramid Ratio Jr : Mid : Senior ratio. A 60:25:15 pyramid keeps costs low. Flatter pyramids (more seniors) increase cost but enable higher-value projects.
COGS (Employee Costs)
Salary Cost Gross salary + benefits + training. Typically 55–65% of revenue. Offshore salary: ₹5–8 LPA junior; ₹15–25 LPA mid; ₹30–60 LPA senior.
Attrition Rate % of employees leaving per year. Higher attrition → higher hiring + training costs. Typical: 15–25%. Models should include replacement hiring cost.
Wage Inflation Annual salary increases. India: 8–12% hike; US onsite: 3–5%. This is a key margin pressure driver.
Operating Expenses
SG&A (15–20% of Rev) Sales + marketing + admin staff + travel + office. Driven by headcount in support functions, number of delivery centers, and client acquisition cost.
R&D / Innovation (2–4%) Investment in new capabilities (AI, cloud, blockchain). Often treated as a % of revenue with step-ups for digital transformation.
EBITDA Margin Drivers
Target: 20–26% Key levers: (1) Increase offshore mix, (2) Improve utilization above 80%, (3) Shift to higher-margin digital/cloud deals, (4) Manage pyramid structure, (5) Control wage inflation through fresher hiring.

🏭 Manufacturing — Key Business Model

Manufacturing companies convert raw materials into finished goods. Revenue is driven by production capacity × utilization × average selling price. Margins depend heavily on commodity prices, energy costs, and operating leverage (spreading fixed costs over higher volumes).

Revenue Drivers
Installed Capacity Maximum production volume (tons, units, liters). Increased through capex (greenfield/brownfield expansion). Track capacity additions timeline.
Utilization Rate Actual output / Maximum capacity. Typical: 70–85%. Below 65% signals weak demand; above 90% may need expansion.
Average Selling Price (ASP) Price per unit of output. Driven by commodity cycles, product mix (value-added vs. commodity), and competitive pricing.
Product Mix High-value vs. standard products. Shift to specialty/higher-grade increases ASP. Track mix as % of total volume.
COGS Drivers
Raw Material Cost Usually 50–65% of COGS. Linked to commodity indices (steel, copper, crude, cotton). Use forward curves or management guidance. Pass-through lag matters.
Energy / Fuel Cost Power, natural gas, diesel. 8–15% of COGS. Linked to crude oil / coal prices. Energy efficiency investments reduce this over time.
Direct Labor Factory workers + supervisors. 10–15% of COGS. Driven by wage inflation and automation level.
Conversion Cost Labor + Energy + Maintenance + Factory OH. Often forecast as cost per unit of output, improving slightly with scale.
Operating Expenses
SG&A (8–12% of Rev) Distribution network + sales team + admin. Distribution cost driven by logistics infrastructure, fuel prices, and geography coverage.
R&D (1–3% of Rev) New product development + process improvement. Higher for specialty manufacturers; lower for commodity producers.
EBITDA Margin Drivers
Target: 12–20% Key levers: (1) Operating leverage (higher volume spreads fixed costs), (2) Raw material hedging, (3) Product mix upgrade, (4) Energy efficiency, (5) Capacity utilization improvement.

🛒 Retail — Key Business Model

Retailers buy products and sell them to consumers through physical stores and online channels. Revenue is driven by number of stores × revenue per store + online GMV × take rate. The key metrics are same-store sales growth (SSG), inventory turns, and gross margin per square foot.

Revenue Drivers
Store Count Total operational stores at period end. New store openings = planned capex pipeline. Track: new stores added − closures = net additions.
Same-Store Sales Growth (SSG) Revenue growth from stores open >12 months. The most watched retail metric. Positive SSG = healthy demand. Driven by footfall × conversion × basket size.
Revenue per Sq Ft Total revenue / Total selling area. Measures store productivity. Fashion: ₹8,000–15,000/sqft; Grocery: ₹12,000–20,000/sqft.
Online / Omnichannel GMV (Gross Merchandise Value) × Take Rate. Online growing at 25-40% for Indian retailers. Track contribution mix: offline vs. online.
Footfall & Conversion Shoppers entering store × % who buy. Conversion rate: 20–35% typical. Basket size (items × price per item) drives revenue per transaction.
COGS (Purchase Cost)
Cost of Goods Purchased Invoiced cost from suppliers. Driven by procurement negotiation power, private label penetration (higher margin), and input commodity prices.
Shrinkage & Wastage Theft + damage + expiry. 1–3% for fashion; 3–8% for grocery (perishables). Key cost to control in grocery retail.
Private Label Mix Own-brand products as % of sales. Private labels have 15–25% higher gross margin vs. branded products. Target: increase mix over time.
Operating Expenses
Rent (18–25% of Rev) Store rent + mall charges. Usually fixed per sq ft with annual escalation (5–8%). Revenue-share models exist in some mall leases.
Staff Costs (10–14%) Store staff + warehouse + HQ. Driven by minimum wage trends, store count, and automation level.
Marketing (3–6%) Advertising + promotions + loyalty programs. Higher during new store launches and festive seasons.
Logistics (4–8%) Warehousing + last-mile delivery. Online orders increase this cost significantly. Track cost per delivery.
EBITDA Margin Drivers
Target: 8–14% Key levers: (1) Same-store growth (operating leverage on rent), (2) Private label expansion, (3) Supply chain optimization, (4) Inventory management (reduce markdowns), (5) Scale economies in logistics.

💊 Pharmaceutical — Key Business Model

Pharma companies discover, develop, manufacture, and sell drugs. Revenue is segmented by geography (US, India, EM) × product type (generics, specialty, OTC, API). Each segment has different drivers. R&D pipeline is the long-term value creator. Regulatory approvals are binary catalysts.

Revenue Drivers (by Segment)
US Generics Volume × Price per unit. Price erosion: 5–15%/year post-launch. Key: number of ANDA approvals, first-to-file opportunities (180-day exclusivity = premium pricing), and market share ramp.
India Branded Primary sales to distributors × growth. Driven by therapy area penetration, doctor prescription habits, medical rep (MR) coverage, and brand strength. Growth: 8–14% typical.
Emerging Markets Market entry + tender-based pricing. Fragmented; driven by registration timelines, distributor network, and government procurement.
API / CDMO Capacity × Utilization × Contract pricing. Backlog-based visibility. Driven by customer contracts and capacity additions.
Product Pipeline ANDA filings × Approval probability × Launch timing × Peak penetration. Use probability-weighted revenue for pipeline products.
COGS Drivers
API / Raw Material Active Pharmaceutical Ingredient cost. 30–45% of COGS. Linked to chemical commodity prices and China import dependency. Backward integration reduces this.
Formulation Cost Excipients + packaging + manufacturing. Driven by plant utilization, batch efficiency, and dosage form complexity.
Quality / Compliance GMP compliance costs, FDA inspection remediation. Lumpy — a warning letter can disrupt revenue and increase quality spending significantly.
Operating Expenses
R&D (6–12% of Rev) ANDA filings, clinical trials, biosimilar development, NCE research. Higher R&D = stronger pipeline but lower current margins. Track ANDA filing run-rate.
Sales Force / MR Coverage (12–18%) Medical representatives × cost per MR × productivity. India branded requires large field force. US requires key account management team.
Regulatory & Legal (2–4%) Patent litigation, FDA compliance, drug safety reporting. Higher for US-facing companies. Can spike during patent challenges.
EBITDA Margin Drivers
Target: 22–32% Key levers: (1) Product mix shift to specialty/complex generics, (2) API backward integration, (3) Plant utilization improvement, (4) Geographic mix (US = higher margin), (5) R&D productivity (more approvals per $ spent).

🏦 Banking — Key Business Model

Banks take deposits and lend them out at a spread. The IS is fundamentally different — there is no "Revenue" or "COGS." Instead, the key line is Net Interest Income = Interest Earned − Interest Paid, plus fee income. The "COGS equivalent" is the cost of funds (deposit rates). Credit risk (provisions) is the biggest variable expense.

Revenue Drivers (Interest + Fee Income)
Loan Book (Advances) Total outstanding loans. Segmented by: retail, corporate, SME, agriculture. Growth: 12–18% typical for Indian banks. Track by segment.
Yield on Advances Interest earned / Average loan book. Typical: 8.5–11%. Driven by loan mix (higher for unsecured/personal), competitive pricing, and RBI rate cycle.
Net Interest Margin (NIM) (Interest Earned − Interest Paid) / Earning Assets. The #1 bank profitability metric. Typical: 3–4.5% for Indian banks. Driven by CASA mix and yield on advances.
CASA Ratio Current Account + Savings Account / Total Deposits. CASA deposits pay near-zero interest → lower cost of funds → higher NIM. Target: >40%.
Fee Income (Non-Interest) Loan processing fees, account charges, card fees, forex, wealth management commissions. Typically 15–25% of total income. Stable, high-margin revenue.
Cost of Funds & Provisions
Cost of Deposits Interest paid on deposits / Average deposits. Savings rate: 2.7–3.5%; Term deposit: 5.5–7.5%. CASA-heavy banks have lower cost of funds.
Cost of Borrowings RBI repo rate + spread, NCDs, bonds. Used when deposit growth < loan growth. Higher cost than CASA.
Credit Cost / Provisions Loan loss provisions / Average loans. The "COGS of banking." Typical: 0.5–2%. Spikes during NPAs. Key driver: GNPA ratio, slippage rate, write-offs. This is the most important variable in a bank model.
Slippage Ratio New NPAs during period / Opening loan book. The fresh stress indicator. Lower = better asset quality. Model this to forecast provisions.
Operating Expenses
Employee Cost (35–45% of OpEx) Branch staff, relationship managers, IT team, back-office. Driven by headcount growth, wage inflation, and digitization (reduces need for branch staff).
Branch / Network (25–35%) Rent, utilities, security, ATM operations. Track: branches added, cost per branch. Digital banks have lower branch costs.
Technology (8–12%) Core banking systems, mobile app, cybersecurity, data centers. Growing as % of OpEx with digital transformation. Capitalized software → amortized over time.
Profitability Metrics (Bank-Specific)
Cost-to-Income Ratio Operating Expenses / (Net Interest Income + Fee Income). The bank equivalent of EBITDA margin. Lower = better. Target: 40–50% for efficient Indian banks.
Return on Assets (ROA) Net Income / Total Assets. Target: 1.0–1.5% for well-run banks. Below 0.5% signals stress.
Capital Adequacy (CRAR) Regulatory capital / Risk-weighted assets. RBI minimum: 9% (plus capital conservation buffer). Constrained growth if CRAR is low.

📊 Cross-Industry IS Driver Summary

IS Line IT Services Manufacturing Retail Pharma Banking
Revenue Driver Headcount × Billing Rate Capacity × Utilization × ASP Stores × Rev/Store + Online Segment mix × Volume × Price Loans × NIM + Fee Income
Revenue Growth 8–15% 5–10% 6–12% 8–14% 10–18% (loan growth)
COGS / Cost of Funds 40–50% (employee cost) 55–65% (raw material + conversion) 65–75% (purchase + shrinkage) 35–45% (API + formulation) 3–5% (cost of deposits)
Key OpEx SG&A + R&D (15–22%) SG&A + R&D (10–15%) Rent + Staff + Marketing (25–35%) R&D + Sales force (20–30%) Staff + Branch + Tech (45–55%)
EBITDA Margin 20–28% 12–20% 8–14% 22–32% N/A (use Cost/Income)
Unique Variable Attrition, Utilization Commodity prices Same-store growth, Inventory Pipeline, FDA approvals Credit cost (provisions)
Statement Linkages

How the Three Statements Connect

Every arrow represents a formula linking one statement to another

📊 Income Statement — Internal Flow
flowchart TD IS1["Revenue"] --> IS2["− COGS"] IS2 --> IS3["= Gross Profit"] IS3 --> IS4["− OpEx (SG&A, R&D)"] IS4 --> IS5["= EBITDA"] IS5 --> IS6["− D&A ← from PP&E Schedule"] IS6 --> IS7["= EBIT"] IS7 --> IS8["− Interest ← from Debt Schedule"] IS8 --> IS9["= EBT"] IS9 --> IS10["− Tax"] IS10 --> IS11["= NET INCOME"] style IS1 fill:#DBEAFE,stroke:#2563EB,stroke-width:2px style IS3 fill:#D1FAE5,stroke:#059669,stroke-width:2px style IS5 fill:#D1FAE5,stroke:#059669,stroke-width:2px style IS11 fill:#2563EB,stroke:#1D4ED8,stroke-width:2px,color:#fff
📤Outputs that feed other statements:

Net Income → Cash Flow Statement (CFO starting line) & Balance Sheet (Retained Earnings)
D&A → Cash Flow Statement (non-cash add-back in CFO)
Interest → Cash Flow Statement (often in CFF)

📗 Balance Sheet — Structure & Incoming Links
flowchart TD subgraph ASSETS["ASSETS"] direction TB CA["Current Assets
Cash ← from CF
AR ← from WC Schedule
Inventory ← from WC Schedule"] NCA["Non-Current Assets
Net PP&E ← from CapEx Schedule
Intangibles, Other Assets"] end subgraph LIAEQ["LIABILITIES + EQUITY"] direction TB CL["Current Liabilities
AP ← from WC Schedule
Short-term Debt ← from Debt Schedule"] LTL["Long-term Debt ← from Debt Schedule"] EQ["Equity
Share Capital (assumption)
Retained Earnings ← Beg RE + NI − Div"] end style ASSETS fill:#D1FAE5,stroke:#059669,stroke-width:2px style LIAEQ fill:#D1FAE5,stroke:#059669,stroke-width:2px style CA fill:#ECFDF5,stroke:#059669,stroke-width:1px style NCA fill:#ECFDF5,stroke:#059669,stroke-width:1px style CL fill:#ECFDF5,stroke:#059669,stroke-width:1px style LTL fill:#ECFDF5,stroke:#059669,stroke-width:1px style EQ fill:#ECFDF5,stroke:#059669,stroke-width:1px

Golden Rule: Total Assets = Total Liabilities + Equity. Every item is linked — no hard-coded inputs on the BS.

📙 Cash Flow Statement — Three Sections
flowchart TD NI["Net Income ← from IS"] --> CFO["CFO
NI + D&A + ΔWC"] DA["D&A ← from PP&E Schedule"] --> CFO WC["ΔWC ← from BS Changes"] --> CFO CFO --> NET["Net Change in Cash"] CFI["CFI
−CapEx + Asset Sales"] --> NET CFF["CFF
+Debt Draws − Repay − Div"] --> NET NET --> END["Ending Cash
Beg Cash + Net Change"] END -.->|"End Cash → BS Cash"| BSCASH["BS: Cash & Equivalents"] style NI fill:#DBEAFE,stroke:#2563EB,stroke-width:2px style DA fill:#DBEAFE,stroke:#2563EB,stroke-width:2px style WC fill:#D1FAE5,stroke:#059669,stroke-width:2px style CFO fill:#FFEDD5,stroke:#EA580C,stroke-width:2px style CFI fill:#FFEDD5,stroke:#EA580C,stroke-width:2px style CFF fill:#FFEDD5,stroke:#EA580C,stroke-width:2px style END fill:#EA580C,stroke:#C2410C,stroke-width:2px,color:#fff style BSCASH fill:#D1FAE5,stroke:#059669,stroke-width:2px,stroke-dasharray:5

🔗 Cross-Statement Links — At a Glance

The 4 critical connections that tie all three statements together:

1. NI → BS + CF

Net Income flows to Retained Earnings (BS) and starts CFO (CF)

2. End Cash → BS

CF ending cash becomes BS Cash & Equivalents

3. BS Δ → CF

Changes in AR, Inv, AP, PP&E, Debt flow into CFO, CFI, CFF

4. Schedules → IS + BS

D&A and Interest feed IS; ending PP&E, Debt feed BS

📋 Complete Linkage Reference

Income Statement → Balance Sheet

Net Income→Retained Earnings
Revenue / COGS→AR / Inventory / AP
D&A→Accum. Depreciation

Income Statement → Cash Flow

Net Income→CFO (starting line)
D&A→CFO (add-back)
Interest→CFF (sometimes CFO)

Balance Sheet → Cash Flow

Δ AR, Δ Inventory→CFO (outflow if ↑)
Δ AP, Δ Accrued Exp→CFO (inflow if ↑)
Δ Debt→CFF (draws/repayments)
Δ PP&E→CFI (CapEx / disposals)

Cash Flow → Balance Sheet

Net Change in Cash→BS Cash & Equivalents
Dividends (in CFF)→Retained Earnings

Schedules → Income Statement

Depreciation (PP&E sched)→IS: D&A line
Interest (Debt sched)→IS: Interest Expense

Schedules → Balance Sheet

Ending PP&E→BS: Net PP&E
Ending Debt→BS: ST / LT Debt
AR, Inv, AP→BS: Current Assets/Liab
Checklist

Model Building Checklist

Print this page and check off each step as you build your model

📦 Phase 1: Foundation
📊 Phase 2: Income Statement (Driver-Based)
🔧 Phase 3a: WC & CapEx Schedules
🏦 Phase 3b: Debt Schedule
📗 Phase 4: Balance Sheet
📙 Phase 5: Cash Flow Statement
✅ Phase 6: Final Checks
Summary

Key Takeaways

  • Build in order: Foundation → IS → Schedules → BS → CF → Checks. Never skip ahead.
  • Driver-based is the professional standard: Identify operational KPIs first, then derive financial outputs — don't just apply growth rates.
  • Industry matters: IT services drivers (headcount, utilization) are completely different from retail drivers (stores, SSG) or banking drivers (NIM, credit cost).
  • Balance Sheet is a collection of links — every line item comes from a schedule or another statement. It MUST balance.
  • Cash Flow Statement is derived — Net Income + D/A + WC Changes − CapEx + Debt changes = Change in Cash.
  • Circularity (Interest → NI → Cash → Debt → Interest) is the trickiest part. Use iterative calculation or a fixed toggle for debugging.
📚Related Sessions

This guide consolidates content from:
Session 3 — Financial Statement Mechanics  |  Session 4 — Building a Historical Model  |  Session 5 — Revenue & Expense Forecasting
Session 6 — Working Capital & CapEx  |  Session 7 — Debt & Interest Schedules  |  Session 8 — Three-Statement Integration