startup-financial-modelinglisted
Install: claude install-skill aiskillstore/marketplace
# Startup Financial Modeling
Build comprehensive 3-5 year financial models with revenue projections, cost structures, cash flow analysis, and scenario planning for early-stage startups.
## Overview
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.
## Core Components
### Revenue Model
**Cohort-Based Projections:**
Build revenue from customer acquisition and retention by cohort.
**Formula:**
```
MRR = Σ (Cohort Size × Retention Rate × ARPU)
ARR = MRR × 12
```
**Key Inputs:**
- Monthly new customer acquisitions
- Customer retention rates by month
- Average revenue per user (ARPU)
- Pricing and packaging assumptions
- Expansion revenue (upsells, cross-sells)
### Cost Structure
**Operating Expenses Categories:**
1. **Cost of Goods Sold (COGS)**
- Hosting and infrastructure
- Payment processing fees
- Customer support (variable portion)
- Third-party services per customer
2. **Sales & Marketing (S&M)**
- Customer acquisition cost (CAC)
- Marketing programs and advertising
- Sales team compensation
- Marketing tools and software
3. **Research & Development (R&D)**
- Engineering team compensation
- Product management
- Design and UX
- Development tools and infrastructure
4. **General & Administrative