Build 3-5 Year Financial Models for Startup Fundraising

This workflow builds a three- to five-year financial model for startup planning and fundraising. It connects cohort-based revenue, operating costs, role-by-role hiring, cash flow, funding events, and key metrics. The intended output is a comprehensive Markdown report with formulas and tables, offering monthly detail for years one and two, quarterly detail for year three, and annual projections for years four and five.

Begin with the business model, pricing, customer segments, current revenue, customer count, team, and cash balance. Growth assumptions include acquisition, churn or retention, contract value, and sales cycle. Cost assumptions cover gross margin or COGS, sales and marketing, and current burn. Planned financing needs explicit amounts and timing rather than being silently assumed to arrive when cash runs low.

Revenue modeling tracks each acquisition cohort, its age-specific cumulative retention, ARPU, and expansion. Cost structure separates COGS, sales and marketing, research and development, and general administration. The hiring plan records role, department, start date, base compensation, fully loaded cost, and equity. Avoid counting payroll or expansion revenue twice across model sections.

Use it to compare budgets, hiring plans, funding needs, or growth assumptions. Conservative, base, and optimistic scenarios vary acquisition, churn, pricing, and CAC. Their example shifts are illustrative assumptions, not measured percentiles. Likewise, example margin targets, departmental ratios, loading factors, and efficiency thresholds are not universal industry benchmarks.

Source actual business inputs, mark unknowns, and keep currency, period, and gross-versus-net definitions explicit. Revenue and cash collection can differ. Reconcile payment terms, taxes, working capital, capital expenditure, financing, and the dates on which money moves. The simple runway approximation applies only to positive monthly net burn; a zero or negative denominator needs another presentation, not an invented runway value.

Outputs include an executive snapshot, model assumptions, revenue tables, departmental costs, headcount, cash flow, metrics, scenario comparisons, funding requirements, and validation. Define net cash burn consistently:

Net cash burn = Cash paid out - operating cash collected (positive when consuming cash)

Metrics include CAC, LTV, LTV:CAC, payback, burn multiple, magic number, Rule of 40, and runway. Use consistent periods and definitions; LTV requires a positive churn assumption, and zero-denominator metrics are N/A. Explain formulas instead of displaying unexplained targets.

The workflow references startup-financial-modeling and team-composition-analysis for related guidance, with market-opportunity and business-case as companion commands; their availability is not established by this catalog entry. Offer to save the report, make spreadsheet conversion possible through explicit formulas, and update assumptions against actual results. Before investor use, verify calculations, benchmark relevance, funding milestones, risks, and the assumptions that need continued monitoring.