
Startup Financial Modeling & Burn Analysis
Build dynamic startup financial models and runway projections with scenario analysis
What You Can Do
You can build sophisticated multi-year financial projections that handle startup-specific uncertainties like non-linear hiring, uncertain revenue, and rapid scaling. Claude helps you model multiple burn scenarios (lean, target, aggressive), stress-test key assumptions, and translate complex financial data into clear board-ready narratives and visualizations. This skill accelerates funding-round preparation and ongoing financial planning by automating model building and scenario sensitivity analysis.
Features
test lean, target, and aggressive spending paths simultaneously to understand runway under different conditions
model team growth with non-linear salary scales, equity vesting, benefits, and onboarding costs
build projections for uncertain or non-existent revenue with multiple growth curves and customer acquisition timing
forecast cash depletion dates and identify funding milestones or breakeven timelines
automatically generate which assumptions (pricing, churn, hiring pace, sales cycle length) have the biggest financial impact
convert raw assumptions into polished P&L, cash flow, and balance sheet outputs with narrative explanations
analyze product margin, customer acquisition cost, lifetime value, and payback periods by segment
evaluate impact of slower sales cycles, pricing pressure, unexpected expenses, or delayed funding closes
Example Output
Monthly Cash Runway Forecast:
- Current Cash: $2.1M
- Monthly Burn (Target Scenario): $185K
- Runway: 11.4 months
- Funding Needed By: Q3 2025
Sensitivity Analysis:
- If sales cycle extends 2 months: runway reduces to 9.2 months
- If hiring pace increases 25%: burn jumps to $215K/month, runway: 9.8 months
- If churn hits 8% (vs. 5% assumption): revenue model extends breakeven 6 months
Board-Ready Summary: Given current burn of $185K/month and $2.1M cash on hand, the company has 11.4 months of runway under base case assumptions. Key risks: delayed customer contracts (extends timeline 2+ months) and accelerated hiring to hit growth targets (costs $30K/month additional burn). Recommend Series A target: $4M to reach 24-month runway to profitability.
What's Included
- SKILL.md: system prompt and usage guidelines
- Financial Model Template: P&L, cash flow, and balance sheet worksheets with formulas
- Scenario Comparison Framework: structured format for lean/target/aggressive spending paths
- Runway Calculator Checklist: step-by-step inputs (headcount, salaries, operating costs, revenue assumptions)
- Sensitivity Analysis Worksheet: pre-built template for testing assumption impact
- Investor Narrative Guide: structure for translating model outputs into funding pitch story
Who It's For
- Early-stage CFOs and VPs of Finance managing seed to Series B funding rounds
- Founders building financial models for investor pitches and board presentations
- Finance operations managers forecasting cash runway and burn scenarios
- Business operations leaders evaluating hiring plans against cash constraints
- Startup finance consultants building models for portfolio companies
Best For
- Annual and multi-year financial projections for fundraising rounds
- Monthly and quarterly runway forecasting and board updates
- Scenario stress-testing (sales delays, hiring acceleration, pricing changes)
- Unit economics modeling for product lines or customer segments
- Sensitivity analysis to identify which assumptions drive financial outcomes







