Tourism Industry in Hong Kong has been severely affected by Covid-19 pandemic. Some hotel owners will have to sell their hotels this year. How many % drop of value of a hypothetical hotel when compared its value today to its value last year. Make all calculations in Excel.

There is no additional provided by the instructors. Please create and state all assumptions you use. This is just a rough calculation. No need to spend too much time for details that have small impact on valuation.