Question

P8-13 (similar to) Question Help Portfolio return and standard deviation Personal Finance Problem Jamie Wong is thinking of b
Year 2013 2014 2015 2016 2017 2018 Expected return Stock L Stock M 16% 24% 17% 22% 19% 20% 19% 18% 20% 16% 21% 14%
International investment returns Personal Finance Problem Joe Martinez, a U.S. citizen living in Brownsville, Texas, invested


Alternative 1 Investment 100% of asset F 50% of asset F and 50% of asset G 50% of asset F and 50% of asset H 2 3
0 0
Add a comment Improve this question Transcribed image text
Answer #1

formula = rp = WL*RL + WM*RM
WL=0.75,   WM=0.25
ANSWER (a) Year Asset L (RL) Asset M (RM) Portfolio Return (rp) EXCEL FORMULA USED
2013 16% 24% 18% [= 0.75*C4 + 0.25*D4 ]
2014 17% 22% 18.25% SAME WAY FOR OTHERS YEARS
2015 19% 20% 19.25%
2016 19% 18% 18.75%
2017 20% 16% 19%
2018 21% 14% 19.25%
ANSWER (b) AVERAGE EXPECTED DEVIATION OF PORTFOLIO RETURN =                                  18.75% SUM(E4:E9)/6
ANSWER ( c) STANDARD DEVIATION OF PORTFOLIO RETURN = 0.52% STDEV(E4:E9)
ANSWER (d) CORRELATION BETWEEN ASSET L & M = -0.976 CORREL(C4:C9,D4:D9)
AS CORRELATION OF ASSETS BETWEEN L & M IS NEGATIVE
ANSWER (e) BY CREATION OF PORTFOLIO
AS CORRELATION OF ASSETS L & M IS NEGATIVE. HENCE, THE STANDARD DEVIATION WILL DECREASE.
WHICH WILL REDUCE RISK FOR INVESTORS
BY COMBINING THESE TWO NEGATIVELY CORRELATED ASSETS, THE OVERALL PORTFOLIO RISK IS REDUCED

NOTE :- THIS SOLUTION IS USED IN THE EXCEL FORMAT

AS PER THE CURRENT HOMEWORKLIB RULES ONE QUESTION WHICH HAVE SUB PARTS SHOULD BE ATTEMPTED AT A TIME IF YOU WANT THE SOLUTION OF OTHER QUESTION PLEASE KEEP POSTED SEPARATELY , WE WILL GREAT FULL TO HELP YOU ! THANK YOU

PLEASE KEEP THUMPS UP IF YOU SATISFIED WITH THE ANSWER , IF YOU ANY QUERY REGARDING SOLUTION PLEASE COMMENT BELOW.......THANK YOU

