Financial Modeling for Founders Who Hate Spreadsheets
Build a startup financial model without an MBA. Learn the five numbers that matter, unit economics, and honest assumptions investors trust.
Why Financial Models Matter
You hate spreadsheets. You got into this to build a product, not to forecast revenue three years out. You would rather spend your time talking to customers or coding than staring at formulas.
Financial models are still critical. Not because you will predict the future accurately. You will not. Financial models matter because they force you to think through your business systematically. They make assumptions explicit. They surface the unit economics of what you are building.
Investors ask for financial models not because they believe your three-year projection. They know you will miss it. They ask because the model reveals how you think about your business. It shows whether you understand your customers' needs. It shows whether you understand how to acquire customers. It shows whether you have thought about what makes you profitable.
A bad financial model is worse than no model at all. A bad model shows confusion. A good model shows coherent thinking even if the numbers are wrong.
The Five Numbers Every Founder Must Know
You do not need a 100-cell spreadsheet. You need to understand five numbers. If you know these five numbers intimately, you understand your business.
1. Customer Acquisition Cost (CAC)
How much you spend to acquire one customer. If you spend $100,000 on marketing in one month and acquire 1,000 customers, your CAC is $100.
This number determines how fast you can grow. A $10,000 CAC limits you by available capital. A $100 CAC lets you scale aggressively.
2. Lifetime Value (LTV)
How much profit a single customer generates over their entire relationship with you. If a customer pays $1,000 per month for 24 months, your revenue is $24,000. Subtract $5,000 in costs to serve them, and your LTV is $19,000.
The LTV:CAC ratio is the most important number in your business. You need at least 3:1 to have a sustainable business. Ideally 5:1 or higher.
| LTV:CAC Ratio | What It Means |
|---|---|
| Below 1:1 | You lose money on every customer. Stop scaling. |
| 1:1 to 2:1 | Barely breaking even. Fix the model before growing. |
| 3:1 | Sustainable. You can grow profitably. |
| 5:1+ | Strong. You have room to invest in growth. |
| 10:1+ | Exceptional. Consider spending more on acquisition. |
3. Burn Rate
Your monthly expense. What do you spend per month to run the company? Include salary, hosting, contractors, marketing, and all costs. If you spend $50,000 per month, your burn rate is $50,000.
4. Runway
How many months you can operate with your current cash. If you have $500,000 in the bank and burn $50,000 per month, you have 10 months of runway.
Target 18 to 24 months of runway. If you have less than 12 months, you are in trouble. If you have less than 6 months and have not started fundraising, you are in a crisis.
5. Monthly Recurring Revenue (MRR)
Predictable revenue generated each month. If you have 100 customers paying $1,000 per month, your MRR is $100,000.
Watch the trend. MRR growing 10% month-over-month means growth is accelerating. Flat MRR means growth has stalled. Declining MRR means you are losing customers.
Track all five monthly. Watch the trends. If CAC is going up and LTV is going down, you have a problem. If burn rate is flat but runway is shrinking, revenue is not growing. These five numbers tell you the health of your business at a glance.
Understanding Unit Economics
Unit economics is a fancy term for the margin you make on a single customer. It is the foundation of your financial model.
How to Calculate It
1. Revenue per customer per year. If a customer pays $1,000/year, that is your starting point. 2. Cost of goods sold (COGS). Hosting at $100/customer/year plus payment processing at $50 equals $150 COGS. 3. Gross margin per customer. $1,000 minus $150 equals $850 per customer per year. 4. Total gross profit. Multiply by customer count. 1,000 customers = $850,000 in gross profit.
From that gross profit, you pay for engineering, marketing, support, and all other operating costs.
A Healthy SaaS Unit Economics Example
Here is what good SaaS unit economics look like:
- CAC: $500 (cost to acquire one customer)
- Monthly price: $200/month
- Monthly COGS: $30/month
- Monthly gross margin: $170/month
- Average customer lifespan: 24 months
- LTV: $170 x 24 = $4,080
- LTV:CAC ratio: 8.2:1
This is a healthy business. You can scale it confidently.
If your unit economics do not work, you cannot scale your way to profitability. If it costs $1,000 to acquire a customer and the customer pays you $50 total, adding more customers makes you poorer. Fix unit economics by increasing price, decreasing cost to serve, or reducing CAC. Work on this until the math works.
Building a Simple Revenue Model
Most founders either build no financial model or build an overcomplex model full of fantasy numbers. The right answer is in between.
The Three Components
A simple revenue model has three components:
1. Number of customers (or user accounts) 2. Average revenue per customer (ARPU) 3. Total revenue = customers x ARPU
Making Realistic Growth Assumptions
Start with what you know. If you have 50 customers today and add 10 new customers per month, you can project forward. But do not assume 20% month-over-month growth forever. Growth slows.
A realistic assumption curve: - Year 1: 20% monthly growth (you are finding product-market fit) - Year 2: 15% monthly growth (market is getting harder) - Year 3: 10% monthly growth (you are at scale)
Project two years out, maximum. Anything beyond two years is guessing.
The Three-Scenario Approach
Build three versions of your revenue model:
- Base case: What you think will happen if things go as expected
- Optimistic case: Growth is faster, ARPU is higher, everything clicks
- Conservative case: Growth is slower, churn is higher, marketing costs more
Investors want to see all three scenarios. It shows you have thought about what could go right and wrong. Even in the conservative case, the business should be viable.
Expense Forecasting
Your expenses have two categories.
Fixed Costs (Do Not Change With Customer Count)
- Founder and co-founder salaries
- Office rent (if applicable)
- Insurance
- Software subscriptions (Slack, GitHub, etc.)
- Most early-stage companies: $30,000 to $50,000/month in fixed costs
Variable Costs (Scale With Customers)
- Payment processing: 2% to 3% of revenue
- Cloud hosting: scales with usage
- Customer support: more customers, more tickets
- Total these as a percentage of revenue. If variable costs are 20% of revenue and you forecast $1 million in annual revenue, budget $200,000 in variable costs.
Hiring: Revenue-Driven, Not Capital-Driven
Many founders assume they will hire immediately after raising capital. This is often a mistake. Instead, forecast hiring based on when revenue demands it.
Example: If one engineer can support 500 customers and you forecast reaching 500 customers in month six, hire in month five. Do not hire until you need the person. Keep fixed costs as low as possible for as long as possible.
How Investors Actually Read Your Model
Investors do not trust your revenue forecast. They have seen too many founders projecting hockey stick growth and then missing targets by 90%. They assume your revenue projection is wrong.
What investors actually look at:
- Do the unit economics make sense? Can you actually acquire a customer for $500? Can you retain them for three years? Can you serve them profitably?
- Is the LTV:CAC ratio healthy? If it is 5:1, investors trust the rest can work. If it is 1:1, the business is broken.
- Are expense assumptions realistic? Are you assuming a finance team of five when you have $2 million in revenue? That seems inefficient. Are you assuming five employees forever? That will not scale.
The forecast itself is less important than the thinking behind it. If the unit economics work, investors do not care if your revenue forecast is off by 50%. You can still build a valuable company. If the unit economics do not work, the revenue forecast is irrelevant.
When to Update Your Model
Do not update your financial model every month. That is too frequent and leads to false precision.
Update quarterly when you have actual data. Or update when something major changes:
- You reach product-market fit
- You double your price
- You launch a new product line
- You are about to pitch investors
When you update, adjust assumptions based on actual results. If you forecasted 10% MRR growth and delivered 7%, adjust future forecasts down. If you forecasted CAC of $500 and achieved $300, adjust that down too. Let reality inform your next forecast.
Show investors your latest version. If you have more traction since the last version, the new model will reflect that. Progress builds confidence.
Related Guides
How to Bootstrap a Startup Without Venture Capital
Not every startup needs VC money. Learn how to bootstrap a profitable business with real revenue, lean operations, and full ownership.
How to Build Your Investor Pipeline Before You Need Money
Start building investor relationships before your raise. Learn how to create a warm pipeline so capital is ready when you are.
The Founder's Guide to Seed Fundraising
A complete guide to raising your seed round. Build your investor pipeline, nail your pitch, negotiate terms, and close the wire.
Need help with financial strategy?
We build financial systems and growth infrastructure for startups. Let's talk.