On the spreadsheet with this chapter you will find the following monthly data for Cisco?s stock price
Question:
On the spreadsheet with this chapter you will find the following monthly data for Cisco?s stock price and the S&P 500 index. Compute the equation rCSCO, t = ?CSCO + ?CSCO rSP,t and include the R2 and t -statistics for the equation and its coefficients.22
Transcribed Image Text:
CISCO (CSCO) AND S&P 500 PRICES July 2002 - June 2007 S&P 500 911.62 Date 3-Jul-02 CSCO 13.19 916.07 4 1-Aug-02 3-Sep-02 1-Oct-02 13.82 815.28 10.48 11.18 885.76 1-Nov-02 936.31 14.92 2-Dec-02 879.82 13.10 2-Jan-03 3-Feb-03 3-Mar-03 13.37 855.70 10 841.15 13.98 848.18 11 12.98 916.92 15.00 12 1-Аpг-03 1-May-03 13 963.59 16.41 14 2-Jun-03 974.50 16.79 15 1-Jul-03 990.31 19.49 1-Aug-03 2-Sep-03 19.14 1008.01 16 995.97 19.59 17 20.93 22.70 18 1-Oct-03 1050.71 19 3-Nov-03 1058.20 20 21 1-Dec-03 1111.92 24.23 2-Jan-04 1131.13 25.71 22 2-Feb-04 1144.94 23.16
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 66% (9 reviews)
We can use the data analysis functionality in excel Go to Data tab of ex...View the full answer
Answered By
Wonder Dzidzormenu
As a professional accountant and a teacher, I explain account ing concepts in a more practical way that makes students more connected to the subject.
With over 10 years of teaching accounting , I offer a well constructed , easily understood and in-depth explanations to students questions.
5.00+
1+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Business questions
-
The beta of Tasty Foods stock of 1.10 used by Rae in computing the required return on equity was based on monthly returns for the past 10 years. If Rae uses daily returns for the past 5 years, the...
-
Below you have been provided the prices for Citigroup and the S&P 500 Index. a. Calculate the monthly holding-period returns for Citigroup and the S&P 500 Index. b. What are the average monthly...
-
You have been at your job for East Coat Yachts for a week now and have decided you need to sign up for the company's 401(k) plan. Even after your decision with Sarah Brown, the Bledsoe Financial...
-
What is GST?
-
If insulin were treated with mercaptoethanol to break its disulfide bonds, and then the mercaptoethanol were removed so that disulfide bonds could re-form, how many different ways could the two...
-
For each of the following functions g(x), determine whether exists. If so, give the limit. lim g(x) x-3
-
The following production information about quality costs has been gathered for June: Using these data, calculate the following: a. Total cost to rework b. Profit lost from not reworking all defective...
-
Hoi Chong Transport, Ltd; operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 105,000 kilometers during a year, the average operating cost is 11.4...
-
Part 4: Analysis and Reporting: Communicating findings and providing mitigation recommendation (Week 8) PROJECT SECTION 4 DETAILS: The fourth part of your project requires you to provide a well...
-
8.21. Specify the following queries in relational algebra on the database schema given in Exercise 5.16: a. List the number of courses taken by all students named John Smith in Winter 2009 (i.e.,...
-
Consider a company which has equity = 1.5 and debt = 0.4. Suppose that the risk-free rate of interest is 6%, the expected return on the market E(r M ) = 15%, and that the corporate tax rate is 40%....
-
You are considering buying the bonds of a very risky company. A bond with a $100 face value, a 1-year maturity, and a coupon rate of 22% is selling for $95. You consider the probability that the...
-
A manufacturer of bicycles has 4815 wheels, 2305 frames, and 2255 handlebars. (a) How many bicycles can be manufactured using these parts? (b) How many parts of each kind are left over? (c) Which...
-
A pressure wave traveling through air is described by the following function p(x, t) in terms of position x and time t. p(x,t) = (1.0 atm) sin[(7.0 rad/m) x - (4.0 rad/s) t] 4 5 What is the pressure...
-
Use the following information (in random order) from a merchandising company and from a service company. McNeil Merchandising Company Accumulated depreciation Beginning inventory Ending inventory...
-
There are three primary organizational structures relevant to projects and project management: 1. Functional structure 2. Projectized structure 3. Matrix structure Out of the three which...
-
On January 1, 2017, a company began constructing a new asset. It borrowed $1,000,000 to finance the construction with an annual interest rate of 5%. Assume the following payments for construction...
-
Raj Gupta thought he had it all. After earning a full five-year scholarship to a premier engineering university in the United States, he married Aashna, who graduated from the same program. Raj had...
-
1. Imoinda's sexuality is a key element in both halves of the work: her virginity is central in the African episodes, and her maternity is central in the Surinam episodes. How does this fact affect...
-
An Atomic Energy Commission nuclear facility was established in Hanford, Washington, in 1943. Over the years, a significant amount of strontium 90 and cesium 137 leaked into the Columbia River. In a...
-
Chang Corporation is part of a three-corporation unitary business. The group has a water's edge election in effect with respect to unitary State Q. State B does not apply the unitary concept with...
-
Using the following information from the books and records of Grande Corporation, determine Grandes total sales that are subject to State Cs sales tax. Grande operates a retail general store. Sales...
-
Indicate for each transaction whether a sales (S) or use (U) tax applies or whether the transaction is nontaxable (N). Where the laws vary among states, assume that the most common rules apply. All...
-
Exhibit 6-5 The weight of items produced by a machine is normally distributed with a mean of 8 ounces and a standard deviation of 2 ounces. Refer to Exhibit 6-5. What percentage of items will weigh...
-
The Harding Corporation has $ 5 1 2 million of bonds outstanding that were issued at a coupon rate of 1 2 . 7 5 percent seven years ago Interest rates have fallen to 1 1 1 percent. Preston Alter, the...
-
(Time Value of Money by Valuing Cash Flows at Different Points in Time) i) Your cousin is currently 12 years old. She will be going to college in 6 years. Your aunt and uncle would like to have...
Study smarter with the SolutionInn App