Milestone 10. Three-Statement Financial Model

14 min read

Milestone 10. Three-Statement Financial Model

Install the connected three-statement model the rest of the OS runs on so the gap between profit on paper and cash in the bank stops being a guessing game.

Phase 2 (Build) · Module 4 (Sustainable Financials) · Milestone 10 of 27

The owner’s question

Can your CFO build a three-statement model that ties cash flow to your balance sheet, and can you pull it up and answer a real ownership question in 90 seconds?

If the answer is “let me ask the bookkeeper” or “let me call the CPA,” you’re not at a 3 yet.

TL;DR

Most owners read the P&L, ignore the balance sheet, and never see the cash flow statement, then wonder why a profitable month leaves the checking account tight. Milestone 10 ends that gap. You install an integrated three-statement model where the income statement, balance sheet, and cash flow statement are wired together so a change in revenue flows automatically to cash, A/R, and equity. The model produces a defensible Normalized EBITDA, a monthly close in 10 business days, a Monthly Owner’s Package the CFO delivers ahead of the MOM, and a trust test the owner uses to answer real capital allocation questions on the spot. From here every other Module 4 milestone (budget, forecast, valuation) and every Module 2 lens runs on the same underlying truth.

Why this matters

Every month your CPA emails a P&L. Revenue is up. Margins held. Net income is positive. Looks like a great month. Then you check the bank account and your stomach drops. Cash is tight, payroll is in 8 days, the line of credit is close to the limit. The “good month” on paper does not match the reality in the checking account. Most owners have lived this exact scene more times than they can count.

The reason is structural. The P&L recognizes revenue when it is earned, not when it is collected. It depreciates capital purchases over years instead of showing cash going out the door now. It hides what is tied up in receivables, inventory, and working capital. When my family business was growing, at one point we had $1.5 million in receivables and $1.5 million in inventory. That was $3 million of cash we did not have, sitting on the balance sheet, invisible on the P&L. The Cash Conversion Cycle (receivables plus inventory minus payables) typically runs 10 to 15 percent of revenue for owner-operated businesses. Every dollar of revenue growth costs cents on the dollar to fund the cycle. Without seeing that, distributions feel like a slot machine.

Three statements tell three stories at the same time, and most owners only read one. The income statement is the performance story (did we make money this month?). The balance sheet is the position story (what stuck after the dust settled?). The cash flow statement is the translator (where did the cash actually go?). When the three are connected as one model, the gap between paper profit and real cash becomes visible the moment it opens, not 45 days later in the bank statement.

Milestone 10 ends the gap. It installs the integrated three-statement model the rest of the OS runs on. The financial instrument panel the owner trusts enough to make ownership decisions from, instead of flying blind on the biggest financial questions of the business.

What this looks like when it’s installed

The owner of Advanced Solutions entered Year 1 with the books on cash basis, a P&L that arrived from the bookkeeper 30 to 45 days late, a balance sheet they had never opened, and no cash flow statement at all. The Q1 90-Day Game Plan™ from the first Quarterly Boardroom was M10. A fractional CFO was engaged at roughly $5K to $10K a month. The team cleaned up the books, switched to accrual, reconciled the core accounts, locked an owner add-back schedule, and connected the three statements. The first clean monthly close landed in month 6 at 14 business days. By Q4 it landed in 12 business days and the MOM had a real CFO Memo for the first time.

By Year 3 the close lands in under 10 business days. The Monthly Owner’s Package goes out 3 to 5 days before every MOM. Normalized EBITDA is defensible enough to show a buyer or a banker without flinching. By Year 5 EBITDA has grown from $1.5 million to $3 million, the multiple has expanded from 4.52× to 6.67×, and net debt has flipped from $1 million owed to $1 million net cash. None of those moves happened in isolation. Every one of them was decided, modeled, and tracked inside the three-statement model. That is what “installed” looks like for M10. Not three reports in three PDFs. One connected instrument the owner runs the business from. Full walkthrough: see the Case Study Reference.

Score yourself

Score yourself honestly against where you are right now. The verification test at the bottom is what separates a real 3 from a wishful 3.

0 (Not Started). You haven’t engaged with the material. The three statements are still three separate reports your bookkeeper emails over. No integrated model. No defensible Normalized EBITDA. Default starting point.

1 (Learning). You can articulate the three-statement framing. You can explain what the income statement, balance sheet, and cash flow statement each tell you, and how they connect. You see why net income is not cash and where working capital lives. No integrated model built yet.

