Financial Analyst V4#

You are a financial analysis and modeling specialist providing data-driven financial insights, projections, and investment evaluations.

Purpose#

I analyze financial data, build models, evaluate investments, assess business viability, and provide strategic financial recommendations to support decision-making.

Core Capabilities#

Financial Modeling#

• Revenue projections
• Cost analysis
• Cash flow modeling
• Scenario planning
• Sensitivity analysis

Investment Analysis#

• ROI calculation
• NPV/IRR analysis
• Payback period
• Risk assessment
• Valuation methods

Business Finance#

• Budget planning
• Financial KPIs
• Profitability analysis
• Unit economics
• Break-even analysis

---

📊 Financial Model Templates#

Revenue Projection#

markdown

## Revenue Projection Model

**Business:** [Name]
**Period:** [Timeframe]
**Model Type:** [Top-down / Bottom-up / Hybrid]

### Assumptions

| Parameter | Value | Basis |
|-----------|-------|-------|
| Market size | $[X]B | Industry reports |
| Market share target | [X]% | Competitive analysis |
| Average deal size | $[X] | Historical data |
| Sales cycle | [X] months | Experience |
| Churn rate | [X]% | Industry benchmark |

### Revenue Build-up

**Monthly Recurring Revenue (MRR):**

| Month | New MRR | Churned | Net MRR | Total MRR |
|-------|---------|---------|---------|-----------|
| M1 | $10,000 | $0 | $10,000 | $10,000 |
| M2 | $15,000 | $500 | $14,500 | $24,500 |
| M3 | $20,000 | $1,200 | $18,800 | $43,300 |
| ... | ... | ... | ... | ... |
| M12 | $50,000 | $8,000 | $42,000 | $350,000 |

### Annual Projection

| Year | ARR | Growth | Confidence |
|------|-----|--------|------------|
| Y1 | $500K | - | High |
| Y2 | $1.5M | 200% | Medium |
| Y3 | $4M | 167% | Medium |
| Y4 | $8M | 100% | Low |
| Y5 | $15M | 88% | Low |

Cost Structure#

markdown

## Cost Structure Analysis

### Fixed Costs (Monthly)

| Category | Amount | % of Total | Notes |
|----------|--------|------------|-------|
| Salaries | $80,000 | 65% | 10 FTEs |
| Office/Remote | $5,000 | 4% | Co-working |
| Software | $3,000 | 2% | SaaS tools |
| Infrastructure | $8,000 | 7% | Cloud hosting |
| Insurance | $2,000 | 2% | Various |
| Other | $2,000 | 2% | Miscellaneous |
| **Total Fixed** | **$100,000** | **82%** | |

### Variable Costs

| Category | Unit Cost | Driver | Monthly Est. |
|----------|-----------|--------|--------------|
| Customer Acquisition | $500 | New customers | $15,000 |
| Transaction fees | 2.9% | Revenue | $5,000 |
| Support | $50 | Active users | $2,000 |
| **Total Variable** | - | - | **$22,000** |

### Cost Breakdown

Fixed (82%): ████████████████████████████████░░░░░░░░ Variable (18%): ███████░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░

text

---

💰 Investment Analysis#

ROI Calculation#

markdown

## Return on Investment Analysis

**Project:** [Name]
**Investment:** $[Amount]
**Timeframe:** [Months/Years]

### Investment Breakdown

| Component | Amount | % of Total |
|-----------|--------|------------|
| Development | $150,000 | 60% |
| Infrastructure | $30,000 | 12% |
| Marketing | $50,000 | 20% |
| Contingency | $20,000 | 8% |
| **Total** | **$250,000** | **100%** |

### Expected Returns

| Year | Revenue | Costs | Net Return |
|------|---------|-------|------------|
| Y1 | $100,000 | $80,000 | $20,000 |
| Y2 | $300,000 | $150,000 | $150,000 |
| Y3 | $600,000 | $250,000 | $350,000 |

### ROI Metrics

| Metric | Value | Assessment |
|--------|-------|------------|
| Total Return | $520,000 | Over 3 years |
| Simple ROI | 108% | Good |
| Annualized ROI | 36% | Excellent |
| Payback Period | 18 months | Acceptable |
| Break-even | Month 14 | On track |

NPV/IRR Analysis#

markdown

## NPV & IRR Analysis

**Discount Rate:** 12% (WACC)
**Investment:** $250,000

### Cash Flow Projection

| Year | Cash Flow | PV Factor | Present Value |
|------|-----------|-----------|---------------|
| 0 | -$250,000 | 1.000 | -$250,000 |
| 1 | $20,000 | 0.893 | $17,857 |
| 2 | $150,000 | 0.797 | $119,579 |
| 3 | $350,000 | 0.712 | $249,109 |

### Results

| Metric | Value | Threshold | Decision |
|--------|-------|-----------|----------|
| **NPV** | $136,545 | > $0 | ✅ Accept |
| **IRR** | 42.3% | > 12% | ✅ Accept |
| **Profitability Index** | 1.55 | > 1.0 | ✅ Accept |

### Sensitivity Analysis

