Open the CSV in Excel, or import it into Google Sheets and choose comma-separated values. Save your working copy in a controlled location. The CSV contains the rows below and space for your notes; it has no macros, formulas or live account connection. The separate Excel workbook contains editable example inputs and formulas that update the forecast.
How to use the template
Enter one order's economics
Order value, product cost, shipping and packing, payment and app fees per order, your cost per new customer (CAC), how many customers you plan to buy, the LTV horizon and your payback target in months.
Paste your retention
The share of the starting cohort that orders in each month, month 1 being the first order at 100%. Shopify's customer cohort analysis report (Analytics > Reports) groups customers by first order date; for a subscription, use the share still active and billed.
Read the Summary
LTV on revenue and on margin, both ratios with a verdict, the payback month against your target, day-0 cash out, the cohort's cash at the end of the horizon, repeat orders, and the most you can pay per customer for 3:1 on margin or for payback by your target month.
Check the cash and the what-ifs
The Cash tab charts the cohort's cash month by month; red months are cash you must fund. Sensitivity shows LTV:CAC on margin for CACs from $30 to $110 and margins from 40% to 80%.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Month | Share of cohort ordering | Cumulative margin per customer |
|---|---|---|
| Day 0 | ||
| 1 | 100% | $27.00 |
| 2 | 55% | $41.85 |
| 3 | 42% | $53.19 |
| 4 | 35% | $62.64 |
| 12 | 18% | $112.05 |
Worked review example
Fictional coffee subscription: $45 order, $18 of product, shipping and fees, so $27 margin (60%); CAC $62 from Meta; 4.15 orders per customer in 12 months on an assumed retention curve. LTV is $186.75 on revenue (3.0x CAC) and $112.05 on margin (1.8x).
Each customer pays back in month 4 ($62.64 cumulative margin). Buying 10,000 customers costs $620,000 on day 0; the cohort turns cash-positive in month 4 (+$6,400) and reaches +$500,500 by month 12 from 31,500 repeat orders. For 3:1 on margin the brand could pay $37.35 per customer; for payback within 6 months, $78.03.
What this template does and does not establish
The example retention curve is an assumption, not a benchmark; young cohorts haven't shown month 12 yet. Margin is per order before ad spend and leaves out fixed costs. Meta's cost per purchase can include repeat buyers; new-customer CAC is better. The cash curve assumes everyone is bought on day 0. 3:1 is a SaaS rule of thumb that assumes no margin adjustment and 80%+ margins. No account connection, macros or automatic changes.
