Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using yahoo finance to find Disney's price data from December 31, 2013 - December 31, 2016. I need to find the stock price, market price,

Using yahoo finance to find Disney's price data from December 31, 2013 - December 31, 2016. I need to find the stock price, market price, stock return, beta, and covariance. Attached is a spread sheet of what the Hw looks like.

image text in transcribed

*Please check this file has three other sheets for Work and the sheet with initial Assumptions(Five Sheets total)*** "You can assume the Risk-Free is 296 and MRP is 596 or you can calculate both parameters if you wish to do so. (MRP-Expected Return of the Market-RiskFree Rate) (Rf you can use 10YrTreasuryBond) **You can get the price data below from Yahoo Finance Covarianc e of Stock and Yahoo Finance Historical Data You can use Excel Formula "COVARIANCE.P Frequency->Monthly of Market You can use Excel Formula VAR.P Time Period: December 31st, 2013 to December 31st 2016 Beta CovarianceStock Marke/VarianceMarket Download Data CAPM E EIRI RfBeta (Market Risk Premium) Must choose *Adj Close P1-POVPO or P1 PO 1 Stock Price Market"Price" "Stock Return Market Return 12/31/2016 11/30/2016 10/31/2016 9/30/2016 8/31/2016 7131/2016 6/30/2016 5/31/2016 4/30/2016 3/31/2016 2/29/2016 1/31/2016 12/31/2015 11/30/2015 10/31/2015 9/30/2015

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 An Integrated Approach

Authors: Bernard J. Winger

4th Edition

0198520972, 9780132696302

More Books

Students also viewed these Finance questions