| Consider the following 3 sheets in Excel, which contain daily closing values of the following indexes: | |||||||||||||||||
| 1) NASDAQ Composite | |||||||||||||||||
| 2) DJIA | |||||||||||||||||
| 3) S&P 500 | |||||||||||||||||
| For the period from Mar 15 2022 to Mar 13 2023, calculate the: | |||||||||||||||||
| 1) Daily Rates of Return | |||||||||||||||||
| 2) The Expected Rate of Return | |||||||||||||||||
| 3) The Devition of Daily Rates of Return from the Expected Rate of Return | |||||||||||||||||
| 4) Calculate the Deviation squared | |||||||||||||||||
| 5) Calculate the Variance of Daily Returns | |||||||||||||||||
| 6) Calculate the Standard Deviation of Daily Returns | |||||||||||||||||
| Please note that you must provide calculations for all cells that are marked by light yellow color in the following 3 sheets | |||||||||||||||||
| 7) Identify, which of the indexes is associated with the highest risk (based on these historical data). | |||||||||||||||||
| 8) Explain by using the calculations done as well as additional calculations, in which index would you invest and why. The answer must be supported by clear arguments! (max. in three sentences). | |||||||||||||||||
Consider the following 3 sheets in Excel, which contain daily closing values of the following indexes: 1) NASDAQ Composite
📝 Need Help With a Similar Assignment?
Our expert writers can deliver a 100% original, plagiarism-free paper tailored to your requirements with fast turnaround.
Get Professional Help Now →
