Brand Strategy Lab 2: Budget, CAC and LTV Scenario Planner with Python

Digital Strategy for Brand Marketing 40 min min read Updated: Nov 18, 2026 Advanced
Brand Strategy Lab 2: Budget, CAC and LTV Scenario Planner with Python
Advanced Topic 2 of 3

Goal

Compare three scenarios and decide how much you can afford to pay to win one customer.

Assumptions

  • Average order value 2,500
  • 3 orders per year for 2 years
  • Scenarios: Lean (CAC 800, margin 30%), Base (CAC 1,250, margin 40%), Premium (CAC 1,500, margin 50%)

Solution

python scenarios = [("Lean", 800, 0.30), ("Base", 1250, 0.40), ("Premium", 1500, 0.50)] aov, orders_per_year, years = 2500, 3, 2 for name, cac, margin in scenarios: ltv = aov * margin * orders_per_year * years print(name, "CAC", cac, "margin", margin, "LTV", ltv, "LTV/CAC %.1f" % (ltv / cac))
Result

Lean CAC 800 margin 0.3 LTV 4500.0 LTV/CAC 5.6 | Base CAC 1250 margin 0.4 LTV 6000.0 LTV/CAC 4.8 | Premium CAC 1500 margin 0.5 LTV 7500.0 LTV/CAC 5.0

Read the Result

  • All three scenarios return more than 4 times the cost
  • The Lean scenario has the best ratio but the lowest total value per customer
  • The Premium scenario wins more total margin per customer. If you can find enough premium customers, it can grow profit faster

Max Affordable CAC

If you want an LTV to CAC ratio of at least 3, the most you should pay is LTV divided by 3. For the Base scenario that is 6,000 / 3 = 2,000.

Your Turn

  1. Change repeat orders from 3 to 2 per year and see which scenario breaks first
  2. Add a fourth scenario for your own business
  3. Write a 3 line recommendation for a manager
Note All numbers are made up for practice. Use your own data and remember LTV is a forecast, not a guarantee.

Conclusion

A small scenario planner shows how margin, repeat rate and acquisition cost change the value of marketing. Use it to set sensible budgets.

Quick Summary: Goal; assumptions; solution; reading; max CAC; exercises.

Get Newsletter

Subscibe to our newsletter and we will notify you about the newest updates on Edugators