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
Intermediate

Quarterly Firm Performance Dashboard (Internal)

Identifies the KPIs the Partners should track to measure the health of the practice.

GPT-4oClaude 3.5 Sonnet
0
0
7
Management Accounting & FP&A
Beginner

Departmental Expense Budget Template

Provides a structured guide for managers to submit their annual spending requests.

GPT-4oGemini 1.5 Pro
0
0
15
Management Accounting & FP&A
Intermediate

Rolling forecast update: variance bridge to new forecast

Updates a rolling forecast by bridging from prior forecast to actuals and new assumptions. Produces a clear bridge and narrative for leadership.

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