Startup Financial Projections Investors Can Trust
By Newtown Analytics · · 7 min read
For startup founders
Startup financial projections are a forecast of revenue, costs, cash burn and runway that show what a company will do with the money it raises and what it expects to achieve. Investors know that early forecasts are uncertain, so they are not looking for accuracy; they look for evidence that you understand your drivers, that the assumptions come from somewhere, that the plan reaches a meaningful milestone before the money runs out, and that you have thought about what happens if things go slower. This guide explains what to build, how to tie costs to a hiring plan, how to calculate runway and use of funds with a worked example, which downside to show, and the mistakes that cost founders credibility. It is part of budgeting and forecasting, uses the structure in the three statement financial model, and links to how to build a financial model, bottom-up revenue modeling and scenario planning.
What to include
| Component | What it shows |
|---|---|
| Assumptions page | Every driver, its value, source and owner |
| Revenue build | How customers, price, conversion and retention produce revenue. See bottom-up revenue model |
| Hiring plan | Roles, start dates, pay and on-costs |
| Operating expenses | Software, marketing, rent, professional fees |
| Income statement | Monthly for 12 to 24 months, annual to year 3 or 5 |
| Cash flow and runway | Monthly burn and closing cash |
| Balance sheet | Needed for most formal raises, and for debt |
| Use of funds | Where the raise goes, by category |
| Milestones | What the raise achieves and when |
| Scenarios | Base, downside and sometimes upside |
Principles that build trust
- Start from drivers you can defend. Pilot results, signed contracts, pipeline, comparable companies. Label what is judgment.
- Tie revenue to capacity. If the plan needs 40 sales demos a month, show who runs them.
- Tie costs to people. Headcount is usually the largest cost. A cost line that does not move with hiring is suspicious.
- Be explicit about timing. Revenue is not cash. Include payment terms, deferred revenue and the lag from hiring to productivity.
- Show a downside. A plan with no downside suggests no risk awareness.
- Keep it as simple as the stage allows. A pre-seed company does not need 40 tabs.
A worked example: hiring-led burn
A hypothetical startup plans to hire these people in year 1:
| Role | Number | Annual salary | Months in year 1 | Base cost |
|---|---|---|---|---|
| Engineers | 3 | $130,000 | 12 | $390,000 |
| Designer | 1 | $100,000 | 12 | $100,000 |
| Sales | 1 | $110,000 | 9 (from month 4) | $82,500 |
| Founders | 2 | $60,000 | 12 | $120,000 |
| Base pay | $692,500 | |||
| On-costs at 20% (taxes, benefits) | $138,500 | |||
| Total people cost | $831,000 |
Check: 3 × 130,000 = 390,000; 110,000 × 9/12 = 82,500; 2 × 60,000 = 120,000; total 692,500; × 1.20 = 831,000. Other operating costs are $209,000 (software, marketing, legal, rent). Year 1 gross profit from early customers is $80,000.
Year 1 net burn = $831,000 + $209,000 - $80,000 = $960,000.
Quarterly burn and runway
The company raises $1,500,000 and already holds $200,000 of cash, for $1,700,000. Burn rises as hires start and revenue ramps more slowly than costs.
| Quarter | Net burn | Cumulative burn | Cash remaining |
|---|---|---|---|
| Q1 | $180,000 | $180,000 | $1,520,000 |
| Q2 | $220,000 | $400,000 | $1,300,000 |
| Q3 | $260,000 | $660,000 | $1,040,000 |
| Q4 | $300,000 | $960,000 | $740,000 |
| Q5 | $320,000 | $1,280,000 | $420,000 |
| Q6 | $330,000 | $1,610,000 | $90,000 |
| Q7 | $340,000 | $1,950,000 | Cash is exhausted |
Year 1 cumulative burn of $960,000 matches the annual calculation. Cash runs out in the seventh quarter: after six quarters $90,000 remains, enough for $90,000 / $340,000 = 0.26 of a quarter. Runway = 6.26 quarters, or about 18.8 months.
Is that enough?
Runway has to be judged against the milestone it must reach. Suppose the next funding round needs $1,000,000 of annual recurring revenue, which the plan reaches in month 15, and fundraising takes about four months. Then the company must start raising by about month 11. Cash at the end of month 11 is the end-of-Q3 balance of $1,040,000 less two months of Q4 burn at $100,000 a month, or $840,000, which is comfortable. If the milestone slips three months to month 18, the company reaches it with only the end-of-Q6 balance of $90,000, a precarious position, and would have had to start raising with less than a year of cash on hand. A founder who shows this analysis and the actions they would take (slow hiring, extend runway, arrange bridge financing) is more credible than one who shows only the best case.
Use of funds
Present the raise as a table that ties to the model:
| Category | Amount | Share |
|---|---|---|
| Engineering and product | $780,000 | 52% |
| Sales and marketing | $420,000 | 28% |
| General and administrative | $150,000 | 10% |
| Contingency reserve | $150,000 | 10% |
| Total | $1,500,000 | 100% |
The categories should reflect the model's actual spending, and the shares should add up to 100 percent (52 + 28 + 10 + 10). A reserve shows prudence.
The downside case
A useful downside changes the assumptions most likely to be wrong, such as customer acquisition and sales cycle length, not everything at once. For example:
| Assumption | Base | Downside |
|---|---|---|
| New customers per month by month 12 | 25 | 15 |
| Sales cycle | 60 days | 90 days |
| Year 1 gross profit | $80,000 | $45,000 |
With $35,000 less gross profit in year 1, year 1 burn rises from $960,000 to $995,000. Average monthly burn in year 1 is $960,000 / 12 = $80,000, so the first-year shortfall alone costs about 0.4 months of runway ($35,000 / $80,000); the slower ramp in later years costs more, which rerunning the model will show. State the new runway and which costs you would delay to restore it. A plan that pre-commits to specific actions, such as pausing a hire until a revenue threshold is hit, reassures investors.
Key metrics to show
| Metric | Why |
|---|---|
| Monthly burn and runway | Survival |
| Revenue growth and recurring revenue | Traction |
| Gross margin | Quality of revenue. See unit economics |
| Customer acquisition cost and payback | Efficiency of growth |
| Retention and churn | Durability. See SaaS revenue forecasting |
| Burn multiple (net burn / net new revenue) | Capital efficiency, if relevant to your model |
| Headcount and revenue per head | Organization scale |
Calculate each from the model with clear definitions, and use the same definitions over time.
Common mistakes
- A hockey-stick curve with no mechanism.
- Costs that do not respond to hiring or growth.
- Revenue recognized at signing with cash arriving months later.
- No allowance for sales ramp time.
- Using top-down market share as the only support.
- Ignoring taxes, payroll taxes, benefits, insurance and recruiting fees.
- No downside case.
- A model that does not balance.
- Different numbers in the model and the deck.
- Presenting false precision (a forecast to the dollar for year 5).
Checklist before you share
- [ ] Every assumption has a source and an owner.
- [ ] Hiring plan ties to costs.
- [ ] Revenue is supported by capacity and conversion.
- [ ] Cash flow reflects timing.
- [ ] Runway and milestones are clear.
- [ ] Use of funds ties to the model.
- [ ] Downside case and actions are included.
- [ ] Balance sheet balances; checks pass. See the model audit checklist.
- [ ] The deck and model show the same numbers.
For common spreadsheet errors that undermine credibility, see common spreadsheet model errors.
FAQs
What should startup financial projections include?
Assumptions, a revenue build, a hiring plan, operating expenses, income statement, cash flow with runway, use of funds, milestones and a downside case.
How many years should startup projections cover?
Monthly for 12 to 24 months, then annual to year three or five, with less detail further out.
How do I calculate runway?
Divide cash by average monthly net burn, or step through the monthly forecast until cash runs out, which is more accurate when burn changes.
Do investors expect accuracy?
They expect sound reasoning, defensible assumptions and awareness of risk, not precision.
Do I need a balance sheet?
For most formal fundraising and any debt financing, yes. For very early rounds, an income statement and cash flow may suffice.
Keep reading
- Complete guide: Budgeting and Forecasting: The Complete Guide for Finance Leaders
- Common Spreadsheet Model Errors and How to Catch Them
- The Three-Statement Financial Model, Explained
- Financial Model Template (Excel and Google Sheets)
- Related topic: Unit Economics: The Complete Guide to Profitable Growth
This article is for general information. It is not accounting, tax, legal or investment advice, and examples use illustrative numbers rather than client data. Confirm decisions that carry financial or legal consequences with a qualified professional.