LogoAI Finance Tools

Three-Statement Model

Integrated financial model linking the income statement, balance sheet, and cash flow statement.

The three-statement model is the foundational financial model type in corporate finance, integrating the income statement, balance sheet, and cash flow statement into a single cohesive model where changes in one statement automatically flow through to the others. This integration is what makes the model a complete, consistent representation of a company's financial position—not three separate spreadsheets, but one interconnected model.

The income statement projects revenues, costs, and expenses to calculate EBIT, EBT, net income, and earnings per share. Key linkages: net income flows into the retained earnings component of stockholders' equity on the balance sheet; tax provision drives deferred tax assets/liabilities.

The balance sheet projects assets (current: cash, receivables, inventory; non-current: PP&E, intangibles) and liabilities plus equity. Key linkages: changes in working capital accounts (AR, inventory, AP) are the same movements modeled in the operating cash flow section; depreciation reduces PP&E; capex increases PP&E; new debt increases debt liabilities; dividends reduce retained earnings.

The cash flow statement reconciles net income to actual cash change: starting with net income, adding back non-cash charges (depreciation, amortization, stock-based compensation), adjusting for working capital changes, then incorporating investing activities (CapEx, acquisitions) and financing activities (debt issuance/repayment, equity raises, dividends). The cash flow statement's ending cash balance equals the cash line on the balance sheet—the model's primary error check.

Mastery of the three-statement model is foundational for investment banking analysts, private equity associates, CFO staff, and any finance professional who builds or reviews financial projections. From this foundation, more specialized models (LBO, M&A merger model, DCF) are built.

FAQs

Why does the balance sheet need to balance in a three-statement model?

The balance sheet must balance (assets = liabilities + equity) because it reflects the fundamental accounting equation: everything a company owns (assets) must be financed by either what it owes (liabilities) or what owners contributed/earned (equity). In a well-built model, the balance sheet balances automatically if all linkages are correctly implemented—cash (from the ending cash per the cash flow statement) is the 'plug' that makes assets equal liabilities plus equity. If the balance sheet doesn't balance, the model has an error: a missing or double-counted item, an incorrect linkage, or inconsistent assumptions between statements.

What is the correct order to build a three-statement model?

The conventional sequence: (1) Build the income statement first—project revenues and costs through to net income; (2) Build the balance sheet structure (assets, liabilities, equity sections) with historical data as the starting point; (3) Build the cash flow statement, starting with net income and adding operating adjustments, then investing (capex from balance sheet assumptions), then financing; (4) Plug cash flow ending balance back into the balance sheet cash line; (5) Add the debt schedule (revolver, term loans) to handle financing needs and interest expense; (6) Wire together any remaining circular linkages (interest expense → income statement → net income → cash flow → debt balance → interest expense). Test balance sheet balance at every step.

How do non-cash charges like depreciation and stock-based compensation flow through the three statements?

Non-cash charges appear on the income statement (reducing pre-tax income and net income) but are added back on the cash flow statement (because they don't represent actual cash outflows), netting to zero effect on cash. Depreciation also reduces PP&E on the balance sheet. Stock-based compensation (SBC) is expensed on the income statement (reducing net income), added back on the cash flow statement, and increases additional paid-in capital (APIC) on the balance sheet equity section—reflecting the equity value transferred to employees. Understanding non-cash charges is essential for EBITDA reconciliation, free cash flow calculation, and evaluating whether reported earnings accurately represent cash generation.

Related Terms

Tools for this concept

Workday Adaptive Planning (formerly Adaptive Insights, acquired 2018) is a cloud-based financial planning and analytics platform that provides flexible, collaborative budgeting, forecasting, and reporting capabilities for organizations of all sizes. For Workday Financials customers, Adaptive Planning provides native integration with actual financial data—enabling real-time plan vs. actual analysis without manual data exports. The platform's modeling environment supports driver-based financial models where operational changes automatically update financial projections. Scenario planning enables finance teams to model multiple futures simultaneously and compare outcomes. Workforce planning connects headcount assumptions to financial models with employee-level detail. Sales planning and pipeline analysis extend planning beyond finance to revenue operations. The Office Connect tool embeds live Adaptive Planning data in PowerPoint and Excel for executive presentations. The platform's accessibility for business partners—not just finance professionals—enables distributed budgeting with central governance. Approvals and workflow manage the budget submission and review process across business units. Real-time dashboards provide financial performance visibility for executives and managers. Workday Adaptive Planning's advantage is its Workday ecosystem integration—combined with Workday HCM and Workday Financials, it creates a comprehensive people, finance, and planning platform with native data consistency across all modules. Gartner rates it among the top cloud FP&A solutions globally.

Prophix is a Corporate Performance Management (CPM) software company providing budgeting, planning, reporting, and consolidation for mid-market organizations that have outgrown Excel but don't require full enterprise EPM complexity or pricing. Founded in 1987 in Mississauga, Canada, Prophix serves over 3,000 companies in 100+ countries with a focus on making financial planning accessible to organizations with 200–2,000 employees. The platform provides a complete FP&A workflow: budget and forecast modeling, variance analysis, management reporting, and financial consolidation. Driver-based planning models connect operational assumptions to financial outputs. The cloud-based platform provides browser access and mobile reporting for executive stakeholders. Prophix IQ uses AI to surface financial insights and assist with narrative generation for reports. Pre-built content and implementation methodology enable faster deployment than bespoke enterprise implementations. Integration with popular ERP systems including NetSuite, SAP, Oracle, and QuickBooks enables automated actuals import. Consolidation capabilities handle multi-entity organizations with currency translation. Prophix's mid-market positioning delivers enterprise FP&A capabilities at accessible pricing, making it competitive for organizations underserved by both enterprise platforms (too complex and expensive) and basic tools (too limited). Gartner recognizes Prophix in the FP&A market as a mid-market leader.

Jedox is an AI-powered planning, analytics, and reporting platform that combines the familiarity of Excel with enterprise-grade planning capabilities, making it particularly accessible for finance teams transitioning from spreadsheet-based planning. Founded in Freiburg, Germany in 2002, Jedox serves over 2,500 organizations globally. The Excel Add-In enables finance teams to work in Excel while accessing a shared, consistent planning database—eliminating version control and data integrity issues of standalone spreadsheets. Cloud and on-premise deployment options accommodate data governance requirements. AI-driven planning assistance provides forecast recommendations, anomaly alerts, and data enrichment automatically. Driver-based financial models connect operational metrics to financial projections. Consolidated planning covers P&L, balance sheet, cash flow, and operational plans in connected models. Workforce planning handles headcount and compensation modeling. Pre-built content for retail, manufacturing, and financial services accelerates deployment. Integration with SAP, Oracle, Microsoft Dynamics, Salesforce, and other systems automates actuals import. Jedox's Excel familiarity reduces training requirements and adoption resistance—a persistent challenge with enterprise planning tools. The platform is particularly popular in Europe and with organizations that want modern planning capabilities while leveraging existing Excel expertise. Gartner recognizes Jedox in the FP&A Solutions market.