Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

just give the answer of 5 part 1. Group, where you put all students' name. 2. Data, where you put all daily pricing info and

image text in transcribedimage text in transcribed

just give the answer of 5 part

1. "Group," where you put all students' name. 2. "Data," where you put all daily pricing info and Rf info 3. Ret," where you compute daily returns in the left half. In the right half, pls report E(ret) and var-cov you compute in step 1. Also report here the 3rd and 4th moments 4. "VaR," where you rank daily return observations ascendingly and use interpolation to compute VaR 5% for each stock. This is from # 2. 5. "MVP2," where you follow #3 and compute the weights of the two stocks for global MVP using 2 best performing stocks 6. "02," where you follow # 4 and compute the weights of the two stocks for global O using 2 best performing stocks. 7. "IOS," where you follow #5, showing all 50 data points in a separate table and a half- moon-shaped IOS/EF and CAL. 8. "Summary," which just put together all relevant numbers from #7. The table should show the weights for individual stocks as well as the risk, ret, and SR for global MVP and O. SWN Mean & SD Average Daily Return Standard Deviation JP -0.08% 3.56% AAPL 0.09% 1.22% CAT 0.11% 1.63% BA 0.07% 1.74% 0.10% 1.77% SWN Var/Cov Matrix SWN JPM JP 0.00127 0.00013 0.00014 0.00020 0.00010 AAPL 0.00013 0.00015 0.00009 0.00012 0.00009 CAT 0.00014 0.00009 0.00027 0.00013 0.00011 BA 0.00020 0.00012 0.00013 0.00030 0.00016 AAPL CAT BA 0.00010 0.00009 0.00011 0.00016 0.00031 1. "Group," where you put all students' name. 2. "Data," where you put all daily pricing info and Rf info 3. Ret," where you compute daily returns in the left half. In the right half, pls report E(ret) and var-cov you compute in step 1. Also report here the 3rd and 4th moments 4. "VaR," where you rank daily return observations ascendingly and use interpolation to compute VaR 5% for each stock. This is from # 2. 5. "MVP2," where you follow #3 and compute the weights of the two stocks for global MVP using 2 best performing stocks 6. "02," where you follow # 4 and compute the weights of the two stocks for global O using 2 best performing stocks. 7. "IOS," where you follow #5, showing all 50 data points in a separate table and a half- moon-shaped IOS/EF and CAL. 8. "Summary," which just put together all relevant numbers from #7. The table should show the weights for individual stocks as well as the risk, ret, and SR for global MVP and O. SWN Mean & SD Average Daily Return Standard Deviation JP -0.08% 3.56% AAPL 0.09% 1.22% CAT 0.11% 1.63% BA 0.07% 1.74% 0.10% 1.77% SWN Var/Cov Matrix SWN JPM JP 0.00127 0.00013 0.00014 0.00020 0.00010 AAPL 0.00013 0.00015 0.00009 0.00012 0.00009 CAT 0.00014 0.00009 0.00027 0.00013 0.00011 BA 0.00020 0.00012 0.00013 0.00030 0.00016 AAPL CAT BA 0.00010 0.00009 0.00011 0.00016 0.00031

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

Capital Market Finance

Authors: Patrice Poncet, Roland Portait, Igor Toder

1st Edition

ISBN: 3030845982, 978-3030845988

More Books

Students also viewed these Finance questions