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

• Working on startup financial modeling tasks or workflows
• Needing guidance, best practices, or checklists for startup financial modeling

Do not use this skill when

• The task is unrelated to startup financial modeling
• You need a different domain or tool outside this scope

Instructions

• Clarify goals, constraints, and required inputs.
• Apply relevant best practices and validate outcomes.
• Provide actionable steps and verification.

Overview

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.

Core Components

Revenue Model

Cohort-Based Projections: Build revenue from customer acquisition and retention by cohort.

Formula:

MRR = Σ (Cohort Size × Retention Rate × ARPU)
ARR = MRR × 12

Key Inputs:

• Monthly new customer acquisitions
• Customer retention rates by month
• Average revenue per user (ARPU)
• Pricing and packaging assumptions
• Expansion revenue (upsells, cross-sells)

Cost Structure

Operating Expenses Categories:

1. Cost of Goods Sold (COGS)

   • Hosting and infrastructure
   • Payment processing fees
   • Customer support (variable portion)
   • Third-party services per customer

2. Sales & Marketing (S&M)

   • Customer acquisition cost (CAC)
   • Marketing programs and advertising