TL;DRResumen
A financial model is not a prediction — it is a structured framework for thinking about your business. A good startup financial model is built from unit economics, shows the path to profitability, and is transparent about key assumptions.Guía paso a paso para construir un modelo financiero de startup que los inversionistas tomen en serio: proyecciones de ingresos, unit economics y planificación de escenarios.
The Building Blocks
Revenue Model (build bottom-up from unit economics):
For SaaS: New customers per month × ACV, monthly churn rate, expansion revenue
MRR = (Prior MRR + New MRR + Expansion MRR) - Churned MRR
Cost Model:
COGS: Hosting, customer support, implementation, third-party software
OpEx: Sales & Marketing (by channel), R&D (engineering headcount), G&A
Headcount Model:
- Current headcount by department
- Planned hires by quarter
- Fully loaded cost per employee (salary + benefits + taxes + equity)
Cash Flow:
EBITDA - Capex ┬▒ Working capital changes = Free cash flow
Key Model Outputs
1. Monthly P&L (at least 24 months)
- Cash balance (showing when you run out of money)
- Key metrics dashboard (MRR, ARR, CAC, LTV, gross margin, burn rate, runway)
4. Scenario analysis (base, upside, downside)
Common Mistakes
1. Top-down revenue assumptions — "1% of a $10B market" is not a model
2. Ignoring COGS — gross margin matters
- Underestimating hiring timelines — 2–3 months to recruit, 3–6 months to ramp
- No scenario analysis — investors will stress-test your assumptions
- Circular references — use a separate assumptions tab
Key Takeaways
Key TakeawaysPuntos Clave
- Build revenue from unit economics, not top-down market share assumptions.
- Model headcount explicitly — it drives the majority of startup costs.
- Show cash balance monthly — investors need to see when you run out of money.
- Include scenario analysis (base, upside, downside).
- A financial model demonstrates management quality — make it defensible.
Resumen
Guía paso a paso para construir un modelo financiero de startup que los inversionistas tomen en serio: proyecciones de ingresos, unit economics y planificación de escenarios.
The Building Blocks
ingresos Model (build bottom-up from economía unitaria):
Para SaaS: New customers per month × ACV, monthly churn rate, expansion ingresos
MRR = (Prior MRR + New MRR + Expansion MRR) - Churned MRR
Cost Model:
COGS: Hosting, customer support, implementation, third-party software
OpEx: Sales & Marketing (by channel), R&D (engineering plantilla), G&A
plantilla Model:
- Current plantilla by department
- Planned hires by quarter
- Fully loaded cost per employee (salary + benefits + taxes + equity)
flujo de efectivo:
EBITDA - Capex ┬▒ capital de trabajo changes = Free flujo de efectivo
Key Model Outputs
1. Monthly P&L (at least 24 months)
- Cash balance (showing when you run out of money)
- Key metrics dashboard (MRR, ARR, CAC, LTV, margen bruto, ritmo de quema, runway)
4. Scenario analysis (base, upside, downside)
Errores comunes
1. Top-down ingresos assumptions — "1% of a $10B market" no es a model
2. Ignoring COGS — margen bruto matters
- Underestimating hiring timelines — 2–3 months to recruit, 3–6 months to ramp
- No scenario analysis — inversionistas will stress-test your assumptions
- Circular references — use a separate assumptions tab
Puntos clave
Puntos Clave
- Build ingresos from economía unitaria, not top-down market share assumptions.
- Model plantilla explicitly — it drives the majority of startup costs.
- Show cash balance monthly — inversionistas need to see when you run out of money.
- Include scenario analysis (base, upside, downside).
- A financiero model demonstrates management quality — make it defensible.