Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use the example in the picture as a template to answer this question. Gather adjusted month end prices for a 10-stock portfolio consisting of

image text in transcribedimage text in transcribed
Please use the example in the picture as a template to answer this question. Gather adjusted month end prices for a 10-stock portfolio consisting of the stocks listed below for the past 60 months (ending October 2020). Use this data to construct a value weighted portfolio. (You can get the market Capitalization data for each company from Yahoo.com). monthly returns of your portfolio and the S&P 500. (Use VFINX as the proxy for the S&P 500 returns). Assume the monthly risk-free rate for the period was .2%. Calculate the portfolio statistics (listed on the template). Use the portfolio statistics, and any other portfolio statistics you wish to calculate, to comment on the risk/return relationship of your portfolio versus the S&P500. Name Symbol Walt Disney Company DIS-US Starbucks Corporation SBUX-US Kellogg Company K-US Halliburton Company HAL-US U.S. Bancorp USB-US Johnson & Johnson JNJ-US FedEx Corporation FDX-US Microsoft Corporation MSFT-US PPG Industries, Inc. PPG-US Southern Company SO-USA1 X Y fx Z M N O P O R S T U V W X Y D E F G H K L Risk-free rate 2 10 Stock Portfolio Stock # S&P500 VFINX Portfolio N 3 4 5 6 7 8 9 10 Average Return 4 Market value Beta 5 Portfolio weight Portfolio Statistics Sharpe Ratio Treynor Ratio 9 Jenson's Alpha 10 Stock returns 11 12 Stock prices S&P500 9 10 Portfolio S&P500 Date VFINX 2 3 5 6 7 8 7 8 9 10 13 Date VFINX 2 3 5 6 14 15 16 17 18 19 20 21A1 X Y fx Z M N O P O R S T U V W X Y D E F G H K L Risk-free rate 2 10 Stock Portfolio Stock # S&P500 VFINX Portfolio N 3 4 5 6 7 8 9 10 Average Return 4 Market value Beta 5 Portfolio weight Portfolio Statistics Sharpe Ratio Treynor Ratio 9 Jenson's Alpha 10 Stock returns 11 12 Stock prices S&P500 9 10 Portfolio S&P500 Date VFINX 2 3 5 6 7 8 7 8 9 10 13 Date VFINX 2 3 5 6 14 15 16 17 18 19 20 21

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

Principles Of Corporate Finance

Authors: Lawrence J. Gitman, Sean M. Hennessey

2nd Canadian Edition

0321452933, 978-0321452931

More Books

Students also viewed these Finance questions