Advanced

SaaS Churn & LTV Analysis Model

Generates a Python script or Excel logic to calculate SaaS metrics. Perfect for FP&A professionals in the tech industry.

Act as an FP&A Analyst for a SaaS startup. Using a dataset with {customer_id}, {mrr}, {signup_date}, and {churn_date}, write a logic flow to calculate: 1. Logo Churn 2. Net Revenue Retention (NRR) 3. Customer Lifetime Value (LTV) assuming a discount rate of {discount_rate}. Provide the formulas and a brief interpretation of the results.

Related Prompts

Management Accounting & FP&A
Advanced

Unit economics for subscription/business model (CAC, LTV, payback)

Creates a unit economics model with CAC, LTV, gross margin, and payback, including sensitivity analysis. Useful for growth planning and investor discussions.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
16
Management Accounting & FP&A
Beginner

Metric definition library (single source of truth) template

Creates a standardized metric dictionary to prevent KPI drift across teams. Useful for scaling reporting and ensuring consistent definitions.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
17
Management Accounting & FP&A
Beginner

Budget kickoff pack: timeline, owners, templates, instructions

Generates a budget kickoff pack with roles, deadlines, template instructions, and FAQs. Useful for FP&A leaders coordinating cross-functional budgeting.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
34