I’ve looked at 300+ financial models. Most fail in 30 seconds. Not bad numbers-bad structure. Founders don’t understand how a VC actually reads a model. They skip the link between assumptions and outputs. They forget the sensitivity analysis. This piece covers the three models that matter, how to build them without looking like an amateur, and the specific errors that torpedo credibility before you ever step into the pitch room.
Why Financial Models Matter in Fundraising
Pitch decks get a glance. Models get scrutiny. That’s when the VC switches from “this is interesting” to “does this founder actually understand their business?” Sloppy model = rejected before the meeting. There’s no recovery from that.
Source: Bain & Company, India VC Report, 2025
A model exposes everything-your CAC, your churn assumptions, whether you’ve thought through cash runway or just prayed it would work. When a VC opens your model, three things happen simultaneously:
- First glance: Do the revenue numbers make sense relative to the market opportunity? Is the founder being realistic?
- Second glance: What’s the payback period for a customer? Is this business unit-economic viable at scale?
- close look: Walk the P&L backwards to understand the assumptions. Do they match industry benchmarks?
Your model is the first document that shows you think like an institutional founder. Not a startup CEO dreaming big-a founder who’s stress-tested their assumptions, built scenarios, knows what breaks the model. That’s it. Everything else is sales.
The 3 Models Every Startup Needs
Three models. Non-negotiable. Every VC will ask for all three. If one is missing, they assume you haven’t built the other two carefully either.
1. P&L Projections
Revenue, cost of goods sold, operating expenses, EBITDA, taxes. Standard 3-5 year build.
2. Cash Flow Model
Monthly for 18 months, quarterly thereafter. Shows when you run out of cash and when you breakeven.
3. Unit Economics Model
CAC, LTV, payback period, gross margin, retention rate. The most important one for early-stage.
Link all three to a master Assumptions Sheet. One number lives there-CAC, churn, pricing, everything. Change the assumption, the model updates. That’s the architecture. An investor throws out a what-if question in the meeting, you update one cell, the whole model recalculates in front of them. That’s how you win credibility in real-time.
Building Revenue Projections
This is where founders crash and burn. Either you’re projecting 5x growth from nowhere (hockey stick), or you’re so conservative nobody believes you can scale. The escape route? Bottom-up thinking, not top-down guessing.
Top-Down vs Bottom-Up
Top-down: “India’s SaaS market is โน10,000 Cr. We’ll get 1%.” Investors will laugh internally and move to the next deck.
Bottom-up: “100 customers acquired monthly at โน50,000 CAC. โน5,000 MRR per customer. 95% retention. Year 3 = 25,000 customers, โน1.5 Cr MRR.” Now you’re talking operational reality. Every number is defensible because it connects to something you actually control.
Source: Sequoia India, Fundraising Data, 2025
A Worked Example: SaaS Startup
Let’s build a revenue projection for a fictional HR SaaS product. Here’s how the calculation flows:
The formula is simple: (existing customers ร retention rate) + (new customer acquisition) ร (average revenue per customer). Do this month-by-month for the first 18 months, then use quarterly averages thereafter.
Unit Economics That Investors Care About
Unit economics answers one question: will this business work when it’s big? Broken unit economics = no amount of scale saves you. You’ll just lose money faster. Healthy unit economics = you can raise money in a downturn, founders can take modest salaries, the business breathes.
The Four Core Metrics
- CAC (Customer Acquisition Cost): How much does it cost to acquire one customer? = Total marketing spend / New customers acquired
- LTV (Lifetime Value): How much revenue does one customer generate over their lifetime? = (Average monthly revenue per customer ร Gross margin) / Monthly churn rate
- LTV/CAC Ratio: Is this business efficient? Investors want to see >3x
- Payback Period: How many months until you recover the CAC? = CAC / (Monthly revenue per customer ร Gross margin). Investors want <18 months
Sector Benchmarks
Unit economics vary dramatically by sector. Here’s how to benchmark yourself:
| Sector | Target CAC Payback (months) | Target LTV/CAC | Target Gross Margin |
|---|---|---|---|
| B2B SaaS | <12 | >3x | 70-80% |
| B2C SaaS (subscription) | <6 | >5x | 60-75% |
| D2C / E-commerce | <4 | >3x | 40-60% |
| Marketplace | Varies (12-24) | >2x | 20-40% |
| Fintech (lending) | <24 | >5x | 50-70% |
Use these benchmarks as your target. If you’re building a B2B SaaS and your payback period is 24 months, that’s a red flag. Either your CAC is too high (you’re spending too much to acquire), or your LTV is too low (your margins or retention need improvement).
Common Financial Modelling Mistakes
I’ve seen these errors in 70% of startup models. Most cost founders the meeting.
1. The Hockey Stick Problem
Flat revenue for six months, then 5x spike. VCs see that and think: “This founder has no idea how sales actually work.” Real growth doesn’t teleport. It compounds. If you’re projecting 10x Year 3 ARR, show the mechanics-customer cohorts stacking, retention normalizing, CAC trending down as you find repeatable channels. Not a cliff. A curve.
2. Ignoring Seasonality
B2B? Q4 dies. Enterprise budgets lock November 15th. D2C? October-December is everything. If your model shows flat months, you haven’t thought about this. Build the dips and peaks in.
3. Single Scenario Modelling
Three scenarios, non-negotiable. Base case, upside, downside. Most founders just show the fairy tale-that’s when VCs start asking the hard what-ifs: CAC up 30%? Churn spikes? You need those answers built in, not scrambled for during the meeting.
4. Mixing Assumptions with Outputs
The cardinal sin. Your model bifurcates: Assumptions live on the left (blue font, hard-coded inputs). Outputs live on the right (black font, formulas). When an assumption is buried in a formula instead of linked, the whole structure collapses. Investors see that and assume you don’t know how to build anything properly.
5. No Sensitivity Analysis
Sensitivity tables are stress tests. CAC up 20%? LTV down 15%? Year 3 profitability still holds? Build a two-variable sensitivity matrix (CAC vs churn usually). Show the model can breathe adversity.
Advanced: DCF and Valuation from Your Model
P&L works? Now build the DCF. Most founders skip it. Mistake. Because a VC will ask: “What’s your Series B valuation look like?” And you need to ground it in your model, not vibes.
How the Model Feeds DCF
DCF answers: “If we generate these cash flows for 10 years, what’s today’s value?” Simple concept. Most founders butcher the execution.
- Step 1: Take your 5-year P&L forecast
- Step 2: Convert to Free Cash Flow (EBITDA minus taxes, plus working capital changes, minus capex)
- Step 3: Assume a terminal growth rate (2-3%) and terminal value
- Step 4: Discount all future cash flows to present value using a discount rate (WACC)
- Step 5: Sum = Equity value today
WACC – The Discount Rate
WACC is your discount rate. The cost of capital to fund the business. Early-stage startups run 15-30% WACC because equity capital is expensive (execution risk is huge). Debt is cheap. Equity? That’s where the risk premium lives.
Terminal Value
Here’s what most founders get wrong: 80% of your DCF valuation comes from Years 6-10, not your detailed forecast. Terminal value. The math is straightforward. Most founders mess it up by being too optimistic or too lazy to do it properly.
Note: These are simplified frameworks. For institutional-grade DCF, consult a financial analyst or use established valuation templates.
Model Colour Coding Standards
This is an industry standard and every investor will expect it. Colour coding makes your model instantly readable and professional.
| Colour | Font | Meaning | Example |
|---|---|---|---|
| Blue | Font (Blue) | Input / Assumption (hard-coded) | Monthly CAC: 50000, Churn rate: 5% |
| Black | Font (Black) | Formula / Calculation | =SUM(customers)*price, =EBITDA/revenue |
| Green | Font (Green) | External Links (pulls data from another sheet or file) | =Index(ExternalSheet!A1:Z100,row,col) |
| Red | Font (Red) | Error Checks / Warnings (shows if logic is broken) | =IF(revenue |
Colour coding is visual grammar. Blue = you own this number. Black = it’s calculated. VCs understand this instantly. One colour mistake and they think you’re not detail-oriented.
Tools and Templates
Excel vs Google Sheets is a real decision. Here’s how to think about it:
Excel
- More powerful (advanced formulas, array functions, better performance on large models)
- Better for complex models with thousands of rows
- Investors often prefer it (feels more “professional”)
- Harder to collaborate if multiple people are editing
Google Sheets
- Real-time collaboration (multiple people can edit simultaneously)
- Cloud-based (accessible from anywhere, version history built-in)
- Sufficient for most startup models (3-5 year forecasts with 50-100 lines)
- Some institutional investors find it less polished
Recommendation: Build in Google Sheets (live collaboration, version history), then convert to Excel when you pitch. Investors have an irrational bias toward Excel. Work around it.
Free Resources
- YC Startup School Model: Template used by Y Combinator portfolio companies (Google Sheets, download-friendly)
- Sequoia Capital Template: Institutional-grade P&L and cash flow model
- Khosla Ventures Financial Model: Includes sensitivity analysis and scenario building
- 500 Global Resources: Sector-specific templates (B2B SaaS, marketplace, D2C)
Don’t reinvent the wheel. Start with Sequoia’s template or Y Combinator’s model. Steal the structure. What matters isn’t originality-it’s whether your assumptions are tight and whether you can defend each one.
Frequently Asked Questions
Five years. Months 1-24 with weekly granularity (or close). Then quarterly. Years 6-10 are terminal value math-don’t waste time forecasting Year 10 when you can’t predict next quarter. Most VCs care about profitability or Series B within 5 years anyway.
That’s the right sign. Keep a changelog. Date every assumption update-who changed it, why. When you pitch, reference the version date: “March 2026 model, updated after we talked to 50 customers.” That shows discipline. Stubbornly defending old assumptions signals arrogance or ignorance.
Only if debt matters to your story. Fintech? Real estate? Lending products? Then yes-build an amortisation schedule that feeds the cash flow. Pure SaaS raising only equity? Skip it.
Check the table above. Below benchmark? That’s the first follow-up question. Have a credible path to improve-scale COGS down, shift product mix upmarket, whatever. Don’t wing it. Public SaaS companies publish their margins in earnings calls.
Absolutely. Start with actuals, show the growth trajectory, then project forward. If you’ve been 2% MoM historically and suddenly you’re forecasting 10%, explain that. New hire? Product pivot? Market shift? VCs see a jump without explanation and assume you’re optimistic.
Key Takeaways
- Three models linked to one Assumptions sheet. That’s the structure.
- Bottom-up projections beat top-down guesses every time.
- LTV/CAC below 2x means you’re broken. Fix it or don’t pitch.
- No hockey sticks. No single scenarios. Sensitivity analysis is mandatory.
- Colour code it: blue = inputs you own, black = calculated outputs, green = external pulls, red = error flags.
- Steal a template. Don’t build from scratch.
- Change log every assumption update. Show you’re learning, not guessing.
- Build in Google Sheets (collaboration), pitch in Excel (optics).
About RedeFin Capital: We advise founders and growth-stage companies on fundraising strategy, financial modelling, and investor relations. Our equity research vertical (Kedge) publishes institutional-grade research on Indian equities. Get in touch if you’d like help with your financial model or fundraising process.
Sources & References
- Inc42, Indian Startup Funding Report, 2025
- Bain & Company, India Venture Report, 2025
- EY-IVCA, PE/VC Trendbook, 2025
- NASSCOM, India Tech Industry Report, 2025
- Tracxn, India Venture Data, 2025
- SEBI, AIF Statistics, December 2025



