How to Build a Series A Financial Model from Scratch
A Series A financial model is not a spreadsheet exercise—it is the quantitative expression of your business thesis. Investors will spend hours in your model asking what-if questions, and the quality of your model directly affects their confidence in your financial management capability. Build it to withstand that scrutiny.
Model Architecture: Start with Structure
A Series A model must be a fully integrated three-statement model: income statement, balance sheet, and cash flow statement, all driven from a single set of assumptions that feed through the model mechanically. A model where revenue projections are in one tab, the P&L in another, and the cash flow in a third that is manually linked is not a model—it is three spreadsheets pretending to be a model. Start with the assumptions tab: a single, clearly organized page that contains every material assumption in the model. Revenue growth rates by segment, gross margin assumptions, headcount plan by department, OpEx growth rates, working capital assumptions, and capital expenditure plan should all live here. When an investor changes an assumption, the entire model should update instantly and consistently. The income statement should roll from the revenue build (detailed customer-level or segment-level revenue drivers) through gross margin to each operating expense line, producing EBITDA, and then through depreciation, interest, and taxes to net income. Every line should be a formula referencing the assumptions tab—no hard-coded numbers anywhere except in the historical actuals. The balance sheet and cash flow statement should tie to the income statement completely. A model where the three statements balance is a model that can be trusted; a model with unexplained gaps between net income and cash flow, or that does not balance, signals that the modeler does not understand basic accounting. Investors will notice immediately.
Revenue Model: The Foundation of Everything
The revenue build is the most important part of the Series A model and the part investors will scrutinize most intensively. Build your revenue from the drivers of your specific business model, not from a top-down growth rate assumption. For a SaaS business, the revenue build should model: beginning ARR by segment, new ARR from new logos (number of new customers × average ACV), expansion ARR from existing customers (net expansion rate × prior period ARR), and churned ARR (churn rate × prior period ARR). This cohort-based model is standard for SaaS businesses; deviating from it will require explanation. For a transactional or marketplace business, model the key volume drivers: active customers, orders per customer per period, average order value. For a services business, model utilization rates, headcount, and average billing rate. Whatever the business model, the revenue build should connect directly to the operational drivers—it should be possible to trace every revenue assumption back to a specific operational action. The most common Series A revenue model mistake is projecting growth rates based on the historical growth rate applied forward. Investors know that early-stage growth rates are rarely sustainable, and they will ask what specifically will maintain or accelerate growth as the business scales. Your revenue model should reflect the answer to this question—new market expansion, new products, additional sales capacity—not just an extrapolation of recent history.
Unit Economics: The Investor's Primary Lens
At Series A, investors evaluate unit economics more than top-line growth. A business growing 150% per year but with deteriorating unit economics is not fundable at institutional rates; a business growing 60% with demonstrably improving unit economics is. The three unit economics metrics every Series A investor will calculate are: Customer Acquisition Cost (CAC), Customer Lifetime Value (LTV), and payback period. Your model should produce these metrics explicitly, not require the investor to calculate them from first principles. CAC is total sales and marketing spend divided by the number of new customers acquired in the period. But calculate blended CAC (all channels combined) and segmented CAC (by channel, by customer size, by geography) so you can show investors that you understand where your most capital-efficient growth is coming from. LTV is gross profit per customer per year divided by churn rate—or equivalently, average contract value × gross margin percentage ÷ churn rate. The numerator matters as much as the denominator: high-LTV businesses have high gross margins, not just low churn. Show the trend in LTV over recent cohorts—improving LTV cohort-over-cohort is one of the strongest signals of a compounding business model. Payback period is CAC divided by gross profit per customer per month. Target payback periods below 18 months for venture-scale businesses; payback periods above 24 months require exceptional LTV or exceptional growth characteristics to attract institutional capital.
Headcount and Operating Expense Planning
Headcount is the largest operating expense for most SaaS businesses and the assumption investors will probe most deeply after revenue. Build a headcount model that shows every planned hire by role and quarter, the timing of each hire relative to the revenue or operational milestone that justifies it, and the fully-loaded cost (salary plus benefits plus equity amortization) for each role. Do not model headcount as a percentage of revenue—model it from first principles. If you plan to hire 4 enterprise sales reps in Q3, explain why 4 (not 2 or 8), when you will hire them (which quarter), and how much quota you expect each to carry within their first year. Investors who see headcount models built from first principles trust the management team's operational thinking; investors who see headcount as "18% of revenue" see a team that has not thought through its operating model. OpEx beyond headcount (software, marketing, T&E, professional services) should also be modeled from first principles wherever possible. Marketing spend should be linked to the CAC and growth model—if you are planning to spend $500K on marketing in year 2, show the customer acquisition that spending is expected to produce. G&A should be modeled as a function of scale milestones (adding financial systems, audit, insurance at specific revenue thresholds) rather than as a steady percentage of revenue.
Frequently Asked Questions
How many years should a Series A model cover?
Three years of projections (the current year plus two more) is standard. Investors know that year 3 projections are highly uncertain, but they need them to model exit scenarios and assess whether the business can reach the scale that justifies the investment. Some investors prefer five-year models for capital-intensive businesses where the return horizon is longer.
Should we build the model in Excel or a purpose-built FP&A tool?
Excel or Google Sheets for the fundraising model—investors have their own Excel models and will want to download and modify yours. Purpose-built FP&A tools (Mosaic, Cube, Planful) are valuable for ongoing operational planning but are not the right format for investor-facing models that need to be downloaded, shared, and modified easily.
How do we present the model to investors?
Present a summary of the model (key metrics, revenue build, unit economics) in the pitch deck. Provide the full model as a downloadable Excel file in the data room after the NDA is signed. Be prepared to walk through the model in a dedicated 60-minute financial deep-dive meeting with the investing partner and their analyst.
Related Articles
What a Fractional CFO Actually Does (vs. Your Bookkeeper)
Most early-stage companies confuse bookkeeping with financial leadership. A bookkeeper records what happened; a fractional CFO shapes what happens next. Understanding the difference—and knowing when your business needs which—is one of the most important financial clarity decisions a founder or CEO makes.
Read →
The Monthly Close Process: A CFO's Step-by-Step Guide
The monthly financial close is the operational heartbeat of the finance function. A clean, timely close process produces the reliable financial data that drives management decisions, satisfies investor reporting requirements, and creates the foundation for an annual audit. Most companies close too slowly and too inconsistently—here is how to fix that.
Read →
Cash Flow Management for High-Growth Companies
High-growth companies can be simultaneously profitable on paper and perilously close to running out of cash. Understanding the mechanics of cash flow—and building the management systems that ensure cash visibility before it becomes a crisis—is one of the most important financial disciplines a CFO can instill.
Read →
The Crimson Bench · Est. 2002 · Founded in New York City
Deploy an Executive in 48 Hours
Verified corporate accounts only. Ivy League-educated. Flat-rate pricing. 14-day no-cause cancellation.
25,000+ Ivy League Executives · 150,000+ Global Consultants · 48-Hour Deployment