NEED SOLUTION OF THESE  LTV 

 

C20 @fx A B D E F G H I J K L M N P Q Year 1 Year 2 Year 3 Year 1 Year 2 Year 3 Year 1 Year 2 Year 3 2 Customers 3 Retention Rate 4 Spending Rate 10000 5000 3000 25000 40.0% 50.0% $140 $150 $160 $60 30.0% $80 45.0% $90 5 Total Revenue $20,00,000 $9,00,000 $5,50,000 6 7 Variable % 60.0% 55.0% 50.0% 70.0% 50.0% 40.0% 8 Variable $ $10,00,000 $4,00,000 $2,00,000 9 Acquisition A=$60 $0 $0 A=$50 1000000 $0 $0 10 Total Cost 11 $14,00,000 $4,00,000 $2,00,000 12 Gross Profit 13 Discount 14 NPV Profit 15 Cum. Profit 16 LTV 17 18 19 20 21 22 23 24 1 1.16 1.35 1 1.16 1.35 1 1.16 1.35