Build a Financial Model for Fundraising: A Founder's Guide

Stop Thinking About Your Model as a Prediction

Your financial model is not a tool for predicting the future. Investors know this. You know this. The moment you pretend your Year 3 revenue projection is a fact, you lose credibility.

An investor uses your model to answer one fundamental question: Do you understand the essential mechanics of your own business? They are looking for evidence that you grasp the levers of growth, the cost of acquiring a customer, and the timeline for turning an investment into a self-sustaining operation. It’s a thinking tool, not a crystal ball.

The Only Two Models You Need

Founders often conflate the model they need to run their business with the model they show to investors. This is a mistake. You need two distinct spreadsheets:

The Operating Model: This is your internal, granular, and probably messy source of truth. It’s a 12- to 18-month forecast, broken down monthly. You use it to manage cash flow, set hiring targets, and make tactical budget decisions. This is for you and your team. · The Fundraising Model: This is a simplified, clean, and assumptions-driven summary for investors. It projects 3 years of high-level performance, usually on an annual basis. Its goal is to communicate your strategy and scale, not to manage day-to-day operations. This is what you share externally.

Your Operating Model feeds the Fundraising Model. The detailed tactical data from your day-to-day operations should inform the high-level assumptions you present to investors.

How to Build Your Fundraising Model, Step-by-Step

A great fundraising model has three core components: an Assumptions tab, a P&L (Income Statement), and a Cash Forecast. That's it. Don’t overcomplicate it.

Part 1: The Assumptions Tab is Everything

This is the most important part of your model. An experienced investor will likely skip your nice-looking charts and go straight here. This is where you show your work. Every major input in your model should be listed here as a variable you can easily change.

Revenue Drivers

This is your growth engine. Be specific and build it from the bottom up.

For a SaaS business: Don't just project "revenue." Break it down into top-of-funnel (e.g., monthly website visitors), activation (e.g., trial sign-up rate), conversion (e.g., trial-to-paid conversion rate), and pricing (e.g., ACV by plan). · For a marketplace: Model both sides. How will you acquire supply (e.g., hosts, sellers) and demand (e.g., guests, buyers)? What is the take rate? What is the average transaction value? · For an e-commerce business: Focus on traffic (by channel), conversion rate, average order value (AOV), and repeat purchase rate.

Cost of Goods Sold (COGS)

These are the direct costs of delivering your product. Your Gross Margin (Revenue - COGS) is a critical indicator of scalability.

Examples: Hosting costs (AWS, GCP), transaction fees (Stripe), data APIs, and salaries for customer support or implementation staff directly serving paying customers.

Personnel Plan

This is usually your biggest expense. Don't just list roles; tie them to triggers.

Connect hiring to growth: "We will hire a new account executive for every $500k in new ARR," or "We need one customer support agent for every 1,000 active users." · Be realistic about salaries. A "senior engineer" isn't $90k. In a major tech hub, that could be $180k-$220k+. Do your research. · Add a "fully-loaded" cost: Include payroll taxes, health insurance, and benefits. A safe bet is to add 20-25% on top of the base salary.

Sales & Marketing (S&M)

Show how you'll acquire customers and what it will cost. This is where you model your CAC (Customer Acquisition Cost).

Model by channel if you can (e.g., Paid Social, SEM, Content). · Assume a realistic CAC. If you don't have data yet, find benchmarks for your industry. A B2B SaaS CAC might be $5,000, while a D2C app might be $5. · Show your CAC payback period. How many months of revenue does it take to earn back the cost of acquiring that customer? Investors want to see this under 12 months for most venture-scale businesses.

Part 2: The P&L (Income Statement)

The P&L is the output of your assumptions. It should be clean, easy to read, and contain zero hardcoded numbers (except for historical data). Everything should flow directly from the Assumptions tab.

Revenue · - COGS · = Gross Profit · - Operating Expenses (Personnel, S&M, R&D, G&A) · = EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization)

For an early-stage startup, EBITDA is a good proxy for cash flow from operations.

Part 3: The Cash Forecast

This is the ultimate gut-check. It answers the most critical question: "When do we run out of money?"

You don’t need a full, GAAP-compliant Statement of Cash Flows. A simple monthly cash-in, cash-out forecast will do. It should look something like this:

Starting Cash + Cash In (Investor Capital, Revenue) - Cash Out (Salaries, S&M, COGS, etc.) = Ending Cash

The most important line item here is the fundraise amount. Your model should clearly show that if you raise $2M, your cash balance turns positive and gives you X months of runway. This directly connects your fundraising "ask" to the operational plan.

Common Founder Mistakes (and How to Avoid Them)

Top-Down Forecasting: "The market is $50B, and we'll capture 1% of it." This is a rookie mistake. Investors fund plans, not market sizes. Your forecast must be bottoms-up, built from actions you will take (e.g., "We will hire 3 salespeople who will each close 5 deals per quarter."). · Miraculous Hockey Sticks: Growth doesn't just appear. Your revenue curve should directly reflect the inputs. If you show a huge ramp in revenue, the hiring and S&M sections must show the investment that drives it. · Hardcoded Numbers: If an investor wants to see what happens if your conversion rate is 1.5% instead of 2%, you should be able to change one cell on the Assumptions tab and have the entire model update. If you have numbers typed directly into your P&L, you'll fail this test. · Ignoring Headcount Load: Forgetting to add 20-25% to salaries for taxes and benefits. This can be a six-figure error that dramatically shortens your runway. · Confusing the Model With Reality: The goal is not to be "right." The goal is to show you understand the cause-and-effect relationships in your business. When an investor challenges an assumption, the right response isn't to get defensive. It's to have a discussion about what levers you would pull if that assumption turns out to be wrong.

How to Talk About Your Model With Investors

Never, ever just email your spreadsheet as an attachment with "see attached." You must present it and control the narrative.

Start with the assumptions. Share your screen and go directly to the Assumptions tab. This signals that you know what matters. · Frame the key drivers. Walk them through the 3-5 most sensitive inputs that determine your success. · Use the "What Would Have to Be True" framework. Your conversation should sound something like this:

"Let me walk you through the core assumptions. We project hitting $2M in ARR by the end of Year 2. For that to be true, we need to hire two AEs by month six, and they need to ramp to a quota of $500k in new ARR annually. We also need to maintain our current CAC of around $4,000. We believe that's achievable because..."

This approach transforms the conversation from a defense of an imaginary number into a strategic discussion about your go-to-market plan and operational capabilities.

How to Apply This This Week

Create two spreadsheets: Name one [Your Company] - Operating Model and the other [Your Company] - Fundraising Model. Commit to keeping them separate. · Build your Assumptions tab first. In your Fundraising Model, list the 5-10 most critical inputs for your revenue, costs, and hiring. Don't write a single formula in the P&L yet. · Link everything. Build your simple, annual P&L so that every single number pulls from the Assumptions tab. Test it by changing an assumption (e.g., price, conversion rate) and watching the whole model update. · Calculate your runway. Build the simple cash forecast and plug in your fundraising target. How many months of life does it buy you? If it's less than 18, your plan may be too aggressive or your ask too small. · Role-play the hard questions. Ask yourself, "If I were an investor, what are the two assumptions here that seem most likely to be wrong?" Prepare your answer.