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
You might also like
This skill automates the complex work of calculating material price, quantity, and usage variances; labor rate and efficiency variances; and overhead variances across products, departments, and time periods. You input production data and standard cost tables, and Claude processes the variance calculations, organizes findings by significance, and generates detailed narratives explaining root causes of deviations. This transforms hours of spreadsheet manipulation into a structured analysis package ready for management review and variance committee meetings.
by eryet
You can rapidly cross-reference transaction patterns, revenue data, and economic activity against state-specific nexus thresholds to identify which states trigger filing obligations. The skill flags compliance gaps across physical presence, economic nexus, click-through, and affiliate nexus types, helping you determine filing requirements, quantify retroactive exposure risk, and prioritize registration in new states as clients expand.
by eryet
You can upload aging reports and AR subledger data to Claude, which analyzes bucket distributions, reconciles balances to the general ledger, flags anomalies and aging pattern irregularities, and generates documented collection strategies. Claude produces prioritized customer lists, DSO benchmarking analysis, allowance adequacy assessments, and compliance-ready audit schedules—transforming raw AR data into actionable cash flow optimization strategies.
by eryet
You can systematically validate employee payroll records, cross-check tax withholding calculations against current tax brackets, verify regulatory compliance across federal/state/local requirements, and flag anomalies that could trigger penalties—all before executing payment runs. This reduces processing time by 40-60% while catching errors that manual spreadsheet reviews typically miss, working across ADP, Workday, Gusto, and manual payroll systems.
by eryet
You systematically extract financial red flags from claim submissions, construct causal narratives linking evidence to fraud conclusions, and quantify potential loss exposure. This skill helps you distinguish between legitimate claim variations and fraud indicators, enabling you to generate investigation summaries defensible in litigation, settlement negotiations, or Special Investigation Unit (SIU) presentations.
by eryet
This skill helps you audit nexus comprehensively by analyzing physical presence rules, economic thresholds, affiliate connections, and marketplace facilitator statutes across all 50 states and relevant localities. You'll document nexus triggers specific to your client's business model—whether they're selling through marketplaces, using drop-shipping, hiring remote employees, or expanding operations. The result is an actionable filing calendar and remediation strategy that minimizes compliance gaps and protects against substantial back-tax assessments, penalties, and interest.
by eryet
You can allocate indirect costs (administration, utilities, depreciation, maintenance) across clinical and non-clinical departments using activity-based costing (ABC) and traditional allocation methodologies. This skill helps you calculate precise allocation rates, model reimbursement scenarios, validate cost driver selections, and document allocation methods for compliance—enabling data-driven decisions on service line profitability, pricing strategies, and payer contract negotiations.
by eryet
You can systematically evaluate payment timing decisions across your vendor base by modeling discount capture opportunities against working capital requirements. The skill analyzes vendor payment terms, your cash flow constraints, and strategic vendor priorities to generate prioritized payment schedules that maximize savings while maintaining adequate liquidity and protecting critical supplier relationships.
by eryet