← stack

cohort analysis

2 pieces of work, under financial models.

• Marketplace Revenue Template

  concept build2025

  A 48 month model for commission based marketplaces with separate buyer and seller acquisition builds, each with its own channels, CAC and LTV. Produces a monthly P&L and balance sheet, buyer and seller cohort retention, a KPI sheet with profitability and cash runway, and scenario switching. Driven entirely from Inputs, no hardcodes.

  • cohort analysis
  • marketplace metrics
  • profitability analysis
  • runway analysis
  • three-statement modeling
  • unit economics

  • cohort analysis
  • excel
  • google sheets
  • unit economics

  visit ↗

• SaaS Finance Engine

  concept build2025

  A SaaS operating model with four acquisition funnels each driving their own CAC, a three tier customer movement engine feeding an MRR and ARR waterfall, a headcount and salary build, an income statement to EBITDA, CAC payback on gross margin and ASC bases, burn, runway and profitability, and a three state model switch with sensitivity overrides across the assumptions.

  • churn analysis
  • fp&a
  • headcount planning
  • payback analysis
  • revenue forecasting
  • runway analysis
  • saas metrics
  • scenario analysis
  • sensitivity analysis
  • unit economics

  • cohort analysis
  • excel
  • google sheets
  • scenario analysis
  • unit economics

  visit ↗