Risk and Return | Get Solution Now

This assignment will require you to analyze time series of monthly returns for different securities. [5 points] 1) Select three companies as follows from Yahoo! Finance website (https://finance.yahoo.com/): a) S&P 500 (ticker=^GSPC) b) Pick Company 1, a company of your choice and note the “Sector” and “Industry” to which it belongs. Hint: Go to Yahoo! Finance website, enter the ticker symbol under Quote Lookup. Then, click on “Profile” to check the sector/industry it belongs to). c) Pick Company 2 that belongs to a different sector or industry than Company 1. d) Enter the name of the two companies you selected, along with their ticker symbol and sectors, under “Mini-case 1 (State names of selected companies)” Forum. If someone else has already posted your companies then you need to pick another set of companies. Please note that, if you pick companies that have already been selected by one of your colleagues, you will receive a grade of zero for subsequent analyses in this Mini-case. [5 points] 2) Download the MONTHLY price data for the 01/01/2016 – 12/31/2020 period for the three securities. Instructions on how to download price data from Yahoo! Finance website: i. Go to Yahoo! Finance website, enter the security’s ticker symbol in “Quote Lookup” box. Then, click on “Historical Data”. Enter “Time Period” as given above. For “Frequency”, make sure Monthly is selected and then click on “Apply”. Click on “Download Data”. A ticker.csv file will be downloaded. ii. Save your file as a .xls or .xlsx file before you start anything – very important step! Comma delimited (.csv) files do not retain the formulae and cell references after closing the file. You will receive a grade of zero if your excel file does not contain cell references and formulae that show how you arrived at the various answers. iii. You only need the “Date” and “Adj Close” columns. Copy over the “Date” and “Adj Close” columns of the three securities into a single excel so you can do the analysis. (Note: the “Adj Close” column in Yahoo! Finance has already adjusted the prices for dividends and stock splits so you do not have to adjust for it again. [20 points] 3) Calculate the MONTHLY return data for the 01/01/2016 – 12/31/2020 period for the selected three securities. Note: Return for Month 2 = (Adj Close for Month 2/Adj Close for Month 1) – 1 [7 points] 4) Calculate the average arithmetic monthly return, variance, and standard deviation of returns for 01/01/2016 – 12/31/2020 period for the selected three securities. FIN 5130 Mini-case 1 Real-world Application: Risk and Return Dr. Darshana Palkar Page 2 of 2 [8 points] 5) Calculate the covariance and correlation of returns between Company A and Company B for the 01/01/2016 – 12/31/2020 period. What does the correlation indicate? [15 points] 6) Calculate the stock betas for Company A and Company B for the 01/01/2016 –12/31/2020 period. What do the betas indicate? Hint: What is a proxy for the market portfolio? What should go in the known-xs array and what should go in the known-ys array? [25 points] 7) Suppose you invest 50% in Company A and 50% in Company B. What is your portfolio average return and standard deviation? [15 points] 8) Compare the average return and standard deviation of Company A and Company B from #4 with the portfolio average return and standard deviation from #7. What do you observe? What can you conclude from your findings?

This question was posted on order ID 11***

Struggling to find relevant content? Order a custom essay on
Risk and Return | Get Solution Now
Let our experts save you the hassle
Order Now
Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Get personalized services with GPA Fix
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
The writer went above and beyond as usual. Always a great experience with these writers.
Customer 452707, December 4th, 2022
Perfectly done! Thanks again.
Customer 452707, July 18th, 2022
Thank you very much
Customer 452669, November 17th, 2021
Social Work and Human Services
Excellent! Done earlier than needed and with more sources than needed! Great work!
Customer 452485, August 22nd, 2021
Everything was done perfectly. Thank you.
Customer 452707, June 15th, 2022
Thank you so very much!!!
Customer 452517, May 11th, 2021
Customer 452521, May 13th, 2021
Good mastery of ABA concepts. Excellent!
Customer 452469, May 14th, 2022
Criminal Justice
Impressive! Will be using the service again.
Customer 452485, December 5th, 2021
Thank you for helping with my assignment.
Customer 452707, July 8th, 2022
Great work. Will definitely recommend
Customer 452523, May 15th, 2021
public speaking
The work was excelent and very professional.
Customer 452653, November 1st, 2021
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat

Save More. Score Better. Use coupon code SPECIAL for a 15%discount