Financial Modeling 101: Building Your First Three-Statement Model

A connected three-statement financial model — linking the income statement, balance sheet, and cash flow statement — is the foundation of every serious financial plan. Whether you're fundraising, planning headcount, or just trying to understand your business better, here's how to build one.

Start With the Income Statement

The income statement (or P&L) is your starting point. Build it from the top down: start with revenue, subtract cost of goods sold to get gross profit, then subtract operating expenses to get operating income. Your revenue model should be bottoms-up wherever possible — driven by specific assumptions about customers, pricing, and growth rates rather than top-down market sizing.

Build the Balance Sheet

The balance sheet captures your assets, liabilities, and equity at a point in time. For most startups, the key balance sheet items are cash, accounts receivable, accounts payable, debt, and equity. The balance sheet must balance — total assets must equal total liabilities plus equity. If it doesn't, you have an error somewhere.

Connect With the Cash Flow Statement

The cash flow statement bridges the income statement and balance sheet. It starts with net income, adjusts for non-cash items like depreciation, and then accounts for changes in working capital, capital expenditures, and financing activities. The ending cash balance on your cash flow statement must match the cash line on your balance sheet. This connection is what makes the model dynamic and internally consistent.

Assumptions Drive Everything

The quality of your model depends entirely on the quality of your assumptions. Create a dedicated assumptions tab where every key input is clearly labeled and easy to change. Revenue growth rate, headcount plan, average salary, customer acquisition cost — all of these should be adjustable from one place. This makes scenario analysis as simple as changing a few cells.

Build for Scenarios

A model with one scenario is an opinion. A model with three scenarios is a tool. Build in the ability to toggle between base, upside, and downside cases. This lets you answer questions like: what happens if we grow 50% slower than projected? What if we lose our biggest customer? What if we raise less than we planned?

Common Mistakes to Avoid

Hardcoded numbers: Every number in your model should flow from an assumption or a formula. Hardcoded values are impossible to audit and break when you try to run scenarios.

Circular references: These happen most often with interest expense calculations. Use an iterative calculation or a simplifying assumption to break the circularity.

Over-complexity: Your model should be as simple as possible while still capturing the key dynamics of your business. A 50-tab model that nobody understands is less useful than a clean 5-tab model that everyone trusts.

When to Get Help

If financial modeling isn't your strength, that's completely normal — it shouldn't have to be. A fractional CFO can build or refine your model, train your team to use it, and ensure it tells the story investors and board members need to hear. The model is a living document that should evolve as your business does.