Answered step by step
Verified Expert Solution
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.
*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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started