Create the line charts for each of S&P, Boeing and IBM series using Close prices against time in Excel and comment on your observations (focusing on different features a time series can exhibit). 2....

1 answer below »
Create the line charts for each of S&P, Boeing and IBM series using Close prices against time in Excel and comment on your observations (focusing on different features a time series can exhibit). 2. a. Calculate returns for these three series in Excel using the transformation: rt = 100*ln(Pt / Pt-1) b. Obtain the summary statistics for returns series in your sample and briefly discuss the risk and average return relationship in each stock. Which stock (Boeing or IBM) is relatively riskier than the other? c. Perform the Jarque-Berra test of normally distributed returns for each of Boeing and IBM. Discuss your findings and also explain why do you test normality test.


Document Preview:

Perform the following. 1. Create the line charts for each of S&P, Boeing and IBM series using Close prices against time in Excel and comment on your observations (focusing on different features a time series can exhibit). 2. a. Calculate returns for these three series in Excel using the transformation: r = 100*ln(P / t t P ) t-1 b. Obtain the summary statistics for returns series in your sample and briefly discuss the risk and average return relationship in each stock. Which stock (Boeing or IBM) is relatively riskier than the other? c. Perform the Jarque-Berra test of normally distributed returns for each of Boeing and IBM. Discuss your findings and also explain why do you test normality test. 3. Test the hypothesis that average return on Boeing stock is at least 3%. Which test statistic would you use to perform this hypothesis test and why? Also, specify the distribution of the test statistic under the null. 4. Before investing in one of the two stocks, you first want to compare risk associated to each of the two stocks. Perform any appropriate hypothesis test using 5% significance level and interpret your results. 5. You further want to determine whether both stocks have same population average return. Perform an appropriate hypothesis test using information in your sample of 65 observations on returns and report your findings. Also, which stock will you prefer and why? 6. Compute excess return on your preferred stock as y = r - r and excess market return t t f,t as x = r - r (that is, you subtract the 10-year T-Bill rate from return on your preferred t M,t f,t stock and the market return). 7. a. Estimate the CAPM using linear regression where the dependent variable is excess return on your preferred stock while the independent variable is excess market return (computed as return on S&P 500 minus the risk fee rate) and report your results. b. Interpret the estimated coefficients in relation to the...



005_p8hpa5o-u3ilwj5b.pdf 005_cslpa5o-0z01zq5p.xlsx
Answered Same DayDec 27, 2021

Answer To: Create the line charts for each of S&P, Boeing and IBM series using Close prices against time in...

Robert answered on Dec 27 2021
120 Votes
Student Name
Course Name
University Name
9
th
-October-2017
Task 1
S&P
S&P which the biggest proxy for equity markets in U.S shows that the market has been on the
constant upside since last few years. The markets have been resilient and performing well
over the last few years.
Boeing
In line with stock market movement, Boeing’s stock price has been on an high ever since.
The market is seeing some downturn during the period. The stock has been steadily up as
0

500
1000
1500
2000
2500
7
/1
/2
0
1
0
1
0
/1
/2
0
1
0
1
/1
/2
0
1
1
4
/1
/2
0
1
1
7
/1
/2
0
1
1
1
0
/1
/2
0
1
1
1
/1
/2
0
1
2
4
/1
/2
0
1
2
7
/1
/2
0
1
2
1
0
/1
/2
0
1
2
1
/1
/2
0
1
3
4
/1
/2
0
1
3
7
/1
/2
0
1
3
1
0
/1
/2
0
1
3
1
/1
/2
0
1
4
4
/1
/2
0
1
4
7
/1
/2
0
1
4
1
0
/1
/2
0
1
4
1
/1
/2
0
1
5
4
/1
/2
0
1
5
7
/1
/2
0
1
5
1
0
/1
/2
0
1
5
S&P
0
20
40
60
80
100
120
140
160
7
/1
/2
0
1
0
1
0
/1
/2
0
1
0
1
/1
/2
0
1
1
4
/1
/2
0
1
1
7
/1
/2
0
1
1
1
0
/1
/2
0
1
1
1
/1
/2
0
1
2
4
/1
/2
0
1
2
7
/1
/2
0
1
2
1
0
/1
/2
0
1
2
1
/1
/2
0
1
3
4
/1
/2
0
1
3
7
/1
/2
0
1
3
1
0
/1
/2
0
1
3
1
/1
/2
0
1
4
4
/1
/2
0
1
4
7
/1
/2
0
1
4
1
0
/1
/2
0
1
4
1
/1
/2
0
1
5
4
/1
/2
0
1
5
7
/1
/2
0
1
5
1
0
/1
/2
0
1
5
BOEING COMPANY
aviation industry as whole is going through decent times. The order book the company is
pretty strong and the same is helping the company in the long run and market is appreciating
the same with decent uplift in stock prices.
IBM
IBM is one of the big technology giant and has been known to set precedents in the whole set
of business. However just like any technology company in the last two years there has been
huge pressure on the industry as the whole sector is facing headwinds. The exchange rates;
falling spending across the globe and concerns related with outsourcing business has hit the
sector hard. Across the board, IBM is undergoing significant change. The company strives to
remake itself in the digital age, while also maintaining a large and more traditional IT
customer base. IBM retains one of the largest partner networks, and its consulting and service
businesses are wide in scope and deep in penetration. The difficulty for the company comes
from how it historically has made money and grown its revenue base. Some traditional
product offerings are in a declining revenue position, but IBM offerings are broad and
difficult to unseat. The IBM sales force is both an advantage and a disadvantage, in that it has
cultivated strong relationships with enterprise clients. As customers seek offerings from new
0
50
100
150
200
250
7
/1
/2
0
1
0
1
0
/1
/2
0
1
0
1
/1
/2
0
1
1
4
/1
/2
0
1
1
7
/1
/2
0
1
1
1
0
/1
/2
0
1
1
1
/1
/2
0
1
2
4
/1
/2
0
1
2
7
/1
/2
0
1
2
1
0
/1
/2
0
1
2
1
/1
/2
0
1
3
4
/1
/2
0
1
3
7
/1
/2
0
1
3
1
0
/1
/2
0
1
3
1
/1
/2
0
1
4
4
/1
/2
0
1
4
7
/1
/2
0
1
4
1
0
/1
/2
0
1
4
1
/1
/2
0
1
5
4
/1
/2
0
1
5
7
/1
/2
0
1
5
1
0
/1
/2
0
1
5
IBM
digital markets, the sales teams struggle to keep up with the rapidly shifting nature of IBM's
business.
Interest Rate in U.S
Interest rate has been the biggest determinant on how the economy will shape up. Interest rate
has been pretty low since 2008 as global recession happened. However post 2014 end,
interest rate hardening has started, however the pace has been pretty slow. It is expected that
as Fed squeezes its balance sheet and trim the bond buyback program, interest rate hardening
will take places and markets will again feel the punch. Markets are expected to feel money
squeeze as capital becomes expensive.
Task 2a
S&P BOEING COMPANY IBM
Returns 26.84442 32.67361229 3.01165343
The table above shows the return of each of the concerned equity instruments and the index.
In this case there are N+1 observation and hence cases of total N returns. This is the log
return of concerned instruments.
Task 2b
0
0.5
1
1.5
2
2.5
3
3.5
4
7
/1
/2
0
1
0
1
0
/1
/2
0
1
0
1
/1
/2
0
1
1
4
/1
/2
0
1
1
7
/1
/2
0
1
1
1
0
/1
/2
0
1
1
1
/1
/2
0
1
2
4
/1
/2
0
1
2
7
/1
/2
0
1
2
1
0
/1
/2
0
1
2
1
/1
/2
0
1
3
4
/1
/2
0
1
3
7
/1
/2
0
1
3
1
0
/1
/2
0
1
3
1
/1
/2
0
1
4
4
/1
/2
0
1
4
7
/1
/2
0
1
4
1
0
/1
/2
0
1
4
1
/1
/2
0
1
5
4
/1
/2
0
1
5
7
/1
/2
0
1
5
1
0
/1
/2
0
1
5
INTEREST RATE ON US -TREASURY NOTE
Jacques Barra Test
JB (observed value) 2.239
JB (critical...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?