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

Inventory Valuation: LIFO vs FIFO Impact

Analyzes the effect of inventory cost flow assumptions on COGS and taxes.

GPT-4oGemini 1.5 Pro
0
0
172
Management Accounting & FP&A
Advanced

Allocating Shared Service Costs (Corporate Overhead)

Determines how to charge back HR, IT, and Finance costs to operating business units.

Claude 3.5 Sonnet
0
0
169
Management Accounting & FP&A
Intermediate

Margin Bridge (EBITDA Bridge) Narrative

Explains the 'walk' from last year's EBITDA to this year's EBITDA.

GPT-4oClaude 3.5 Sonnet
0
0
160