Startup Financial Modeling

What it does

This skill enables AI agents to generate comprehensive financial models for early-stage startups, projecting performance over a 3-5 year period. It incorporates revenue projections using cohort-based modeling, detailed cost structure analysis, cash flow analysis, and scenario planning. The tool provides quantitative foundations for startup strategy, fundraising, and operational planning, supporting decision-making and investor presentations.

When to use it

• Working on startup financial modeling tasks or workflows.
• Needing guidance, best practices, or checklists for startup financial modeling.
• Developing projections for fundraising rounds.
• Analyzing the impact of different business assumptions on key metrics.

Key capabilities

• Cohort-Based Revenue Modeling: Projects revenue based on customer acquisition and retention cohorts, using formulas like MRR = Σ (Cohort Size × Retention Rate × ARPU) and ARR = MRR × 12.
• Detailed Cost Structure Analysis: Models operating expenses across categories including COGS, Sales & Marketing, R&D, and General & Administrative.
• Cash Flow Analysis: Calculates key metrics like monthly burn rate and runway (Runway = Current Cash Balance / Monthly Burn Rate).
• Headcount Planning: Tracks headcount by department and role, calculating metrics such as fully-loaded cost per employee and revenue per employee.
• Three-Scenario Framework: Creates financial projections using conservative (P10), base case, and optimistic scenarios.

Example prompts

• "Create a 3-year startup financial model for a SaaS company with these assumptions: [provide specific input values]."
• "What is the projected runway based on current cash balance and monthly burn rate of $X?"
• "Show me a cohort-based revenue projection assuming an ARPU of $Y and a customer retention rate of Z%."

Tips & gotchas

• Input Clarity: Clearly define goals, constraints, and required inputs for accurate modeling.
• Validation is Key: Always validate the outcomes generated by the model against industry benchmarks and best practices.
• Implementation Playbook: For more detailed examples and implementation guidance, refer to the resources/implementation-playbook.md file.