Question
In: Finance
Pick 6 stocks, download monthly returns on yahoo finance, calculate the standard deviation for each of...
Pick 6 stocks, download monthly returns on yahoo finance, calculate the standard deviation for each of them and then create a histogram in excel
Solutions
Expert Solution
The data regarding the following stocks are collected .
From the adjusted close price , we need to calculate the monthly returns as
Monthly return = ( End price / begin price ) -1
The returns are as following
Now in order to draw a histogram the data range of the return is selected and we proceed to
Data Tab – Data Analysis – Histogram
The Histogram of the stock return is plotted as follows
Thanks
jeff jeffy answered 2 years agoRelated Solutions
Please download historical monthly price data for General Electric (GE) from Yahoo Finance for the period...
Please download historical monthly price data for General
Electric (GE) from Yahoo Finance for the period of 01/December/2007
– 01/December/2018.
(a) Please calculate the monthly return.
(b) Please calculate the annual stock returns.
(c) An analyst expects the return for GE stock to be 10% lower
than the historical average while its volatility to be 20% higher.
Assume that the probability distribution of the returns of GE stock
for 2019 is normal with the expected value and standard deviation
as...
Calculate the calculate the value of Apples’ stocks given These following inputs from Yahoo finance to...
Calculate the calculate the value of Apples’ stocks given These
following inputs from Yahoo finance to see how close the model will
match the current mkt price. These are 2019 figures:
FCF’s = 60 billion
growth=
5%
wacc =
7.5% Treasury
securities = 51 billion
debt = 92
billion
#shares= 4.6 billion
Assume the growth rate listed is for the first 4 years and then
FCF’s will grow at 3.5% thereafter. (HV)
Calculate the P/E ratio by showing the inputs....
What is the standard deviation of the returns on a portfolio that is invested in stocks...
What is the standard deviation of the returns on a portfolio
that is invested in stocks A, B, and C? 20 percent of the portfolio
is invested in stock A and 45 percent is invested in stock C.
State of Economy
Boom Normal Bust
Probability of Returns if State Occurs
State of Economy Stock A Stock B Stock C 20% 9% 3% 11%
55%4%5%8% 25% -2% 10% -13%
Month Monthly Returns (%) Month Monthly Returns (%) Month Monthly Returns (%) Ended Yahoo Google S&P500...
Month
Monthly Returns (%)
Month
Monthly Returns (%)
Month
Monthly Returns (%)
Ended
Yahoo
Google
S&P500
Ended
Yahoo
Google
S&P500
Ended
Yahoo
Google
S&P500
Dec-07
-13.241
-0.219
-0.692
Dec-06
-5.442
-5.018
1.403
Dec-05
-2.610
2.457
0.036
Nov-07
-13.794
-1.980
-4.182
Nov-06
2.544
1.767
1.899
Nov-05
8.818
8.806
3.778
Oct-07
15.861
24.632
1.590
Oct-06
4.193
18.534
3.257
Oct-05
9.249
17.595
-1.668
Sep-07
18.093
10.096
3.736
Sep-06
-12.314
6.174
2.575
Sep-05
1.561
10.650
0.810
Aug-07
-2.237
1.029
1.497
Aug-06
6.227
-2.087
2.376...
Q1: Calculate the standard deviation of returns on a stock that had the following returns in...
Q1: Calculate the standard deviation of returns on a
stock that had the following
returns in the past three years:
Year Return
1 9%
2
-12%
3
18%
Q:
A company has a target capital structure of 55% common
stock, 10% preferred
stock, and 35% debt.
Its cost of equity is 13%, the cost of preferred stock is
7%,
and the cost of debt
is 8%. The relevant tax rate is 30%. What is the
company’s
Weighted Average
Cost...
What is the standard deviation of the returns on a $40,000 portfolio which consists of stocks...
What is the standard deviation of the returns on a $40,000
portfolio which consists of stocks C and D? Stock C is valued at
$22,000.
State of
Economy
Probability of
State of Economy
Returns if State Occurs
Stock C
Stock D
Boom
20%
15%
4%
Normal
70%
9%
6%
Recession
10%
-2%
5%
3.Yahoo said people who subscribe to the download service on a monthly basis will see their...
3.Yahoo said people who subscribe to the download
service on a monthly basis will see their memberships increase from
$6.99 per month to $11.99 per month. Portal company Yahoo Inc. (
Nasdaq: YHOO - news) informed customers of its subscription music
download service that it will increase pricing for users who
transfer their tunes onto portable devices or CDs. Explain yahoo’s
pricing strategy
1. Go to Yahoo! Finance or another source and pick a stock to track for the...
1. Go to Yahoo! Finance or another source and pick a stock to
track for the last year. Discuss the performance of the stock over
the last year and offer your thoughts being specific about why the
stock has done well or not.
2. What are some reasons that a company might choose common
stock as means of financing their business rather than using debt?
Also comment on why a company might choose debt over common
stock.
1. Go to Yahoo! Finance or another source and pick a stock to track for the...
1. Go to Yahoo! Finance or another source and pick a stock to
track for the last year. Discuss the performance of the stock over
the last year(2018) and offer your thoughts being specific about
why the stock has done well or not.
2. What are some reasons that a company might choose common
stock as means of financing their business rather than using debt?
Also comment on why a company might choose debt over common
stock.
You are to calculate the mean and standard deviation for the rate of returns for IBM...
You are to calculate the mean and standard deviation for the
rate of returns for IBM and GE. Use monthly values for the period
August 1, 2007 through August 1, 2018
Q10.You are to calculate the mean and standard deviation for the
rate of returns for IBM and GE. Use monthly values for the
periodAugust 1, 2007 through August 1, 2018. Data can be obtained
from the WWW as follows 1.Go to http:www.yahoo.com. Select the
Finance option 2.Enter your stock's...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- write an implementation of the ADT stack that uses a resizeable array to represent the stack...
- Problem) Fraud Scheme - Purchasing Agent: A purchasing agent for a large hardware retailer has sole...
- Ivanhoe Corporation has collected the following information after its first year of sales. Sales were $1,600,000...
- There are two major approaches to corporate valuation: a) using comparable firms (via multiples, i.e. ratios)...
- A 4-year annuity of eight $9,800 semiannual payments will begin 7 years from now, with the...
- Consider the following relation schema about project meetings: PMG(projID, title, type, manager, jobID, start-date, end-date, contractor,...
- Question 3 a) A coil consist of 2000 turns of copper wire having a cross sectional...
ADVERTISEMENT