please help me to calculate the question 5, I have calculated the question 1 to 4 by exel
5. Assume customers have a lifetime of 5 years, what is the customer lifetime value? 6. Based on the information calculated write a 150 word summary interpreting the information. 7. What three (3) conclusions would you make based on the information obtained? B. What recommendations would you make based on your conclusions? JB Hi-Fi Limited ( (BH) is a specialty discount retailer of branded home entertainment products. The Group's products particularly focus on consumer electronics, software (including music, games and movies), whitegoods and appliances. The company primarily operates from standalone destination sites and shopping centre locations and its online stores in Australia and New Zealand. \begin{tabular}{|l|r|r|r|r|c|} \hline JB Hi-Fi Limited Financials & 06/2015 & \multicolumn{1}{|c|}{06/2016} & \multicolumn{1}{|c|}{06/2017} & 06/2018 & \multicolumn{1}{|c|}{06/2019} \\ \hline Revenue (S'000) & 3,652,136 & 3,954,467 & 5,628,000 & 6,854,300 & 7,095,300 \\ \hline Cost of Goods Sold (S'000) & 2,853,883 & 3,089,059 & 4,397,500 & 5,384,100 & 5,568,200 \\ \hline Gross Profit (\$'000) & 798,253 & 865,408 & 1,230,500 & 1,470,200 & 1,527,100 \\ \hline Operating expenses (\$'000) & 3,411,065 & 3,691,788 & 5,268,000 & 6,443,200 & 6,669,400 \\ \hline Profit (EBITDA) (S'000) & 241,702 & 263,225 & 362,000 & 412,200 & 428,300 \\ \hline & & & & & \\ \hline Sales and marketing expenses (S'000) & & & & \\ \hline \end{tabular} 5. Assume customers have a lifetime of 5 years, what is the customer lifetime value? 6. Based on the information calculated write a 150 word summary interpreting the information. 7. What three (3) conclusions would you make based on the information obtained? B. What recommendations would you make based on your conclusions? 3. Assume the average customer sale in 2019 is $45.00 and $40 in 2018 , and customers on average purchase twice per year how many customers would JB HiFi have served in 2019 and 2018? 4. Assume that 20% of customers are new customers, how many new customers would they have? \begin{tabular}{|l|l|l|l|} \hline Averagec customer sales valuetyear & 5 & 2018 & 2019 \\ \hline \end{tabular} Etimated customers served 1 Etimated now customers 32 Cuntomer acquistion cost (CAC) 33 Time to parback CAC 34 1. For this we need the Grow Margin. 35 le. Growsentit/ cogs 35 2. Then:Grow Marein per Annual Customer 37 saie 31 3. Then CAC/GM
