Customer Lifetime Value & Ad Budget Calculator – LTV, CAC, LTV to CAC Ratio, Payback & Max Ad Spend
Guarantee Safe Checkout
Customer Lifetime Value & Ad Budget Calculator – LTV, CAC, LTV to CAC Ratio, Payback & Max Ad Spend
Know What a Customer Is Worth and What to Spend on Ads — Lifetime Value, Customer Cost, Ratio, Payback, and Max Ad Budget
A customer lifetime value and ad budget calculator. Enter average order value, product cost and fee shares, shipping you pay, repeat customer rate, orders per repeat customer per year, customer lifespan, retention cost, monthly ad spend, new customers per month, and a target ratio to get profit per order, lifetime orders and sales, lifetime value, customer cost (CAC), LTV to CAC ratio, orders to pay back CAC, first order profit after CAC, max CAC, max monthly ad budget, budget room, and the value of more repeat buyers.
What This Spreadsheet Calculates
- Profit per order
- Lifetime orders and sales
- Lifetime value per customer
- Cost to get a customer
- LTV to CAC ratio
- Orders to pay back CAC
- Max CAC and max ad budget
- Value of more repeat buyers
Ads are not too expensive if customers come back. Know your lifetime value and spend with confidence.
Spend smarter on ads.
Each purchase comes with a .xlsx spreadsheet compatible with Microsoft Excel, Google Sheets, and Numbers. Enjoy free updates for every spreadsheet you own. You'll be notified when a file is updated, and you can download the latest version anytime from your account page.
This is a one-time payment, so you pay once and own the spreadsheet forever. You can download the original file anytime, and future updates are included at no extra cost!
We offer a 7-day money-back guarantee. If you feel our spreadsheets aren't providing the pricing calculations you need, we'll refund your purchase—no questions asked!
Need More Than One Spreadsheet?
The Craft Calculators Lifetime Spreadsheet Vault includes 323 spreadsheets across 29 categories — soap and bath, crochet and knitting, machine embroidery, home bakery, candle making, pricing, labor costs, HTV, balloon decor, paper crafts, jewelry, Etsy fees, digital products, and more. One-time payment. Lifetime access. Free future updates.