Add a comment
Know the answer?
Add Answer to:
P8-13 (similar to) Question Help Portfolio return and standard deviation Personal Finance Problem Jamie Wong is...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Portfolio return and standard deviation Personal Finance Problem Jamie Wong is thinking of building an investment...

    Portfolio return and standard deviation Personal Finance Problem Jamie Wong is thinking of building an investment portfolio containing two stocks, L and M. Stock L will represent 45% of the dollar value of the portfolio, and stock M will account for the other 55%. The historical returns over the next 6 years, 2013-2018, for each of these stocks are shown in the following table: a. Calculate the actual portfolio return, ro, for each of the 6 years. b. Calculate the...

  • Portfolio return and standard deviation Personal Finance Problem Jamie Wong is thinking of building an investment...

    Portfolio return and standard deviation Personal Finance Problem Jamie Wong is thinking of building an investment portfolio containing two stocks, Land M. Stock L will represent 65% of the dollar value of the porto, stock M will count for the other 35%. The historical returns over the next 6 years, 2013 - 2018, for each of these stocks are shown in the following table a. Calculate the actual portfolio return for each of the years. b. Calculate the expected value...

  • International investment returns Personal Finance Problem Joe Martinez, a U.S. citizen living in Brownsville, Texas, invested...

    International investment returns Personal Finance Problem Joe Martinez, a U.S. citizen living in Brownsville, Texas, invested in the common stock of Telmex, a Mexican corporation. He purchased 3,000 shares at 20.50 pesos per share. Twelve months later, he sold them at 26.00 pesos per share. He received no dividends during that time. a. What was Joe's investment return (in percentage terms) for the year, on the basis of the peso value of the shares? b. The exchange rate for pesos...

  • p8-15 A-C 333 CHAPTER 8 Risk and Return a. If the returns of assets V and...

    p8-15 A-C 333 CHAPTER 8 Risk and Return a. If the returns of assets V and W are perfectly positively correlated (correlation coefficient = +1), describe the range of (1) expected return and (2) risk associ- ated with all possible portfolio combinations. b. If the returns of assets V and W are uncorrelated (correlation coefficient = 0), describe the approximate range of (1) expected return and (2) risk associated with all possible portfolio combinations c. If the returns of assets...

  • 0.43 Portfolio return and standard deviation Jamie Wong is thinking of building an investment portfolio containing...

    0.43 Portfolio return and standard deviation Jamie Wong is thinking of building an investment portfolio containing two stocks, L and M. Stock L will represent 40% of the dollar value of the portfolio, and stock M will account for the other 60%. The historical returns over the last 6 years, 2013-2018, for each of these stocks are shown in the following table. Year Expected return Stock L Stock M 14% 20% 14 16 2013 2014 2015 2016 2017 2018 a....

  • Joe Martinez, a U.S. citizen living in Brownsville, Texas, invested in the common stock of Telmex,...

    Joe Martinez, a U.S. citizen living in Brownsville, Texas, invested in the common stock of Telmex, a Mexican corporation. He purchased 4,000 shares at 21.00 pesos per share. Twelve months later, he sold them at 29.75 pesos International investment returns Personal Finance Problem per share. He received no dividends during that time. a. What was Joe's investment return (in percentage terms) for the year, on the basis of the peso value of the shares? b. The exchange rate for pesos...

  • Portfolio return and standard deviation Jamie Wong is thinking of building an investment portfolio containing two...

    Portfolio return and standard deviation Jamie Wong is thinking of building an investment portfolio containing two stocks, L and M. Stock L will represent 40% of the dollar value of the portfolio, and stock M will account for the other 60%. The historical returns over the last 6 years, 2013-2018, for each of these stocks are shown in the following table. P8-13 Expected return Year Stock L Stock M 2013 2014 2015 2016 2017 2018 14% 14 16 17 17...

  • 5-12 Portfolio return and standard deviation Jamie Wong is considering building a portfolio containing two assets,...

    5-12 Portfolio return and standard deviation Jamie Wong is considering building a portfolio containing two assets, L and M. Asset L will represent 40% of the dollar value of the portfolio, and asset M will account for the other 60%. The expected returns over the next 6 years, 2004–2009, for each of these assets, are shown in the following table. Expected return Asset L Asset M Year 20% 14% 14 16 2004 2005 2006 2007 2008 2009 17 a. Calculate...

  • Portfolio return and beta Personal Finance Problem Jamie Peters invested $122,000 to set up the following...

    Portfolio return and beta Personal Finance Problem Jamie Peters invested $122,000 to set up the following portfolio one ye X Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) a. Calculate the portfolio bela on the basis of the original cost figures. b. Calculate the percentage return of each asset in the portfolio for the year. c. Calculate the percentage retum of the portfolio...

  • Portfolio return and beta Personal Finance Problem Jamie Peters invested $114,000 to set up the following...

    Portfolio return and beta Personal Finance Problem Jamie Peters invested $114,000 to set up the following portfolio one year ago Calculate the porta o beta on the basis of the original cost foures b. Calculate the percentage retum of each asset in the portfolio for the year c. Calculate the percentage retum of the portfolio on the basis of original cos, using income and gains during the year. d. At the time Jamie made his investments, investors were estimating that...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT