Written by: Andrew Cohen, CFA, CPA, Managing Partner, Condesa Financial Group

Key Takeaways

• Founders preparing an imminent raise must convert operational realities into a transparent, bottoms-up financial model that investors can audit in minutes.
• A seven-step process defines purpose, centralizes assumptions, builds revenue and expense forecasts, calculates runway and dilution, links the model to the cap table, and hands off to ongoing oversight.
• Each step includes required inputs, decision checkpoints, stakeholder roles, and clear completion criteria to ensure investor-ready deliverables.
• Common pitfalls include weak documentation, missing scenario tabs, and underperforming prior accountants that necessitate full model reconstruction.
• Condesa Financial Group delivers the complete model and fractional CFO support at price-competitive nearshore rates, staffed by ex-Big 4 professionals based in Panama and Mexico City. Talk with Condesa to scope your fundraising model today.

Before You Begin: How the Seven Steps Fit Together

The first four steps establish the model’s purpose, assumptions tab, bottoms-up revenue forecast, and operating-expense structure. The final three steps convert those elements into cash runway, dilution scenarios, cap-table linkage, and stress-tested deliverables ready for investor review and ongoing fractional CFO management.

Step 1: Define the Model’s Purpose and Fundraising Milestones

Required inputs: raise amount, target close date, stage (pre-seed, seed, or Series A), and the specific milestones the capital must fund.

Decision checkpoint: Confirm that the raise amount, milestone timeline, and runway target are internally consistent before building any other tab. Pre-seed investors evaluate three elements: the amount being raised, what the funds will be spent on, and the milestones that will be achieved before cash runs out. At Series A, the raise should provide 18 to 24 months of runway at the projected burn rate, and less than 18 months risks returning to market before reaching Series B milestones.

Stakeholders: Founder or CEO sets milestones, and the fractional CFO translates them into model parameters.

Completion criteria: A one-page milestone map exists, each milestone has a named month and a capital requirement, and the raise amount reconciles to the runway target.

Ready to translate your milestones into model parameters? Condesa’s ex-Big 4 team can help you scope the raise. Schedule a milestone-to-model review.

Step 2: Build the Assumptions Tab as the Single Source of Truth

With milestones and capital requirements defined, the next step centralizes every driver that feeds those projections into one auditable assumptions tab.

Required inputs: pricing, conversion rates, monthly new customers, gross margin, founder salaries, opening cash balance, expected raise amount and timing, and all revenue and cost drivers.

Decision checkpoint: The assumptions tab centralizes all key drivers so that changing one cell updates the entire model. This centralization is exactly what investors look for during diligence, and they expect to see every input listed with its source, review date, and confidence level in one place. Hard-coded values inside formula cells are among the most common investor diligence failures because they make assumptions invisible and unauditable.

Stakeholders: The fractional CFO owns the tab architecture, the founder supplies business-specific inputs, and no other team member edits this tab without a documented change log.

Completion criteria: Every downstream cell in the model traces to a named assumption on this tab, no hard-coded values exist outside it, and a version log records each change.

Condesa’s Ecuador engagement illustrates the stakes. When Ecuador’s largest real estate developer engaged Condesa to build financial models for two large real estate projects, the assumptions tab formed the foundation that allowed investors to audit the logic independently. Both rounds, one raising $20 million and one raising $80 million, closed successfully. The discipline started here.

Want an assumptions tab investors can audit in minutes? Have Condesa’s nearshore team build and own it from day one.

Step 3: Construct a Bottoms-Up Revenue Forecast

Required inputs: acquisition channels, new customers per channel per month, average contract value or price per unit, churn rate, expansion revenue assumptions, and LTV:CAC ratio.

Decision checkpoint: Investors trust a bottom-up model built from three or four real growth drivers and expect lifetime value to be at least three times customer acquisition cost. Investors view top-down revenue forecasts, such as “1% of a $40B market”, as a red flag that signals weak understanding of customer acquisition. The forecast should cover 18 to 24 months on a monthly basis.

Stakeholders: The Head of Sales or Revenue supplies pipeline data, the fractional CFO translates pipeline into model logic, and the founder reviews channel assumptions for operational realism.

Completion criteria: Revenue is built from controllable inputs (leads × conversion × price) by channel, the LTV:CAC ratio is explicitly calculated, and one conservative base case and at least one downside case exist.

Need a revenue build investors can challenge line by line? Work with Condesa to build a bottoms-up forecast that withstands scrutiny.

Step 4: Model Operating Expenses and Headcount

Required inputs: current headcount with fully loaded costs, planned hires with start months and role-level salaries, software and infrastructure costs, marketing spend, legal and admin costs, and one-time onboarding expenses such as recruiter fees.

