Calculate the historical average return

Reference no: EM13706788

1)DATA COLLECTING AND HANDLING a) Download one year of daily prices (1/1/2014 to 12/31/2014) for the following four stocks: MICROSOFT , PFIZER, WALMART, BANK OF AMERICA.

2)BASIC STOCK ANALYSIS a) For each stock calculate the historical average return, the volatility, both on a daily base and annualized, and the correlation amongst the four stocks. Explain how you calculate them. b) What is your first assessment about the four stocks? Discuss briefly the above figures. c) Calculate the Sharpe Ratio of each stock. Explain how you calculate them. d) How do you interpret this number? Can you relate it with the volatility of the stock?

3) 3) BASIC PORTFOLIO ANALYSIS a) Calculate the historical average return and the volatility of an equally weighted portfolio. Compare them with the figures of the four stocks. b) Calculate the Sharpe Ratio of the equally weighted portfolio. How do you interpret this number? Compare it with the Sharpe Ratio of the stocks.

Reference no: EM13706788

Questions Cloud

Contract to purchase a new house : You've entered into contract to purchase a new house, and the closing is scheduled for next week. It's typical for some last minute bargaining to occur at the closing table, where sellers often try to tack on extra fees. You have three options ..

Explain karl marx''s role in economics : Explain Karl Marx's role in economics 100 words or more.

What happens if the sensor does not move with the fluid : The static pressure of a location inside moving fluid is measured by a measuring sensor. What happens if the sensor does not move with the fluid?

Thermocouples were made by using copper-constantan wires : During a lab demonstration, two thermocouples were made by using copper-constantan wires. The junction diameter of one thermocouple is 1 mm, while the other is 0.2 mm. Initially, both thermocouples were held in a constant-temperature environment and ..

Calculate the historical average return : 2)BASIC STOCK ANALYSIS a) For each stock calculate the historical average return, the volatility, both on a daily base and annualized, and the correlation amongst the four stocks. Explain how you calculate them. b) What is your first assessmen..

The adiabatic flame temperature : Calculate the adiabatic flame temperature attained when methane at 298k, is combusted (a) with oxygen in the molar ratio air/CH4 = 9.524. Assume that CO2 and H2O are the products of the combustion. The adiabatic flame temperature is that temperature ..

Static pressure in moving fluid can be measured accurately : In theory, the static pressure in moving fluid can be measured accurately when the measuring sensor moves with the fluid. Why is it necessary to have the sensor moving with the fluid?

Are the wall taps used to measure static pressure of air : In the wind tunnel experiment, four wall taps are used to measure pressure. Are those wall taps used to measure pressure of the air very close to the wall surface? What is the velocity of air close to the wall surface? Are the wall taps used to measu..

What is equilibrating forces : What is equilibrating forces as it relates to unintended consequences?

User Account

All Pages