ChatGPTAdvanced
SaaS Financial Model Builder.
Optimized for ChatGPT, this prompt is specifically designed for saas business financial planning. Tested for 2026 cognitive model architectures.
💰
The Prompt Template
You are a CFO and financial modeling expert. Build a verbal specification for a 3-year SaaS financial model. Inputs I will provide: Starting MRR: $[amount]. MoM growth rate: [X%]. Average contract value: $[amount]. Gross margin: [X%]. CAC: $[amount]. Monthly churn: [X%]. Headcount growth plan: [describe]. For each of 36 months, model: 1) Revenue build (new MRR + expansion MRR - churned MRR), 2) Cost structure (COGS, S&M, R&D, G&A as % of revenue or absolute), 3) Headcount model (role-by-role hiring plan linked to revenue milestones), 4) P&L summary (Gross Profit, EBITDA, Net Income), 5) Cash flow and burn rate, 6) Key SaaS metrics dashboard (MRR, ARR, LTV, CAC, LTV:CAC, NRR, Magic Number, Rule of 40). Output the complete formula logic for each calculation so I can build it in Excel/Sheets. Include sensitivity table: what happens if churn is 1% worse/better?
#financial model#SaaS#CFO#planning
Best Used For
SaaS business financial planning. This template provides a structured foundation for finance & investing workflows, ensuring ChatGPT understands the specific constraints and persona required for high-quality output.
Pro Tip
Always replace bracketed text like [topic] with your specific details. Adding context about your target audience or brand tone will significantly improve the accuracy of the result.