Stats
Actions
Tags
Help us improve
Share bugs, ideas, or general feedback.
Build comprehensive 3-5 year financial models with revenue projections, cost structures, cash flow analysis, and scenario planning for early-stage startups. Use this skill when creating financial projections, calculating burn rate or runway, modeling fundraising scenarios, or preparing investor-ready financials for a seed or Series A raise.
npx claudepluginhub bachsh/supermarket --plugin startup-business-analystHow this skill is triggered — by the user, by Claude, or both
Slash command
/startup-business-analyst:startup-financial-modelingThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Build comprehensive 3-5 year financial models with revenue projections, cost structures, cash flow analysis, and scenario planning for early-stage startups.
Provides UI/UX resources: 50+ styles, color palettes, font pairings, guidelines, charts for web/mobile across React, Next.js, Vue, Svelte, Tailwind, React Native, Flutter. Aids planning, building, reviewing interfaces.
Fetches up-to-date documentation from Context7 for libraries and frameworks like React, Next.js, Prisma. Use for setup questions, API references, and code examples.
Explores codebases via GitNexus: discover repos, query execution flows, trace processes, inspect symbol callers/callees, and review architecture.
Share bugs, ideas, or general feedback.
Build comprehensive 3-5 year financial models with revenue projections, cost structures, cash flow analysis, and scenario planning for early-stage startups.
Financial modeling provides the quantitative foundation for startup strategy, fundraising, and operational planning. Create realistic projections using cohort-based revenue modeling, detailed cost structures, and scenario analysis to support decision-making and investor presentations.
Cohort-Based Projections: Build revenue from customer acquisition and retention by cohort.
Formula:
MRR = Σ (Cohort Size × Retention Rate × ARPU)
ARR = MRR × 12
Key Inputs:
Operating Expenses Categories:
Cost of Goods Sold (COGS)
Sales & Marketing (S&M)
Research & Development (R&D)
General & Administrative (G&A)
Components:
Formula:
Runway = Current Cash Balance / Monthly Burn Rate
Monthly Burn = Monthly Revenue - Monthly Expenses
Role-Based Hiring Plan: Track headcount by department and role.
Key Metrics:
Typical Ratios (Early-Stage SaaS):
Conservative Scenario (P10):
Base Scenario (P50):
Optimistic Scenario (P90):
Detailed Projections: 3 Years
High-Level Projections: Years 4-5
Clarify revenue model and pricing.
SaaS Model:
Marketplace Model:
Transactional Model:
Use cohort-based methodology for accuracy.
Monthly Customer Acquisition: Define new customers acquired each month.
Retention Curve: Model customer retention over time.
Typical SaaS Retention:
Revenue Calculation: For each cohort, calculate retained customers × ARPU for each month.
Break down costs by category and behavior.
Fixed vs. Variable:
Scaling Assumptions:
Model headcount growth by role and department.
Inputs:
Example:
Engineer: $150K salary × 1.35 = $202K fully-loaded
Sales Rep: $100K OTE × 1.30 = $130K fully-loaded
Calculate monthly cash position and runway.
Monthly Cash Flow:
Beginning Cash
+ Revenue Collected (consider payment terms)
- Operating Expenses Paid
- CapEx
= Ending Cash
Runway Calculation:
If Ending Cash < 0:
Funding Need = Negative Cash Balance
Runway = 0
Else:
Runway = Ending Cash / Average Monthly Burn
Track metrics that matter for stage.
Revenue Metrics:
Unit Economics:
Efficiency Metrics:
Cash Metrics:
Create three scenarios with different assumptions.
Variable Assumptions:
Fixed Assumptions:
Revenue Drivers:
Key Ratios:
Example Projection:
Year 1: $500K ARR, 50 customers, $100K MRR by Dec
Year 2: $2.5M ARR, 200 customers, $208K MRR by Dec
Year 3: $8M ARR, 600 customers, $667K MRR by Dec
Revenue Drivers:
Key Ratios:
Example Projection:
Year 1: $5M GMV, 15% take rate = $750K revenue
Year 2: $20M GMV, 15% take rate = $3M revenue
Year 3: $60M GMV, 15% take rate = $9M revenue
Revenue Drivers:
Key Ratios:
Revenue Drivers:
Key Ratios:
Pre-Money Valuation: Based on metrics and comparables.
Dilution:
Post-Money = Pre-Money + Investment
Dilution % = Investment / Post-Money
Use of Funds: Allocate funding to extend runway and achieve milestones.
Example:
Raise: $5M at $20M pre-money
Post-Money: $25M
Dilution: 20%
Use of Funds:
- Product Development: $2M (40%)
- Sales & Marketing: $2M (40%)
- G&A and Operations: $0.5M (10%)
- Working Capital: $0.5M (10%)
Identify Key Milestones:
Funding Amount: Ensure runway to achieve next milestone + 6 months buffer.
Pitfall 1: Overly Optimistic Revenue
Pitfall 2: Underestimating Costs
Pitfall 3: Ignoring Cash Flow Timing
Pitfall 4: Static Headcount
Pitfall 5: Not Scenario Planning
Sanity Checks:
Benchmark Against Peers: Compare key metrics to similar companies at similar stage.
Investor Feedback: Share model with advisors or investors for feedback on assumptions.
To create a startup financial model: