How To Build an Investor-Ready Fundraising Model

Published by Andrew Cohen, CFA, CPA on September 14, 2026

Key Takeaways

A fundraising financial model needs monthly detail for the first 18–24 months to pass investor diligence and show true runway.
Bottom-up revenue drivers, a clear headcount plan, and fully loaded opex connect day-to-day operations to the capital ask and dilution.
Investors review MRR/ARR, gross margin, CAC payback, churn, burn rate, and revenue per employee to judge growth quality and scalability.
Runway planning should use a three-month trailing average net burn, with 18–24 months of post-close runway and a 15–20% buffer.
Condesa Financial Group helps founders build and defend investor-ready models, so schedule a free consultation before your next investor conversation.

Set Up The Basics Before You Open The Model

The model needs context before you start building tabs. Define these elements first:

Stage and instrument. Pre-seed, seed, and Series A rounds have different metric expectations and legal instruments. A post-money SAFE and a priced preferred round create different cap table outcomes.
Current cash position and monthly burn. These two numbers define your remaining time and how quickly the model must be ready.
Existing cap table and option pool. Outstanding SAFEs, convertible notes, and the current option pool size all shape dilution at conversion.
The milestone this round funds. Revenue, product, team, or customer milestones define the model’s endpoint and the ask size.

The model’s architecture depends on several variables: business model, revenue granularity, headcount plan, geographic complexity, entity structure, and who owns finance work. Business model matters most because it sets revenue drivers, COGS treatment, and cash timing. A SaaS model and a real estate development model share a three-statement structure but diverge sharply in how revenue is recognized and when cash arrives.

Founders can often build a first-pass model in-house if they know Excel or Google Sheets and understand their unit economics. Outside financial modeling, FP&A, or fractional CFO support becomes useful when the model must survive institutional diligence, when no finance leader exists to pressure-test assumptions, or when a self-taught predecessor left a fragile model that needs a rebuild.

Condesa Financial Group is a price-competitive fractional CFO and outsourced accounting firm with nearshore teams in Panama and Mexico City staffed by ex-Big 4 talent. Condesa built the financial models Ecuador’s largest real estate developer used to raise $20M and $80M for two projects, and both rounds closed successfully. For founders who need the model built and defended, the starting point is a free consultation via the Contact Us form.

Speak with an ex-Big 4 finance professional about your fundraising model and diligence readiness.

Core Components Of An Investor-Ready Fundraising Model

Investor-ready fundraising models use monthly granularity for the first 24 months, then quarterly detail for years 3 through 5. Annual-only models struggle when intra-year timing matters, such as tight cash runway, seasonal revenue, phased hiring, or covenant tests. Stable, mature businesses can sometimes rely on annual views, while fundraising models use monthly detail in year one and quarterly views later.

A complete fundraising financial model includes seven components:

Executive dashboard. A one-tab summary of key outputs such as MRR, burn, runway, headcount, and gross margin that updates when assumptions change.
Three statements. A monthly P&L, balance sheet, and cash flow statement. Together they show value creation, survivability, and what the company owns and owes.
Bottom-up revenue drivers. Revenue tied to specific sales and pricing levers instead of a top-down market-share percentage.
Headcount plan. Every hire dated, department-tagged, tied to a revenue or product milestone, and costed on a fully loaded basis.
Opex build. Software, infrastructure, facilities, travel, and professional fees that scale with revenue instead of staying flat.
Scenario analysis. Downside, base, and upside cases driven by operational changes rather than a simple topline adjustment.
Cap table and dilution schedule. SAFEs, convertible notes, option pool, and the next round’s conversion tracked in one place.

With those seven components in mind, the sequence below shows how to build them in a logical order.

How To Build The Model: A Step-By-Step Sequence

Step 1: Document Your Assumptions

Create a dedicated assumptions tab. Every driver such as churn, conversion rates, average contract value, headcount timing, and COGS percentage lives there. Avoid hardcoding numbers in the model body. Completion criterion: changing churn from 5% to 7% updates the entire model automatically.

Step 2: Build Revenue Bottom-Up

