SaaS financial model with unit economics

🎭 Role

Act as a world-class SaaS CFO and Financial Modeler with deep expertise in venture capital, startup scaling, and investor relations. You have a track record of building robust, driver-based financial models that satisfy both internal operational needs and external due diligence requirements.

🌐 Context

I am preparing for a [FUNDING STAGE, e.g., Series A] round and require a professional, investor-ready SaaS financial model. The goal is to demonstrate [PRIMARY OBJECTIVE, e.g., a path to profitability, scaling efficiency, or market penetration] while providing clear visibility into our operational health and unit economics.

🛠️ Task Instruction

Design a comprehensive, driver-based SaaS financial model that is scalable, audit-ready, and insightful. Structure your response according to the following logic:

1. Revenue Engine: Build a model based on cohort analysis, incorporating new customer acquisition, expansion revenue, contraction, and churn.
2. Unit Economics: Calculate CAC (blended and paid), LTV, and the LTV:CAC ratio. Explain the assumptions used for payback periods.
3. Operational Expenditure (OpEx): Provide a detailed breakdown across COGS, S&M, R&D, and G&A, ensuring the logic aligns with our headcount plan.
4. Cash Flow & Runway: Construct a cash flow statement that maps out burn rate and runway projections based on the provided [GROWTH RATE] and [FUNDING AMOUNT].
5. Scenario Planning: Develop a framework for Best, Base, and Worst-case scenarios by adjusting key variables (e.g., churn rate, sales cycle length, or conversion rates).
6. Executive Dashboard: Summarize key SaaS metrics, including ARR, NRR, GRR, and the "Rule of 40."
7. Cap Table & Dilution: Outline a basic cap table logic that illustrates the impact of [INVESTMENT SIZE] at a [PRE-MONEY VALUATION].

⚖️ Constraints & Tone

• Tone: Professional, analytical, objective, and financially rigorous.
• Clarity: Avoid unnecessary jargon; provide clear definitions for complex financial inputs.
• Avoid: Do not provide generic boilerplate text; ensure every section references specific SaaS benchmarks (e.g., Bessemer/SaaS Capital standards).
• Length: Be concise but comprehensive. Prioritize logical flow and structural integrity.

📝 Output Format

• Introduction: A brief summary of the model’s architecture.
• Model Framework: Use Markdown tables to present logical structures, formulas, and variable inputs.
• Key Insights: A section explaining the strategic "why" behind these specific modeling choices.
• Sensitivity Analysis: Provide a table illustrating how changes in [CRITICAL VARIABLE, e.g., Churn] impact the 24-month ARR projection.

Placeholders

• [FUNDING STAGE]: (e.g., Seed, Series A)
• [PRIMARY OBJECTIVE]: (e.g., Efficiency, Rapid Growth)
• [GROWTH RATE]: (e.g., 10% MoM)
• [FUNDING AMOUNT]: (e.g., $5M)
• [PRE-MONEY VALUATION]: (e.g., $20M)
• [CRITICAL VARIABLE]: (e.g., Customer Churn Rate)