Intermediate

SaaS: CAC Payback Period & Cohort Analysis

Analyzes the efficiency of customer acquisition spend across different monthly cohorts.

As a SaaS FP&A Lead, analyze the {month_year} cohort. Total Marketing Spend: {marketing_spend}. New Customers: {new_customers}. Average MRR: {average_mrr}. Gross Margin: {margin_percent}%. Calculate the 'CAC Payback Period' in months and suggest a strategy if it exceeds {target_months} months.

Related Prompts

Industry-Specific
Intermediate

Standard costing variance dashboard (PPV, labor, overhead)

Creates a variance dashboard structure and investigation playbook for standard costing variances. Useful for plant controllers and operations reviews.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
75
Industry-Specific
Advanced

SaaS revenue waterfall: bookings → billings → revenue → cash

Builds a SaaS revenue waterfall reconciling bookings, billings, deferred revenue, and revenue recognition. Useful for FP&A and accounting alignment and board reporting.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
76
Industry-Specific
Intermediate

ARR/MRR rollforward with churn, expansion, and cohort view

Creates an ARR/MRR rollforward and cohort-based retention view using subscription data. Useful for SaaS metrics reporting and investor updates.

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