Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. use the following information to answer questions

Use the following information to answer questions 15-37. Please enter percentages as whole numbers, e.g....

90.2K

Verified Solution

Question

Finance

image
Use the following information to answer questions 15-37. Please enter percentages as whole numbers, e.g. enter 7.1118% as 7.1118 not 0.071118. Context 3: Go to Yahoo!Finance, find the monthly adjusted closing prices for XOM and GOOGL spanning the 3 years 30Nov 14 to 31Dec17. (Since the closing prices are adjusted, your downloaded prices can differ from the Canvas answers, but that is ok.] Read off the end- of-the-year prices. [If you click on monthly, they may be marked by the wrong day of Dec, e.g. 12/1/2015 instead of 12/31/2015. If you click on daily, they will be labelled correctly but more numbers to scroll through.). Compute continuous returns for 2015-17. Find the means and the st. devs of the returns (use stdev.p). Compute the returns for a portfolio invested 70% in XOM and 30% in GOOGL. Find the mean and the st. deviation of the portfolio. Year XOM Prc GOOGL Prc XOM Ret GOOGL Ret Portfolio Ret Dec 2014 #15 #16 Dec 2015 #17 #18 #19 #20 #21 Dec 2016 #22 #23 #24 #25 #26 Dec 2017 #27 #28 #29 #30 #31 #32 #33 Mean #34 #35 St Dev #36 #37

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students