CAC & LTV Calculator

Work out customer acquisition cost and lifetime value for every channel, and see which channels pay back.

Type spend, new customers and a few numbers about repeat orders. The file shows CAC, LTV, the LTV:CAC ratio and the payback time per channel.

What's in the file

  • Start here — step-by-step guide and colour legend
  • Guide — How to read the numbers. Plain explanations of every number, how to read the result and the mistakes to avoid.
  • Settings — Your currency and targets. You fill in: Currency, Target LTV:CAC ratio, Longest payback you accept (months).
  • Channels — One row per channel, same period for every row. You fill in: Channel, Marketing spend, Sales cost, New customers, Average order value, Orders per customer / year, Gross margin, Years as a customer. Worked out for you: CAC, Gross profit per customer / year, LTV, LTV:CAC, Payback (months), Verdict.
  • Dashboard — Which channels pay back. Shows: Spend + sales cost, New customers, Blended CAC, Blended LTV, LTV:CAC, Payback (months), a chart.
  • Summary — What the numbers say. Shows: Blended LTV:CAC, Blended payback (months), Best channel (highest LTV:CAC), Weakest channel (lowest LTV:CAC), Channels losing money, Channels to watch, Spend on losing channels, Share of spend on losing channels.
  • Action plan — What you will change next. Write what you will change, why, who owns it and by when; status shows in colour.
  • Checklist — Monthly CAC and LTV review. 12 steps to tick off, with a progress bar.

How to use it

  1. Open Settings: set your currency, the LTV:CAC ratio you aim for and the longest payback you accept.
  2. In Channels, type one row per channel: marketing spend, sales cost and new customers for the same period.
  3. Add average order value, orders per customer per year, gross margin and how many years a customer stays.
  4. Read CAC, LTV, the ratio and payback months. Dashboard compares channels and shows the blended figures.

What it does

  • CAC including sales costs, per channel and blended
  • LTV from order value, repeat orders, margin and lifetime
  • LTV:CAC ratio and payback months with a Healthy / Watch / Losing money flag
  • Chart of CAC against LTV by channel
  • Two files in each language: a blank Template to fill in, and an Example filled with sample data
  • Available in several languages; Arabic files are laid out right-to-left
  • Formulas only, no macros or add-ins
  • Instant download after purchase

Included Files

  • A file in the language you choose
  • Arabic files laid out right-to-left
  • Step-by-step guide
  • Free updates for this version

Works With

  • Microsoft Excel
  • Excel for Mac

Support

Questions about setup? Send us a message from your account page and we reply by email.

CAC & LTV Calculator

The video tutorial for this template is coming soon.

No reviews yet. Reviews appear here after customers rate the template.

Write a review
Your rating
FAQ
  • Which language is the file in?

    You get the file in the language you pick at the top of the site. If a template is not available in that language yet, you get the English file. Arabic files are laid out right-to-left.

  • Do I need macros or add-ins?

    No. The templates use formulas and built-in charts only.

  • Can I change the template?

    Yes. Rename columns, add rows, change colours and add your logo.

  • How do I get the files after paying?

    The download link appears on the order page and in your account right after payment.

Personal License

For you, on your own projects and your own company reports.

Team License

Share the files with up to 10 people in your company.

$29.00

$39.00

Free

File language: English

Add To Cart
Mia Ready
39 templates in the shop
View All Templates
  • Last updateNov 16, 2026
  • PublishedNov 16, 2026
  • CategoryAds & Performance
  • File format.xlsx
  • LanguagesEnglish
  • LayoutLeft-to-right; Arabic right-to-left
  • MacrosNone
  • Works WithMicrosoft Excel, Excel for Mac
  • Tags Excel, Ads & Performance
Like this template?

Found it useful? Recommend it to other marketers and earn 30% of every sale you bring in.

Become an affiliate