Tuscan Lifestyle data sheet PDF

Preview

Summary

Tuscan Lifestyle data sheet for excel analysis...

Description

Revenue Total customers in the cohort Ordering customers Response rate Avg # orders among buyers Total number of Orders Average order Size Revenues Taking out the cost COGS+shipping costs Catalogue cost Gross profit

Time 0

Year 1

Year 2

Year 3

4657 4657 1 4657 $31,84 $148.279

4657 4046 87% 1,17 4741 $32,09 $152.139

4657 1918 41% 1,36 2612 $41,78 $109.129

4657 970 21% 1,44 1399 $51,05 $71.419

Year 4 4657 927 20% 1,42 1312 $52,43 $68.788

$86.002 $172.107 -$109.829

$88.240 $27.942 $35.956

$63.295 $27.942 $17.892

$41.423 $27.942 $2.054

$39.897 $27.942 $949

0 1,00 -$109.829

1 1,10 $32.687

2 1,21 $14.787

3 1,33 $1.543

4 1,46 $648

Year 2 3296 1653 50% 1,49 2463 $74,02 $182.311

Year 3 3296 866 26% 1,52 1315 $67,75 $89.091

Year 4 3296 761 23% 1,40 1068 $67,12 $71.684

Discounting Year Discount factor NPV Profit Cumulative NPV Profit CLV (=50)

$58,30

Year 5 4657 820 18% 1,33 1093 $53,63 $58.618

$33.998 $27.942 -$3.323

5 1,61 -$2.063 -$62.227

Year 5 3296 623 19% 1,34 837 $78,26 $65.504

$37.992 $19.776 $7.736

5 1,61 $4.803 $192.146...