part a please

repo rate is 2.2%

Three days have passed. It is now mid-day on Thursday, August 16, 2018. Since your initial decision to hold onto the position in Tesla 5.3% notes, questions have been raised in press accounts about Musk's "funding secured statement. This morning, it came to light that the SEC has commenced a formal investigation of Elon Musk's public statements regarding Tesla's plans. Rather than weathering the turmoil, you decide to execute a sale of $ 100 million face value of the Tesla 5.3% notes at a yield of 7.156%. (In practice, it could be difficult to liquidate the full $100 million position on a single day without substantial price impact). The closing Tesla 5.3% yields over the period of August 10 to August 20 are: Date Yield 8/10 7.005% 8/13 7.024% 8/14 6.951% 8/15 7.118% 8/16 7.156% 8/17 7.388% 8/20 7.604% Suppose for simplicity that you decided not to put on the treasury-note hedge and that the repo rate continues to be 2.20%. Provide a spreadsheet showing, for each day from and including Friday, August 10, 2018 to the day that your Tesla 5.3% note position is fully liquidated and all of cash has been transferred to your GS prime brokerage account, each of the following: (a) Your closing cash balance each night at GS. (b) The closing quantity (face value) of Tesla 5.3% notes posted to JPM on repo. (c) The settlement amount due on the closing (morning) leg of the previous day's repo. (d) The new financing provided on the opening (afternoon) leg of the current day's repo. (e) The net amount of cash transferred between your GS cash account and JPM, indicating clearly who pays the cash and who receives the cash. Three days have passed. It is now mid-day on Thursday, August 16, 2018. Since your initial decision to hold onto the position in Tesla 5.3% notes, questions have been raised in press accounts about Musk's "funding secured statement. This morning, it came to light that the SEC has commenced a formal investigation of Elon Musk's public statements regarding Tesla's plans. Rather than weathering the turmoil, you decide to execute a sale of $ 100 million face value of the Tesla 5.3% notes at a yield of 7.156%. (In practice, it could be difficult to liquidate the full $100 million position on a single day without substantial price impact). The closing Tesla 5.3% yields over the period of August 10 to August 20 are: Date Yield 8/10 7.005% 8/13 7.024% 8/14 6.951% 8/15 7.118% 8/16 7.156% 8/17 7.388% 8/20 7.604% Suppose for simplicity that you decided not to put on the treasury-note hedge and that the repo rate continues to be 2.20%. Provide a spreadsheet showing, for each day from and including Friday, August 10, 2018 to the day that your Tesla 5.3% note position is fully liquidated and all of cash has been transferred to your GS prime brokerage account, each of the following: (a) Your closing cash balance each night at GS. (b) The closing quantity (face value) of Tesla 5.3% notes posted to JPM on repo. (c) The settlement amount due on the closing (morning) leg of the previous day's repo. (d) The new financing provided on the opening (afternoon) leg of the current day's repo. (e) The net amount of cash transferred between your GS cash account and JPM, indicating clearly who pays the cash and who receives the cash