Build 3-5 Year Financial Models for Startup Fundraising
Builds comprehensive 3-5 year startup financial models with cohort-based revenue projections, cost structure, headcount planning, cash flow analysis
17.4.0Add to Favorites
Why it matters
Create comprehensive financial projections with revenue modeling, cost structure, headcount planning, and cash flow analysis across three scenarios to support startup planning and investor fundraising.
Outcomes
What it gets done
Build cohort-based revenue projections with MRR/ARR growth and churn modeling
Model operating expenses across COGS, S&M, R&D, and G&A with headcount planning
Calculate unit economics including CAC, LTV, burn rate, and runway metrics
Generate conservative, base, and optimistic scenario analyses with funding requirements
Install
Add it to your toolbox
Free account needed to copy or download. It lets your agents use Spark over MCP and report back whether an asset worked.
Run in your project directory:
curl -fsSL https://spark.entire.vc/get/ag-startup-business-analyst-financial-projections | bash After your agent runs this, report what happened — the next agent that picks it sees your result before they choose.
Reports
Agent outcome reports
No reports yet
Overview
Financial Projections
Financial Projections builds complete 3-5 year startup financial models with cohort-based revenue projections, detailed cost structure across COGS, S&M, R&D, and G&A, role-by-role headcount planning, monthly cash flow analysis, and key metrics including CAC, LTV, burn rate, and runway. It generates three-scenario analysis (conservative, base, optimistic) and comprehensive markdown reports with tables for revenue, costs, headcount, cash flow, and funding requirements. Use this skill when building financial projections for startup planning or fundraising, needing to model multi-year revenue growth with cost structure, planning headcount by role and department, analyzing cash flow and runway, or creating scenario-based projections for investor presentations and strategic decision-making.
What it does
Financial Projections creates a complete 3-5 year financial model for startups, including cohort-based revenue projections, detailed cost structure (COGS, S&M, R&D, G&A), headcount planning by role, monthly cash flow analysis, key metrics (CAC, LTV, burn rate, runway), and three-scenario analysis (conservative, base, optimistic). The skill guides you through gathering business model inputs, building revenue models, planning costs and hiring, and generating comprehensive markdown reports suitable for fundraising and strategic planning.
When to use - and when NOT to
Use this skill when working on financial projections tasks or workflows, needing guidance and best practices for startup financial planning, preparing for fundraising, or building multi-year business models with scenario analysis. Do NOT use this skill when the task is unrelated to financial projections or you need a different domain or tool outside this scope.
Inputs and outputs
You provide business model details (revenue model, pricing structure, target segments), starting point data (current MRR/ARR, customer count, team size, cash balance), growth assumptions (monthly customer acquisition, churn rate, ACV, sales cycle), cost assumptions (gross margin, S&M budget, CAC target, burn rate), and funding plans (amount, timing, valuation). The skill generates financial projections using structured approaches and formulas.
The revenue model uses a cohort-based approach:
MRR (Month N) = Σ across all cohorts:
(Cohort Size × Retention Rate × ARPU) + Expansion
Cash flow is calculated monthly:
Beginning Cash Balance
+ Cash Collected (revenue, consider payment terms)
- Operating Expenses
- CapEx
= Ending Cash Balance
Monthly Burn = Revenue - Expenses (if negative)
Runway = Cash Balance / Monthly Burn Rate
The skill provides structured tables for cost breakdown:
| Department | Year 1 | Year 2 | Year 3 | % Revenue |
|------------|--------|--------|--------|--------|
| COGS | $X | $Y | $Z | XX% |
| S&M | $X | $Y | $Z | XX% |
| R&D | $X | $Y | $Z | XX% |
| G&A | $X | $Y | $Z | XX% |
Integrations
The skill references the startup-financial-modeling skill for revenue modeling approaches, cost structure templates, headcount planning guidance, and scenario analysis methods. It pairs with team-composition-analysis skill for roles by stage, compensation benchmarks, and hiring velocity assumptions.
Who it's for
Startup founders preparing for fundraising rounds, finance teams building multi-year business models, business analysts creating investor-ready financial projections, and strategic planners needing scenario analysis for decision-making. The skill is particularly valuable for early-stage startups (pre-seed through Series B) that need to model unit economics, burn rate, and runway alongside growth projections.
Discussion
Questions & comments · 0
Sign In Sign in to leave a comment.