Skill

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


91
Spark score
out of 100
Updated 4 days ago
Source checked Sep 17, 2026
Version 17.4.0

Add 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

01

Build cohort-based revenue projections with MRR/ARR growth and churn modeling

02

Model operating expenses across COGS, S&M, R&D, and G&A with headcount planning

03

Calculate unit economics including CAC, LTV, burn rate, and runway metrics

04

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.