Building a Simple Financial Model
A non-intimidating guide to projecting revenue, expenses, and break-even for your first year — no spreadsheet degree required.
Why You Need a Financial Model
A financial model isn't a crystal ball — it's a structured way to think through whether your business makes sense financially before you spend a lot of money finding out.
Even a rough model forces you to answer questions you might otherwise avoid:
- ›How many customers do I need to break even?
- ›What happens to my margins if my costs go up 20%?
- ›When do I run out of cash?
The Three Core Statements
A full financial model has three statements. Here's what each does:
1. Profit & Loss (P&L) / Income Statement — Shows revenue minus expenses = profit or loss over a period of time.
2. Cash Flow Statement — Shows actual cash moving in and out. A business can be "profitable" on paper but run out of cash — this statement shows you when.
3. Balance Sheet — A snapshot of what you own (assets), what you owe (liabilities), and what's left (equity). Less critical at the early stage.
For most early founders, focus on the P&L and cash flow.
Building Your Revenue Projection
Start with the simplest possible model:
Units × Price = Revenue
Example: If you sell 50 coaching sessions per month at $150 each, that's $7,500/month revenue.
Build monthly projections for 12 months. Start conservatively — it always takes longer to ramp than you think.
Ask yourself: "What does it take to achieve this number?" If you need 50 clients, how do you get them? This keeps your model honest.
Listing Your Costs
Separate costs into two types:
Fixed costs — The same every month regardless of sales: rent, software subscriptions, insurance, loan payments, your own salary.
Variable costs — Change with your sales volume: materials, shipping, transaction fees, contractor pay, commissions.
Add them up for a monthly cost total.
Finding Your Break-Even Point
Break-even is when revenue = total costs. Before break-even, you're losing money. After, you're profitable.
Formula: Break-Even Revenue = Fixed Costs ÷ Gross Margin %
Example: Fixed costs of $3,000/month, a product that sells for $100 and costs $40 to deliver (a 60% gross margin) breaks even at $3,000 ÷ 0.60 = $5,000/month revenue (50 units).
Now try it with your own numbers below.
Your Break-Even Point
Contribution margin
$30 / unit
60.0% of price
Break-even units
100 / month
Break-even revenue
$5,000 / month
The Cash Flow Column
Even if your P&L looks profitable, check your cash. Track:
- ›When does revenue actually hit your bank account? (customers may pay late)
- ›When are your big expenses due? (annual insurance, quarterly taxes)
A business can be profitable and still run out of cash. This is the #1 surprise for new founders.
Key Takeaways
- ›A simple P&L and cash flow projection is enough to start — build it in a spreadsheet
- ›Revenue projections should be conservative and tied to a plan to acquire customers
- ›Know your break-even number and work backwards to a sales goal
- ›Model "what if" scenarios: what if revenue is 30% lower than expected?
- ›Update your model every month with actual numbers
Discussion & questions
Ask a question about this lesson or share your take.
Loading…