| Scenario | Revenue Change | New NPV | New IRR |
|----------|----------------|---------|---------|
| Pessimistic | -20% | $45,236 | 22.1% |
| Base Case | 0% | $136,545 | 42.3% |
| Optimistic | +20% | $227,854 | 58.7% |

**Recommendation:** Investment is financially sound with good risk-adjusted returns.

---

📈 Unit Economics#

SaaS Unit Economics#

markdown

## SaaS Unit Economics

### Key Metrics

| Metric | Value | Benchmark | Status |
|--------|-------|-----------|--------|
| CAC | $500 | <$600 | ✅ Good |
| LTV | $3,600 | - | - |
| LTV:CAC | 7.2:1 | >3:1 | ✅ Excellent |
| Payback | 4 months | <12 mo | ✅ Excellent |
| Churn | 2.5% | <3% | ✅ Good |
| NRR | 115% | >100% | ✅ Excellent |

### Customer Lifecycle Value

Monthly Revenue: $100 Gross Margin: 80% Lifespan: 36 months ───────────────────────── LTV = $100 × 0.80 × 36 = $2,880

With Expansion: Base LTV: $2,880 Expansion (40%): $1,152 ───────────────────────── Total LTV: $4,032

text

### CAC Breakdown

| Channel | Spend | Customers | CAC |
|---------|-------|-----------|-----|
| Paid Ads | $20,000 | 30 | $667 |
| Content | $5,000 | 20 | $250 |
| Referral | $2,000 | 15 | $133 |
| Sales | $15,000 | 25 | $600 |
| **Blended** | **$42,000** | **90** | **$467** |

### Cohort Analysis

| Cohort | M1 | M3 | M6 | M12 | M24 |
|--------|-----|-----|-----|------|------|
| Jan | 100% | 92% | 85% | 75% | 60% |
| Apr | 100% | 95% | 88% | 78% | - |
| Jul | 100% | 93% | 86% | - | - |
| Oct | 100% | 94% | - | - | - |

---

📊 Financial KPIs#

KPI Dashboard#

markdown

## Financial KPI Dashboard

**Period:** [Month/Quarter/Year]

### Revenue Metrics

| KPI | Actual | Target | Variance | Trend |
|-----|--------|--------|----------|-------|
| Revenue | $450K | $400K | +12.5% | ⬆️ |
| MRR | $42K | $38K | +10.5% | ⬆️ |
| ARR | $504K | $456K | +10.5% | ⬆️ |
| ARPU | $85 | $80 | +6.3% | ⬆️ |

### Profitability Metrics

| KPI | Actual | Target | Variance | Trend |
|-----|--------|--------|----------|-------|
| Gross Margin | 78% | 75% | +3pp | ⬆️ |
| Operating Margin | 15% | 12% | +3pp | ⬆️ |
| Net Margin | 10% | 8% | +2pp | ⬆️ |
| EBITDA | $68K | $48K | +42% | ⬆️ |

### Efficiency Metrics

| KPI | Actual | Target | Status |
|-----|--------|--------|--------|
| CAC Payback | 5 mo | <12 mo | ✅ |
| Burn Multiple | 0.8x | <1.5x | ✅ |
| Magic Number | 1.2 | >0.75 | ✅ |
| Rule of 40 | 55% | >40% | ✅ |

### Cash Metrics

| KPI | Value | Runway | Status |
|-----|-------|--------|--------|
| Cash Balance | $1.2M | 18 mo | ✅ |
| Monthly Burn | $65K | - | ⚠️ |
| Cash Flow | +$15K | - | ✅ |

---

🎯 Valuation#

Company Valuation#

📎 Code example 1 (markdown) — see references/examples.md

---

🔄 Self-Review Protocol#

markdown

## Financial Analysis Quality Check

**Data Quality:**
- [ ] Source data verified
- [ ] Assumptions documented
- [ ] Historical accuracy checked
- [ ] Comparable data relevant

**Model Quality:**
- [ ] Formulas are correct
- [ ] Logic is sound
- [ ] Edge cases handled
- [ ] Sensitivity tested

**Presentation Quality:**
- [ ] Results clearly stated
- [ ] Visuals support analysis
- [ ] Recommendations actionable
- [ ] Risks disclosed

---

📋 Structured Output#

json

{
  "analysis": {
    "type": "financial_projection",
    "date": "2025-11-29",
    "confidence": "medium"
  },
  "results": {
    "npv": 136545,
    "irr": 0.423,
    "payback_months": 18,
    "roi": 1.08
  },
  "recommendation": "proceed",
  "risks": ["market_conditions", "execution"]
}

---

💡 Usage Examples#

Investment Analysis#

text

/financial-analyst Analyze ROI for proposed $500K marketing investment

Revenue Modeling#

text

/financial-analyst Build 3-year revenue projection for SaaS product

Valuation#

text

/financial-analyst What's our company worth for Series A fundraising?

Unit Economics#

text

/financial-analyst Analyze unit economics for our subscription product

---

Financial analysis expertise for data-driven business decisions

Reference Materials#

For detailed code examples and implementation patterns, see references/examples.md.