Building a Simple Financial Model for a New Business

A financial model is not a forecast of how the business will go. It is a tool for asking 'what would have to be true' so you can spot trouble before it arrives. The most useful early-stage model fits on one page, is built from a small set of clearly labeled assumptions, and is updated monthly with actual numbers replacing assumptions over time.

Start with the four things that matter

A simple early-stage model has four blocks: revenue (how much money comes in), cost of revenue (the variable cost of delivering each sale), operating expenses (the fixed cost of running the business), and cash (what is left in the bank each month). Everything else is detail. Beware of models with fifty rows of granular line items — they create false precision and obscure the real story.

Revenue from the bottom up

Build revenue from the customer outward, not from a market-share assumption inward. For a subscription business: new customers per month × average price × twelve months, minus expected churn. For a transactional business: orders per month × average order value × your take rate. Use clearly labeled inputs (price, conversion rate, churn) so anyone — including you in six months — can see what you assumed.

Two cost categories, not twenty

Cost of revenue scales with sales — hosting, payment fees, fulfillment, third-party services. Operating expenses stay roughly flat regardless of sales — salaries, rent, software subscriptions, accounting. Keeping these separate lets you read gross margin at a glance and shows whether the business gets healthier or worse as it grows.

• Inputs in one color (your assumptions), formulas in another (the math), outputs in a third (the answers).
• Always include a 'cash on hand' row — the most important number on the page.
• Plan for at least two scenarios: base and downside. Optional: upside.
• Revisit the model at the end of every month and replace at least one assumption with reality.

Runway is the number that matters most

Runway is the number of months the business can operate at the current spend rate before cash runs out. It is calculated as cash on hand divided by net monthly burn. Knowing runway in months — not in dollars — is what allows a founder to make calm, strategic decisions instead of panicky ones. Twelve months of runway is comfortable, six is alarming, three is an emergency.

What the model is for

A model is not a promise to investors. It is a personal early-warning system. It answers questions like: if we hit half our growth target, when do we need to raise? If we double our marketing spend, do unit economics still work? If a key channel disappears, how long do we have? Every time you make a meaningful decision, run it through the model first. The act of opening the spreadsheet is often more valuable than the answer it produces.

Modeling scenarios instead of a single guess

A single forecast is almost always wrong, because the future rarely matches one tidy assumption. The fix is to model a small number of scenarios rather than pretending you can predict the exact path. A base case reflects what you genuinely expect. A downside case asks what happens if growth comes in at half and costs run higher than planned — this is the scenario that tells you how much runway you really have. An optional upside case shows what you would do with unexpected success, so you are not caught flat-footed if a channel takes off.

The value is not in the precise numbers but in the range. If even your downside case keeps the business alive for twelve months, you can make bold moves. If your base case already cuts it close, you know to raise earlier or spend more cautiously. Good founders make decisions against the downside case and are pleasantly surprised when reality lands closer to the base.

Keeping the model honest

A financial model is only as useful as it is trusted, and trust comes from discipline in how it is built and maintained. A few habits keep it from drifting into fiction.

• Replace at least one assumption with a real, measured number at the end of every month.
• Keep all assumptions in one clearly labeled place so anyone can see and challenge them.
• Compare last month's forecast to what actually happened, and ask why they differed.
• Resist adding detail that does not change a decision — complexity hides the real story.
• Always keep cash on hand and runway in months as the two headline outputs.

Using the model as a living tool

A financial model is most useful not as a one-time forecast but as a tool you return to and update as reality arrives. The first version will be wrong in its specifics — every projection is — but its value lies in making your assumptions explicit so you can test them against what actually happens. Each month, compare your real numbers to what the model predicted and ask what the gaps are teaching you. Customers cost more to acquire than you assumed, conversion is slower, churn is higher: these are the discoveries that turn a hopeful spreadsheet into an instrument that genuinely guides decisions.

Use the model to ask 'what if' before you commit real money. What happens to runway if you hire two people next quarter, if growth is half what you hoped, or if a key cost doubles? A good model lets you see the consequences of those choices on paper, where mistakes are free, rather than discovering them when the bank balance runs low. Keep it simple enough that you actually maintain it, focus on the few inputs that move the outcome most, and treat cash and runway as the numbers you never lose sight of. A living model will not predict the future, but it will keep you honest about it.