Financial Modeling
Build financial models that tell a coherent story to investors. From driver-based revenue modeling and headcount planning to P&L statements and scenario analysis, these articles cover the complete framework for creating models that withstand investor scrutiny.
How to Build a 5-Year Financial Model for Your Startup
A financial model projects your revenue, expenses, and cash runway for five years. Investors expect three statements: P&L, cash flow, and balance sheet. Use bottom-up forecasting (
The 7 Formula Errors I Find in Every Founder's Financial Model
After auditing dozens of startup financial models, the same mistakes appear almost every time. Seven errors from blank subtotals to inconsistent formulas, with how to find and fix
Headcount Planning by Stage: From Pre-Seed to Series A, What is Realistic
Month-by-month headcount plans at $500K, $1.5M, $2.5M, and $5M raise sizes. Five rules for every stage: map hires to milestones, founders do everything first, budget 1.25-1.50x bas
The Revenue Recognition Trap: When Your Books and Your Bank Account Disagree
Revenue recognition and cash collection are different. Deferred revenue, payment terms, and AR aging create gaps.
Expanding Internationally: Tax, Currency, and Multi-Entity Financial Modeling
Multi-market businesses require separate models per geography. CAC, LTV, and margins vary dramatically by market.
Runway vs. Profitability: Which Path Is Right for Your Business at Each Stage
Pre-seed and seed stages focus on runway and capital efficiency. Series A focuses on growth while managing burn.
Building Your Runway Model: A Month-by-Month Survival Guide
Runway is how many months you can operate with current cash. Formula: Current cash divided by Monthly burn equals Runway in months.
From Model to Board Report: Keeping the Spreadsheet Alive Post-Raise
The financial model that closed the round is not the model that runs the company. Post-raise, the model transitions from a fundraising instrument to an operational tool: a living d
How to Update Your Model Mid-Fundraise Without Losing Consistency
Updating a financial model mid-fundraise is not only common, it is expected. Investors ask questions that reveal gaps. New monthly data comes in. Pricing assumptions get challenged
Financial Model Red Flags: What Breaks Investor Confidence
Financial models fail investor diligence not because the business is bad, but because the model signals that the founder does not understand the business well enough to defend it.
How to Model Pre-Revenue Startups
A pre-revenue startup cannot model historical unit economics because there are none. What it can model is the path to first revenue, the cost structure required to get there, the a
The Balance Sheet Founders Skip (And Why That's a Mistake)
Most startup financial models have a P&L and a cash flow statement. Very few have a properly constructed balance sheet. This matters because the balance sheet is the document that
Excel vs. Google Sheets for Startup Financial Modeling: The Honest Answer
Excel is the standard for serious financial modelling and investor-facing work. Google Sheets is faster to collaborate on and easier to share, but hits performance and formula limi
How to Audit Your Financial Model Before Sharing It With Investors
A financial model that has not been audited before it goes to investors is a liability. Errors, inconsistencies, and broken links that you did not catch will be caught in diligence
Sensitivity Analysis: Pre-Building the Questions Investors Will Ask
Sensitivity analysis is the practice of testing how your model outputs change when key input assumptions change. Done well, it pre-answers the most important investor questions bef
How to Model Gross Margin for Different Business Models
Gross margin is the first number sophisticated investors check in a financial model, and the benchmark they use depends entirely on your business model. A 60% gross margin is excep
Multi-Currency Financial Models: How to Run Finance Across UK, US, and Europe
Running a startup across multiple currencies is not just an accounting complexity --- it creates real economic exposure that will affect your P&L, your runway calculation, and your
SaaS vs. Marketplace Financial Models: The Key Differences That Change Everything
SaaS and marketplace businesses look similar on the surface: they are both technology-enabled, both have recurring revenue characteristics, and both are venture-fundable. But their
How to Model a Two-Sided Marketplace: A Complete Financial Model Guide
A marketplace financial model is fundamentally different from a SaaS model because you are modeling two interdependent customer groups, not one. Supply and demand interact: the val
How to Build Three Scenarios That Prove You Have Actually Thought About What Could Go Wrong
Every investor-ready financial model needs at least three scenarios: conservative, base, and aggressive. A single-scenario model tells investors you have not stress-tested your own
The Cash Flow Statement Founders Always Get Wrong
Profit is an accounting concept. Cash is what keeps your company alive. The cash flow statement is the bridge between the two, and it is the statement that most first-time founders
COGS vs. OpEx: Why Getting This Wrong Destroys Your Gross Margin Story
Cost of Goods Sold (COGS) is what it costs to deliver your product or service to one additional customer. Operating Expenses (OpEx) is what it costs to run the company regardless o
How to Build a Headcount Plan That Investors Trust and Founders Can Actually Use
Headcount is typically 60-80% of a startup's burn rate, and yet most founders model it as a single line: "Salaries: $800K." That is not a plan. It is a number with no structure beh
The Assumptions Tab: The Most Important Sheet in Your Entire Financial Model
The assumptions tab is a single, dedicated sheet where every key input in your financial model lives, documented with its value, source, date, and rationale. It is the first tab an
The Cohort Method for Revenue Forecasting: The Most Accurate Way to Predict Startup Revenue
Cohort-based revenue forecasting groups customers by the month they were acquired and tracks each group's revenue contribution over time. It is the most accurate forecasting method
Driver-Based Modeling: Build Revenue From Reality, Not From Hope
Driver-based modeling means your financial outputs are calculated from the real operational inputs of your business: leads, conversion rates, average deal size, churn, hiring pace.
How to Build a Financial Model for Your Startup (2026 Guide)
A startup financial model is a driver-based forecast of revenue, costs, and cash flow that investors use to evaluate your business --- and founders use to make decisions. The best