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
Advanced

Channel rebates and returns accrual model (consumer goods)

Designs an accrual model for rebates, returns, and allowances common in consumer goods, with rollforward schedules. Useful for close and audit support.

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

Loan accounting: nonaccrual, troubled debt, and interest income checks

Builds a checklist and analytics for loan nonaccrual status, modifications, and interest income recognition. Useful for bank controllers and auditors.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
8
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
8