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
BeginnerMonthly variance analysis: budget vs actual with bridges
Automates variance analysis with price/volume/mix and spending bridges where applicable. Produces exec-ready narratives and follow-up questions.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
47
Management Accounting & FP&A
IntermediateCost allocation model: shared services and drivers
Designs a cost allocation approach for shared services using clear drivers and documentation. Useful for management reporting and chargeback models.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
67
Management Accounting & FP&A
BeginnerMetric 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
56