Bottom-up revenue uses the core formula Revenue = Price × Quantity, customized by industry. For example, e-commerce often uses Orders × Average Order Value, while SaaS often uses Subscriptions × Monthly Fee or Units × Output per Unit × Price. Use grounded conversion rates. For SaaS, a realistic demo-to-close rate usually falls around 10%–20%, with 20% or more desirable, so 25% sits above typical benchmarks. Completion criterion: revenue ties back to specific sales and pricing levers instead of a market-share guess.

Step 3: Build The Headcount Plan

Headcount usually drives the largest cash outflow. Include fully loaded costs such as payroll taxes, benefits, and equipment, not just salary. In a downside case, a single fully loaded hire can cut runway by roughly three months once salary, tax, benefits, tooling, management bandwidth, and opportunity cost are included. Completion criterion: every hire has a start date, department tag, and link to a revenue or product milestone.

Step 4: Build Operating Expenses

List software, infrastructure, facilities, travel, and professional fees. For growth firms with roughly $5M–$20M revenue, Sales and Marketing often becomes the largest opex category, reaching 40%–60% of revenue in the $5M–$10M band. Completion criterion: opex scales with revenue instead of remaining flat.

Step 5: Roll Up To The P&L

Link revenue, COGS, and opex into a monthly P&L. For SaaS, COGS such as hosting, third-party software, and customer support salaries typically run 15–25% of revenue for subscription-only or private B2B SaaS, while public SaaS companies showed a median of about 26% in 2024. Completion criterion: monthly gross margin and EBITDA are visible, and the J-curve shows profitability in Year 4 or 5 instead of Year 2.

Step 6: Build The Cash Flow Statement

Cash timing often breaks otherwise solid models. Annual prepays, quarterly collections, and working capital move cash differently from revenue recognition. Completion criterion: ending cash by month reconciles to the balance sheet.

Step 7: Build The Cap Table And Dilution Schedule

Track SAFEs, the option pool, and the next round’s conversion before you launch the raise. Completion criterion: you can state post-round ownership without opening a separate file.

Step 8: Build Downside, Base, And Upside Scenarios

Use a single scenario toggle cell, such as a Data Validation dropdown, that assumption cells reference via INDEX/MATCH. This structure audits more easily than nested IF statements. Build scenarios from operational variations such as churn rising 2–3 points, a key hire slipping four months, or pipeline dropping 40% for two quarters. Avoid simple flat topline haircuts. Completion criterion: switching scenarios requires one cell change and runs in seconds.

Have Condesa’s ex-Big 4 team build this sequence for your raise; the team delivers the model and defends it in the data room.

What Investors Actually Look For In A Financial Model

Investors use the model to test assumptions, not to review formatting. Each metric answers a specific question about the business.

MRR/ARR. Shows that revenue is real and recurring. Seed-stage SaaS benchmarks often sit around $10K–$50K MRR with 10–25% month-over-month growth, and 15–20% MoM as a common target band. As of 2026, Series A ARR expectations vary by sector, with traditional SaaS around a $2.2M median, AI-native SaaS around $1.1M, and B2B fintech around $3.0M.
Growth rate. Shows that momentum persists beyond a single strong month. Seed-stage SaaS companies that attract Series A interest often grow MRR 10–25% month-over-month for at least three to four months. Below $1M ARR, many investors focus on accelerating growth, such as 10% to 12% to 15% MoM, rather than a fixed percentage.
Gross margin. Shows whether the unit scales. Private SaaS companies with $1M–$5M ARR often show median gross margins of 63–69%, with best-in-class reaching 78–82%. Gross margin sets the ceiling for profitability, but industry norms vary, and high gross margin can still coexist with negative net margin when overhead and marketing dominate.
CAC and CAC payback. Shows acquisition efficiency. LTV:CAC of at least 3:1 is a common threshold, with 3:1 to 5:1 healthy for many B2B SaaS businesses. At Series A, CAC payback under 18 months usually passes, with under 12 months preferred for SMB and self-serve motions.
Churn and net revenue retention. Shows whether customers stay and expand. Series A investors often expect net revenue retention above 100%, with 110–120% competitive and 120% or more considered premium.
Burn and runway. Shows how long capital lasts and when the next raise must begin.
Revenue per employee. Shows operating leverage. ARR per employee around $100K–$150K is typical for early-stage SaaS, $150K–$250K looks healthy for many scaling startups, and $250K+ signals strong efficiency.
Break-even month. Shows whether the path to profitability looks credible.

