In the Excel file, there is a worksheet called “Data”. This contains information about some trades between Omni Corp and counterparties that occurred over 2 consecutive days

In the Excel file, there is a worksheet called “Data”. This contains information about some trades between Omni Corp and counterparties that occurred over 2 consecutive days. Assume you start with 100 shares of each security in each CSD. 1. Fill in the “Expected settlement date” column in the “Data” tab. Use details from the information sheets as you need. 2. The company BnL Corp. has an internal systems malfunction. This means all trades that BnL Corp. is trading in will fail to settle. With this in mind, calculate the end of day positions at each CSD in each separate security. There is more than one way to get the correct answers, please remember to show your working. Give your answers in the tables found in the “Answers” worksheet.
Note: the attached Data_Answer_Key file is what I believe to be the correct answer. However, no work is shown and I would like to understand how to solve this in Excel. This question has been asked on this site before, but the answer appears to be incorrect.

Looking for a similar assignment? Get help from our qualified experts!

Order Now

Don't use plagiarized sources. Get Your Custom Essay on
In the Excel file, there is a worksheet called “Data”. This contains information about some trades between Omni Corp and counterparties that occurred over 2 consecutive days
Just from $8/Page
Order Now