Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help and show equations used... I'm so confused In this problem, we will find the portfolio return and risk for a three-asset portfolio using

image text in transcribed

Please help and show equations used... I'm so confused

image text in transcribed
In this problem, we will find the portfolio return and risk for a three-asset portfolio using IBM, JNJ, and KO. We have collected monthly stock prices for the past four years. As with our prior chapter, we are using the adjusted price, which accounts for stock splits and dividends. Our goal here is to find the portfolio's expected return and variance if we invest 25% in IBM, 50% in JNJ, and the remaining 25% in KO. (NOTE: We are assuming that the future returns will follow the historical pattern.) Next, we find the monthly returns for each stock in our portfolio. Date IBM JNJ KO Return IBM Return JNJ Return KO IBM JNJ KO 4/1/2019 140.44 139.90 48.21 Expected return 3/1/2019 141.10 139.79 46.45 Variance 2/1/2019 136.54 135.74 44.95 Standard deviation 1/1/2019 132.87 32.20 47.71 Weight 12/1/2018 112.36 28.20 46.94 11/1/2018 121.2 145.01 49.57 Portfolio return 10/1/2018 112.67 138.19 47.09 Covariance IBM, JNJ 9/1/2018 147.59 136.39 45.05 Covariance IBM, KO 8/1/2018 141.44 132.0 43.47 Covariance JNJ, KO 7/1/2018 139.95 129.95 45.48 6/1/2018 134.90 118.98 42.40 Portfolio variance 5/1/2018 134.95 116.43 41.57 Portfolio standard devation 4/1/2018 138.44 123.12 41.77 3/1/2018 146.53 124.74 41.61 2/1/2018 147.37 25.62 41.41 1/1/2018 154.81 133.65 45.60 12/1/2017 145.09 135.13 43.96 11/1/2017 139.63 133.94 3.50 10/1/201 144.25 134.01 43.70 9/1/201 135.85 124.98 42.44 8/1/2017 132.53 126.44 42.95 7/1/2017 134.05 26.78 43.22 6/1/2017 142.53 126.37 41.94 5/1/2017 140.05 21.70 42.52 Portfolio vairance (using MMULT) Note: use Ctrl+Shift+Enter 4/1/2017 147.08 17.16 40.35 Portfolio standard deviation 3/1/2017 159.79 118.19 39.34 2/1/2017 163.71 115.21 38.90 1/1/2017 158.88 106.76 38.54 12/1/2016 151.12 108.61 38.94 11/1/2016 146.36 104.20 37.09 10/1/2016 138.66 108.59 38.98 9/1/2016 143.32 10.60 38.59 8/1/2016 142.12 10.99 39.60 7/1/2016 143.67 116.47 39.78 6/1/2016 135.76 112.8 41.02 5/1/2016 134.91 104.06 40.36 4/1/2016 128.06 103.50 40.54 3/1/2016 132.90 99.91 41.65 2/1/2016 113.82 96.45 38.73 1/1/2016 108.40 95.75 38.54 12/1/2015 119.54 94.17 38.57 11/1/2015 119.9 92.13 37.98 10/1/2015 120.55 91.94 37.7 9/1/2015 124.76 84.95 35.44

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Authors: Jack R. Kapoor, Les R. Dlabay, Robert J. Hughes, Melissa Hart

12th edition

1259720683, 978-1259720680

More Books

Students also viewed these Finance questions

Question

=+b) If you identified a seasonal component, what is the period?

Answered: 1 week ago

Question

more of the itack was $104 ger share on June 8

Answered: 1 week ago