Create detailed 3-5 year financial model with revenue, costs, cash
npxskills add rmyndharis/antigravity-skills--skill startup-business-analyst-financial-projectionsLoading…
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.
This command builds a complete financial model including:
When this command is invoked, follow these steps:
Ask the user for essential information:
Business Model:
Starting Point:
Growth Assumptions:
Cost Assumptions:
Funding:
The startup-financial-modeling skill provides frameworks. Reference it for:
Use Cohort-Based Approach:
For each month, track:
Formula:
MRR (Month N) = Σ across all cohorts:
(Cohort Size × Retention Rate × ARPU) + Expansion
Project:
Break down operating expenses:
1. Cost of Goods Sold (COGS)
Target gross margin:
2. Sales & Marketing (S&M)
3. Research & Development (R&D)
4. General & Administrative (G&A)
Create role-by-role hiring plan:
Reference team-composition-analysis skill for:
For each role:
Track departmental ratios:
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:
Calculate monthly/quarterly:
Unit Economics:
Efficiency Metrics:
Cash Metrics:
Build conservative, base, and optimistic projections:
Conservative (P10):
Base (P50):
Optimistic (P90):
Create comprehensive markdown report with tables:
Section 1: Executive Summary
Section 2: Model Assumptions
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
Section 10: Validation
Offer to save as markdown file:
financial-projections-YYYY-MM-DD.mdDo:
Don't:
Pairs well with:
/market-opportunity - Use SOM for revenue ceiling/business-case - Include projections in business caseUser: /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]
Create or update AgentSkills. Use when designing, structuring, or packaging skills with scripts, references, and assets.
Create or update AgentSkills. Use when designing, structuring, or packaging skills with scripts, references, and assets.
Set up and use 1Password CLI (op). Use when installing the CLI, enabling desktop app integration, signing in (single or multi-account), or reading/injecting/running secrets via op.
CLI to manage emails via IMAP/SMTP. Use `himalaya` to list, read, write, reply, forward, search, and organize emails from the terminal. Supports multiple accounts and message composition with MML (MIME Meta Language).
Create or update AgentSkills. Use when designing, structuring, or packaging skills with scripts, references, and assets.
Create or update AgentSkills. Use when designing, structuring, or packaging skills with scripts, references, and assets.
Set up and use 1Password CLI (op). Use when installing the CLI, enabling desktop app integration, signing in (single or multi-account), or reading/injecting/running secrets via op.
CLI to manage emails via IMAP/SMTP. Use `himalaya` to list, read, write, reply, forward, search, and organize emails from the terminal. Supports multiple accounts and message composition with MML (MIME Meta Language).