Decision checkpoint: Fully loaded employee costs typically run 20 to 30 percent above base salary because of employer payroll taxes, health insurance, retirement contributions, and equipment. A single hire at seed stage typically burns $10,000 to $15,000 in monthly cash, and employee compensation consumes over 75 percent of operating expenses. Payroll must sit in a separate tab from operating expenses.

Stakeholders: The CEO or COO owns the hiring plan, and the fractional CFO models fully loaded costs and links each role to a revenue driver or operational trigger.

Completion criteria: Every planned hire has a named role, start month, base salary, fully loaded cost at 1.25–1.4x, and a linked revenue or milestone trigger. Payroll and opex tabs are separate, and the headcount plan feeds directly into the cash flow statement.

Condesa’s Austin real-estate startup engagement demonstrates the cost of skipping this discipline. When Condesa took over as fractional CFO, the prior CFO’s model was rebuilt from scratch over four weeks, simplifying a deliverable produced by a capable but self-taught predecessor who had not separated payroll from operating expenses or linked hires to milestones. The startup now goes to market with a cohesive model and investor narrative.

Concerned your expense model will not hold up in diligence? Ask Condesa’s team to rebuild or validate your headcount and opex tabs before the raise.

Step 5: Calculate Cash Runway and Dilution Scenarios

Required inputs: opening cash balance, monthly net burn (operating expenses minus revenue), raise amount, close date, and proposed terms (SAFE, priced round, or convertible note).

Decision checkpoint: Founders should model SAFE conversion and dilution before signing so the raise size and financial model agree. Seventy-three percent of founders do not model dilution scenarios, which leaves many to negotiate funding terms without understanding the long-term impact on their cap table.

The table below illustrates a simple runway calculator across three scenarios. Net burn is monthly operating expenses minus monthly revenue. Runway is current cash divided by net monthly burn.

Stakeholders: The fractional CFO owns the runway and dilution calculations, the founder reviews dilution scenarios against personal ownership targets, and legal counsel reviews instrument terms.

Completion criteria: The model displays opening cash, monthly net burn, and the specific month when cash reaches zero for each scenario. Dilution is calculated for base, upside, and downside raise amounts, and the downside scenario demonstrates a viable path to a fundable milestone.

Want clear visibility on how this round affects your ownership and runway? Have Condesa model your runway and dilution scenarios.

Step 6: Link the Model to the Cap Table and Investor Narrative

Required inputs: current cap table (founders, employees, existing investors, option pool), proposed round size, instrument type, pre-money valuation or SAFE cap, and pro-forma ownership targets.

Decision checkpoint: The financial model should align with the cap table by linking funding rounds to ownership changes and keeping equity math transparent, which shows dilution and price per round at a glance and builds trust during diligence. EY’s guide to startup financial modeling identifies financing modules, including the cap table, as a key component of any complete model even at the pre-seed stage.

Stakeholders: The fractional CFO links the cap table to the financial model, the founder and legal counsel verify ownership math, and the founder drafts the investor narrative, which the fractional CFO reviews for numerical consistency.

Completion criteria: The cap table tab is formula-linked to the raise amount and instrument terms in the assumptions tab, pro-forma ownership is calculated for each scenario, and the investor narrative references specific model outputs such as runway, milestones, and use of funds without contradiction.

Need your story, cap table, and model to tell the same story? Ask Condesa to connect your cap table and investor narrative to a single, auditable model.

Step 7: Stress-Test and Hand Off to Ongoing Fractional CFO Oversight

Required inputs: base-case assumptions, the five to eight highest-impact drivers (typically CAC, churn, ACV, conversion rate, and gross margin for SaaS), and three to four explicit scenarios beyond the base case.

Decision checkpoint: Founders preparing for a Series A or B raise should rerun the entire financial model with every key assumption set 20 percent worse and then examine the resulting impact on runway and milestone achievement. Companies preparing for Series A that build robust stress tests into their financial models receive significantly better term sheets because they have already addressed questions investors ask during due diligence.

Stakeholders: The fractional CFO runs the stress-test suite and documents management responses for each scenario, the founder reviews and approves the downside response plan, and the complete model passes to the fractional CFO for monthly actuals-versus-plan tracking post-raise.

Completion criteria: Base, upside, and downside scenarios exist with a scenario toggle cell. A sensitivity table shows runway impact from changes in the top three drivers, a one-paragraph response plan is documented for each downside trigger, and the fractional CFO has a monthly cadence to update actuals and reforecast.

Ready to see how your plan holds up when things go sideways? Engage Condesa to stress-test your model and establish ongoing fractional CFO oversight.

