Customer Acquisition Payback and Cohort Efficiency Breakdown

Role: Principal Growth Marketing Financial Analyst

Context

• Target Company Profile: {{company_profile}}
• In-Scope Acquisition Channels: {{acquisition_channels}}
• Cohort Retention & Churn Data: {{cohort_retention_data}}
• Gross Margin Percentage: {{gross_margin_rate}}
• Cost of Capital / Discount Rate: {{discount_rate_wacc}}
• Acquisition Budget & Spend: {{blended_cac_budget}}

Task

Deliver a rigorous quantitative cohort efficiency analysis that models customer acquisition cost (CAC) payback periods, customer lifetime value (LTV) dynamics, and net cash flow yield across channels.

Method

1. Calculate channel-specific fully-loaded CAC using {{acquisition_channels}} and {{blended_cac_budget}}.
2. Map monthly revenue decay curves using retention milestones in {{cohort_retention_data}}.
3. Apply {{gross_margin_rate}} to gross cohort revenue to determine cumulative contribution margin per user.
4. Determine the exact month where cumulative gross profit matches fully-loaded CAC for each cohort.
5. Discount future cash flows across a 36-month period using {{discount_rate_wacc}} to compute discounted LTV:CAC ratios.
6. Compare performance between organic-assisted and purely paid acquisition cohorts.
7. Synthesize findings into capital allocation guidelines for {{company_profile}}.

Constraints

• MUST calculate payback periods in fractional months rounded to one decimal place.
• MUST NOT blend distinct channel economics without presenting unblended metrics first.
• Overhead and operational acquisition costs must be incorporated into the fully loaded CAC.
• Assume standard straight-line churn unless {{cohort_retention_data}} specifies otherwise.

Output format

• Unit Economics Overview (tabular format: Channel, CAC, Payback Period in Months, 12M LTV:CAC, 36M LTV:CAC)
• Cohort Decay and Cash Recovery Synthesis (max 250 words)
• Risk Analysis: Cohort Underperformance Drivers (3-4 analytical observations)
• Strategic Capital Guidance (max 200 words with explicit spend reallocation directives)

Self-review

• Ensure discount rate from {{discount_rate_wacc}} is properly applied to extended LTV forecasts.
• Check that gross margin is factored into payback calculations rather than raw revenue.
• Validate that all acquisition channels from {{acquisition_channels}} appear in the unit economics overview.