1. What to replace:
Replace each {{placeholder}} with your SaaS brand name, pricing tiers, current baseline financial data, forecast horizon, and customer acquisition channels.
2. How to customize variables:
- business_name: Enter your company name.
- monetization_structure: Specify monthly, annual, per-seat, or API usage pricing.
- current_baseline_metrics: Include starting MRR/ARR, customer counts, and historical churn rates.
- forecast_horizon: Tailor for 12 months, 24 months, or 3 years.
- growth_channels: Reflect your actual go-to-market motion (PLG vs Sales-Led).
3. Compatible AI Tools:
ChatGPT (GPT-4o), Claude 3.5 Sonnet, Gemini 1.5 Pro.
4. Expected Result:
A complete formula-ready spreadsheet architecture ready to build in Google Sheets, Excel, or Causal with verifiable SaaS unit economics.
Act as a Wall Street Venture CFO and SaaS Financial Modeling Expert. Design a comprehensive, investor-grade Financial Model Architecture and Unit Economics Forecast for a SaaS business named "{{business_name}}".
Financial Baseline & Business Model:
- Monetization Model: {{monetization_structure}} (e.g., Seat-based subscription, usage-based metering, hybrid tiered model)
- Current Financial Baseline: {{current_baseline_metrics}} (e.g., $50k MRR, $800 ACV, 3.2% monthly churn)
- Target Forecast Horizon: {{forecast_horizon}} (e.g., 24-Month Monthly Forecast or 3-Year Annual Projection)
- Core Growth Drivers: {{growth_channels}} (e.g., Inbound SEO, Outbound SDRs, Product-Led Growth self-serve)
Financial Model Architecture Deliverables:
1. Revenue & Cohort Retention Mechanics:
- Mathematical formula for New MRR, Expansion/Upsell MRR, Contraction MRR, and Churn MRR.
- Cohort Retention Layer: Net Revenue Retention (NRR) and Gross Revenue Retention (GRR) decay curves.
- Customer Count Waterfall: Beginning Customers + New Adds - Churned Customers = Ending Customers.
2. Cost of Goods Sold (COGS) & Gross Margin Structure:
- Hosting/Cloud infrastructure (AWS/Azure cost scaling curves), customer support staffing ratios, payment gateway processing fees (Stripe 2.9% + $0.30), target gross margin (80%+).
3. Operating Expenses (OpEx) Headcount & Capacity Planning:
- R&D (Engineering salaries, AI model API tokens, tools).
- S&M (Sales rep quotas, SDR:AE ratios, commission tiers, paid ad spend).
- G&A (Executive, legal, compliance SOC-2, accounting).
4. Executive Unit Economics & Benchmark Dashboard:
Formulas and realistic benchmarks for:
- CAC (Customer Acquisition Cost) by channel
- CAC Payback Period in months
- LTV (Customer Lifetime Value) & LTV:CAC Ratio (target >3:1)
- Burn Multiple (Net Burn / Net New ARR)
- Magic Number (Sales Efficiency)
- Rule of 40 Calculation (YoY Revenue Growth Rate + Free Cash Flow Margin)
Customize this prompt (fill variables)
How to use this prompt
Example: what to expect
Example input
business_name: CloudGuard
monetization_structure: Annual contract enterprise security SaaS averaging $24,000 ACV billed upfront
current_baseline_metrics: $80k MRR ($960k ARR), 40 enterprise clients, 0.8% monthly logo churn, 122% NRR
forecast_horizon: 3-Year annual forecast targeting $5M ARR
growth_channels: Outbound enterprise sales reps with 90-day sales cycles and partner channel referrals
Example output
A complete 3-year financial model architecture specifying the Revenue Waterfall, Headcount hiring ramp (scaling from 2 AEs to 6 AEs with $800k quotas), Cloud hosting COGS at 14% of revenue, and an executive dashboard computing CAC Payback at 11 months, LTV:CAC at 4.2x, and a Rule of 40 score of 48%.
Variables explained
| Variable | What to enter |
|---|---|
{{business_name}} |
Enter company name. |
{{monetization_structure}} |
Specify subscription tiers or usage fees. |
{{current_baseline_metrics}} |
List starting MRR, customer count, and churn. |
{{forecast_horizon}} |
Specify timeframe. |
{{growth_channels}} |
Define your GTM acquisition motion. |
Tips for better results
Best used for: SaaS financial modeling and unit economics
- Give the AI context first: who you are, who the audience is, and what “good” looks like for you.
- Ask for output in a specific format (bullets, table, markdown) when you need structure.
- If the result is close but not perfect, reply with “keep the structure, make it more…” — do not start over.
- For long tasks, split the prompt into steps instead of expecting one giant answer.
- Different tools behave differently — ChatGPT, Claude and Gemini each have their own style. Try this prompt on the tool you use most.
How to use this Finance prompt effectively
What this prompt does
Build an investor-grade SaaS financial forecast including 3-statement model architecture, cohort retention modeling, CAC payback, and burn multiple projections.
Getting the most out of it
- Copy the prompt and paste it into your AI tool of choice (ChatGPT, Claude or Gemini).
- Fill the variables in curly brackets with your own topic, audience and tone — the customize button above builds a ready version for you.
- Review the first draft for facts and style before using it. AI output is a starting point, not a final product.
- Iterate: tell the AI what to keep and what to change. Small corrections beat re-typing the whole prompt.
Common mistakes to avoid
- Leaving the {{variables}} unfilled — the AI then guesses your topic.
- Expecting one output to be perfect — plan for 2–3 rounds of refinement.
- Pasting confidential information into public AI tools.