Complete the case by (1) using the spreadsheet to gather data about possible financial scenarios and (2) documenting your findings in a memo. Snow Top managers would like you to explore two sets of three scenarios. They request that the first set not include any summer expansion. The input values for these scenarios are as follows: 1. OptimisticThe number of skiers will increase each year by 1 percent, and the economic out-look is good. The climate change factor will be zero in 2020 and 2021, and will be -3 percent in 2022. 2. NeutralThe number of skiers will remain the same (no percentage increase or decrease), and the economic outlook is good. The climate change factor will be -2 percent in 2020 and 2021, and will be -6 percent in 2022. 3. PessimisticThe number of skiers will decrease each year by 3 percent, and the economic out-look is poor. The climate change factor will be -8 percent in 2020, 2021, and 2022. The management would also like to see the same scenarios with summer expansion in 2022. (It wi