CUSTOMER LIFETIME VALUE$-$BONUS ASSIGNMENT

PLEASE COMPLETE THE FOLLOWING TWO EXERCISES

Please calculate the CLV using the simple formula based on the following information: $($Please show your calculations$)$

a$.$ Initial cost of acquisition $=$$$350$

b$.$ Annual profit contribution per customer $=$$$750$

c$.$ Customer retention rate $=67\%$

Please calculate the missing values in the highlighted cells.

$\backslash$table$[[,\backslash$table$[[$Initial Cost$],[$of$],[$Acquisition$]],$Year $1,$Year $2,$Year $3,$Year $4],[,$$$250,,,,],[\backslash$table$[[$Annual$],[$Customer$],[$Revenue$]],,450,700,750,900],[\backslash$table$[[$Costumer$],[$Costs$]],,225,350,375,450],[\backslash$table$[[$Average$],[$Profit$]],,100\%,80\%,95\%,80\%$