Reference no: EM1377606
You have been given an excel spreadsheet called "Eviews Assessment Dataset- FNM221". This consists of monthly observations on financial and macroeconomic data. The sample starts in March 1986 until April 2007.
|
Microsoft
|
|
Stock Prices of Microsoft
|
|
SANDP
|
|
Value of Standards and Poor
|
|
CPI
|
|
Consumer Price Index
|
|
Industrial production
|
|
Industrial production in billions of US $
|
|
USTB3M
|
|
Rate on 3 months Treasury Bill
|
|
USTB6M
|
|
Rate on 6 months Treasury Bill
|
|
USTB1Y
|
|
Rate on 12 months Treasury Bill
|
|
USTB3Y
|
|
Rate on 3 year Treasury Bill
|
|
USTB5Y
|
|
Rate on 3 year Treasury Bill
|
|
USTB10Y
|
|
Rate on 3 year Treasury Bill
|
|
M1MONEY SUPPLY
|
|
Money Supply (M1)
|
|
CONSUMER CREDIT
|
|
Consumer Credit
|
|
BAA-AAA SPREAD
|
|
Corporate Default Spread
|
Answer ALL questions; marks for each section are noted in brackets.
Input the data in Eviews.
(1) Plot log returns (log (Pt/Pt-1) of Microsoft and Standard and Poors over the sample size. Give a brief explanation of how the stock performed over time. Compute the correlation coefficient between the market and the stock and comment.
(2) Tabulate the summary Statistics (Mean, Median, Standard Deviation, Skewness and Kurtosis) table for Microsoft and comment.
(3) One of the earlier tests of the CAPM (the Market Model) simply assumes the following relationship:
Ri = α + βRm + ui
Estimate this relationship, and comment on the goodness of fit.
(4) Test the hypothesis that α = 0 against the alternative that α ≠ 0
(5) Test the hypothesis that β = 0 against the alternative that β ≠ 0
(6) The Arbitrage Pricing Theory is another competitor for the CAPM. This pricing theory states that certain "factors" can influence returns. The factors which are considered include the following: Difference in log Industrial Production (also, known as change in GDP), Difference in log of Consumer Credit, BAA-AAA Spread.
First create the log of change in Industrial Production and Consumer Credit. (similar to how you computed returns in step 1)
Estimate the APT:
Ri = α + β1Rm + β2X2 + β3X3 + β4X4 + ui
Where : X2, X3, X4 are respectively the log change in industrial production, log change in consumer credit and BAA-AAA spread. Comment on the new model, paying special attention to the goodness of fit, and the parameters.
Does the APT improve on the CAPM as a measure of predicting returns? (Hint test the joint hypothesis that β2= β3= β4= 0. )
|
Sources of synergy among the diversified companies
: Recognize the sources of synergy or core competencies among the diversified companies.First, list at least 3-items or services; second, indicate possible sources of synergy, and third, give the actual firm being described in your discussion.
|
|
Describe the production process
: Assume you had to visit two fast food restaurants that produce hamburgers. Being that you do not eat fast food this is kind of hard for you to do and was wondering if you could get some help.
|
|
Describe the roles and mechanisms of these rna
: Most of the genome does not code for protein, therefore 99% of the human genome is junk that serves no purpose?. With specific reference to examples long and short non-coding RNAs discuss whether you agree with this statement. In your answer you shou..
|
|
Designing a training web site
: Suppose that you require to design the Web site of a call center, Conations, with offices across in Tennessee, Washington, India, Illinois, China, and Germany. The Web site will be used to provide Website based training to existing workers and orien..
|
|
Compute the correlation coefficient
: Give a brief explanation of how the stock performed over time. Compute the correlation coefficient between the market and the stock and comment.
|
|
Communist kerala landmark agreement
: SmartCity and Government of Kerala sign landmark contract Dubai, May 13, 2007(WAM): Opening another horizon of business partnership in India and UAE, SmartCity, a joint venture in TECOM Investments and Sama Dubai,
|
|
Approaches to overcoming resistance in hospitals
: Create a description of how you would implement each of three best approaches at the hospital. Make a distinct, one hundred to 200 word plan for each approach.
|
|
Question about delegation
: Discuss why do many managers have a difficult time delegating effectively and explain why is effective communication a direct link to successful delegation?
|
|
Data collection strategy and sampling, measurement
: Discuss and explain three important things about data collection strategy and sampling, measurement, information collection instruments, and data preparation and display.
|