In Task 2.2, sort firms into two groups based on the yearly BAS in each year. The top group includes firms with higher liquidity and the bottom group includes firms with lower liquidity. Label the top group as "high liquid stock" and bottom group as "low liquid stock" for each year. Name the cell as "n/a" if there is no yearly BAS value in that year, and hence it should be logically excluded from the ranking of yearly BAS. Again, an incomplete VBA function is provided. Improve it before populating the results to "Ranked" cells. Task 3 Between March 3 and March 12, 2020, the US stock markets declined between 7% and 10% from its closing price the day before due to the Coronavirus fear. In this task, the aim is to explore the extent to which the level of stock liquidity responds to COVID-19 pandemic by examining the magnitude of change in liquidity around the event. We consider week 10 in 2020 as the event day. 1. First, compute weekly BAS over week 1 to week 10 in 2020 from the data in "Inputdata" cells and populate the results to "COVID" cells. A buggy subroutine is provided.