Question

In: Accounting

Table 1: ANNUAL RETURNS (%) Lyx Malaysia Lyx Singapore Lyx USDJIA Lyx would 2009 2.00 5.86...

Table 1: ANNUAL RETURNS (%)

Lyx Malaysia

Lyx Singapore

Lyx USDJIA

Lyx would

2009

2.00

5.86

5.56

7.69

2010

4.25

22.40

6.11

5.79

2011

-29.40

-27.07

7.94

-3.28

2012

13.23

0.06

18.29

20.75

2013

8.86

-6.84

17.09

14.14

2014

2.31

33.87

14.20

15.06

2015

-2.96

-9.28

-4.71

-4.28

Table 2: PORTFOLIO WEIGHTS (%)

Assets

Exising Portfolio Weights

New Portfolio Weights

Lyx Malaysia

60

40

Lyx Singapore

40

30

Lyx USDJIA

30

Questions:

  1. Using the given information in Table 1, calculate the mean return, standard deviation, covariance and correlation for the given stocks.

  2. Calculate the return and standard deviation for the portfolio consisting of the two stocks.

  3. After adding the stock Lyx USDJIA, what is the portfolio return and standard deviation? How does the new portfolio differ from the first portfolio calculate in question 2?

  4. Basedonyouranalysis,explainshouldAlbertdiversifyhisportfolioorremain invested in Malaysia and Singapore only?

  5. Calculate beta for the current portfolio and the new portfolio. Assuming a risk free rate of 2.5% and a market risk premium of 5.5% and calculate the expected return for both portfolios.

Solutions

Expert Solution

Hi Friend,

Please find solution below.


Related Solutions

The following table summarizes the annual returns you would have made on two companies – Scientific...
The following table summarizes the annual returns you would have made on two companies – Scientific Atlanta, a satellite and date equipment manufacturer and AT&T, the telecom giant from 1988 to 1998. Year Scientific Atlanta (%) AT&T (%) 1989 80.95 58.26 1990 -47.37 -33.79 1991 31 29.88 1992 132.44 30.35 1993 32.02 2.94 1994 25.37 -4.29 1995 -28.57 28.86 1996 0.00 -6.36 1997 11.67 48.64 1998 36.19 23.55 A) Estimate the average and standard deviation in annual returns in each...
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014....
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014. Year Period (t) Revenue ($ billions) 2009 1 23.6 2010 2 29.2 2011 3 37.8 2012 4 50.3 2013 5 59.8 2014 6 66.6 a) What type of pattern exists in the data? The time series plot shows an upward curvilinear trend. The time series plot shows a downward curvilinear trend.      The time series plot shows a downward linear trend. The time series...
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014....
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014. Year Period (t) Revenue ($ billions) 2009 1 23.8 2010 2 29.4 2011 3 37.8 2012 4 50.3 2013 5 59.7 2014 6 66.6 (a) Construct a time series plot. A time series plot contains a series of 6 points connected by line segments. The horizontal axis ranges from 0 to 7 and is labeled: Period. The vertical axis ranges from 0 to 80...
EXCEL FILE ONLY Refer to the table below. The table below shows the annual returns (in...
EXCEL FILE ONLY Refer to the table below. The table below shows the annual returns (in percentages) for 2 major market indices. For each index, calculate the arithmetic mean return and the geometric mean return of full-year returns from 2005-2015. What is the relationship between the arithmetic and geometric mean returns? 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 Nasdaq Composite Index 1.37 8.59 50.0 -31.5 -21.1 -39.3 85.6 39.6 21.6 22.7 39.9 Dow Jones Industrial Average...
The following table shows the annual returns (in percent) and summary measures for a sample of...
The following table shows the annual returns (in percent) and summary measures for a sample of returns from the Vanguard Energy Fund and the Vanguard Health Care Fund from 2012 through 2016. Year Energy (%) Health Care (%) 2012 44.6 15.41 2013 19.68 10.87 2014 37 10.43 2015 -42.87 -18.45 2016 28.36 20.96 If the risk-free rate is 3%, using mean-variance analysis, which fund performed better, and why? a. The Energy Fund performed better, because its Sharpe Ratio was higher....
Consider the following table for the total annual returns for a given period of time. Series...
Consider the following table for the total annual returns for a given period of time. Series Average return Standard Deviation Large-company stocks 11.7 % 20.6 % Small-company stocks 16.4 33.0 Long-term corporate bonds 5.6 9.1 Long-term government bonds 6.1 9.4 Intermediate-term government bonds 5.6 5.7 U.S. Treasury bills 3.8 3.1 Inflation 3.1 4.2 What range of returns would you expect to see 68 percent of the time for long-term corporate bonds? (A negative answer should be indicated by a minus...
Ten annual returns are listed in the following? table: ?19.1?%    16.4?%      17.9?%     ?49.5?%...
Ten annual returns are listed in the following? table: ?19.1?%    16.4?%      17.9?%     ?49.5?%      43.2?%    1.9?%     ?16.7?%      45.5?%     45.4?%     ?3.8?% a. What is the arithmetic average return over the? 10-year period? b. What is the geometric average return over the? 10-year period? c. If you invested? $100 at the? beginning, how much would you have at the? end? a. What is the arithmetic average return over the? 10-year period? The arithmetic average return...
The following​ table, contains annual returns for the stocks of ABC Corp. ​(ABC ​) and XYZ...
The following​ table, contains annual returns for the stocks of ABC Corp. ​(ABC ​) and XYZ Corp. ​(XYZ ​). The returns are calculated using​ end-of-year prices​ (adjusted for dividends and stock​ splits). Use the information for ABC Corp. ​(ABC ​) and XYZ Corp. ​(XYZ ​) to create an Excel spreadsheet that calculates the average returns over the​ 10-year period for portfolios comprised of ABC and XYZ using the​ following, respective,​ weightings: (1.0,​ 0.0), (0.9,​ 0.1). The average annual returns over...
Table 3 (below) shows annual returns for the S&P 500 for the years 2000-2016: Table 3:...
Table 3 (below) shows annual returns for the S&P 500 for the years 2000-2016: Table 3: Annual Returns Year Returns 2000 -9.0% 2001 -11.9% 2002 -22.0% 2003 28.4% 2004 10.7% 2005 4.8% 2006 15.6% 2007 5.5% 2008 -36.6% 2009 25.9% 2010 14.8% 2011 2.1% 2012 15.9% 2013 32.2% 2014 13.5% 2015 1.4% 2016 11.7% Calculate: The cumulative return over the 17 years; The average annual return; The standard deviation; The Sharpe Ratio (assuming a risk free rate of 2.3% on...
The following table repeats the annual total returns on the MSCI Germany Index previously given and...
The following table repeats the annual total returns on the MSCI Germany Index previously given and also gives the annual total returns on the JP Morgan Germany five- to seven-year government bond index (JPM 5–7 Year GBI, for short). During the period given in the table, the International Monetary Fund Germany Money Market Index (IMF Germany MMI, for short) had a mean annual total return of 4.33 percent. Use that information and the information in the table to answer the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT