← Back to blog

Financial Model for Investors: What to Build and Show

November 10, 2026
Financial Model for Investors: What to Build and Show

A financial model for investors is a spreadsheet that turns your business plan into numbers: revenue, costs, cash and the funding you need. A good one links the three financial statements, rests on documented assumptions, shows scenarios and makes your cash runway obvious. It lets an investor test your story instead of taking it on faith.

This guide covers what to include, how to build it when you have little history, and what investors look for when they open it.

Kapvista
Put Your Model in Front of Investors
Kapvista connects early-stage founders with qualified investors, including VCs, family offices, and angel investors across 15 countries.
Visit Kapvista

TL;DR

  • Link the income statement, balance sheet and cash flow statement so a change in one assumption flows through all three.
  • Build revenue from drivers (customers times price), not hard-coded totals, and document the source of every assumption.
  • Show base, downside and upside scenarios, plus a clear runway and a specific funding requirement tied to use of funds.
  • With little history, work bottom-up from pricing, pipeline and funnel metrics, then sanity-check top-down.
  • Keep it simple enough to walk through live. Credibility beats complexity.

Table of Contents

What investors use your model for

Investors do not read a model to find the exact future. They read it to understand how you think. According to GOV.UK guidance on financial model essentials, investors rely heavily on models to judge past performance, growth potential and operational discipline, and transparency about revenue, runway, costs and team gives them confidence you can execute.

A venture investor also uses the model to ask what they would have to believe for the company to become very large. BBG Ventures explains that the model helps them understand market size, speed of scaling, and the levers behind growth, profitability and financing needs.

In general terms, the CFA Institute describes a financial model as a spreadsheet that combines financial statements, operating assumptions and forecasting techniques to project performance, so analysts can test scenarios and evaluate risk. That is exactly the job yours does in a data room.

One useful mindset comes from Mergers & Inquisitions: aim to be roughly correct rather than precisely wrong. A model that claims false precision at year five invites doubt. A model that is transparent about ranges earns trust.

What an investor-ready model includes

The components below are what we see founders asked for most often, and they line up with published guidance.

The core structure

Corporate Finance Institute lists the main sections of a model as assumptions and drivers, income statement, balance sheet, cash flow statement, supporting schedules, valuation and sensitivity analysis. Ascent CFO adds that a modular layout, with separate tabs for assumptions, revenue drivers, operating expenses, capital expenditures and executive outputs, makes changes flow through every statement automatically.

In practice, that means:

  1. An assumptions tab. Every input in one place, labeled, with units.
  2. A revenue build. Driven by customers, price, conversion and churn.
  3. Cost schedules. Headcount by function and hire date, software, infrastructure, marketing.
  4. Three linked statements. Income statement, balance sheet, cash flow.
  5. A summary tab. Key outputs: revenue, gross margin, burn, runway, funding need.
  6. Scenarios and sensitivities. Switchable cases, not three separate files.

How much history and how far forward

GOV.UK guidance suggests at least two years of historic data and five years of forecast, covering revenues, gross margin progression, operating expenses, EBITDA, cash runway, breakeven and funding requirements. For a pre-revenue startup, the history will be thin or empty, and that is fine. What matters is the monthly detail where cash timing is critical. Oh Ventures argues that monthly resolution for at least 24 months is needed because annual figures hide hiring ramps, seasonality and cash dips. The Oakworth Group asks for three years monthly and treats a balance sheet that does not balance as an immediate red flag.

A practical rule we like: monthly for the first two to three years, then annual for the outer years, so the near term is tested hard and the long term stays honest.

How much history and how far forward

How the three statements connect

This is where many early models break. The links are mechanical, and investors check them first. According to Wall Street Prep:

  • Net income flows to retained earnings on the balance sheet (prior retained earnings plus net income minus dividends) and is the starting line of the cash flow statement.
  • The cash flow statement adjusts net income for non-cash items and working capital changes to reach cash from operations.
  • Capital expenditures raise property and equipment on the balance sheet but appear as cash outflows.
  • Ending cash on the cash flow statement becomes cash on the balance sheet.

If your balance sheet balances in every month and every scenario, you have passed the first test. If it only balances after a manual plug, fix the logic before you send the file.

Build it when you have little history

Most early-stage founders have a few months of data at best. That does not block a credible model. It changes the method.

Start bottom-up

Golden Egg Check recommends modeling revenue from individual customer metrics: define segments, estimate customer acquisition cost per segment, set funnel conversion rates, estimate average revenue per customer and project lifetime value. For a B2B SaaS company, Glencoyne suggests defining funnel stages, go-to-market motion, conversion rates, sales cycle length and average contract value, then using benchmark ranges as a starting point, such as 60 to 90 days for the sales cycle.

Then check top-down

The same Glencoyne guide proposes comparing your projected share of your serviceable obtainable market against a rule of thumb: capturing more than 10% to 15% within a few years suggests the assumptions are likely too aggressive. If you have not sized your market carefully, our piece on market sizing methods and dating every source will help you set that ceiling.

Rank assumptions by confidence

Profitual advises documenting every assumption and grouping them by confidence: pricing and fixed costs high, conversion rates medium, growth and churn low. Then spend your diligence effort on the low-confidence ones, because those are the ones an investor will probe.

When you lack internal data, BizPlanr notes you can use industry benchmarks for costs and margins, competitor pricing and realistic estimates of early customers, as long as every number has a clear reason behind it.

Document your assumptions

An assumption without a reason is a guess. Glencoyne's assumption documentation guide proposes five fields for each one: the driver name, the value with its unit, the source, the rationale and a sensitivity rating of high, medium or low.

