13- Complete Live Case section in the Scenario worksheet. There are 4 scenarios in this model: Consensus, Bull, Bear, and Other. The numbers in the live case should reflect one of the cases based on cell K14, which is dynamically linked to the scenario selected in the dropdown menu at the top of the worksheet. What formula will you use to fill cell G21 (online stores for 2018E)? 

choice the corret answer 

a)=CHOOSE($B$1,G76,G130,G184,G238)

b)=CHOOSE($K$14,G76:Q238)

c)=CHOOSE($K$14,G76,G130,G184,G238)

d)=CHOOSE($B$1,G76:Q238) 

Transcribed Image Text:

2 D © Corporate Finance Insitute. All rights reserved. 2 Historical Analysis (in millions, except per share data) 2013A. 2014A 2015A 2016A 2017A 2018E 2019E 2020E 2021E 2022E 2023E 2024 5 Historical Analysis 6 Time Periods 7 BOP 8 EOP 9 Days 10 1/1/2013 1/1/2014 1/1/2015 1/1/2016 1/1/2017 1/1/2018 1/1/2019 1/1/2020 1/1/2021 1/1/2022 1/1/2023 1/1/202 12/31/2013 12/31/2014 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/31/2019 12/31/2020 12/31/2021 12/31/2022 12/31/2023 12/31/202 365 365 365 366 365 365 365 366 365 365 365 36 11 Segmented Revenue Growth 12 Online Stores 13 Physical Stores 14 Retail Third-Party Seller Services 15 Retail Subscripfion Services 16 AWS 17 Oner na na 19.0% 18.5% na na na na na na 42.9% 38.7% na na 43.1% 52.0% na na 55.1% 42.9% na na 72.5% 57.7% 18 Total Net Sales 19 19.5% 20.2% 27.1% 30.8% 20 Expenses 21 Cost of Sales 22 Fulfilment 23 Marketing 24 Technology and Content 25 General and Administrative 73% 71% 67% 65% 63% 12% 12% 13% 13% 14% 4% 5% 5% 5% 6% 9% 10% 12% 12% 13% 2% 2% 2% 2% 2% 26 Other Operating Expense, net 27 Total Operating Expenses 28 0% 0% 0% 0% 0% 99.0% 99.8% 97.9% 96.9% 97.7% 29 Stock-Based Compensation (SBC) (% of SG&A) 30 Tax Rate Cover Page Financial Model Scenarios 5.8% 5.7% 6.4% 6.8% 6.8% 31 8% 0 0% 60 6% 36.6% 20.2% Disclaimer II Ready 画回四 100% EN 8:18 PM -234 2 D © Corporate Finance Insitute. All rights reserved. 2 Historical Analysis (in millions, except per share data) 2013A. 2014A 2015A 2016A 2017A 2018E 2019E 2020E 2021E 2022E 2023E 2024 5 Historical Analysis 6 Time Periods 7 BOP 8 EOP 9 Days 10 1/1/2013 1/1/2014 1/1/2015 1/1/2016 1/1/2017 1/1/2018 1/1/2019 1/1/2020 1/1/2021 1/1/2022 1/1/2023 1/1/202 12/31/2013 12/31/2014 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/31/2019 12/31/2020 12/31/2021 12/31/2022 12/31/2023 12/31/202 365 365 365 366 365 365 365 366 365 365 365 36 11 Segmented Revenue Growth 12 Online Stores 13 Physical Stores 14 Retail Third-Party Seller Services 15 Retail Subscripfion Services 16 AWS 17 Oner na na 19.0% 18.5% na na na na na na 42.9% 38.7% na na 43.1% 52.0% na na 55.1% 42.9% na na 72.5% 57.7% 18 Total Net Sales 19 19.5% 20.2% 27.1% 30.8% 20 Expenses 21 Cost of Sales 22 Fulfilment 23 Marketing 24 Technology and Content 25 General and Administrative 73% 71% 67% 65% 63% 12% 12% 13% 13% 14% 4% 5% 5% 5% 6% 9% 10% 12% 12% 13% 2% 2% 2% 2% 2% 26 Other Operating Expense, net 27 Total Operating Expenses 28 0% 0% 0% 0% 0% 99.0% 99.8% 97.9% 96.9% 97.7% 29 Stock-Based Compensation (SBC) (% of SG&A) 30 Tax Rate Cover Page Financial Model Scenarios 5.8% 5.7% 6.4% 6.8% 6.8% 31 8% 0 0% 60 6% 36.6% 20.2% Disclaimer II Ready 画回四 100% EN 8:18 PM -234

Answer rating: 100% (QA)

K14 ell hs the number dynmilly liked ... View the full answer