If you've worked with financial models but never built a 3-statement from scratch, the individual statements aren't the hard part. You know what an income statement is. The hard part is the plumbing — understanding exactly which numbers flow where, and why the balance sheet won't balance when you get it wrong (and you will get it wrong the first time).
This article walks through how the model is actually wired together, what breaks it, and how to structure it in Google Sheets from the start.
Why the Linkages Are What Actually Matter
Most guides open with "Step 1: Build the income statement." That's fine, but it skips the thing that matters most: before you type a single formula, you need to understand what connects these statements.
There are 3 primary linkages:
Net income → retained earnings. Net income from the bottom of your income statement flows into retained earnings on the balance sheet. Specifically: ending retained earnings = beginning retained earnings + net income − dividends. If your retained earnings don't move by exactly net income (minus any dividends), something's broken.
Cash flow statement → cash on balance sheet. The ending cash balance on your cash flow statement must equal the cash line on the balance sheet. This is your first sanity check. If these don't match, you have a circular reference error or a formula pointing to the wrong year column.
D&A and capex bridge income statement to balance sheet. Depreciation runs through the income statement as an expense (reducing net income) but gets added back on the cash flow statement as a non-cash item. Capex appears as a cash outflow in investing activities, then increases PP&E on the balance sheet. PP&E then depreciates over time, feeding back into the income statement. This loop is where most first-time builders lose the thread.
These 3 linkages, wired correctly, are what make a model a model rather than 3 separate spreadsheets sitting next to each other.
The Structure Before the Formulas
Before you build anything, set up your file correctly. A typical 3-statement model in Google Sheets has at minimum 4 tabs:
- Assumptions — every hardcoded input lives here. Revenue growth rates, gross margin targets, tax rate, capex as % of revenue, D&A schedule, working capital days. Nothing hardcoded in the model tabs themselves.
- Income Statement — revenue down to net income, typically annual columns for a 5-year projection.
- Balance Sheet — assets, liabilities, equity, with a check row at the bottom confirming assets = liabilities + equity.
- Cash Flow Statement — operating, investing, and financing activities, ending with the change in cash and ending cash balance.
Some models add a Debt Schedule tab for revolvers, term loans, and interest calculations. If your model has meaningful debt, that tab earns its place — trying to cram amortization schedules into the main tabs makes everything harder to audit.
Color convention matters more than people admit. Blue font for hardcoded inputs, black for formulas. It's not aesthetic — it's how you (or anyone reviewing your model) instantly knows what can be changed versus what's calculated. Investors and senior analysts will look for this immediately.
Building the Income Statement
Your income statement is the starting point, but it should contain almost no hardcoded numbers. Revenue for Year 1 is your anchor — that can be hardcoded if you're starting from a known base. Everything else should pull from your Assumptions tab.
A basic structure for a SaaS or product company:
Revenue =Assumptions!B4 * (1 + Assumptions!B5)
COGS =Revenue * Assumptions!B6
Gross Profit =Revenue - COGS
Operating Expenses =Revenue * Assumptions!B7
EBITDA =Gross Profit - Operating Expenses
D&A =(see D&A schedule or assumptions)
EBIT =EBITDA - D&A
Interest Expense =(pulls from debt schedule)
EBT =EBIT - Interest Expense
Tax =EBT * Assumptions!B8
Net Income =EBT - Tax
D&A is where people reach for a simple percentage of revenue, and that works for early-stage models. More precise models build a PP&E schedule: beginning PP&E + capex − depreciation = ending PP&E, where depreciation is calculated based on asset life assumptions. That ending PP&E figure then rolls onto your balance sheet. The D&A from that schedule feeds back into your income statement. It's circular in concept but not in formula — each period builds on the prior.
The Balance Sheet
The balance sheet is where 3-statement models either come together or fall apart. Assets must equal liabilities plus equity, always. If yours doesn't balance, you have a missing linkage somewhere.
On the assets side, cash is the most important line — it's calculated last, as the output of your cash flow statement, not an assumption. Working capital items (accounts receivable, inventory, accounts payable) are typically driven by days metrics from your assumptions tab:
Accounts Receivable = Revenue / 365 * DSO_days
Inventory = COGS / 365 * DIO_days
Accounts Payable = COGS / 365 * DPO_days
As of March 2026, most financial modeling courses and CFA materials use this days-based approach as the standard for projecting working capital. According to the CFA Institute's corporate finance curriculum, changes in working capital are defined as (Δ current assets excluding cash) − (Δ current liabilities), which is exactly what flows into your cash flow statement's operating section.
On the equity side: retained earnings for each period = prior period retained earnings + net income − dividends. This is your link to the income statement. Build this formula carefully. A broken retained earnings roll is one of the most common reasons a balance sheet won't balance.
The Cash Flow Statement
The cash flow statement has 3 sections — operating, investing, financing — and they each pull from different places.
Operating activities starts with net income (from the income statement), adds back D&A (non-cash), and then adjusts for changes in working capital. An increase in accounts receivable is a use of cash (you invoiced but haven't collected); an increase in accounts payable is a source of cash (you owe but haven't paid). The signs on working capital changes trip up almost everyone the first time.
Net Income (from IS)
+ D&A (add back non-cash)
- Δ Accounts Receivable (increase = cash outflow)
- Δ Inventory
+ Δ Accounts Payable (increase = cash inflow)
= Cash from Operations
Investing activities is mostly capex. Capex is a cash outflow; asset sales are inflows. Keep it simple unless the business has material M&A or securities investments.
Financing activities covers debt draws and repayments, equity issuances, and dividends. If you have a revolver in your model, this section gets more complex — you're calculating whether the business needs to draw on the line or can pay it down, based on the ending cash balance from operations and investing.
Ending cash = beginning cash + cash from operations + cash from investing + cash from financing. That ending cash number goes directly onto your balance sheet. That's the linkage.
The Balance Check
Add a balance check row on your balance sheet tab. It's one formula:
=IF(ABS(Total_Assets - (Total_Liabilities + Total_Equity)) < 0.01, "BALANCED", "ERROR")
The < 0.01 threshold accounts for rounding. If this row reads ERROR, you have a broken linkage somewhere. Common culprits: retained earnings not picking up net income, cash on balance sheet not pointing to CFS ending cash, or a missing working capital item.
This check should be the first thing you look at when something feels off. A 3-statement model that doesn't balance isn't a model — it's 3 spreadsheets that don't know about each other.
Where AI Actually Helps Here
The mechanical part of this — building the structure, wiring the formulas, making sure the right cells point to the right tabs — is exactly the kind of work that's tedious to get right and painful to debug. ModelMonkey can read your existing spreadsheet, understand the structure, and build or fix the linkages across tabs. If you've got an income statement already and need to wire it to a balance sheet and cash flow statement, describing what you need in plain language is faster than tracing cell references across 4 tabs manually.
It won't replace understanding why the cash flow statement starts with net income or why D&A gets added back. But once you understand those things, having the formulas built correctly across a multi-tab model saves real time.