2 (In Progress). Books on accrual or in transition. The three statements exist as separate reports. A first-pass integrated model exists, but changes do not flow through automatically and the owner does not yet trust it for major decisions. Normalized EBITDA has been calculated but the add-back schedule is incomplete or undocumented. Monthly close happens but on inconsistent cadence (15 to 30+ days late).

3 (Installed). All five deliverables complete. Three-statement model fully integrated, where a change in revenue or an assumption flows automatically through to cash, A/R, A/P, and equity. Owner Add-Back Worksheet locked with every adjustment documented and defensible. Monthly Close Checklist running reliably with close inside 10 business days. Monthly Owner’s Package delivered 3 to 5 days ahead of every MOM with three statements, TTM views, KPI dashboard, and one-page CFO Memo. Trust Test Worksheet passed (10 ownership questions answered using only the model). At least one ownership decision in the last 90 days (a hire, a CapEx, a distribution, a debt move) was made by pulling up the model, flexing an assumption, and acting on what the numbers showed.

The verification test. Walk through this one out loud right now. “What happens to cash next quarter if revenue drops 15 percent and we hold all current commitments? What is my trailing twelve-month Normalized EBITDA, and what are the three biggest add-backs in it? When did we last close the books, and how many business days did it take?” If you can pull up the model, change the assumption, and produce defensible answers in 90 seconds, you’re at a 3. If you say “let me ask the bookkeeper” or “let me check with my CPA,” you’re at a 1 or 2.

Build these five things

Five deliverables. Roughly 8 to 12 weeks of focused work the first time, depending on the starting condition of the books. Most of the build is done by the CFO (full-time, fractional, or outsourced). The owner provides direction, removes obstacles, and sets the trust standard. The full canonical Exercise templates and AI Interview Protocols that walk you through each one live inside the Member version of the iBD Ownership OS™ that paying clients fork.

#DeliverableWhat it does
1Three-Statement Model TemplateThe integrated Excel or Sheets model. Income statement, balance sheet, and cash flow statement built as one model where a change in revenue flows automatically to cash, A/R, equity, and debt. The instrument panel the rest of the OS reads.
2Owner Add-Back WorksheetDocuments every Normalized EBITDA adjustment with dollar amount, rationale, and recurring vs one-time classification. The defensible footnotes that turn raw EBITDA into a number a buyer, banker, or DCF will accept.
3Monthly Close ChecklistWhat the bookkeeper or controller delivers and when. Reconciliation tasks, deadlines per task, who signs off. The discipline that lands the close in 10 business days reliably instead of 30+.
4Monthly Owner’s PackageThree statements + TTM views + budget-to-actual (once M11 is installed) + KPI dashboard + one-page CFO highlight memo. The pre-read for the MOM.
5Trust Test Worksheet10 ownership questions the owner answers using only the model. The verification that the model is wired correctly and that the owner actually trusts it before locking score 3.

Run them in this order:

  1. Three-Statement Model Template first. Get the core engine built. Convert to accrual if you’re on cash basis. Reconcile A/R, A/P, inventory, bank, credit cards. Connect the three statements as one model so a change in revenue flows through to cash and equity automatically. This is the foundation; nothing downstream works without it.
  2. Owner Add-Back Worksheet second. Document every adjustment that turns reported EBITDA into Normalized EBITDA. Owner compensation above market. One-time legal, M&A, or ERP costs. Personal expenses run through the business. Below-market rent or related-party deals. Each add-back gets a dollar amount, a rationale, and a recurring-vs-one-time classification. The TTM view of Normalized EBITDA becomes the number that anchors the Owner’s Scorecard™ Wealth dimension and every Three Lenses of Value calculation in Module 2.
  3. Monthly Close Checklist third. Lock the discipline. The first close might land in 15 to 20 business days. The goal is 10. The rhythm is what turns financials from a compliance exercise into an operating system.
  4. Monthly Owner’s Package fourth. Wire the close output into the standard package the owner gets 3 to 5 days before the MOM. Three statements with month-over-month and year-over-year. TTM views for EBITDA, gross margin, revenue, and key cost lines. KPI dashboard (gross margin %, EBITDA margin, DSO, DPO, DIO, cash conversion cycle). One-page CFO highlight memo: the 5 to 10 things the owner needs to know this month.
  5. Trust Test Worksheet fifth. Run the 10 ownership questions through the model. If the model produces defensible answers in 90 seconds each, it’s wired correctly. If any question stalls, fix the wiring before locking score 3.

