Financial Model for a Business: How to Build One Without a Finance Person

Financial Model for a Business: How to Build One Without a Finance Person

A financial model is a forward-looking calculation of your business, built so that any assumption can be changed and the result updates instantly. Raise a price by 10% — you see the new profit. Hire someone — you see when the investment pays off.

For a small business, it fits into four blocks and one page. Let's go through the structure, build a model for a year, and see which assumptions affect the result the most.

In plain terms. It's like planning a trip before a vacation. You rough it out: this much for travel, this much for lodging, this much per day. Then you change one thing — not a week but ten days — and immediately see the new total. A financial model does the same thing with a business: change one condition and see what happens to the result.

What a financial model is

It's a table where your business is broken down into components, and the result is calculated automatically from those components. There's one key property: assumptions and results are connected.

So the model doesn't answer “how much will we earn,” it answers “what happens if.” And that second question comes up every time a decision needs to be made: raise prices or not, hire or wait, open a second location or grow the first.

How a model differs from a budget

A budget is a decision, fixed in numbers. A model is the tool used to make that decision. Usually you build the model first, pick a scenario, and only then turn it into a year's budget.

The main principle: a model is built from assumptions

This is what sets a model apart from an ordinary forecast spreadsheet. In a spreadsheet, you write “March revenue — $6,000.” In a model, you write “60 customers, average check $250” — and revenue calculates itself.

The difference shows up the moment something changes. In a spreadsheet, you'd have to rewrite every cell by hand. In a model, you change one number in the assumptions, and the whole year recalculates.

Careful. This leads to a practical rule: a model should never contain a number that was just “put in.” Every figure is either an assumption you can justify, or something calculated from other numbers. The moment an amount shows up in the table with no explanation for where it came from, the model stops being a tool.

Four blocks of the model

The structure is the same for any small business.

Block 1. Assumptions

The most important block, and the only one you fill in by hand. All the starting conditions go here, each on its own line.

Block 2. Revenue

Nothing gets typed in by hand here — everything is calculated from the assumptions.

Revenue = Number of customers × Average check

If you have several lines or pricing tiers, each is calculated on its own line, then totaled. That way you see not just total revenue, but each line's contribution to it.

Block 3. Costs

Split into two parts, and this split is essential.

• Variable costs — grow together with volume. Calculated as a percentage of revenue or an amount per customer.

• Fixed costs — don't depend on the number of customers. Entered as monthly amounts.

This exact split is what gives the model its ability to show what happens with a change in volume: variable costs follow revenue, fixed costs stay put.

Block 4. Result

A monthly summary calculated from the blocks above: gross profit, operating profit, net profit, and a running cumulative total. That last line is especially useful — it shows exactly when the business will cover its initial losses.

Example: a model for a year

Let's take a service business. First, the assumptions.

Now the result. I'm showing three checkpoint months — the full model calculates all twelve.

Here's what's visible right away. Month 1 runs at a loss, and that's normal: gross profit exactly covers fixed costs, and the tax pushes it into the negative. From there, the customer count grows, fixed costs stay the same — and almost every new customer flows straight into profit. By month 12, net profit reaches $2,400.

This entire picture is built from six assumptions. Change any one of them, and all twelve months recalculate.

Three scenarios instead of one

A single model gives you a single result, and treating it as a plan is risky: reality rarely matches assumptions exactly. That's why you build three versions.

A working rule for the conservative scenario: take the base assumptions and worsen them by roughly a third. In our example, that's 2% growth instead of 5%, and a $184 check instead of $200. In that case, month 12 doesn't produce $2,400 — it produces about $200 in net profit.

That's valuable information: the business stays in the black even under noticeably worse conditions. If the conservative scenario had shown a loss, that would be a reason to revisit fixed costs before ever starting.

Which assumption matters most

Not all assumptions affect the result equally. This is simple to check: change them one at a time by the same amount and watch how profit reacts.

The same 10% change produces a different effect: the check moves the result almost twice as much as fixed costs do. That tells you where to put your attention — in this business, working on price and the value of the service matters more than trimming overhead.

Every business has its own version of this breakdown, and it's worth doing once. It shows your actual levers, instead of generic advice.

What makes a model useful in practice

• Assumptions are kept separate. All the starting numbers live in one block, not scattered across the table. That way a change takes seconds.

• Every assumption has a justification. Next to each number, it helps to keep a short note on where it came from: a six-month average, a supplier agreement, data from your books.

• The horizon is twelve months. That's enough for a small business. Beyond that, accuracy drops so much the calculation loses its point.

• The step is one month. An annual figure hides seasonality and the moment the business turns profitable.

• Costs are split into variable and fixed. Without that split, the model can't show what happens at a different volume.

How to check the model against reality

A model gets more accurate the more you compare it against reality. Once a month, it's worth looking at two things: how far the actual result diverged from the plan, and exactly which assumption was off.

The second question matters more. If revenue came in lower, the reason could be the number of customers or the average check — and those are two different problems. The model lets you see which specific assumption didn't hold, instead of just noting a gap in the total.

After a few rounds of this, assumptions get more realistic, and future models come out more accurate. It's a normal working cycle: the model gets refined by reality, and reality gets planned by the model.

Where to get the numbers for your assumptions

A model is only as reliable as the numbers going into it. The best source is your own data from past periods.

In BizFin, the “Profit and Loss” report gives you average revenue, cost structure, and the share of variable costs in revenue — three of the four key assumptions. Fixed costs show up there too, as a separate group, as long as categories are split out in “Directories.” Customer count and average check are calculated from transactions under “Transactions.”

A practical approach: use the average over the last three to six months, not just one. A single month can be atypical, while an average smooths out fluctuations and gives you a more realistic foundation.

Once the model is ready, it's worth checking its result against cash flow too: profit in the model and cash in the account are two different things, and a month with good profit can still turn out tight on cash.

What's worth remembering

• A model is built from assumptions, not finished numbers. Every figure is either justified or calculated from others.

• Four blocks: assumptions, revenue, costs, result. Only the first one is filled in by hand.

• Three scenarios beat one. The conservative version is built by worsening base assumptions by roughly a third.

• Check which assumption matters most. It shows your actual levers.

• Check it against reality every month. The model gets refined by reality and becomes more accurate.

Frequently asked questions

What is a financial model, in plain terms?

It's a forward-looking calculation of your business where the result is computed from assumptions. Change one assumption — revenue, price, number of customers — and you immediately see what happens to profit.

How is a financial model different from a business plan?

A business plan is a document describing the idea, market, and strategy, in which the model is the financial section. The model is the calculation itself, and you need it not just at startup, but before every major decision.

How many months should a model cover?

For a small business, the working horizon is twelve months in monthly steps. Beyond that, the accuracy of assumptions drops so much that the calculation gives little value.

Can I build a model in Excel?

Yes, and for a small business that's plenty. The key is keeping all assumptions in a separate block and linking formulas to them, so changing one number recalculates the whole table.

How many scenarios do I need?

Three is enough: base, conservative, and optimistic. The conservative one is built by worsening the base assumptions by roughly a third — it shows whether the business can survive a worse turn of events.

What do I do if reality doesn't match the model?

That's normal, and useful. The key is finding exactly which assumption didn't hold — customer count, check size, or costs. After a few rounds of this, assumptions get more realistic.