Common Mistakes in Fundraising Models

Three failure modes appear consistently in fundraising models submitted to investors.

1. Weak or missing documentation. Hiding assumptions inside formulas instead of exposing them on the assumptions tab is one of the most common credibility-killing mistakes in startup financial models. Every material input requires a label, a source, and a review date.
2. Missing scenario tabs. True scenario planning requires modeling fundamentally different business trajectories rather than simple sensitivity adjustments of plus or minus 10 to 15 percent to the base-case revenue line. A single-path model signals to investors that the founder has not considered failure modes.
3. Underperforming prior accountants. Founders who arrive with books maintained by a discount accounting firm frequently discover that the underlying data cannot support a bottoms-up model without a full reconstruction. The information asymmetry between non-technical business owners and the accountants that service them is a structural problem, not a personal failing, and a fractional CFO layer exists to close this gap.

How Investors Evaluate Your Model

An investor-ready financial model is evaluated on process indicators, not forecast accuracy. Investors reviewing a startup model first examine runway, burn multiple, gross margin trajectory, and the scale of year-one versus year-two revenue growth. The underlying question is whether the founder understands the business well enough to defend every assumption line by line.

Clean assumptions, transparent logic, and investor-ready formatting are the three process indicators that determine whether a model survives due diligence. Many CFOs prefer financial models with a limited number of core assumptions because simplicity builds investor confidence. Complexity does not substitute for rigor.

Using the Model After the Raise

Post-raise, the financial model shifts from a fundraising artifact to an operating tool. Founders should save the original fundraising financial model before creating new monthly projections so they can compare actual progress against investor assumptions and streamline board updates. The fractional CFO role at this stage is to update actuals monthly, reforecast quarterly, and flag assumption drift before it becomes a board-level surprise.

Nearshore execution offers a structural advantage in this ongoing phase. Condesa’s Panama and Mexico City delivery model provides ex-Big 4 analytical capacity at below-US-market rates, the same quality-to-price arbitrage that makes the initial model build accessible to 1–100 employee SMEs in high-cost markets like New York, Chicago, and San Francisco. The team operates in aligned time zones and communicates in fluent English, which removes the coordination friction that often undermines offshore alternatives.

Frequently Asked Questions

What is the difference between a financial model for fundraising and a standard accounting report?

A fundraising financial model is a forward-looking, driver-based document that projects revenue, expenses, cash runway, and dilution across multiple scenarios for the next 18 to 36 months. A standard accounting report, such as a profit and loss statement or balance sheet, records historical transactions. Investors use the financial model to evaluate whether the business logic is sound and whether the raise amount purchases a credible milestone. They use historical accounting reports to verify that the model’s starting assumptions are grounded in real numbers. Both are required for a complete fundraising process, and both must be consistent with each other.

When should a founder engage a fractional CFO for fundraising preparation?

A minimum lead time of three months before active investor outreach is the practical threshold. Clean books, proper revenue recognition, a defensible financial model, and a polished data room each require dedicated time to prepare. Founders who begin with fewer than six months of runway signal distress to investors and face downward pressure on terms. The fractional CFO engagement should begin before the model is built, not after a first investor meeting reveals gaps in the assumptions tab or cap table linkage.

How many scenarios should a fundraising financial model include?

Three scenarios, base, upside, and downside, are the standard. The base case models customer acquisition, churn, and operating expenses from current traction and actual data. The upside case assumes two or three specific positive events occur, such as a channel outperforming by 30 to 40 percent. The downside case reflects 20 to 30 percent slower growth and higher CAC, and must demonstrate that the business can still reach a fundable milestone. All three scenarios should be driven by a single assumptions tab with a scenario toggle cell, not by separate files or manually edited copies of the model.

What does “bottoms-up revenue forecast” mean in practice?

A bottoms-up revenue forecast builds projected revenue from controllable operational inputs rather than market-share percentages. See Step 3 for the detailed methodology and a worked SaaS example that shows how leads, conversion rates, and contract values combine to produce monthly recurring revenue.

How does Condesa Financial Group price its financial modeling and fractional CFO services compared to US-based alternatives?

Condesa Financial Group operates a nearshore delivery model staffed by ex-Big 4 professionals based in Panama and Mexico City. This structure allows Condesa to deliver work at a quality level consistent with large professional services firms while pricing below US-market rates, a quality-to-price arbitrage that is most pronounced for clients in high-cost markets such as New York, Chicago, and San Francisco. Condesa is not a discount accounting firm; it is a price-competitive one. Founders who treat finance as a strategic function and need both a financial model and ongoing fractional CFO oversight, without the cost of a full-time US-based CFO, are the clients Condesa is built to serve.