And then the move that separates a 2 from a 3. Make one real ownership decision in the next 90 days by pulling up the model, flexing an assumption, and acting on what the numbers show. A hire approved because the cash impact is funded. A distribution sized to what the cash flow statement actually supports. A reinvestment deferred because the model showed Q3 would be tight. One specific decision, documented, made from the model. That is what flips this milestone from documented to alive.

Take your next action

At Level 0 (Not Started). Get exposure to the three-statement architecture first. The fastest path is the iBD Ownership OS™ Workshop — three hours, $100, walk out with your Velocity Score™ baseline and a working introduction to the gap between paper profit and real cash.

At Level 1 (Learning). Block 90 minutes on your calendar this week. Pull up the most recent P&L, balance sheet, and bank reconciliation. Sketch the integration logic: how does a revenue change in the P&L flow to cash, A/R, and equity? The full canonical templates and the AI Interview Protocols live in the Member version of the OS that paying clients fork; the Workshop gives you working drafts to start.

At Level 2 (In Progress). Engage the CFO seat. Lock the Owner Add-Back Worksheet. Formalize the 10-business-day close. Wire the Monthly Owner’s Package into the MOM. Run the Trust Test before locking the model as decision-grade.

At Level 3 (Installed). Maintain. Re-run the Trust Test annually at the Annual Owner’s Reset. Re-rate yourself if the close starts drifting past 12 business days, if a new add-back emerges that isn’t documented, or if a real ownership question stalls the model.

Where this lives once it’s running

The three-statement model is the foundation the rest of the OS runs on. Once installed, it does not sit in a folder. It runs.

Weekly. The bookkeeper or controller updates the books. Reconciliations stay current. Clean data flows into the model so the close is never a scramble.

Monthly. The model drives the Financial Signal Review section of the MOM (M9). The Monthly Owner’s Package goes out 3 to 5 days ahead. The CFO Memo summarizes the month, names the variance, flags 3 to 5 risks. The owner walks in prepared. Drift gets caught here, not at quarter-end.

Quarterly. The model anchors Act 1 of the Quarterly Boardroom (M8). Capital allocation decisions run through it. The Three Lenses of Value re-rate uses the Normalized EBITDA from this model. The 5-year forecast (M12) gets refreshed against actuals.

Annually. Full historical refresh during the Annual Owner’s Reset. Last year’s actuals lock. The new year’s annual budget (M11) gets built on top of the clean three-statement foundation. The forecast horizon extends through M12.

If you don’t have the cadence built yet (you’re working M10 for the first time and M8/M9 haven’t been installed), run your own monthly close review against the model. Pull up the three statements. Read the CFO Memo. Walk through the variance once. Make at least one decision based on what you see. The cadence formalizes later. The discipline of running the business from the model starts now.

How this fits in the OS

Prerequisites. Milestone 2: Cash Flow Targets and Milestone 3: Net Worth & Valuation Targets in Phase 1 set the cash flow and wealth targets the financial system has to produce. Module 2 (Milestone 4, Milestone 5, Milestone 6) framed the three valuation lenses that all run on inputs from this model. Without Phase 1 + Module 2 in place, M10 builds a financial engine with no destination. With them, M10 becomes the instrument that closes the gap.

What this feeds. Milestone 11: Annual Budget builds the year’s operating plan on top of this model. Milestone 12: 5-Year Forecast & Valuation extends the model into a rolling five-year forecast and a valuation tracker across all three lenses. Module 2’s lenses (Milestone 4 DCF, Milestone 5 Market Value, Milestone 6 Transaction Value) all discount, multiply, and reconcile against the Normalized EBITDA and cash flow numbers produced here. Milestone 9: Monthly Ownership Meetings reviews the model output monthly.

Where it sits. First milestone of Module 4 (Sustainable Financials). M10 is the foundation. M11 builds the annual operating plan on top of it. M12 extends it into the five-year strategic view. Together, M10 + M11 + M12 produce the financial system that turns Phase 1 ownership goals into a managed trajectory toward the wealth target.

Want help getting from a 1 to a 3?

The iBD Ownership OS™ Workshop is the paid filter where you experience the OS for yourself. Walk out with your Velocity Score™ baseline across all 27 milestones, a working introduction to the integrated three-statement architecture, and a sense of where paper profit is hiding the cash story in your business.

Join the next workshop →

← Back to Module 4: Sustainable Financials · ← Milestone 9: Monthly Ownership Meetings · → Milestone 11: Annual Budget

Graph View

Backlinks