How to Build a Financial Model for a Startup or Small Business

A financial model turns your assumptions about revenue, costs, and growth into a working Excel forecast you can use to plan, raise money, or pressure-test a decision. This guide covers what goes into one, how to build it step by step, and the mistakes that break most spreadsheets.

A practical guide from the team behind DraftPlan.

What is a financial model?

A financial model is a spreadsheet that projects a business's future financial performance based on a set of assumptions.

At its simplest, you enter what you believe about the business — how many customers you'll win, what you'll charge, what it costs to operate — and the model calculates the results: revenue, profit, and cash in the bank over time. Change an assumption, and every downstream number updates through linked formulas. That is what separates a real model from a static budget: it's a connected system, not a list of numbers.

Founders use models to size a fundraise, set hiring and spending plans, decide whether a price change pays off, and show investors a credible path. Small-business owners use them to see whether a new location, product line, or loan actually works on paper before committing cash.

What are the core components of a financial model?

A complete financial model has six building blocks: an assumptions tab, a revenue build, a cost structure, and the three financial statements — profit and loss, cash flow, and balance sheet.

• Assumptions tab. Every input that drives the model — growth rates, pricing, headcount, payment terms — lives in one place. Nothing should be hard-coded inside a formula elsewhere.
• Revenue build. How sales are generated, broken into drivers (units × price, or customers × average revenue) rather than a single guessed total.
• Cost structure. Variable costs that scale with revenue (cost of goods, payment fees) and fixed costs that don't (rent, salaries, software).
• Profit & loss (income statement). Revenue minus costs, down to net profit, period by period.
• Cash flow. When money actually moves — which is different from when revenue is booked. This is what tells you if you'll run out of cash.
• Balance sheet. What the business owns and owes at each point in time. A full three-statement model ties all three together so they stay consistent.

How do you build a financial model, step by step?

Build from drivers to outputs: set the timeline, list your assumptions, model revenue, layer in costs, link the statements, then add scenarios.

1. Set the timeline. Use monthly columns for the first 12–24 months (where cash timing matters most), then annual columns for years 2–5.
2. Separate inputs from calculations. Put every assumption on its own tab and reference it everywhere else. This is the single habit that keeps a model auditable.
3. Build the revenue engine. Pick the drivers that actually move your sales and model them explicitly, so a reviewer can see why revenue grows, not just that it does.
4. Add the cost structure. Tie variable costs to revenue or volume; enter fixed costs directly. Don't forget payroll taxes, software, and the costs that creep in as you scale.
5. Link the statements. Flow the P&L into cash flow (adjusting for timing) and into the balance sheet. When cash and the balance sheet tie out, the model is internally consistent.
6. Add scenarios and check it. Build low, base, and high cases, then sanity-check the outputs against reality before anyone relies on them.

Should you model revenue top-down or bottom-up?

Bottom-up is almost always more credible: build revenue from the units you can actually influence, then sanity-check it against the top-down market size.

A top-down approach starts from a big market figure and assumes you capture a slice of it ("the market is $10B, we'll take 1%"). It's fast but unconvincing — the 1% is a guess with nothing behind it. A bottom-up approach starts from your own levers: leads × conversion rate × price, or seats × monthly fee × retention. It forces you to state assumptions you can defend and later measure. Use bottom-up for the model itself, and keep a top-down number nearby as a reality check — if bottom-up implies you'll capture 60% of the market in year two, something is off.

Why every model needs scenarios

A single forecast is a guess; scenarios show the range of outcomes and where the business breaks.

Build at least three cases — a conservative low, a realistic base, and an optimistic high — driven by a few key assumptions like growth rate, pricing, and churn. The point isn't to predict which one happens; it's to see how much cushion you have, when you'd run out of cash in the downside, and which assumptions matter most. A model that only shows the rosy case tells investors and lenders nothing they can trust.

Common financial modeling mistakes

• Hard-coding numbers inside formulas. If an assumption is buried in a calculation, no one can find or change it. Keep inputs on the assumptions tab.
• Confusing revenue with cash. Booking a sale isn't the same as getting paid. Models that ignore payment timing miss the cash crunch that actually kills businesses.
• Hockey-stick growth with no driver. Revenue that suddenly triples needs a reason — a channel, a hire, a launch — not just a steeper line.
• Forgetting costs that scale. Support, infrastructure, and payment fees grow with customers. Flat costs against rising revenue produce fantasy margins.
• No way to check it. Without scenarios and a few sanity checks, errors hide in plain sight. A model you can't audit is a liability.

How long does it take, and should you build or buy?

Building a solid model by hand takes anywhere from a day to a week; a generic template is faster but rarely fits, and a freelancer is thorough but costs $500–$3,000.

The trade-off is time, money, and fit. A downloadable Excel template costs $50–$100 but is built for a generic business, so you'll spend hours reworking its formulas to match yours — and still wonder whether the logic is right. A freelance financial modeler delivers a custom, polished result but charges $500–$3,000 and takes days to weeks. Building it yourself is free but assumes you know how to structure the statements and link them cleanly.

This is the gap DraftPlan was built to close: you answer a short questionnaire about your business, and it generates a custom Excel model — real formulas, three scenarios, and the statements already linked — in minutes, for $49–$59. It's a finished starting point you fully own and can edit, not a template you have to rebuild.

Modeling a specific type of business? See our walkthrough for a coffee shop financial model in Excel, with startup costs, cost benchmarks, and break-even worked through end to end.