Question: Calculate and report the total return, standard deviation, and Sharpe ratio of your portfolio on a weekly basis. The total fund is 1millions dollars USD

Calculate and report the total return, standard deviation, and Sharpe ratio of your portfolio on a weekly basis. The total fund is 1millions dollars USD

Stock ticker Date Quantity Price
NVDA 29/04/2024 300 876.5
MSFT 29/04/2024 350 405.95
AMZN 29/04/2024 850 179.46
MA 29/04/2024 269 462
NVDA 30/04/2024 300 872.4
MSFT 30/04/2024 350 401.49
AMZN 30/04/2024 850 181.09
MA 30/04/2024 269 456.26
APPL 30/04/2024 500 173.33
TSLA 30/04/2024 800 187.11
NVDA 1/05/2024 300 864.2
MSFT 1/05/2024 350 389.33
AMZN 1/05/2024 850 175
MA 1/05/2024 269 451.2
APPL 1/05/2024 500 170.33
TSLA 1/05/2024 800 183.28
NVDA 2/05/2024 300 844.49
MSFT 2/05/2024 350 397.66
AMZN 2/05/2024 850 180.85
MA 2/05/2024 269 443
APPL 2/05/2024 500 172.51
TSLA 2/05/2024 800 182.86
NVDA 3/05/2024 300 887.89
MSFT 3/05/2024 350 406.66
AMZN 3/05/2024 850 186.21
MA 3/05/2024 269 443.58
APPL 3/05/2024 500 183.38
TSLA 3/05/2024 800 181.19
Week 2
NVDA 6/05/2024 300 921.4
MSFT 6/05/2024 350 413.54
AMZN 6/05/2024 850 188.7
MA 6/05/2024 269 449.37
APPL 6/05/2024 500 181.71
TSLA 6/05/2024 800 184.76
NVDA 7/05/2024 300 905.4
MSFT 7/05/2024 350 409.34
AMZN 7/05/2024 850 188.76
MA 7/05/2024 269 453.06
APPL 7/05/2024 500 182.4
TSLA 7/05/2024 800 177.81
NVDA 8/05/2024 300 905.29
MSFT 8/05/2024 350 410.57
AMZN 8/05/2024 850 188.88
MA 8/05/2024 269 453.55
APPL 8/05/2024 500 182.56
TSLA 8/05/2024 800 175.01
NVDA 9/05/2024 300 887.47
MSFT 9/05/2024 350 412.32
AMZN 9/05/2024 850 179.46
MA 9/05/2024 269 445.49
APPL 9/05/2024 500 184.57
TSLA 9/05/2024 800 171.97
NVDA 10/05/2024 300 902.99
MSFT 10/05/2024 350 413.01
AMZN 10/05/2024 850 189.45
MA 10/05/2024 269 456.5
APPL 10/05/2024 500 184.89

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

1.8 List and describe two key areas of organisational policies and procedures for financial administration relating to budgeting, e.g. reporting, recordkeeping, accuracy of data, historical records...

Q:

You are hired as an investment consultant by a hedge fund that focuses on the following five US stocks Spirit Mobile (ticker SPR), Nike (ticker NKE), Amazon (ticker AMZN), Goldman Sachs (ticker GS),...

Q:

Hi, I have an Assignment for my Finance Subject. I have attached the necessary documentation here for you to view including the Lecture slides of all the Topics covered for this assignment. Please...

Q:

Hi Vandana, this is a case study for my investment class. a little heavier than the last one I asked you about. Could you please help? details attached. Original Portfolio Mean Return Standard...

Q:

Help with this assignment is greatly appreciated. Please see the attached pictures for details. 2. You are going to form a portfolio out of two assets: a risk-free asset (the current 3-month Treasury...

Q:

Section A. If the one year spot rate is 4% and the forward rates for years 2, 3, 4, 5 are 5%, 7%, 8%, and 6%, respectively, then today's interest rate on a five-year bond should be : 4% 5% 6% 7% 8%...

Q:

I need your help with this: Can you please quote from the attached chapters / resource if possible? Corporations often use different costs of capital for different operating divisions. Using an...

Q:

Please Provide a 2 to 3 page article review for each, there attached on this question. Your discussion should include a brief summary (including the big ideas or major points of the article) along...

Q:

This is spread sheet assignment. I will attached direction of assignment. Thanks Question #1 You have been given daily return data. In order to calculate average return, std deviation, Sharpe ratio,...

Q:

This is excel assignment again. Please see the attachment Thanks Question #1 You have been given daily return data. In order to calculate average return, std deviation, Sharpe ratio, semideviation,...

Q:

Need help with the 70 multiple choice questions for final exam - if you can, please provide explanation for harder questions. A s ae o . s h r d n. . Surname: ______________________ Q1 Given names:...

Q:

Paper Corp. purchased 70% of the outstanding shares of Sand Ltd. on January 1, Year 2, at a cost of $84,000. Paper has always used the equity method to account for its investments. On January 1, Year...

Q:

Alf is a recently retrenched corporate manager who decides to form a lawnmowing business In his local area to help him keep fit and earn a little income (no more than $30,000 per year). He already...

Q:

when compounding what is best to measure 3 5 ml

Q:

Retter Shoe Company has expected overhead costs of $12,000,000. The majority of the overhead costs are incurred providing production support to the direct labor force, Direct labor rates vary from...

Q:

Deepa Dalal opened a free-standing radiology clinic. She had anticipated that the costs for the radiological tests would be primarily fixed, but she found that costs increased with the number of...

Q:

What is the difference between the operation of a thermosyphon solar water heater system and an active, closed loop solar water heater?

Q:

The sales department of F. Pollard Manufacturing Co. has forecast sales in March to be 20,000 units. Additional information follows: Finished goods inventory, March 1....................................

Q:

The sales department of Macro Manufacturing Co. has forecast sales for its single product to be 20,000 units for June, with three-quarters of the sales expected in the East region and one-fourth in...

Q:

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

Q:

Nion is a retail goods outlet operating from a head office in London and a branch in Brighton. The following trial balances have been extracted from the books of account as at 31 October 2014. Head...

Q:

Packer and Stringer were in partnership as retail traders sharing profits and losses: Packer ts, Stringer '/4. The partners were credited annually with interest at the rate of 6% per annum on their...

Q:

EG Company Limited, a manufacturing business, exports some of its products through an overseas branch whose currency is florins, which carries out the final assembly operations before selling the...