wshobson/agents / plugins/startup-business-analyst/skills/startup-financial-modeling
startup-financial-modeling
VerifiedBuild 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.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 7.6 KB |
| references/details.md | markdown | 2.8 KB |
references/details.md
View on GitHub# startup-financial-modeling — detailed sections
## Step-by-Step Process
### Step 1: Define Business Model
Clarify revenue model and pricing.
**SaaS Model:**
- Subscription pricing tiers
- Annual vs. monthly contracts
- Free trial or freemium approach
- Expansion revenue strategy
**Marketplace Model:**
- GMV projections
- Take rate (% of transactions)
- Buyer and seller economics
- Transaction frequency
**Transactional Model:**
- Transaction volume
- Revenue per transaction
- Frequency and seasonality
### Step 2: Build Revenue Projections
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:**
- Month 1: 100%
- Month 3: 90%
- Month 6: 85%
- Month 12: 75%
- Month 24: 70%
**Revenue Calculation:**
For each cohort, calculate retained customers × ARPU for each month.
### Step 3: Model Cost Structure
Break down costs by category and behavior.
**Fixed vs. Variable:**
- Fixed: Salaries, software, rent
- Variable: Hosting, payment processing, support
**Scaling Assumptions:**
- COGS as % of revenue
- S&M as % of revenue (CAC payback)
- R&D growth rate
- G&A as % of total expenses
### Step 4: Create Hiring Plan
Model headcount growth by role and department.
**Inputs:**
- Starting headcount
- Hiring velocity by role
- Fully-loaded compensation by role
- Benefits and taxes (typically 1.3-1.4x salary)
**Example:**
```
Engineer: $150K salary × 1.35 = $202K fully-loaded
Sales Rep: $100K OTE × 1.30 = $130K fully-loaded
```
### Step 5: Project Cash Flow
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
```
### Step 6: Calculate Key Metrics
Track metrics that matter for stage.
**Revenue Metrics:**
- MRR / ARR
- Growth rate (MoM, YoY)
- Revenue by segment or cohort
**Unit Economics:**
- CAC (Customer Acquisition Cost)
- LTV (Lifetime Value)
- CAC Payback Period
- LTV / CAC Ratio
**Efficiency Metrics:**
- Burn multiple (Net Burn / Net New ARR)
- Magic number (Net New ARR / S&M Spend)
- Rule of 40 (Growth % + Profit Margin %)
**Cash Metrics:**
- Monthly burn rate
- Runway (months)
- Cash efficiency
### Step 7: Scenario Analysis
Create three scenarios with different assumptions.
**Variable Assumptions:**
- Customer acquisition rate (±30%)
- Churn rate (±20%)
- Average contract value (±15%)
- CAC (±25%)
**Fixed Assumptions:**
- Pricing structure
- Core operating expenses
- Hiring plan (adjust timing, not roles)
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| reverse-engineer-anythingmorluto/reaReverse engineer native, managed, Electron/JavaScript, packaged, firmware, and browser targets with REA, and build agent environments (AgentEnv bundles) of web applications from a live instance or a capture, and of Linux desktop apps with a task from a request. Use shipped-artifact or requested runtime evidence to explain features, compare versions, decompile code, or guide a reconstruction. Skip REA for ordinary source-repository architecture analysis. | Stars: 472k | Updated | Claude CodeCodex | Unverified | Install |
| diagnosing-superpowersobra/superpowersUse when a superpowers session went wrong and your human partner wants to know why — repeated work, ignored plans, stumbles, poor results, a skill that didn't fire, "it took too long", "why is it so expensive", "what is it doing" — or wants to build a bug report for the superpowers maintainers, for the current session or a past one identified by id or path, on any harness. | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| dispatching-parallel-agentsobra/superpowersUse when facing 2+ independent tasks that can be worked on without shared state or sequential dependencies | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| executing-plansobra/superpowersUse when executing an implementation plan in the current session as the implementer yourself — your human partner chose inline execution, or no subagent tool is available | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |