How to create a financial model for investment rounds

To create a financial model for investors, you need to build a spreadsheet that forecasts your business's income, expenses, and cash flow for the next three to five years. This isn't about perfectly predicting the future; it's about demonstrating to investors that you have a deep understanding of what drives your business, how you make money, and how their investment will be used to fuel growth. Your model tells the story of your business in numbers.

What is a Financial Model and Why Do You Need One?

Think of your financial model as the business plan translated into figures. It’s a set of spreadsheets that projects your financial performance into the future based on a set of assumptions. For pre-seed or seed funding rounds, investors will scrutinise this model to assess the viability and potential return of your venture. They want to see that you’ve thought through your strategy and can map it to concrete financial outcomes.

A strong model shows investors:

• Your Understanding: You know your market, your costs, and your key business drivers.
• The Opportunity: The potential scale of the business and the return on their investment.
• Your Plan: How you will use their capital to achieve specific milestones (e.g., hire key staff, launch a marketing campaign, develop new features).

Key Components of an Investor-Ready Financial Model

Your model should be built in a spreadsheet program like Microsoft Excel or Google Sheets. The best practice is to have different tabs for different components to keep things organised.

1. The Assumptions Tab

This is the most important part of your entire model. It's a dedicated sheet where you list all the key assumptions your forecasts are built on. This allows you and your investors to easily test different scenarios by changing a single number. Your assumptions should be ambitious but grounded in reality, based on market research, early data, or industry benchmarks.

Key assumptions include:

• Market size and your target market share.
• Pricing per product/service or subscription tier.
• Customer conversion rates (e.g., website visitors to paying customers).
• Customer Acquisition Cost (CAC).
• Customer churn rate (% of customers who cancel each month).
• Key staff hiring plan and average salaries.

2. Revenue Projections

This is where you forecast your sales. A "bottom-up" approach is most credible. Instead of saying "we'll capture 1% of a £1 billion market" (top-down), you build your revenue from the ground up:

1. User/Customer Growth: How many customers will you acquire each month? Link this to your marketing spend. For example: Marketing Spend / CAC = New Customers.
2. Revenue Calculation: Multiply your number of customers by your pricing. For a subscription business, this would be your Monthly Recurring Revenue (MRR). MRR = Number of Customers x Average Monthly Subscription Price.

3. Costs & Expenses

Here you'll detail everything you spend money on. Split them into two main categories:

• Cost of Goods Sold (COGS): The direct costs of delivering your product. For a software company, this might be server hosting and third-party API costs. For a physical product, it's manufacturing and materials.
• Operating Expenses (OpEx): The costs of running the business.
  • Salaries: Your biggest expense. Detail your hiring plan.
  • Sales & Marketing: This should be directly linked to your customer growth assumptions.
  • Technology: Software subscriptions, IT equipment.
  • General & Admin: Rent, utilities, legal fees, accounting.

4. The Financial Statements

The assumptions, revenue, and costs all feed into three core financial statements. For an early-stage business, the first two are the most critical.

• Profit & Loss (P&L) Statement: This shows your profitability over time. It’s your Revenue minus your COGS and OpEx.
• Cash Flow Statement: This is arguably the most important statement for a startup. It tracks the actual cash moving in and out of your bank account. Profit doesn't equal cash, and running out of cash is what kills most startups. This statement shows your monthly "burn rate" (how much cash you're losing) and your "runway" (how many months you have until the cash runs out).
• Balance Sheet: A snapshot of your company's financial health, showing assets, liabilities, and equity.

Bottom-Line Up Front Tip: Start with a simple model. You can always add more detail later. The goal is to create a tool that helps you and your investors make better decisions, not to build something impossibly complex.

Telling Your Story

Your financial model must align with the story you tell in your pitch deck. If you say you’re going to expand into a new market in year two, the model should show the associated costs (marketing, staff) and projected revenues. Every significant claim in your pitch should be backed up by a number in your spreadsheet. This consistency builds credibility and shows investors you have a clear, actionable plan to turn their capital into a high-growth business.