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)

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