Investors often rebuild cohort views themselves. Self-reported topline numbers without cohort support rarely survive a partner meeting. When the model cannot explain why actuals diverged from plan, the real issue is the story behind the numbers.

How To Calculate Burn Rate And Runway For Your Raise

The basic runway formula is Cash Runway = Current Cash Balance ÷ Monthly Net Burn Rate. Cash balance means immediately accessible cash on hand, excluding anticipated fundraising. Net burn equals monthly cash expenses minus monthly cash revenue.

Net burn represents the monthly cash loss and can be calculated as (Monthly Revenue – COGS) – Gross Burn Rate or as total monthly cash outflows minus cash inflows from revenue. Gross burn equals total cash outflow with no revenue offset. Net burn works best for runway and board reporting once the company has meaningful, collectible revenue, while early-stage companies with lumpy or single-customer revenue should also track gross-burn runway as a floor. Use a three-month trailing average burn rate to smooth one-time items and seasonality when burn changes over time.

The bottoms-up ask-sizing rule ties directly to the model. Hiring plan plus cost projections define monthly burn; 18–24 months of burn define capital needed; a 15–20% buffer sets the final target round size.

The timing of the raise matters as much as the amount. Carta data shows that fundraising from first investor meeting to money in the bank typically takes three to six months, with longer timelines in some cases. Starting a raise with only six months of runway leaves no buffer for delays and often forces founders to accept weaker terms or risk running out of cash. Starting with 12 months of runway preserves negotiating flexibility, and many advisors recommend opening with 12–18 months of runway.

The table below summarizes target runway and fundraising trigger points by stage.

Stage	Target Runway Post-Close	Start Fundraising At	Typical Monthly Net Burn
Pre-Seed	Pre-seed startups often target 12–18 months of runway post-close to reach MVP and early validation, with 18–24 months now viewed as safer	Some guides recommend starting fundraising with at least 9 months of runway at pre-seed, though thresholds vary	Pre-seed monthly net burn ranges from near-zero to roughly $45K–$50K, with a median around $25K
Seed	Seed startups often target 18–24 months of post-close runway sized to a specific milestone, with 24 months safer in the current market	Seed companies typically start fundraising with 9–12 months of runway, with higher-burn teams starting earlier	Seed-stage startups often show monthly net burn of roughly $50K–$150K, with a median around $75K–$85K
Series A	Series A startups often target 24+ months of runway, though some investors frame the range as 18–24 months	Series A founders usually start fundraising with around 9–12 months of runway	Series A companies often burn roughly $200,000 to $600,000 per month, with a median around $380,000
Series B+	Series B and later rounds often target 24–36 months of runway, with median actual post-raise runway closer to 22 months	Series B+ startups typically start fundraising with at least 9 months of runway, since these rounds often take 4–6 months	Series B companies often show monthly net burn between $300,000 and $1.5 million

Consider a simple example. With $1.5M in cash and $125K average monthly net burn, the company has 12 months of runway. A $2M raise at a $10M post-money valuation cap gives the SAFE investor 20% ownership before the priced round and extends runway enough, at the same burn, to reach milestones that support a Series A.

How Dilution Works For SAFEs And Priced Rounds

Post-money SAFE ownership follows a simple formula: Investment ÷ Post-Money Valuation Cap = Ownership Percentage. A $500,000 SAFE on a $5 million post-money cap equals 10% ownership, fixed at signing and measured immediately before the next priced round, after which new investors and any option pool expansion dilute that percentage.

Post-money SAFEs stack additively. Each SAFE’s percentage is fixed at signing as investment divided by its post-money cap, and SAFEs do not dilute one another. A $500K SAFE at a $5M cap, then $1M at an $8M cap, then $2M at a $10M cap produces combined SAFE ownership of 10% + 12.5% + 20% = 42.5% at conversion.

Under a post-money SAFE, the option pool that exists before the priced round is included in the Company Capitalization used for SAFE conversion. That structure places dilution on founders and other common holders, while SAFE investors keep their fixed percentage. The pool increase negotiated with the new priced-round investor sits outside the SAFE conversion denominator and dilutes both founders and SAFE holders, which makes post-money SAFEs more dilutive to founders than pre-money versions.

