Determine the optimal asset allocation to make across

Reference no: EM13199596

Q1. Calculate the discrete monthly rates of returns. Using the monthly returns, calculate the arithmetic mean monthly return and the geometric mean monthly return of each series for the overall period. Convert the mean returns to annualised returns.

Q2. Calculate the variances and standard deviations of the monthly returns of each series. Annualise the variances and standard deviations

Q3. Calculate the covariances of the monthly returns between each pair, and the corresponding correlation coefficients.

Q4. Based on the annualised returns and variances calculated, compute the rates of return and the variances of two- country equally weighted portfolios and the three-country equally weighted portfolio you can form from the three country indices. Make use of your knowledge of matrix algebra for your calculations.

Q5. Determine the optimal asset allocation to make across the three stock markets, by computing and examining the efficient portfolio frontier and the minimum variance portfolio

Q6. Interpret and comment on the results in (a) above, how do they compare with your results for the portfolios examined in Part 2? Comment on your observations.

Attachment:- Data.xlsx

Reference no: EM13199596

Questions Cloud

How long would annual payments : How many years would it take to have $50,000 for a home down payment if the first payment is made at the end of the upcoming year (year 1)?

What is its resulting output and profit : Making dresses is a labor-intensive process. Indeed, theproduction function of a dressmaking firm is well described by theequation Q = L - L2/800, where Q denotes the number ofdresses per week and L is the number of labor hours per week.

Calculate barbows after-tax weighted average cost : Calculate Barbows after-tax weighted average cost of capital, using the data in the balance sheet - One of the first items they want to examine is their cost of capital. According to the accounting department

How accurate is the regression equation in predicting sales : Compute the price elasticity of demand for pies at the firm's mean price: ($7.50) and mean weekly sales quantity (20,000 pies). Next, compute the cross-price elasticity of demand. Comment on these estimates.

Determine the optimal asset allocation to make across : Calculate the discrete monthly rates of returns. Using the monthly returns, calculate the arithmetic mean monthly return and the geometric mean monthly return of each series for the overall period. Convert the mean returns to annualised returns.

Determine the average product function : Determine the mariginal product. Determine the average product function. Find the value of L that maximizes QFind the value of L at which the marginal product function takes on its maximum value.

Calculate the profit of each firm at the equilibrium : Suppose that two identical firms produce widgets and that they are the only firms in the market. Their costs are given by C1 = 60Q1 and C2 = 60Q2, where Q1 is the output of Firm 1 and Q2 the output of Firm 2.

What are some viable alternatives to the problem : how can we as a country can provide universal health coverage. Approximately 47 million individuals in the U.S. are uninsured or underinsured. What might this mean in terms of future growth in the U.S. In addition,

What quantity of bmws should the firm sell in each market : Suppose that BMW can produce any quantity of cars at a constant marginal cost equal to $20,000 and a fixed cost of $10 billion. You are asked to advise the CEO as to what prices and quantities BMW should set for sales in Europe and in the United S..

User Account

All Pages