Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need to know the formulas in the cells, not just the number. A D F H K B E E G 1 Based on

I need to know the formulas in the cells, not just the number.

image text in transcribed

A D F H K B E E G 1 Based on a survey, In 2017, the IT Strategy team decided to develop a mobile application for the e-commerce store, and the firm launched the mobile app on 1st Jan 2018. 2 Before 2018, smartphone visitors accessed the e-commerce store using the mobile website. 3 Table 5 shows the average monthly visitors to the mobile website and mobile app from 2014 to 2019. (a) Write a formula in cell E15 to compute mobile website visitors' CAGR from 2014 to 2017. 4 5 6 7 8 Year Table 5 Mobile Website Mobile App 2014 23085|NA 2015 28001 NA 9 10 2016 35430 NA 11 45122 NA 2017 2018 2019 48219 13500 49000 28000 12 13 14 15 Mobile Website Visitor CAGR during the period 2014 to 2017 16 17 Superficially, it looks like the mobile app has not cannibalized the mobile website, this is because the monthly mobile website visitor has grown in 2018 and 2019. 18 However, the comparison of actual visitors in 2018 to 2017 actual visitors is not correct. To find cannibalization, we should compare the actual visitors to the expected visitors. 19 Assume that if the firm did not launch the app, the mobile website user base would have grown at the CAGR rate. 20 (b) Using CAGR computed in E15, write the formula in cells D26 and D27 to calculate the Expected Mobile website visitor in 2018 and 2019, respectively. 21 (c) Compute the percent decline or increase in the mobile website visitors, write a formula in cell E26 and copy to cell E27. (d) In cell F26, Use the IF Function to create a formula to print "Yes" if there is cannibalization; else, the formula should print "No". Copy the formula to cell F27. 22 Hint: If the percent increase is negative then there is cannibalization, else there is no cannibalization. 23 24 Table 6 Expected Mobile Percentage Is there 25 Year Mobile Website Website Visitor Increase cannibalization? 26 2018 48219 27 2019 49000 28

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions