Q1.What is the share price when the discount rate is 13% and revenue growth is 15%?

1. 36.70
2. 35.47
3. 36.83
4. 39.70

Q2. What is the share price when COGS increases by 5%?

1. 29.29
2. 30.47
3. 26.87
4. 22.71

Q3. The formula contained in the YELLOW cell (G179) is ___________ Hint: do not forget the $ when using absolute references. Use absolute reference so this formula can be copied over to other cells in this section without any manual modification.

1. =SMALL($F$177:$F$180,E179)
2. =SMALL(F177:F180,$E$179)
3. =SMALL(E177:E180,$F$179)
4. =SMALL($E$177:$E$180,F179

Q4.The formula contained in the ORANGE cell (H178) is__________ =($A$177:$G$180________,(________,$F$177:$F$180,0),MATCH($A$177,$A$177: $F$177,0))

Hint: do not forget the $ when using absolute references.

Q5. What type of chart did we use to build a tornado chart?

1. Column chart
2. Clustered bar chart
3. Tornado chart
4. Stacked bar chart

Google drive Link (excel file): https://drive.google.com/file/d/1bBI5XzV67NdUr9jn_-ZW6GEFRFy-rZkG/view?usp=sharing