Which drivers matter most? Inflection CFO groups startup inputs into four tiers:

TierWhat it coversExamples
1. Core business modelUnit economicsCAC, lifetime value, sales cycle, average contract value, churn, gross margin
2. OperationalCost baseHeadcount and hire timing, loaded salaries, infrastructure, software
3. Growth and scaleHow economics changeSales efficiency at scale, market expansion, channel revenue
4. Financial mechanicsCash timingPayment terms, payroll timing, tax rate, working capital, capex

The same source suggests tagging inputs as observed, comparable or directional. That small label tells an investor at a glance which numbers are facts and which are informed estimates, and it makes you look like someone who knows the difference.

Scenarios, runway and the size of your raise

A single forecast line looks confident and is almost always wrong. Investors prefer to see the range.

Three scenarios

The Startup Project suggests a bear case at roughly 50% to 70% of base revenue with higher churn and delayed hires, a base case on your expected trajectory, and a bull case at 130% to 150% of base. EY recommends asking specific what-if questions, such as what happens if launch slips six months, to see the effect on cash, profitability and funding need. GOV.UK guidance likewise calls sensitivity analysis on launch delays, cost overruns and slower customer acquisition essential.

Revenue ranges across bear, base, and bull cases

Run one-variable tests on price, churn and CAC first, then pair them. Ascent CFO recommends this to isolate the effect on ARR and runway and to catch interaction effects.

Runway

Runway is the number investors look for before anything else. BBG Ventures states that investors usually expect a raise to provide at least 12 months of runway without revenue, preferably 18. Ascent CFO suggests targeting 18 to 24 months, longer in tighter markets, with a 10% to 20% buffer for delays and overruns. To get the arithmetic right, see this walkthrough of cash runway calculation and what it tells investors.

How much to raise

TechCrunch advises projecting needs two years out and multiplying the operating need by at least 1.5, or 2 to be safer, to set the target. Whatever multiple you choose, tie the number to a use-of-funds table by hire, product milestone and channel, so the ask reads as a plan. Our seed round strategy guide shows how the raise size fits the rest of the process.

How investors read your model

Investors review it in minutes, then probe the weak spots. They typically look at:

  • Whether it balances and links. Hard-coded outputs are, according to Oh Ventures, the fastest way to lose credibility in a walkthrough. Revenue should be the result of a calculation.
  • Whether the history reconciles. Historical figures should match your accounts.
  • Your forecasting record. GOV.UK guidance notes that investors compare past performance against earlier forecasts, and if you tend to overestimate growth they may discount projections. Point to what has changed and give evidence.
  • Whether the output supports the valuation. Models feed valuation discussions, so it helps to understand how your numbers translate into price. A guide on using two or three methods for an investor-ready valuation is useful context, and our own piece on seed round valuation and terms covers the US seed market.

Expect the model to be one piece of evidence among several. Pair it with a clean cap table and organized documents; our investor due diligence checklist and cap table guide cover those.

Common mistakes to fix before you send it

  1. Revenue typed in, not calculated. Rebuild it from customers, price and conversion.
  2. Hockey-stick growth with no driver. Tie each step up to a hire, channel or product release.
  3. A balance sheet that needs a plug. Trace the cash and working capital links.
  4. Annual-only columns. Add monthly detail for the first two to three years.
  5. No scenarios. Add a switch for base, downside and upside.
  6. Runway buried. Put runway, burn and funding need on the summary tab.
  7. Undocumented inputs. Add source, rationale and confidence for each.

Our perspective

We talk to founders every week who have a strong product and a spreadsheet that works against them. The model is not a formality. It is the first place an investor decides whether you think like an operator.

Our advice is to build the smallest model that answers three questions: what you assume, how much cash you need, and what happens if you are wrong. Then rehearse it. A founder who can change one input live and explain the result is far more convincing than one with fifty tabs.

This is also why we pair introductions with preparation. At KapVista we connect founders with VCs, family offices and angels, and we have seen that the founders who get quick follow-up meetings are the ones whose numbers hold up in the first conversation. Get the model right, and a warm introduction has something solid to land on.

Daniel

Put your model in front of investors

Once your model is ready, the next step is reaching the right people. KapVista is a global platform that connects early-stage founders with qualified investors, including VCs, family offices and angels, through tailored introductions and personalized support. Paid offerings start from 39 USD per month; see the KapVista FAQ for what each option includes.

Kapvista

If you want hands-on help with investor communication, explore our Investor Relations services. Before you reach out, run through the capital raising checklist to confirm the model, deck and data room are aligned.

FAQ

What is a financial model for investors?

It is a spreadsheet that projects your revenue, costs, cash and funding needs from a set of documented assumptions. Investors use it to test your growth story, understand your runway and judge how you think about risk.

How many years should a startup financial model cover?

GOV.UK guidance suggests two years of history and five years of forecast where available. For early-stage companies, make the first two to three years monthly, because cash timing matters most there, and keep the outer years annual.

Do I need all three financial statements?

Yes for most institutional raises. Published guidance on investor-ready models consistently calls for an integrated income statement, balance sheet and cash flow statement, so that a change in one assumption updates the others and the balance sheet balances.

How much runway should my model show after the raise?

Sources aimed at founders point to at least 12 months, preferably 18, with some recommending 18 to 24 months, longer in tight markets. Choose a target, add a buffer for delays, and show it in your base and downside cases.

What if I have no historical data?

Build bottom-up from pricing, pipeline, funnel conversion and sales cycle, document each assumption with its reason, and sanity-check against your market size. Label inputs by confidence so investors see what is known and what is estimated.

Sources