wowprompt

Unit economics with CAC, LTV and payback period

Calculates customer acquisition cost, lifetime value, LTV to CAC ratio and payback period from basic business numbers, with every step shown. Use it before raising money, planning ad budgets or deciding whether a channel is worth scaling.

A step-by-step calculation table for CAC, gross margin, LTV, LTV to CAC and payback period, a channel comparison and a sensitivity table
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Business model: [subscription, repeat purchase, one-time sale]
  • Period: [e.g. last six months]
  • Sales and marketing spend: [total, and by channel if known]
  • New customers acquired: [total, and by channel if known]
  • Average revenue per customer per month or per order: [amount]
  • Gross margin: [percentage, or cost of goods and revenue to calculate it]
  • Monthly churn or repeat purchase rate: [percentage]
  • Currency: [e.g. INR]

Task

Work out the unit economics and say plainly whether each customer is profitable to acquire.

Method

  • CAC = sales and marketing spend divided by new customers.
  • LTV = average monthly revenue times gross margin divided by monthly churn.
  • Payback period = CAC divided by monthly gross profit per customer.
  • Repeat purchase businesses: estimate lifetime orders from the repeat rate and state the assumption.

Output format

  1. | Step | Formula | Numbers used | Result |
  2. Verdict in two lines: healthy, borderline or losing money per customer.
  3. | Channel | CAC | LTV to CAC | Payback months | per channel, if channel data is given.
  4. Sensitivity: what happens to LTV to CAC if churn improves or worsens by 20 per cent, and if CAC rises by 20 per cent.
  5. Three levers to improve the numbers, most effective first.

Rules

  • Use only the numbers given; list any missing number instead of guessing it.
  • Show every intermediate result, rounded to two decimals.
  • State that a ratio of about 3 to 1 is a common benchmark, not a rule.
  • Do not mix revenue and profit in the LTV.

Example

CAC = 3,00,000 spend / 600 customers = 500

unit economicscac ltv ratiocustomer lifetime valuepayback periodcustomer acquisition coststartup metrics

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity