SOLUTION: Archegos Capital Fire Sale | My Assignment Tutor

Problem 1. Archegos Capital Fire Sale Please do research for the events surrounding Archegos Capital Fire Sale. For example, the link here from New York Times. In addition, the link here from thestreet.com. 1.Discuss how derivatives play a part in the events. Please explain. 2. Can you describe total return swaps and contracts for difference, particularly financial liabilities to each counterparty? 3. What role do these derivatives play in triggering the fire sale? 4. What ways could these derivatives cause another financial crisis? Problem 2. Trading Data Statistics( Excel) 1 Select one company stock that you would like to analyze. You need to know the name of the company or the ticker of the company. Search the company from yahoo finance. Download the data from Yahoo Finance at here: https://finance.yahoo.com/ . Ideally, you need at least one year worth of data. 2 Create close price changes in percentage. For example, if you want to find close price change from yesterday to today. First, you take the close price difference between today and yesterday. Then, the difference is divided by yesterday’s close price. To add some fun, can you create in-cell bar charts? Please find the chart at the Home Tab-Conditional Formatting-data bar- choose either gradient fill or solid fill. 3 Create a frequency distribution table showing the days when stock open price is higher than close price and the days when the opposite happens. You might use “countif”. Please see the video here: https://youtu.be/_avkg8ILpXs . Alternatively, you could use “Frequency”. See the video here: 4 Find the mean (average), median (median), standard deviation (stdev.s), and variance (var.s) of the stock close price