Financial Modeling
Financial modeling playbook for startups: assumptions, revenue build, cohort economics, and investor-ready outputs.
75 articles
Three-Scenario Modeling for Startups: Base, Optimistic, and Pessimistic Cases
Master three-scenario modeling to stress-test your startup's financial projections and prepare for multiple outcomes.
Depreciation and Amortization: Non-Cash Expenses and Financial Impact
Depreciation and amortization are non-cash expenses that reduce profit but don't affect cash flow. Understanding how they work is critical for accurate financial modeling.
Accounts Receivable: Modeling Customer Payment Timing
Accounts receivable represents money customers owe you. Understanding collection timing and modeling A/R accurately is critical for cash flow planning and startup survival.
Revenue Recognition: When Income Appears on Your P&L
Revenue recognition determines when you record income on your P&L, and it's governed by strict accounting standards. Mishandling revenue recognition creates audit issues and…
Connecting the Three Statements: Financial Reconciliation Mechanics
The three financial statements—income statement, balance sheet, and cash flow—are interconnected. Learning to reconcile them ensures your financial model is accurate and catches…
Income Statement (P&L) Fundamentals: Revenue, Expenses, and Profit
The income statement (P&L) shows your company's revenues, operating expenses, and bottom-line profit. Understanding this core financial statement is essential for tracking…
Financial Model Documentation: Explaining Your Assumptions to Investors
Master financial model documentation: explain assumptions clearly, build credibility with investors, and prevent misunderstandings. Learn how to document models so investors…
Operating Leverage: The Path to Startup Profitability Explained
Master operating leverage: the mechanism by which increasing revenue enables decreasing costs as percentage of revenue. Learn how to achieve operating leverage and build a path…
Seasonal Adjustments in Startup Revenue Forecasting
Master seasonal revenue patterns in your industry. Learn how to adjust forecasts for seasonality, build accurate month-by-month models, and manage cash through seasonal peaks and…
Sensitivity Analysis: Testing Assumptions and Business Levers
Master sensitivity analysis to stress-test financial assumptions and identify critical business levers. Learn how to build scenario models that reveal which variables most impact…
Expense Projections: Modeling Headcount and Startup Cost Structure
Master expense modeling by building detailed headcount plans and understanding fully-loaded costs. Learn how successful startups control burn rate, optimize cost structure, and…
Revenue Projections: Bottom-Up vs Top-Down Forecasting for Startups
Master two approaches to revenue forecasting: bottom-up (from customer acquisition plans) and top-down (from market sizing). Learn when to use each and how to reconcile them for…
Bookings vs Revenue: Understanding SaaS Cash Flow Timing
Understand why bookings and revenue differ in SaaS accounting. Master the timing gap between cash received and GAAP revenue recognition to build accurate financial models and…
Cohort Analysis: Tracking Customer Performance by Acquisition Month
Master cohort analysis for SaaS. Learn how to segment customers by acquisition month, track retention and expansion, identify trends, and use cohort data to guide product and…
The SaaS Magic Number: Measuring CAC Efficiency and Growth Speed
Understand the SaaS Magic Number metric, how to calculate it, why investors use it to evaluate growth efficiency, and how to optimize your business to achieve and sustain high…
Annual Contract Value (ACV) and Customer Segmentation for SaaS
Master ACV calculations, segment customers by contract value, and understand how ACV impacts go-to-market strategy, sales model decisions, and profitability targets.
Dollar Based Net Retention: Why It Matters More Than New Sales
Understand dollar-based net retention (DNRR), how it differs from other retention metrics, why it matters more to SaaS growth than new customer sales, and how to build it into…
Net Revenue Retention: The True SaaS Growth Metric Investors Love
Understand net revenue retention (NRR), how it differs from churn rate, why investors obsess over this metric, and how to calculate and improve it to demonstrate durable SaaS…
Churn Rate Calculation: Monthly and Annual Cohort Analysis for SaaS
Master churn rate calculations for SaaS companies. Learn monthly vs. annual cohort analysis, interpret the metrics that matter most, and discover why understanding churn is…
MRR Monthly Recurring Revenue: The Daily Pulse of SaaS Finance
MRR (Monthly Recurring Revenue) is the monthly revenue from active subscriptions. Calculate as sum of monthly subscription values or ARR divided by 12. Track MRR trends, growth…
Convertible Note Pro Formas: Modeling Conversion Scenarios Step by Step
Pro formas project how convertible notes impact your cap table at Series A conversion. We walk through building models, stress-testing scenarios, and using them to inform funding…
Seasonal Burn Rate Variation: Managing Cash Through Business Cycles
Most startups treat burn rate as a constant monthly metric. In reality, seasonality creates dramatic swings in cash requirements. Managing through seasonal cycles requires…
Co-Founder Departure: Managing Equity When Founders Leave
Founder departures trigger: vesting acceleration (unvested forfeited), equity repurchase options, non-compete negotiation. With vesting, company retains unvested shares. Key…
Founder Equity Splits: How to Allocate Fair Initial Shares
Equal splits (50-50, 33-33-33) simplest but ignore contribution asymmetry. Framework: assess idea ownership, sweat equity contribution, ongoing time commitment, domain expertise,…
Cap Table Modeling Tools: Spreadsheet vs Software Comparison
Excel/Google Sheets: free, flexible, error-prone. Cap table software (Pulley, Carta, Captable.io): $50-500/mo, automation, audit trails, integration. Spreadsheets work for seed,…
SAFE Agreement Mechanics: Why It Is Not Equity Yet
SAFEs are post-money equity agreements with no debt, interest, or maturity dates. They convert to equity only at priced round or acquisition. On cap table: don't count as shares…
Advisor Equity: Common Grant Sizes and Vesting Schedules Explained
Strategic advisors typically receive 0.25-1% of fully diluted equity in options. Vesting: 2-4 year vest with 6-month or 1-year cliff. Board advisors (non-employee) often…
Employee Stock Option Pool: Sizing for Startup Growth Stages
ESOP sizing depends on growth stage. Seed stage: 10-20% of fully diluted cap table. Series A: 15-20%. Series B+: 10-15%. Most startups reserve new tranches each funding round to…
Series A Cap Table Impact: Common Stock vs Preferred Stock Explained
Series A introduces Preferred Stock with liquidation preferences that significantly affect cap table mechanics and exit outcomes. Understanding the distinction between Common…
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…
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…
Sensitivity Analysis for Startups: How to Stress-Test Your Financial Model
Two-variable matrix approach, which variables matter most, typical test ranges, and how investors use sensitivity tables during due diligence.
Three-Scenario Planning for Startups: Base, Bull, and Bear Case Modeling
How to construct base, bull, and bear cases with real multipliers. What 20% revenue variance does to runway, and when to trigger contingency plans.
Startup P&L Guide: How to Build a Profit and Loss Statement Investors Trust
Gross margin benchmarks by model (SaaS 70-85%, marketplace 40-65%), OpEx breakdown, operating margin by stage, and COGS definitions by business type.
Startup Headcount Planner: How to Model Team Costs and Hiring Timelines
Loaded cost multipliers by geography, salary benchmarks by role, team composition by stage, and revenue per employee targets for efficient startups.
AI-Powered Financial Forecasting: What Works, What Does Not, and What Is Coming
AI can accelerate model building and scenario analysis. It cannot replace understanding business mechanics.
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.
You Do Not Need to Be a Genius With Excel Anymore. AI Does That Now.
AI tools have fundamentally changed what a financial analyst or modeller can accomplish alone. Tasks that previously required hours of manual work --- building model structure,…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
What Happens When Investors Challenge Your Numbers (And How to Win the Conversation)
Every investor will challenge your financial model. It is not hostility; it is their job. The founders who raise successfully are not the ones with unchallenged models. They are…
Seed Round vs. Series A: How Your Financial Model Must Change Between Stages
The financial model that closes a seed round and the financial model that closes a Series A are fundamentally different documents. A seed model is a hypothesis: it demonstrates…
The B2B2C Marketplace Bible: The Definitive Operating Guide for Founders
The definitive guide to building B2B2C marketplaces. Covers cold start, unit economics, pricing, supply management, enterprise sales, technology, financial modeling, fundraising,…
The SaaS Financial Modeling Bible: The Complete Guide for Founders
The definitive guide to building SaaS financial models. Covers revenue modeling, cost structure, unit economics, scenario planning, and investor-ready presentation. From pre-seed…
Scenario Planning: Best Case, Base Case, Worst Case for Startups
Master scenario planning for startups: build best case, base case, and worst case financial models. Scenario analysis reveals business model resilience and identifies critical…
How to Build a Three-Statement Financial Model for Startups
Build a three-statement financial model integrating income statement, balance sheet, and cash flow statement. Startup financial models require monthly detail, revenue…
Financial Modeling Best Practices: Assumptions That Kill Startups
Master financial modeling best practices: avoid toxic assumptions about customer acquisition, unit economics, and growth rates. Stress-test models with realistic benchmarks and…
How to Build a Hiring Plan That Aligns With Your Budget
Master startup hiring planning: build headcount budgets aligned with revenue. Create hiring plans that balance growth and burn rate to extend runway.
Startup Cash Flow Forecasting: A Practical Framework
Master startup cash flow forecasting with 13-week projections and 24-month models. Understand burn rate, runway, and cash timing to extend your funding window.
How to Model Churn and Its Impact on LTV
Master churn rate modeling and LTV calculation. Understand cohort analysis, predict customer lifetime value, and build retention strategies that multiply revenue.
Building a Bottom-Up Revenue Forecast for Your Startup
Bottom-up revenue forecasting starts with customer acquisition assumptions (how many customers, at what price) and builds month-by-month projections. This approach is more…
How to Create a Startup Budget: From Zero to Series A
A startup budget projects expenses across hiring, infrastructure, and marketing for 12-24 months. Build bottom-up by estimating line items (salaries, tools, rent), model multiple…
Startup Burn Rate: How to Calculate and Manage Cash Runway
Burn rate is your monthly cash outflow; calculating it reveals how long your startup can operate with current funding. Founders must distinguish between gross and net burn, track…