Reference no: EM13909735
Download the most recent 5 years of monthly data for VTI, Proctor and Gamble (PG), Exxon Mobil (XOM), Apple (AAPL), Alcoa (AA), Century Aluminum (CENX) and the 3-month T-Bill (^IRX) using Yahoo Finance. VTI is a low-cost ETF that tracks the Wilshire 5000 index and is our proxy for the market return.
For the stocks and the ETF, enter the ticker and then on the left-side menu, click on historical prices. Use the adjusted closing prices. For the 3-month T-Bill also use the adjusted close. Note that the TBill returns are annual rates that must be converted to monthly rates.
a. Calculate the monthly return for each stock or ETF. For stocks and the ETF, do this the normal way, but make sure you are moving the correct way through time! For the T-Bill, the rate you download is the annualized percentage return. Convert the annualized return you have downloaded to a monthly return as follows: if you download 1.69, then the monthly return would be (1+0.0169)^(1/12) - 1, or 0.001398.
b. Using the data for the stocks and the stock index, calculate the mean and standard deviation for each return series you have calculated, and the correlation coefficients between each combination of PG, XOM, AAPL, AA, CENX and VTI. (Use the formulas that are built into Excel).
c. Calculate the betas of PG, XOM, AAPL, AA and CENX and graph the results using the "Line fit plot" feature in Excel. Do this by regressing the monthly excess return of each stock on the excess return of the index.
d. What is the R2 of each regression? What does this mean?
e. Is the beta relationship significant? Explain how you know this.
f. Can you tell how large the firm specific risk is for each stock? Explain.
g. If VTI increases by 1%, what is your best guess for the increase in PG? Explain your answer
|
What primary advantages of the capital asset pricing model
: What are the primary advantages and disadvantages of the Capital Asset Pricing Model (CAPM) compared with the Constant Dividend Growth Model for use in pricing common stock?
|
|
Write an interactive webgl program
: Write an interactive WebGL program that stores points and colors in GPU memory once, then uses matrix transformations to modify the scene in various ways.
|
|
The production department in a process manufacturing system
: The production department in a process manufacturing system completed 80,000 units of product and transferred them to finished goods during a recent period. Of these units, 24,000 were in process at the beginning of the period.
|
|
What is expecte number of user able to continue using system
: What is the probability that a particular user, say user 1, is able to continue using the system? What is the expected number of users able to continue using the system?
|
|
Calculate the monthly return for each stock or etf
: Calculate the monthly return for each stock or ETF. For stocks and the ETF, do this the normal way, but make sure you are moving the correct way through time! For the T-Bill, the rate you download is the annualized percentage return.
|
|
Plasminogen for directional subcloning
: Design PCR primers to amplify Kringles 2-4 of human plasminogen for directional subcloning into PBluescript. Show the exact sequence where the PCR product is directionally ligated (2 restriction enzymes) into the vector ( don't show all the interv..
|
|
Database driven web application
: The project is to design, create, evaluate and present/defend a database driven PHP web site, to demonstrate what you have learnt from the module topics.
|
|
Prove the given theorem using one-sided chebyshev inequality
: For all zero-mean rv s X with variance σ 2 other than the special case in (a), show that Pr{X ≥ σ } 0.5.Hint: Use the one-sided Chebyshev inequality of Exercise 1.32.
|
|
The following flowchart shows the august production
: The following flowchart shows the August production activity of the Spalding Company.
|