Skip to content
startup-business-analyst-financial-projections logo

Financial Projections

startup-business-analyst-financial-projections

Create a comprehensive 3-5 year financial model with revenue projections, cost structure, headcount planning, cash flow analysis, and three-scenario modeling (conservative, base, optimistic) for startup financial planning and fundraising.

SKILL.md

Full skill instructions

Financial Projections

Create a comprehensive 3-5 year financial model with revenue projections, cost structure, headcount planning, cash flow analysis, and three-scenario modeling (conservative, base, optimistic) for startup financial planning and fundraising.

Use this skill when

  • Working on financial projections tasks or workflows
  • Needing guidance, best practices, or checklists for financial projections

Do not use this skill when

  • The task is unrelated to financial projections
  • You need a different domain or tool outside this scope

Instructions

  • Clarify goals, constraints, and required inputs.
  • Apply relevant best practices and validate outcomes.
  • Provide actionable steps and verification.
  • If detailed examples are required, open resources/​implementation-playbook.md.

What This Command Does

This command builds a complete financial model including:

  1. Cohort-based revenue projections
  2. Detailed cost structure (COGS, S&M, R&D, G&A)
  3. Headcount planning by role
  4. Monthly cash flow analysis
  5. Key metrics (CAC, LTV, burn rate, runway)
  6. Three-scenario analysis

Instructions for Claude

When this command is invoked, follow these steps:

Step 1: Gather Model Inputs

Ask the user for essential information:

Business Model:

  • Revenue model (SaaS, marketplace, transaction, etc.)
  • Pricing structure (tiers, average price)
  • Target customer segments

Starting Point:

  • Current MRR/​ARR (if any)
  • Current customer count
  • Current team size
  • Current cash balance

Growth Assumptions:

  • Expected monthly customer acquisition
  • Customer retention/​churn rate
  • Average contract value (ACV)
  • Sales cycle length

Cost Assumptions:

  • Gross margin or COGS %
  • S&M budget or CAC target
  • Current burn rate (if applicable)

Funding:

  • Planned fundraising (amount, timing)
  • Pre/​post-money valuation

Step 2: Activate startup-financial-modeling Skill

The startup-financial-modeling skill provides frameworks. Reference it for:

  • Revenue modeling approaches
  • Cost structure templates
  • Headcount planning guidance
  • Scenario analysis methods

Step 3: Build Revenue Model

Use Cohort-Based Approach:

For each month, track:

  1. New customers acquired
  2. Existing customers retained (apply churn)
  3. Revenue per cohort (customers × ARPU)
  4. Expansion revenue (upsells)

Formula:

MRR (Month N) = Σ across all cohorts:
  (Cohort Size × Retention Rate × ARPU) + Expansion

Project:

  • Monthly detail for Year 1-2
  • Quarterly detail for Year 3
  • Annual for Years 4-5

Step 4: Model Cost Structure

Break down operating expenses:

1. Cost of Goods Sold (COGS)

  • Hosting/​infrastructure (% of revenue or fixed)
  • Payment processing (% of revenue)
  • Variable customer support
  • Third-party services

Target gross margin:

  • SaaS: 75-85%
  • Marketplace: 60-70%
  • E-commerce: 40-60%

2. Sales & Marketing (S&M)

  • Sales team compensation
  • Marketing programs
  • Tools and software
  • Target: 40-60% of revenue (early stage)

3. Research & Development (R&D)

  • Engineering team
  • Product management
  • Design
  • Target: 30-40% of revenue

4. General & Administrative (G&A)

  • Executive team
  • Finance, legal, HR
  • Office and facilities
  • Target: 15-25% of revenue

Step 5: Plan Headcount

Create role-by-role hiring plan:

Reference team-composition-analysis skill for:

  • Roles by stage
  • Compensation benchmarks
  • Hiring velocity assumptions

For each role:

  • Title and department
  • Start date (month/​quarter)
  • Base salary
  • Fully-loaded cost (salary × 1.3-1.4)
  • Equity grant

Track departmental ratios:

  • Engineering: 40-50% of team
  • Sales & Marketing: 25-35%
  • G&A: 10-15%
  • Product/​CS: 10-15%

Step 6: Calculate Cash Flow

Monthly cash flow projection:

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

Include Funding Events:

  • Timing of raises
  • Amount raised
  • Use of proceeds
  • Impact on cash balance

Step 7: Compute Key Metrics

Calculate monthly/​quarterly:

Unit Economics:

  • CAC (S&M spend / new customers)
  • LTV (ARPU × margin% / churn rate)
  • LTV:CAC ratio (target > 3.0)
  • CAC payback period (target < 18 months)

Efficiency Metrics:

  • Burn multiple (net burn / net new ARR) - target < 2.0
  • Magic number (net new ARR / S&M spend) - target > 0.5
  • Rule of 40 (growth% + margin%) - target > 40%

Cash Metrics:

  • Monthly burn rate
  • Runway in months
  • Cash efficiency

Step 8: Create Three Scenarios

Build conservative, base, and optimistic projections:

Conservative (P10):

  • New customers: -30% vs. base
  • Churn: +20% vs. base
  • Pricing: -15% vs. base
  • CAC: +25% vs. base

Base (P50):

  • Most likely assumptions
  • Primary planning scenario

Optimistic (P90):

  • New customers: +30% vs. base
  • Churn: -20% vs. base
  • Pricing: +15% vs. base
  • CAC: -25% vs. base

Step 9: Generate Financial Model Report

Create comprehensive markdown report with tables:

Section 1: Executive Summary

  • 3-5 year financial snapshot
  • Key metrics at scale
  • Funding requirements

Section 2: Model Assumptions

  • Revenue model and pricing
  • Growth assumptions
  • Cost structure assumptions
  • Headcount plan summary

Section 3: Revenue Projections Monthly/​quarterly tables showing:

| Month | New Customers | Total Customers | MRR | ARR | Growth % |
|-------|---------------|-----------------|-----|-----|----------|

Section 4: 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%       |

Section 5: Headcount Plan

| Department | Current | Year 1 | Year 2 | Year 3 |
|------------|---------|--------|--------|--------|
| Engineering| X       | Y      | Z      | W      |

Section 6: Cash Flow Analysis

| Quarter | Revenue | Expenses | Net Burn | Cash Balance | Runway |
|---------|---------|----------|----------|--------------|--------|

Section 7: Key Metrics

| Metric | Year 1 | Year 2 | Year 3 | Target |
|--------|--------|--------|--------|--------|
| CAC | $X | $Y | $Z | <$A |
| LTV | $X | $Y | $Z | >$B |
| Burn Multiple | X | Y | Z | <2.0 |

Section 8: Scenario Analysis

| Scenario | Year 3 ARR | Customers | Burn | Runway |
|----------|------------|-----------|------|--------|
| Conservative | $Xم | Y | $Z | W mo |
| Base | $X | Y | $Z | W mo |
| Optimistic | $X | Y | $Z | W mo |

Section 9: Funding Requirements

  • Amount needed
  • Use of proceeds breakdown
  • Milestones to achieve
  • Expected valuation impact

Section 10: Validation

  • Sanity checks performed
  • Benchmark comparisons
  • Risk factors
  • Assumptions to monitor

Step 10: Save Model

Offer to save as markdown file:

  • Suggest filename: financial-projections-YYYY-MM-DD.md
  • Include note that user can convert to Excel/​Sheets
  • Provide formulas for key calculations

Financial Model Best Practices

Do:

  • Use cohort-based revenue model
  • Include 3 scenarios
  • Show monthly detail (Year 1-2)
  • Calculate key metrics
  • Validate against benchmarks
  • Document all assumptions
  • Show cash flow and runway
  • Include fundraising milestones

Don't:

  • Be overly optimistic on growth
  • Underestimate costs
  • Forget fully-loaded compensation
  • Ignore cash timing
  • Skip scenario analysis
  • Use static headcount
  • Forget to validate

Integration with Other Commands

Pairs well with:

  • /​market-opportunity - Use SOM for revenue ceiling
  • /​business-case - Include projections in business case

Example Usage

User: /​financial-projections

Claude: I'll create a comprehensive financial model for your startup. Let me gather the key inputs.

What's your business model?
→ "B2B SaaS, subscription-based"

Current state?
→ "$50K MRR, 100 customers, 5-person team, $500K cash"

Growth assumptions?
→ "Expect 15% MoM growth, 10% monthly churn, $500 ACV"

[Claude builds complete model with all sections]

Notes

  • Model building takes 45-90 minutes
  • Results in comprehensive planning tool
  • Update monthly to track vs. actuals
  • Share with investors and board
  • Use for fundraising decks
  • Basis for budget and hiring decisions

More skills from MudassarAbrar

salesforce-development logo
MudassarAbrar/SAGE__GEMINI_LIVE_AGENT_HACKATHON

salesforce-development

