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)?

Review Later

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

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

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

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

In theconsensus case, what is the exit multiple terminal value on Dec 31, 2028?

Review Later

1,853,611

2,232,891

1,605,714

2,151,659

In theconsensus case, what is Amazon's enterprise value on the valuation date using the exit multiple terminal value?

Review Later

1,414,325

1,029,071

2,088,584

1,378,837

What is the expected AMZN value per share in 2028 in thebear caseusing the exit multiple terminal valuation method?

Review Later

3,570

7,721

5,038

4,892

Calculate AMZN's target share price using theconsensus caseassumptions and exit multiple terminal value, then perform a sensitivity analysis. What will the share price be if the exit multiple is 16.0x and the discount rate is 10.5%?

Review Later

2,502

2,686

2,717

2,473

What will the internal rate of return (IRR) be if the exit multiple is 10.0x and the purchase price per share is $1,700 in thebull case(given that the terminal value is calculated using the exit multiple method)?

Review Later

15.4%

13.8%

13.5%

13.1%