Financial Modeling Basics
Build financial models that help you make better decisions and communicate clearly with investors. Learn to create revenue forecasts, expense budgets, cash flow projections, and scenario analyses that stand up to scrutiny.
What You'll Learn
- ✓Build a bottom-up revenue forecast based on realistic assumptions
- ✓Create an expense budget that accounts for fixed and variable costs
- ✓Project cash flow and determine when you will need additional funding
- ✓Use scenario analysis to stress-test your model with optimistic, base, and pessimistic cases
Revenue Forecasting
Start with a bottom-up approach by estimating how many customers you can acquire each month and what they will pay. Factor in churn, expansion revenue, and seasonality. A good revenue forecast clearly states its assumptions so that anyone reviewing it can evaluate whether those assumptions are reasonable.
Expense Budgeting
Categorize expenses into fixed costs like rent and salaries and variable costs like hosting and payment processing that scale with revenue. Do not forget to include hiring plans, because people costs typically represent 60% to 80% of a startup's burn rate. Build in a 10% to 15% buffer for unexpected expenses.
Cash Flow Projections
Cash flow is not the same as profit. Your model must track when cash actually enters and leaves the business. Payment terms, prepaid annual contracts, and delayed receivables can create significant gaps between revenue on paper and cash in the bank. Always project your runway in months.
Scenario Analysis
Build three scenarios: optimistic, base case, and pessimistic. Vary your key assumptions like growth rate, churn, and CAC across each scenario. This shows investors you have thought critically about risks and gives you decision triggers for when to accelerate spending or cut costs.
Key Takeaways
- ★People costs typically represent 60% to 80% of a startup's total burn rate
- ★The most common modeling mistake is confusing revenue with cash flow
- ★Investors expect three-year projections at minimum and five years for later-stage rounds
- ★Bottom-up forecasts are more credible because each assumption can be independently verified
- ★Monthly granularity is essential for the first 18 to 24 months of a financial model
Check Your Understanding
Why is cash flow different from profit in a startup context?
Profit is an accounting concept based on when revenue is earned and expenses are incurred. Cash flow tracks when money actually moves. A profitable startup can run out of cash if customers pay on 90-day terms but expenses are due immediately.
What is the purpose of scenario analysis in a financial model?
Scenario analysis stress-tests your model by varying key assumptions. It helps you understand your range of outcomes, identify the assumptions that matter most, and create decision triggers for adjusting strategy based on actual performance.
How do you determine startup runway from a financial model?
Divide your current cash balance by your monthly net burn rate (total expenses minus total revenue). The result is the number of months before you run out of money. Most advisors recommend maintaining at least six months of runway at all times.
Frequently Asked Questions
Everything you need to know about BusinessIQ
Spreadsheets like Google Sheets or Excel remain the standard for startup financial models. They offer flexibility, are easy to share, and investors are comfortable reviewing them. Specialized tools can help but are not necessary for early-stage companies.
No one expects perfect accuracy. What matters is that your assumptions are clearly stated, internally consistent, and grounded in real data. Investors evaluate the quality of your thinking, not whether you hit exact numbers.
Apply This to Your Plan
BusinessIQ turns these concepts into a real business plan tailored to your idea.
Get BusinessIQ