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

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
173
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
127
Industry-Specific
Advanced

Inventory reserve framework: obsolescence, shrink, and markdowns

Designs an inventory reserve approach for obsolescence and markdowns with calculation templates and controls. Useful for retail and manufacturing close and audit support.

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