Compute the means and covariances of the rates of return

Assignment Help Financial Management

Reference no: EM131235396

The Vanguard European stock fund, Pacific stock fund, and Exxon Mobil reported the following historical dividend-adjusted prices:

2354_Table 5.jpg

(a) Compute the means and covariances of the rates of return on these three assets.

(b) Draw the efficient frontier if you can only invest in VEURX and VPACX.

(c) Now add Exxon Mobil. Use Excel to draw 1,000 random numbers in two columns, called wE and wP. (Create one formula, and copy it into all of the cells.) Each of these 2,000 cells should use the formula 'rand()*3-1'. Create a new column that is 1.0 minus wE and wP, and call it wX.

Now consider these random numbers as investment weights in VEURX, VPACX, and XOM. Compute the risk and reward for each of these portfolios (one portfolio is three numbers: one wE, one wP, and one wX), using the standard deviation and expected rate of return formulas. Finally create an x-y plot that shows, for each of your wE, wP, and wX portfolios, the riskreward combinations. What doesthe plot look like?

(d) If the risk-free rate stood at 5% per annum, what would be the tangency portfolio?

Reference no: EM131235396

Questions Cloud

What do you think the impact will be on other countries : Several countries around the world are transitioning to market economies; the most significant of these are China and Russia. What do you think the impact will be on other countries around the world as these two countries become even more signifi..

What are the obstacle to global expansion : 1. How is a services company's focus different from that of a manufacturing company? What elements are necessary for a service company to achieve global success? What are the obstacle to global expansion?

What is meant by the term deseasonalized demand : What is meant by the term tracking the forecast? In which two ways can forecasts go wrong?

How do you think they would describe your personality : If I asked 3 people, who know you better than anyone else does - how do you think they would describe your personality? Would they say the same things about you or different things based on your relationship with each person

Compute the means and covariances of the rates of return : Compute the means and covariances of the rates of return on these three assets. - Draw the efficient frontier if you can only invest in VEURX and VPACX.

Ethical ramifications for multinational enterprises : Can you think of any specific examples past or present that has legal or ethical ramifications for multinational enterprises?

Provide an example of the model in real time or as scenario : Analyze the method that you are supporting, detailing the strengths and weaknesses from all stakeholder group (e.g., patient, provider, and third-party payer) perspectives. Provide an example of the model in real time or as a scenario.

Describe the types of decisions : 1. Describe the types of decisions that do not involve uncertainty and risk and common approaches used for analyzing them. 2. Explain how payback period, NPV, and IRR criteria are used in decision making.

What is the mean absolute deviation : What action should be taken when unacceptable error is found in tracking a forecast?

User Account

All Pages