Write My Paper Button

WhatsApp Widget

Consider the following 3 sheets in Excel, which contain daily closing values of the following indexes: 1)  NASDAQ Composite

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).

Scroll to Top