standard deviations and coefficients of variation, calculate market....

Project Description:

bill jobs at compu is looking to expand his product line into cell phones to complement his computer business. warren lynch suggests purchasing a company that is already established in selling cell phones on university campuses; this would not only make compu’s product line more diverse, but it would also expand compu’s geographic area since they could begin to sell computers at the campuses where the cell phone businesses are already established. after doing some research, warren has selected two companies that compu should examine to purchase – cellu and uphone. data on the two companies and the market are given below.

table 1 - probability distribution data
rate of return under these conditions
economy prob. t-bills market cellu uphone
strong 0.25 6.0% 20% 50.0% -8.0%
normal 0.50 6.0% 12.0% 16.0% 12.0%
weak 0.25 6.0% -4.0% -30.0% 32.0%

table 2 - time series data
year market cellu uphone
2003 13.0% -6.0% 40.0%
2004 -6.0% 41.0% -15.0%
2005 -2.0% 7.0% -10.0%
2006 20.0% 20.0% -15.0%
2007 25.0% -11.0% 50.0%

1. find the expected returns, standard deviations, and coefficients of variation for assets in table 1, then rank the assets from least risky to most risky based on their standard deviations and coefficients of variation.

2. using the historical returns data in table 2 to calculate market, cellu, and uphone’s expected returns, standard deviations, beta coefficients, and correlation coefficients with the market. re-rank the assets from least risky to most risky.

3. now use the data in table 2 to calculate the returns and standard deviations on portfolios consisting of 50% each of cellu and uphone for the period 2003-2007. also, calculate the correlation coefficient between cellu and uphone.

4. is the probability data give in table 1 consistent with the time series data given in table 2? if the securities’ expected values and standard deviations as shown in the two sets of data are different, does this prove that something is wrong with the data; i.e. that one or the other data sets must be incorrect?

5. based on your findings, which company should compu invest in? why?
Skills Required:
Project Stats:

Price Type: Negotiable

Total Proposals: 3
1 Current viewersl
15 Total views
Project posted by:


Proposals Reputation Price offered