A Founder's Guide to Financial Models: From Napkin Math to Series A
Stop building financial models investors ignore. Here’s how to build the right model for the right stage — from a simple unit economics test to a powerful fundraising and operating tool.
TL;DR: Your financial model is a tool for making decisions, not just a fundraising document. For an idea-stage startup, a simple LTV/CAC model is enough to validate the business. For a seed round, you need a 24-36 month fundraising model that tells a believable story of growth, driven by a clear assumptions tab. Post-seed, you need a detailed 12-month operating model to manage cash and hold departments accountable.
Key takeaways
- Stop building one giant model. Use the right model for the right stage.
- Before you write code, model your unit economics (LTV/CAC) to see if you have a viable business.
- Your fundraising model is a story about your growth. Justify your "hockey stick" with a bottoms-up revenue build.
- The most important tab in your model is "Assumptions." It shows investors you've thought from first principles.
- A P&L showing profit is useless if you run out of cash. Always model your runway.
- After you raise, your model becomes an operating tool for monthly budget vs. actuals review.
Your Financial Model is a Machine for Making Decisions
Your financial model isn't just a spreadsheet you send to investors. It's the operating system for your business. It’s a tool for making decisions under pressure. It forces you to think from first principles about how your business actually works and what has to be true for it to succeed.
Most founders get this wrong. They either build nothing, running on gut feel and a Stripe balance, or they build a monstrous, 20-tab spreadsheet they can’t update or explain. Both are dangerous. The goal is to build the *right* model for your stage.
The Three Models You Need: Pre-Seed, Seed, and Series A
You don't need one master model. You need three different models over the course of your company's life. Each serves a distinct purpose.
1. The "Can This Even Work?" Model (Idea Stage)
Before you write a line of code or hire an employee, you need to test the fundamental viability of your idea. The goal here isn't precision; it's to understand the core levers of your potential business. You do this with a simple unit economics calculator.
Primary Goal: Validate that you can acquire customers for meaningfully less than they will be worth to you.
Key Metrics:
- Lifetime Value (LTV): The total profit you expect to make from a single customer.
- Customer Acquisition Cost (CAC): The total cost to acquire that customer.
A simple LTV formula for a SaaS business is: (Average Revenue Per User Per Month * Gross Margin %) / Monthly Customer Churn %
Let's make this concrete. Imagine a B2B SaaS tool:
- Price:
00/month
- Gross Margin: 85% (your costs are hosting and support, not a physical good)
- Monthly Churn: 4% of customers cancel each month
Your LTV is (
00 * 0.85) / 0.04 =
,125. This means a typical customer is worth
,125 in profit over their entire lifespan. Now, you estimate your CAC. How will you get customers? Let's say you plan to use paid search. You estimate it might cost you $300 in Google Ads to get one paying customer. Your LTV/CAC ratio is ,125 / $300 = ~7. That’s a strong signal. A ratio below 3:1 is a red flag. A ratio above 5:1 suggests you have a powerful growth engine.
Continue reading the full guide
Related guides
Read on Startup Fundraising ·
More articles ·
Browse the Library