3-Statement Model: Build a Financial Model Step-by-Step
Learn how to build a professional 3-statement financial model in Excel and Google Sheets. Complete guide with formulas, linking logic, and AI automation to speed up the process.
What is a 3-Statement Model?
A 3-statement model is a financial model that integrates and links three core financial statements: the Income Statement (P&L), Balance Sheet, and Cash Flow Statement. These three statements are interconnected, with changes in one statement automatically flowing through to the others, creating a dynamic financial model that shows how a company's operations, financing, and investing activities affect its financial position.
Income Statement
Shows revenue, expenses, and net income over a period. The bottom line (net income) flows to the balance sheet and cash flow statement.
Balance Sheet
Shows assets, liabilities, and equity at a point in time. Must balance: Assets = Liabilities + Equity. Links to income statement and cash flow.
Cash Flow Statement
Shows cash inflows and outflows from operations, investing, and financing. The ending cash balance links back to the balance sheet.
Why Use SheetXAI?
- Generate complex linking formulas automatically with natural language
- Build all three statements and link them together in minutes
- Automate data flow between statements with AI-powered formula generation
- Create sensitivity analysis and scenario planning automatically
How to Build a 3-Statement Model: Step-by-Step Guide
Follow these steps to build a professional 3-statement model in Excel or Google Sheets.
Build the Income Statement
Start with revenue projections, then build down to operating expenses, interest, taxes, and net income. Include assumptions for growth rates, margins, and operating leverage.
Key Formulas Needed:
- Revenue growth formulas
- COGS and operating expense calculations
- EBITDA, EBIT, and net income formulas
- Tax calculations
💡 SheetXAI Tip:
Use SheetXAI to generate these formulas automatically. Just describe what you need: "Link net income from income statement to retained earnings on balance sheet" or "Calculate operating cash flow by adding depreciation to net income and subtracting working capital changes."
Build the Balance Sheet
Create assets (current and non-current), liabilities (current and long-term), and equity sections. Link retained earnings from the income statement and cash from the cash flow statement.
Key Formulas Needed:
- Working capital formulas (AR, AP, Inventory)
- PP&E and depreciation schedules
- Debt and equity calculations
- Retained earnings: Previous + Net Income - Dividends
💡 SheetXAI Tip:
Use SheetXAI to generate these formulas automatically. Just describe what you need: "Link net income from income statement to retained earnings on balance sheet" or "Calculate operating cash flow by adding depreciation to net income and subtracting working capital changes."
Build the Cash Flow Statement
Start with net income from the income statement, then add back non-cash items (depreciation), adjust for changes in working capital, and include investing and financing activities.
Key Formulas Needed:
- Operating cash flow: Net Income + Depreciation - Changes in WC
- Investing cash flow: CapEx calculations
- Financing cash flow: Debt issuance/repayment, dividends
- Ending cash = Beginning cash + Net cash flow
💡 SheetXAI Tip:
Use SheetXAI to generate these formulas automatically. Just describe what you need: "Link net income from income statement to retained earnings on balance sheet" or "Calculate operating cash flow by adding depreciation to net income and subtracting working capital changes."
Link the Statements Together
Create the circular references and links between statements. Net income flows to retained earnings and cash flow. Ending cash flows to balance sheet. Changes in working capital affect both balance sheet and cash flow.
Key Formulas Needed:
- Link net income to retained earnings
- Link net income to cash flow statement
- Link ending cash to balance sheet cash
- Link working capital changes to both statements
- Handle circular references properly
💡 SheetXAI Tip:
Use SheetXAI to generate these formulas automatically. Just describe what you need: "Link net income from income statement to retained earnings on balance sheet" or "Calculate operating cash flow by adding depreciation to net income and subtracting working capital changes."
Balance the Balance Sheet
Ensure Assets = Liabilities + Equity. Use a balancing mechanism (often a plug account like cash or revolver) to make the balance sheet balance automatically.
Key Formulas Needed:
- Assets = Liabilities + Equity check
- Plug account formulas (cash or revolver)
- IF statements for balancing logic
💡 SheetXAI Tip:
Use SheetXAI to generate these formulas automatically. Just describe what you need: "Link net income from income statement to retained earnings on balance sheet" or "Calculate operating cash flow by adding depreciation to net income and subtracting working capital changes."
Add Supporting Schedules
Create supporting schedules for depreciation, working capital, debt, and equity. These feed into the main statements and make the model more detailed and accurate.
Key Formulas Needed:
- Depreciation schedules
- Working capital schedules
- Debt schedules with interest
- Equity schedules
💡 SheetXAI Tip:
Use SheetXAI to generate these formulas automatically. Just describe what you need: "Link net income from income statement to retained earnings on balance sheet" or "Calculate operating cash flow by adding depreciation to net income and subtracting working capital changes."
Build Sensitivity Analysis
Create data tables and scenario analysis showing how the model changes with different assumptions (revenue growth, margins, interest rates, etc.).
Key Formulas Needed:
- Data tables
- Scenario analysis
- Goal seek functionality
- Sensitivity tables
💡 SheetXAI Tip:
Use SheetXAI to generate these formulas automatically. Just describe what you need: "Link net income from income statement to retained earnings on balance sheet" or "Calculate operating cash flow by adding depreciation to net income and subtracting working capital changes."
Common 3-Statement Model Mistakes to Avoid
Learn from common errors to build more accurate and reliable 3-statement models.
Balance Sheet Doesn't Balance
The most common error - Assets must equal Liabilities + Equity. This usually happens when links between statements are incorrect or missing.
Solution: SheetXAI can help identify and fix balancing issues by generating proper linking formulas.
Incorrect Cash Flow Linking
Not properly linking cash flow statement to balance sheet. Ending cash must match balance sheet cash, and changes must reconcile.
Solution: SheetXAI can generate accurate cash flow linking formulas with proper references.
Missing Working Capital Changes
Forgetting to account for changes in working capital (AR, AP, Inventory) which affects both balance sheet and cash flow.
Solution: SheetXAI can help build comprehensive working capital schedules and link them correctly.
Circular Reference Errors
Creating circular references incorrectly, especially with interest expense and cash balances. Need proper iterative calculation setup.
Solution: SheetXAI can help set up circular references correctly or break them with proper logic.
Incorrect Retained Earnings
Not properly calculating retained earnings as previous retained earnings + net income - dividends.
Solution: SheetXAI can generate the correct retained earnings formula linking income statement to balance sheet.
Depreciation Not Flowing Through
Depreciation affects income statement (expense), balance sheet (reduces PP&E), and cash flow (add-back). Must flow through all three.
Solution: SheetXAI can help create depreciation schedules that properly link to all three statements.
Automate 3-Statement Model Creation with SheetXAI
SheetXAI can automate many of the complex tasks involved in building a 3-statement model, saving you hours of work.
Generate Linking Formulas
Create complex formulas that link the three statements together automatically with natural language commands.
Build Supporting Schedules
Automatically generate depreciation, working capital, and debt schedules with proper formulas.
Balance the Model
Use AI to identify balancing issues and generate formulas to ensure Assets = Liabilities + Equity.
Everything you need to
know about SheetXAI
Think in operations, not credits.
Everything on your plan is priced in credits, but each plan tells you what that maps to in real work:
- - Light operation — ~10 credits. Good for most things you do. Uses a solid mid-tier AI that can handle sorting, deduping, summarizing, basic content, and simple charts. Chatbot actions like "Sort by revenue", "Find duplicates", or building a simple graph all fall here.
- - Heavy operation — ~50 credits. Good for the tough stuff — building forward-looking financial models, running deep multi-step analysis, or anything where you'd want a senior AI on the job. Same kind of action as light, but switched to the strongest, most capable AI available.
- - Content row — ~2 credits per row. Generating content row by row down a column. Good for product descriptions, summaries, outreach copy, and anything where you're generating content at scale.
Most operations are light — you don't need the heavy AI for everyday work. Reach for heavy ops only when the task is genuinely complex. One operation = one charge, even if it touches a million rows. Analysis is flat-fee, not per-row.
Stop memorizing formulas.
Tell your spreadsheet what to do.
Join 4,000+ professionals saving hours every week with SheetXAI.