A comprehensive guide to building linked Income Statement, Balance Sheet, and Cash Flow projections.
A 3-statement financial model links the Income Statement, Balance Sheet, and Cash Flow Statement into a single, cohesive model. It's the foundation of financial analysis, valuation, and investment decision-making.
Start with 3-5 years of audited financial data. You need: Revenue, Cost of Goods Sold, Operating Expenses, Interest, Taxes (Income Statement); Total Assets, Liabilities, Equity (Balance Sheet); Operating, Investing, and Financing cash flows (Cash Flow Statement).
Pro tip: Use FinModel to extract this data automatically from PDF annual reports. It saves hours of manual entry.
Project revenue using growth assumptions. Then calculate: COGS (as % of Revenue), Gross Profit, Operating Expenses (fixed and variable), EBITDA, Depreciation & Amortization, EBIT, Interest Expense, EBT, Tax, and Net Income.
Key items to project: Accounts Receivable (using Days Sales Outstanding), Inventory (using Days Inventory Outstanding), Accounts Payable (using Days Payable Outstanding), Fixed Assets (using CapEx assumptions), Debt (based on borrowing schedule), and Equity (retained earnings from IS).
The Cash Flow Statement bridges the IS and BS: Start with Net Income, add back non-cash items (D&A), adjust for working capital changes, subtract CapEx, account for debt issuances/repayments, and arrive at ending cash balance.
The magic of a 3-statement model is in the linking: Cash from CF → BS cash line item. Net Income from IS → Retained Earnings on BS. D&A from IS → CF adjustment. CapEx from CF → Fixed Assets on BS.
With historical data linked, extend the model 3-10 years forward using growth assumptions, margin targets, and industry benchmarks.
Building this manually takes 5-8 hours. FinModel generates a fully linked 3-statement model from your PDF in minutes — complete with forecasting and professional formatting. Try it free.
Upload your first annual report and generate a 3-statement model in minutes.
Start Free Trial