Column B has Average Purchase Value, Column C has Average Number of Purchases per Year, Column D has Average Customer Lifespan (years). Write the formula for Customer Lifetime Value in E2.
Scenario
Column B has Average Purchase Value, Column C has Average Number of Purchases per Year, Column D has Average Customer Lifespan (years). Write the formula for Customer Lifetime Value in E2.
Ready to try it?
Create a free account and try "Calculate LTV (Simple Model)" free for 7 days, no card required. Earn 50 XP and track your internship progress.