Loading...
Loading...
Build comprehensive 3-5 year financial models with revenue projections, cost structures, cash flow analysis, and scenario planning for early-stage startups.
resources/implementation-playbook.md.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.
Cohort-Based Projections: Build revenue from customer acquisition and retention by cohort.
Formula:
MRR = Σ (Cohort Size × Retention Rate × ARPU)
ARR = MRR × 12
Key Inputs:
Operating Expenses Categories:
Cost of Goods Sold (COGS)
Sales & Marketing (S&M)
Research & Development (R&D)
General & Administrative (G&A)
Components:
Formula:
Runway = Current Cash Balance / Monthly Burn Rate
Monthly Burn = Monthly Revenue - Monthly Expenses
Role-Based Hiring Plan: Track headcount by department and role.
Key Metrics:
Typical Ratios (Early-Stage SaaS):
Conservative Scenario (P10):
Base Scenario (P50):
Optimistic Scenario (P90):
Detailed Projections: 3 Years
High-Level Projections: Years 4-5
Clarify revenue model and pricing.
SaaS Model:
Marketplace Model:
Transactional Model:
Use cohort-based methodology for accuracy.
Monthly Customer Acquisition: Define new customers acquired each month.
Retention Curve: Model customer retention over time.
Typical SaaS Retention:
Revenue Calculation: For each cohort, calculate retained customers × ARPU for each month.
Break down costs by category and behavior.
Fixed vs. Variable:
Scaling Assumptions:
Model headcount growth by role and department.
Inputs:
Example:
Engineer: $150K salary × 1.35 = $202K fully-loaded
Sales Rep: $100K OTE × 1.30 = $130K fully-loaded
Calculate monthly cash position and runway.
Monthly Cash Flow:
Beginning Cash
+ Revenue Collected (consider payment terms)
- Operating Expenses Paid
- CapEx
= Ending Cash
Runway Calculation:
If Ending Cash < 0:
Funding Need = Negative Cash Balance
Runway = 0
Else:
Runway = Ending Cash / Average Monthly Burn
Track metrics that matter for stage.
Revenue Metrics:
Unit Economics:
Efficiency Metrics:
Cash Metrics:
Create three scenarios with different assumptions.
Variable Assumptions:
Fixed Assumptions:
Revenue Drivers:
Key Ratios:
Example Projection:
Year 1: $500K ARR, 50 customers, $100K MRR by Dec
Year 2: $2.5M ARR, 200 customers, $208K MRR by Dec
Year 3: $8M ARR, 600 customers, $667K MRR by Dec
Revenue Drivers:
Key Ratios:
Example Projection:
Year 1: $5M GMV, 15% take rate = $750K revenue
Year 2: $20M GMV, 15% take rate = $3M revenue
Year 3: $60M GMV, 15% take rate = $9M revenue
Revenue Drivers:
Key Ratios:
Revenue Drivers:
Key Ratios:
Pre-Money Valuation: Based on metrics and comparables.
Dilution:
Post-Money = Pre-Money + Investment
Dilution % = Investment / Post-Money
Use of Funds: Allocate funding to extend runway and achieve milestones.
Example:
Raise: $5M at $20M pre-money
Post-Money: $25M
Dilution: 20%
Use of Funds:
- Product Development: $2M (40%)
- Sales & Marketing: $2M (40%)
- G&A and Operations: $0.5M (10%)
- Working Capital: $0.5M (10%)
Identify Key Milestones:
Funding Amount: Ensure runway to achieve next milestone + 6 months buffer.
Pitfall 1: Overly Optimistic Revenue
Pitfall 2: Underestimating Costs
Pitfall 3: Ignoring Cash Flow Timing
Pitfall 4: Static Headcount
Pitfall 5: Not Scenario Planning
Sanity Checks:
Benchmark Against Peers: Compare key metrics to similar companies at similar stage.
Investor Feedback: Share model with advisors or investors for feedback on assumptions.
For detailed model structures and advanced techniques:
references/model-templates.md - Complete financial model templates by business modelreferences/unit-economics.md - Deep dive on CAC, LTV, payback, and efficiency metricsreferences/fundraising-scenarios.md - Modeling funding rounds and dilutionWorking financial models with formulas:
examples/saas-financial-model.md - Complete 3-year SaaS model with cohort analysisexamples/marketplace-model.md - Marketplace GMV and take rate projectionsexamples/scenario-analysis.md - Three-scenario framework with sensitivitiesTo create a startup financial model:
For complete templates and formulas, reference the references/ and examples/ files.
startup-financial-modeling is an expert AI persona designed to improve your coding workflow. This skill should be used when the user asks to "create financial projections", "build a financial model", "forecast revenue", "calculate burn rate", "estimate runway", "model cash flow", or requests 3-5 year financial planning for a startup. It provides senior-level context directly within your IDE.
To install the startup-financial-modeling skill, download the package, extract the files to your project's .cursor/skills directory, and type @startup-financial-modeling in your editor chat to activate the expert instructions.
Yes, the startup-financial-modeling AI persona is completely free to download and integrate into compatible Agentic IDEs like Cursor, Windsurf, Github Copilot, and Anthropic MCP servers.
This skill should be used when the user asks to "create financial projections", "build a financial model", "forecast revenue", "calculate burn rate", "estimate runway", "model cash flow", or requests 3-5 year financial planning for a startup.
Download Skill Package.cursor/skills@startup-financial-modeling in editor chat.Copy the instructions from the panel on the left and paste them into your custom instructions setting.
"Adding this startup-financial-modeling persona to my Cursor workspace completely changed the quality of code my AI generates. Saves me hours every week."
Developers who downloaded startup-financial-modeling also use these elite AI personas.
Expert in building 3D experiences for the web - Three.js, React Three Fiber, Spline, WebGL, and interactive 3D scenes. Covers product configurators, 3D portfolios, immersive websites, and bringing depth to web experiences. Use when: 3D website, three.js, WebGL, react three fiber, 3D experience.
Structured guide for setting up A/B tests with mandatory gates for hypothesis, metrics, and execution readiness.
You are an accessibility expert specializing in WCAG compliance, inclusive design, and assistive technology compatibility. Conduct audits, identify barriers, and provide remediation guidance.
Explore our most popular utilities designed for the modern Indian creator.