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
Beginner

Nonprofit: Functional Expense Allocation (990)

Allocates expenses between Program, Management, and Fundraising buckets.

GPT-4oGemini 1.5 Pro
0
0
54
Industry-Specific
Advanced

CECL allowance model governance: assumptions, controls, and doc

Designs a CECL model governance and documentation package including assumptions, controls, and validation. Useful for banks and auditors supporting allowance estimates.

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

Retail gross margin bridge: markdowns, mix, shrink, freight

Builds a gross margin bridge explaining changes driven by markdowns, mix, shrink, and freight. Useful for merchandising and finance alignment.

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