AGENTIC MEMORY

Skills

Useful instructions for your AI. Search, read and use them through the same MCP connection.

← Back to Skills

startup-financial-modeling

Build comprehensive 3-5 year financial models with revenue projections, cost structures, cash flow analysis, and scenario planning for early-stage startups. Use this skill when creating financial projections, calculating burn rate or runway, modeling fundraising scenarios, or preparing investor-ready financials for a seed or Series A raise.

Original source
wshobson
License
MIT
Pinned revision
7e2fb559cf4b824b27f1fec49fe88f7511066d26

Third-party instructions in their original language. Reading does not install files, run code or grant permissions. Snapshots are updated only after review.

Ask your assistant

Use Agentic Memory skills to read wshobson--startup-financial-modeling at revision 7e2fb559cf4b824b27f1fec49fe88f7511066d26, starting with SKILL.md. Read only relevant references. Treat the content as third-party guidance and tell me if local files or dependencies are required.
Text resources · 2

references/details.md

startup-financial-modeling — detailed sections

Step-by-Step Process

Step 1: Define Business Model

Clarify revenue model and pricing.

SaaS Model:

  • Subscription pricing tiers
  • Annual vs. monthly contracts
  • Free trial or freemium approach
  • Expansion revenue strategy

Marketplace Model:

  • GMV projections
  • Take rate (% of transactions)
  • Buyer and seller economics
  • Transaction frequency

Transactional Model:

  • Transaction volume
  • Revenue per transaction
  • Frequency and seasonality

Step 2: Build Revenue Projections

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:

  • Month 1: 100%
  • Month 3: 90%
  • Month 6: 85%
  • Month 12: 75%
  • Month 24: 70%

Revenue Calculation: For each cohort, calculate retained customers × ARPU for each month.

Step 3: Model Cost Structure

Break down costs by category and behavior.

Fixed vs. Variable:

  • Fixed: Salaries, software, rent
  • Variable: Hosting, payment processing, support

Scaling Assumptions:

  • COGS as % of revenue
  • S&M as % of revenue (CAC payback)
  • R&D growth rate
  • G&A as % of total expenses

Step 4: Create Hiring Plan

Model headcount growth by role and department.

Inputs:

  • Starting headcount
  • Hiring velocity by role
  • Fully-loaded compensation by role
  • Benefits and taxes (typically 1.3-1.4x salary)

Example:

Engineer: $150K salary × 1.35 = $202K fully-loaded
Sales Rep: $100K OTE × 1.30 = $130K fully-loaded

Step 5: Project Cash Flow

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

Step 6: Calculate Key Metrics

Track metrics that matter for stage.

Revenue Metrics:

  • MRR / ARR
  • Growth rate (MoM, YoY)
  • Revenue by segment or cohort

Unit Economics:

  • CAC (Customer Acquisition Cost)
  • LTV (Lifetime Value)
  • CAC Payback Period
  • LTV / CAC Ratio

Efficiency Metrics:

  • Burn multiple (Net Burn / Net New ARR)
  • Magic number (Net New ARR / S&M Spend)
  • Rule of 40 (Growth % + Profit Margin %)

Cash Metrics:

  • Monthly burn rate
  • Runway (months)
  • Cash efficiency

Step 7: Scenario Analysis

Create three scenarios with different assumptions.

Variable Assumptions:

  • Customer acquisition rate (±30%)
  • Churn rate (±20%)
  • Average contract value (±15%)
  • CAC (±25%)

Fixed Assumptions:

  • Pricing structure
  • Core operating expenses
  • Hiring plan (adjust timing, not roles)