all the links of the historical data are put feel free touse them thank you for...
all the links of the historical data are put feel free touse them thank you for your needed help
1) Go to Yahoo FINANCE. Obtain two years’ worth of daily stock rates of return for PepsiCo: https://finance.yahoo.com/quote/PEP/history?p=PEP, Coca Cola:https://finance.yahoo.com/quote/KO/history?p=KO , and for the S&P 500: https://finance.yahoo.com/quote/%5EGSPC/history?p=%5EGSPC, index. Use a spreadsheet to compute PepsiCo’s and Coca-Cola’s historical market betas. (Note: For future market betas, you should further shrink towards 1.)
2) Download 3 years of historical daily (dividendadjusted) prices for Intel (INTC) and the S&P 500 from Yahoo FINANCE. here are the links for the 3 years INTC :https://finance.yahoo.com/quote/intc/history/. S&P 500: https://finance.yahoo.com/quote/%5EGSPC/history?p=%5EGSPC.
1. Compute the daily rates of return.
2. Compute the average rates of return and risk of portfolios that combine INTC and the S&P 500 in the following proportions: (0.0,1.0), (0.2,0.8), (0.4,0.6), (0.6,0.4), (0.8,0.2), (1.0,0.0). Then plot them against one another. What does the plot look like?
3. Compute the historical market beta of Intel.
Homework Answers
Request Answer!
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Add Answer to:
all the links of the historical data are put feel free touse
them thank you for...
This assignment will require you to analyze time series of monthly returns. Start by retrieving MONTHLY...
This assignment will require you to analyze time series of monthly returns. Start by retrieving MONTHLY data for the period of 08/01/2015 – 08/31/2019 from Yahoo website for − S&P 500 Index (ticker: ^GSPC) − General Electric Company (ticker: GE) − Chevron Corporation (ticker: CVX) − Intel Corporation (ticker: INTC) − Tesla, Inc. (ticker: TSLA) Instructions for downloading the data from Yahoo! Website (https://finance.yahoo.com/): To obtain the monthly data for each company, on Yahoo! Finance website, enter the ticker symbol...
To fill out the first table, you will need to select 3 bonds with maturities between...
To fill out the first table, you will need to select 3 bonds with maturities between 10 and 20 years with bond ratings of "A to AAA," "B to BBB" and "C to CC" (you may want to use bond screener at the Web site linked above). All of these bonds will have these values (future values) of $1,000. You will need to use a coupon rate of the bond times the face value to calculate the annual coupon payment....
integrated mini-case: Disney’s Beta When you go on the web to find a firm’s beta, you...
integrated mini-case: Disney’s Beta
When you go on the web to find a firm’s beta, you do not know
how recently it was computed, what index was used as a proxy for
the market portfolio, or which time series of returns the
calculations used. Earlier in this chapter, it was shown that when
we went on the Web to find a beta for Disney, we found the
following: MSN Money (1.29) and Yahoo! Finance (1.18). An
alternative is to compute...
The Beta for Colgate-Palmolive
Joey Moss, a recent finance graduate, has just begun his jobwith the investment firm of Covili and Wyatt. Paul Covili, oneof the firm’s founders, has been talking to Joey about the firm’sinvestment portfolio.As with any investment, Paul is concerned about the riskof the investment as well as the potential return. More specifically, because the company holds a diversified portfolio, Paulis concerned about the systematic risk of current and potentialinvestments. One such position the company currently holdsis stock in Colgate-Palmolive (CL)....
I need help calculating all kf these questions. Really stuck on all of them! Thank you!...
I need help calculating all kf these questions. Really stuck
on all of them! Thank you!
Year using the returns for the first three years. The next rolling ace would be calculated using the returns from Years 2. 3. and 4, and so on Using the annual returns for large company stocks and Treasury bills, calculate both the 5- and 10-year rolling average return and standard deviation. h Over how many 5-year periods did Treasury bills outreform Caree company stocks?...
Whenever a stock price changes, one of two things is probably happening investors are updating their...
Whenever a stock price changes, one of two things is probably happening investors are updating their expectations about Tesla's future cash flows, or investors are updating their beliefs about the appropriate "discount rate to apply to those estimated future cash flows. What discount rate are Tesla's investors using for their cash flows? In this question, we are going to calculate one possible estimate for this discount rate, which is known as the weighted Average Cost of Capital for WACC) The...
integrated mini-case: Disney’s Beta
When you go on the web to find a firm’s beta, you do not know
how recently it was computed, what index was used as a proxy for
the market portfolio, or which time series of returns the
calculations used. Earlier in this chapter, it was shown that when
we went on the Web to find a beta for Disney, we found the
following: MSN Money (1.29) and Yahoo! Finance (1.18). An
alternative is to compute...
I need help calculating all kf these questions. Really stuck
on all of them! Thank you!
Year using the returns for the first three years. The next rolling ace would be calculated using the returns from Years 2. 3. and 4, and so on Using the annual returns for large company stocks and Treasury bills, calculate both the 5- and 10-year rolling average return and standard deviation. h Over how many 5-year periods did Treasury bills outreform Caree company stocks?...
Whenever a stock price changes, one of two things is probably happening investors are updating their expectations about Tesla's future cash flows, or investors are updating their beliefs about the appropriate "discount rate to apply to those estimated future cash flows. What discount rate are Tesla's investors using for their cash flows? In this question, we are going to calculate one possible estimate for this discount rate, which is known as the weighted Average Cost of Capital for WACC) The...
Most questions answered within 3 hours.
-
1. In a labor market, marginal cost for a firm is
____________.
a. recruiting cost
b....
asked 12 minutes ago -
On January 1, 2019, ABC Company issued $60,000,000 of 20-year,
10.5% bonds when the market rate...
asked 36 minutes ago -
39.4% of US homes continue to use a landline in addition to cell
phone service. 3...
asked 1 hour ago -
Starting with benzene, synthesize 1-phenyl-1-butyne.
Show intermediates and reagents.
asked 2 hours ago -
Create a 32-run crossed array design with six control factors
and two noise factors such that...
asked 3 hours ago -
A 500g sample of sand from source A has the following amounts
retained on each sieve....
asked 3 hours ago -
In
your own words, please explain the essay by John Keynes wrote "The
End of Laissez...
asked 3 hours ago -
How are the matrix and pixels related? Why are smaller
pixels better for diagnostic quality?
asked 3 hours ago -
2. An AC generator has 80 rectangular loops on
its armature. Each loop is 11 cm...
asked 3 hours ago -
Please help me with this question. Consider Aldi’s current and
potential geographic markets (see Exhibit 4...
asked 3 hours ago -
What are the main components of the fermentation process and
give an explanation of each? Include...
asked 3 hours ago -
Explain which types of cells in the body (belonging to which
organs, etc.) are sensitive to...
asked 3 hours ago