Data Analytics
Calculate the difference in CLV using the spreadsheet data compiled by Boulogne and Scott in Exhibit 8. If you opt to use the simplified formula shared by the professor, assume that the first contributions from customers acquired would occur in the next, rather than the current reporting period. As discussed in class, the professor’s recommended formula understates contribution by about one period of revenue contribution. You will need to adjust your calculations accordingly. You are free to use bullets to explain your calculation, if needed. Be concise. Keep it simple and get to the point quickly. Please limit responses to no more than 100 words.
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
m*r/(1 +i-r)
576*
B /
U Paragraph v* Arial
1Opt
A
Tx