Y Combinator’s SAFE User Guide notes that a priced round below or too close to the valuation cap can cause SAFEs to convert into more than the estimated ownership. Y Combinator makes its post-money SAFE templates available for free on its website, including three US versions plus an optional Pro Rata Side Letter and several international variants.

The table below compares three common early-stage fundraising instruments.

Instrument	Ownership Certainty	Interest / Maturity	Typical Stage
Post-Money SAFE	The investor’s ownership percentage is fixed at signing as investment divided by the post-money cap and does not change with later SAFEs, though it dilutes in the priced round and new option pool	No interest and no maturity date	Common at pre-seed through seed
Convertible Note	Ownership becomes clear at conversion, when the valuation cap or discount sets the effective price per share and dilution	Accrues interest and has a maturity date that requires extension or repayment	As of 2025–2026, convertible notes appear in a minority of pre-seed and seed deals and often serve as bridge or post-seed instruments
Priced Round (Preferred)	Ownership is fixed at closing, with new shares issued at a set price per share	No interest and no maturity	Priced rounds usually begin at priced seed or Series A and continue through Series B and later rounds

What To Put In The Investor-Facing Summary

The one-page investor summary acts as a primary deliverable. The summary slide earns the meeting, and the underlying model supports the check.

The summary should cover raise amount, instrument, target runway, current and projected ARR, gross margin, key milestones, and the metric that unlocks the next round. Show 6–12 months of historical actuals and 3 years of annual projections on the summary slide. The detailed monthly model belongs in the data room.

Tie Use of Funds directly to hiring and spending assumptions by linking each category to specific dollar amounts, percentages, and milestones. For example, 45% to product and engineering, 40% to go-to-market, and 15% to G&A and runway buffer. Showing profitability in Year 2 on a seed round often raises concerns when break-even aligns exactly with the end of current funding. Most early-stage fundraising models show profitability in Years 3–5 of a 3–5 year projection, not in Year 1.

Tooling That Holds Up In Diligence

Excel remains the standard for complex modeling. Google Sheets works well for pre-seed through seed models before roughly $1M ARR, when collaboration and speed matter more than formula depth. AI tools can help with structure and formulas, but they cannot own or defend assumptions in a partner meeting.

Condesa’s stack uses QuickBooks Online as the default US accounting platform, NetSuite for larger organizations, Ramp for spend management, Gusto or Rippling for payroll, and Google Workspace for collaboration, with Microsoft Excel reserved for sophisticated modeling.

Scenario Discipline For Downside, Base, And Upside Cases

A base case that requires a “cascade of miracles,” a term popularized by Alan Patricof in No Red Lights, does not function as a true base case. Build scenarios from realistic operational variations such as churn rising 2–3 points, a key hire slipping four months, or pipeline dropping 40% for two quarters.

Scenario planning usually includes three cases: low, medium, and high, with the company run on the medium base case. Reserve the bull case for specific, achievable catalysts such as a major feature release, vertical expansion, or margin gains from automation. In a fundraising pitch, present the base case with sensitivities and share the full scenario set with the board.

A bull case that shows 400% revenue growth in Year 2 with no increase in sales headcount signals a modeling problem. Investors fund logic and coherent assumptions, not unchecked ambition.

Common Modeling Mistakes And Diligence Watch Outs

Several recurring model-level mistakes often slow or stall fundraising rounds:

Annual-only models with no monthly cash timing
Top-down TAM math instead of bottom-up drivers
Hockey-stick growth without matching sales headcount
Ignoring working capital and cash timing differences from revenue
Leaving the option pool out of dilution math
Confusing pre-money and post-money SAFE mechanics
Models that have not been opened or updated in six months

Common diligence watch outs include:

Profitability shown in Year 2 on a seed round
Revenue tripling while R&D headcount stays flat
Hardcoded numbers with no assumptions tab
Actuals that diverge from plan with no variance narrative

Symptoms of an underperforming prior accountant or CFO, such as missed deadlines, errors in the books, missing documentation, absent cash reconciliations, and weak processes, appear in diligence as unexplained variances and unreconciled cash. When the model cannot explain why actuals diverged from plan, the underlying issue is the narrative and controls, not the spreadsheet alone.

