
A startup financial model for fundraising should explain how the business turns activity into revenue, how spending supports the next milestone, and how much cash is needed to get there. It is not a prettier version of the pitch deck. It is the working file behind the numbers in the deck.
The best place to start is a simple, driver-based model that founders can explain without an analyst beside them. Every important output should trace back to an assumption that can be tested.
1. Define the decision the model must support
Before opening a spreadsheet, write down the question. Common examples are:
- How much should we raise?
- Which milestones can this round finance?
- When will cash fall below the minimum operating buffer?
- Which hires can we afford, and when?
- What happens if revenue arrives three months late?
- How much dilution might the proposed round create?
The Startup India funding guide asks founders to assess why funding is required, determine the right amount and prepare a milestone-based plan. That is a useful test: if the model cannot connect the proposed raise to specific work and measurable milestones, it is not ready for an investor discussion.
2. Clean the historical numbers first
Start with actual monthly figures, not forecasts. Depending on the startup's age, include 12 to 24 months of revenue, payroll, marketing, technology, professional fees and other operating costs. Reconcile these figures to the accounting records and bank balances.
Separate recurring items from one-off expenses. Founder-funded payments, reimbursements and costs paid personally should be identified rather than buried. If monthly management accounts are incomplete, mark the gaps clearly. A model built on unreconciled historical data may look precise while carrying the wrong opening cash, cost base or revenue trend.
Use one consistent definition for each operating metric. For example, if “active customer” means a customer who paid during the month, do not count trial users in some months and paying users in others.
3. Build revenue from operating drivers
Avoid starting with “we will capture 1% of the market.” Build from the activity that creates revenue.
A subscription business may use:
- leads generated;
- conversion rate;
- new paying customers;
- monthly churn;
- average revenue per account; and
- expansion or downgrade assumptions.
A marketplace may use buyers, transaction frequency, average order value and take rate. A services startup may use available team capacity, billable utilisation and average fee. A product business may use units, price, returns and channel margins.
Keep the assumptions in a dedicated section. Add a short note beside each major input stating whether it comes from actual performance, a signed pipeline, a test, management judgement or an external reference. The government's Startup India enabler guidance similarly emphasises cash inflows, investment required, milestones, break-even, growth rates and clearly stated reasonable assumptions.
4. Model costs at the level founders control
Costs should follow operating decisions. Build the headcount plan employee by employee or role by role, with joining month, salary, benefits and recruitment cost. Link variable costs to the activity that causes them: payment charges to transactions, cloud cost to usage, logistics to orders, and sales commission to qualifying revenue.
Group fixed costs separately, including rent, software, insurance, compliance and professional support. Do not hide all overheads inside a single percentage of revenue. Investors may want to understand which costs can be delayed and which are unavoidable.
For each proposed hire or major spend, record the operational reason. This makes the model useful even if the fundraising timeline changes.
5. Connect profit, working capital and cash
A profit forecast alone does not show runway. The model should connect the projected profit and loss account to cash movement.
Include customer collection periods, supplier payment terms, inventory where relevant, taxes, capital expenditure, loan servicing and refundable deposits. Show the opening cash balance and monthly closing balance. If the startup receives annual subscriptions upfront or has long customer-credit periods, the difference between revenue and cash becomes especially important.
The cash schedule should answer three questions plainly:
- What is the monthly net burn?
- In which month does cash approach the minimum buffer?
- How much additional capital is needed to reach the next milestone with a sensible contingency?
6. Show unit economics without forcing certainty
Use the metrics that fit the business model. These may include gross margin, contribution margin, customer acquisition cost, payback period, retention, churn, average revenue per user or order contribution.
Do not present an early estimate as a proven benchmark. If the startup has only a small customer sample, show the calculation and label its limits. It is better to state that acquisition cost is based on a three-month experiment than to display a confident ratio that cannot be reproduced.
Tie unit economics to the forecast. If the model assumes faster growth, it should also show the marketing spend, sales capacity or product change expected to produce it.
7. Add scenarios that change real assumptions
At minimum, prepare a base case and a downside case. A useful upside case can be added when there is evidence for it. Scenarios should change the drivers, not merely reduce every line by the same percentage.
A downside scenario might include:
- slower conversion;
- delayed enterprise contracts;
- higher churn;
- lower selling price;
- a postponed fundraising close; or
- a key hire joining earlier than revenue catches up.
Show how each scenario changes cash runway and the required raise. This turns the model into a planning tool rather than a single promised outcome.
8. Reconcile the model with the pitch deck and data room
The pitch deck, financial model and supporting records must tell the same story. Revenue, customer counts, burn, runway and use of funds should reconcile across all three.
Before sharing the file, run a simple review:
- actual months are locked and clearly separated from forecast months;
- formulas work across the full period;
- no unexplained hard-coded numbers sit inside formulas;
- totals reconcile to source records;
- scenario switches work;
- charts match the model outputs; and
- confidential employee or customer data is removed or appropriately controlled.
Give the file a clear version name and maintain a change log. When an investor asks for a revised assumption, the team should know which version produced each chart.
How ProTax can support the process
ProTax's Startup Finance & Fundraising Readiness service can help founders organise historical financials, build a driver-based forecast, calculate runway, test funding scenarios and prepare consistent financial material for the data room. Management remains responsible for the commercial assumptions, and no model can guarantee funding or future performance.
The practical test is simple: a founder should be able to explain where every important number comes from, what would change it and what decision follows if it moves.
*Photo: olia danilevich / Pexels (free Pexels licence).*
