Building a Simple Financial Model

A financial model isn't a crystal ball. It's a structured way to think through whether your business makes sense financially before you spend a lot of money finding out the hard way.

Take a founder opening a small bakery. She loves baking, she has a lease she's excited about, and she's ready to sign. But she hasn't written down what rent, ingredients, and a part-time employee actually cost against what she'd need to sell every day to cover them. Three months after opening, she's making beautiful bread and losing money on every loaf, because her flour and packaging costs were higher than she guessed and she priced based on what nearby cafes charged, not on her own numbers. A one-page model built before she signed the lease would have shown her that at her planned price, she needed 140 loaves a day just to break even, in a neighborhood that could realistically support maybe 60.

Even a rough model, built in an evening in a spreadsheet, forces you to answer questions you might otherwise avoid until it's too late:

• ›How many customers or sales do I need to break even each month?
• ›What happens to my margins if my costs go up 20 percent, or a supplier raises prices?
• ›When do I actually run out of cash, even if the business looks profitable on paper?

You don't need to be an accountant to build one. You need one spreadsheet, an hour of focused time, and a willingness to write down numbers you can defend.

A full financial model has three statements, and each one answers a different question. Understanding what each one is for keeps you from building the wrong thing first.

The profit and loss statement (also called the income statement, or P&L) answers "am I making money?" It shows revenue minus expenses over a period, usually a month, and the result is your profit or loss for that period.

The cash flow statement answers a different question: "do I actually have the money in the bank?" It tracks cash moving in and out. A business can show a profit on its P&L and still run out of cash, because profit counts a sale the moment it's earned, not the moment the customer actually pays.

The balance sheet answers "what is the business worth right now?" It's a snapshot of what you own (assets), what you owe (liabilities), and what's left over (equity, the owner's stake). It matters more once you have real assets, debt, or investors asking for it. In the first year of a small, owner-run business, it's usually the least urgent of the three.

For most early founders, the P&L and the cash flow statement do almost all the work. Build those two first.

Start with the simplest possible formula:

Units times price equals revenue.

A coach selling 50 sessions a month at $150 each projects $7,500 a month in revenue. A subscription box service with 300 subscribers at $35 a month projects $10,500 in monthly recurring revenue. The formula is the same; only the definition of "unit" changes depending on how your business actually makes money (the decision tool below walks through that).

Build monthly projections for at least 12 months, and start conservatively. Nearly every founder overestimates how fast sales will ramp in the first two quarters, because the plan assumes marketing works immediately and customers decide fast, and real buyers usually take longer on both counts.

The single most useful discipline in this section is to ask, for every number you write down: "what does it take to actually achieve this?" If the model says 50 clients in month one, how do you get 50 people to say yes that fast? If you can't describe a believable path to a number, the number is a guess dressed up as a plan, and you should lower it until you can.

Separate every cost you'll pay into two categories, because they behave completely differently as your business grows.

Fixed costs stay roughly the same every month regardless of how much you sell: rent, software subscriptions, insurance, loan payments, and your own salary if you're paying yourself one. Fixed costs are the floor you have to cover before you make a dollar of profit.

Variable costs rise and fall with your sales volume: materials, shipping, payment processing fees, contractor pay tied to jobs completed, and sales commissions. A candle maker's wax and wicks are variable; her studio rent is fixed. Double her sales and her wax bill roughly doubles, but her rent doesn't move.

Add up your fixed costs for a monthly total, and calculate your variable cost per unit separately. Both numbers feed directly into the break-even calculation in the next section, so it's worth getting them right rather than lumping everything into one "expenses" line.

Break-even is the point where revenue equals total costs. Below it, you're losing money every month. Above it, every additional sale contributes to profit.

Formula: Break-even revenue equals fixed costs divided by gross margin percent.

Here's the bakery example worked through. Fixed costs (rent, a part-time baker's wages, insurance) run $3,000 a month. A loaf sells for $8 and costs $3.20 in flour, butter, and packaging to make, a 60 percent gross margin. Break-even revenue is $3,000 divided by 0.60, or $5,000 a month, which works out to 625 loaves a month, about 21 a day. That's a very different, much more achievable number than the 140 loaves a day the founder was originally assuming without having done this math.

Break-even isn't a one-time calculation. Recalculate it whenever a major cost changes, like a rent increase or a new hire, or whenever your pricing changes, since both move the number directly. Try it with your own numbers below.

Even if your P&L looks profitable every month, check your cash separately, because the two tell different stories.

A consulting founder invoices a client $20,000 for a project completed in March. Her P&L shows $20,000 of March revenue the moment she sends the invoice. But the client's payment terms are net 60, so the cash doesn't actually land in her bank account until late May. If she'd planned payroll and rent in April assuming that $20,000 was already available, she'd have come up short despite technically being profitable.

Track two things month by month: when revenue actually hits your bank account, since customers with payment terms or slow-paying habits create a gap between a sale and the cash from it, and when your big expenses are actually due, since annual insurance premiums, quarterly estimated taxes, and equipment purchases tend to arrive in lumps rather than smooth monthly amounts.

The gap between "profitable on paper" and "cash in the bank" is the single most common surprise for new founders, and it's the reason cash flow projections matter as much as the P&L, not less. The calculator below estimates how many months your current cash would last if expenses stay ahead of revenue, sometimes called your runway.