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: 75% (8 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...
-
Write the name of each of the following molecular compounds. (a) HI (b) NF 3 (c) SO 2 (d) N2Cl 4
-
Compare and contrast the ethical approaches of its legal, therefore, its ok and the ends justify the means. Are there similarities? Are there differences?
-
The stockholders equity accounts of Omega Corporation on January 1, 2012, were as follows. Preferred Stock (7%, $100 par noncumulative, 5,000 shares authorized) ...$ 300,000 Common Stock ($4 stated...
-
A 1 kg metal block is heated to 200 C and then dropped into a thermally isolated container with 4 kg of water and 100 gr of ice both at a temperature of 0 C. If the specific heat of water is cw=4186...
-
Stan and Susan, two calendar year taxpayers, are starting a new business to manufacture and sell digital circuits. They intend to incorporate the business with $600,000 of their own capital and $2...
-
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...
-
For the designs obtained in part (a) of Problem 31, use a computer method to plot the actuator torque versus time. Compare the peak torque values for each case. In problem 31(a) Compute the required...
-
Lana finished the race in 13.2 seconds. If 84 other girls ran in the event, approximately how many runners did she beat?
-
A certain beach has 400 yards of sand, but erosion is decreasing it by 30% each year. Which expression represents the amount of beach as a function of time? Use the formula A(t)=a(1+-r)^(t).
-
Simplify the expression (1)/(1+cosx)+(1)/(1-cosx) into one term involving one trigonometric function without fractions.
-
The number of girls at a small high school is 60 greater than the number of boys. If there are 1250 total students, how many girls are there?
-
Maggie's Manpower Moving (MMM) is launching a new project. Depending on the success of the project next year MMM will be worth $90 million, $150 million or $200 million with equal probability. Assume...
-
Consider the Sun Gas proposed entry into ecommerce in P1-42A. Smith revises her estimates of the benefits from the new system's lower labour costs. She now thinks the savings will be only $933,000....
-
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...
-
2. The latency of task through a processor is defined as the time between the moment the task enters the processor to the moment the task leaves the processor. A single-stage processor can finish a...
-
Integration can be regarded as taking the area under a curve. When a "curve" is a straight line, such as in Figure 1, this is simple geometry. When the curve actually curves, however, geometry can...
-
Use as few of the nine types of parent functions as possible to satisfy each constraint at least once. The nine types include: linear, quadratic, exponential, square root, rational (y = 1/x),...
Study smarter with the SolutionInn App