Expert patterns for Salesforce platform development including Lightning Web Components (LWC), Apex triggers and classes, REST/Bulk APIs, Connected Apps, and Salesforce DX with scratch orgs and 2nd ...

3 0
View
azure-monitor-opentelemetry-ts logo
MudassarAbrar/SAGE__GEMINI_LIVE_AGENT_HACKATHON

azure-monitor-opentelemetry-ts

Instrument applications with Azure Monitor and OpenTelemetry for JavaScript (@azure/monitor-opentelemetry). Use when adding distributed tracing, metrics, and logs to Node.js applications with Appli...

3 0
View
popup-cro logo
MudassarAbrar/SAGE__GEMINI_LIVE_AGENT_HACKATHON

popup-cro

Create and optimize popups, modals, overlays, slide-ins, and banners to increase conversions without harming user experience or brand trust.

3 0
View
mtls-configuration logo
MudassarAbrar/SAGE__GEMINI_LIVE_AGENT_HACKATHON

mtls-configuration

Configure mutual TLS (mTLS) for zero-trust service-to-service communication. Use when implementing zero-trust networking, certificate management, or securing internal service communication.

3 0
View
azure-cosmos-db-py logo
MudassarAbrar/SAGE__GEMINI_LIVE_AGENT_HACKATHON

azure-cosmos-db-py

Build Azure Cosmos DB NoSQL services with Python/FastAPI following production-grade patterns. Use when implementing database client setup with dual auth (DefaultAzureCredential + emulator), service...

3 0
View
terraform-infrastructure logo
MudassarAbrar/SAGE__GEMINI_LIVE_AGENT_HACKATHON

terraform-infrastructure

Terraform infrastructure as code workflow for provisioning cloud resources, creating reusable modules, and managing infrastructure at scale.

3 0
View
one-drive-automation logo
MudassarAbrar/SAGE__GEMINI_LIVE_AGENT_HACKATHON

one-drive-automation

Automate OneDrive file management, search, uploads, downloads, sharing, permissions, and folder operations via Rube MCP (Composio). Always search tools first for current schemas.

3 0
View
memory-safety-patterns logo
MudassarAbrar/SAGE__GEMINI_LIVE_AGENT_HACKATHON

memory-safety-patterns

Implement memory-safe programming with RAII, ownership, smart pointers, and resource management across Rust, C++, and C. Use when writing safe systems code, managing resources, or preventing memory...

3 0
View
fp-ts-errors logo
MudassarAbrar/SAGE__GEMINI_LIVE_AGENT_HACKATHON

fp-ts-errors

Handle errors as values using fp-ts Either and TaskEither for cleaner, more predictable TypeScript code. Use when implementing error handling patterns with fp-ts.

3 0
View
framework-migration-code-migrate logo
MudassarAbrar/SAGE__GEMINI_LIVE_AGENT_HACKATHON

framework-migration-code-migrate

You are a code migration expert specializing in transitioning codebases between frameworks, languages, versions, and platforms. Generate comprehensive migration plans, automated migration scripts, and

3 0
View
azure-ai-voicelive-java logo
MudassarAbrar/SAGE__GEMINI_LIVE_AGENT_HACKATHON

azure-ai-voicelive-java

Real-time, bidirectional voice conversations with AI assistants using WebSocket technology.

3 0
View
agent-memory-mcp logo
MudassarAbrar/SAGE__GEMINI_LIVE_AGENT_HACKATHON

agent-memory-mcp

A hybrid memory system that provides persistent, searchable knowledge management for AI agents (Architecture, Patterns, Decisions).

3 0
View

Popular AI tools

Kaiber logo
Video

Kaiber

Generate, edit, and beat-sync AI video with leading models in one workspace.

Paid
View
Vimcal logo
Productivity

Vimcal

The world's fastest calendar for remote work

Free
View

Transform Your Design with AI Designer by ImgCreator.ai

Freemium
View
Akool AI logo
Content & writing

Akool AI

Revolutionizing Video Production with AI-Powered Creativity

Paid
View

Extend an image past the frame and let AI fill the new aspect ratio.

Freemium
View
StarByFace logo
Security

StarByFace

Discover your celebrity doppelgänger with StarByFace!

Free
View
C

ChainClarity explains 700+ crypto whitepapers in plain English, with layered summaries, comparisons, research tools, alerts, and a $4.99 Pro plan.

Freemium
View
Opus Clip logo
Coding & apps

Opus Clip

Opus.ai: Revolutionize Your Web Experience

Free
View