Have Condesa rebuild or refresh your model before you go to market; the team recently rebuilt one Austin real estate startup’s model from scratch in four weeks ahead of their raise.

How To Evaluate Modeling Progress

Model maturity shows up in process quality more than in a single fundraising outcome. Cleaner assumptions documentation, faster scenario turnaround, fewer unresolved investor questions, stronger supporting schedules, and better visibility into burn and runway all signal progress.

A working model can be refreshed monthly by replacing budget assumptions with actuals for completed months and rolling the forecast forward. With FP&A software, this monthly reforecast often takes one to two days instead of one to two weeks in spreadsheets, and once the structure is sound, the financials portion can update in minutes.

Advanced Finance Stack And Next Steps

After the core model is stable, the next layer of work includes cross-border entity and tax structuring, system upgrades from QuickBooks to NetSuite as volume grows, a formal forecasting cadence, internal controls, audit readiness, and tight coordination between accounting and finance.

Condesa Financial Group serves founders who need both the model and the finance function behind it. The firm is industry- and geography-agnostic, serving multinationals from Panama and Mexico City with time-zone-aligned, English-fluent ex-Big 4 teams that deliver Big-4-caliber work at below-US-market rates. Engagements begin with a free consultation.

Request your free consultation to discuss financial modeling, FP&A, and fractional CFO oversight for your next raise.

Frequently Asked Questions

How Many Years Should A Fundraising Model Cover?

Most fundraising models cover three to five years, with monthly granularity for the first 18–24 months and quarterly or annual views later. As noted earlier, annual-only models struggle when intra-year timing matters. The pitch deck shows annual summary figures, and the detailed monthly model lives in the data room.

How Much Should I Raise?

Raise enough to fund 18–24 months of milestones plus a 15–20% buffer for delays and overruns. Size the round from the bottom up using your hiring plan and burn projection. Competitor round sizes rarely match your burn profile, team, or milestones.

Can I Use Excel?

Excel works well for sophisticated modeling and remains the standard. What matters is an assumption-driven, monthly model that you can defend in a partner meeting. Google Sheets can support pre-seed and seed models before roughly $1M ARR, as long as you maintain a dedicated assumptions tab and avoid hardcoding.

How Is Runway Calculated?

Runway equals current cash balance divided by monthly net burn. Net burn reflects total monthly cash outflows minus cash inflows from revenue. A three-month trailing average smooths one-time items, and a monthly cash-flow model captures burn changes as hires and contracts ramp. Cash not yet in the bank, including signed-but-unclosed SAFEs and unsigned term sheets, should sit outside the runway calculation.

How Does Post-Money SAFE Dilution Work?

Under a post-money SAFE, the investor’s ownership percentage equals investment amount divided by the post-money valuation cap and remains fixed through later SAFE rounds. Post-money SAFEs stack additively, so each SAFE’s percentage adds to the total. The existing option pool sits inside the conversion denominator and dilutes founders and other common holders, while the pool increase at the priced round dilutes both founders and SAFE holders.

What Is The Difference Between Fractional CFO Scope And Accounting Scope?

Accounting scope covers bookkeeping, accounts payable, accounts receivable, payroll, and day-to-day financial operations. Fractional CFO scope covers FP&A, financial modeling, forecasting, tax structuring, and executive-level interpretation of results. Condesa delivers both layers, with ex-Big 4 nearshore accounting professionals supported by fractional CFO oversight.

How Does Nearshore Delivery Affect Quality And Time-Zone Alignment?

Condesa’s Panama and Mexico City teams are ex-Big 4, English-fluent, and time-zone aligned with US clients in markets such as New York, Chicago, and San Francisco. The nearshore model provides Big-4-caliber work at below-US-market rates without offshore communication lag or on-site hiring costs.

Conclusion

A strong fundraising model follows a clear build sequence, keeps every input on an assumptions tab, reconciles every output, and runs scenarios in seconds. Founders who treat the model as a living instrument enter diligence with clear answers and credible plans.

Request a free consultation with Condesa Financial Group to review your fundraising model before your next investor conversation.