Please solve for CLV (Customer Lifetime Value) and CAC and show work.

1. CLV

Average revenue per customer per period _____

Average customer relationship length ____

2. CAC

All costs spent to acquire customers in a period ____

Number of customers acquired in the period _____

3. RATIO

CLV ____ / CAC ____ = _____

Travel Bags
Customer Segment Profile - 20-30 years old - Part-time employee - Interests: photography, outdoors, sustainability - Values simplicity
Customer ID	Months as customer	Revenue last 12 months
10000	25	115
10001	22	112
10002	13	92
10003	27	130
10004	52	124
10005	25	159
10006	9	95
10007	10	144

Income		$2,501,215
Sales	$2,501,215
Expenses
COGS	$750,365	$ (1,721,765)
Salaries	$250,122
Marketing Costs	$500,243
Water and Electricity	$12,225
Property Rates and Taxes	$1,200
Insurance	$8,500
Taxes	$187,591
Other	$11,520
Net Profit		$779,450
Total new customers in the last 12 months: 4,852

Answer rating: 100% (QA)

CLV Average revenue per customer per period 2501215 7 35730214 Average customer relatio... View the full answer