The file Stock.xlsx contains monthly stock returns for General Motors and Microsoft. Name the ranges containing the
Question:
The file Stock.xlsx contains monthly stock returns for General Motors and Microsoft. Name the ranges containing the monthly returns for each stock and compute the average monthly return on each stock.
Transcribed Image Text:
E F -0.240320429 -0.202509 0.276619107 0.338983 CSCO 0.037267081 53 30-Apr-90 54 31-May-90 0.258620679 0.083515622 55 29-Jun-90 0.121518984 0.040485829 0.022284122 0.010753 0.047404062 -0.003891051 -0.053892214 -0.035422344 0.010638 0.221518993 0.115819208 0.042105 0.005444646 -0.025906736 -0.020565553 0.070707 0.034296028 -0.05319149 -0.020997375 -0.037736 -0.25 -0.131367296 -0.029412 -0.088050313 -0.090909 0.04109589 56 31-Jul-90 -0.125 57 31-Aug-90 -0.075187966 -0.13438046 58 28-Sep-90 0.024390243 -0.003745318 -0.113387093 -0.04587156 0.007518797 0.013793103 0.311111 59 31-Oct-90 0.011904762 60 30-Nov-90 0.13333334 0.052884616 0.119402982 0.013605442 0.338983 61 31-Dec-90 0.041522492 0.057260275 62 31-Jan-91 0.115468413 0.303986698 0.026666667 -0.05821918 0.136076 0.188311681 0.054545455 0.303621 0.043715846 0.100689657 -0.042735 0.023897059 -0.020942409 -0.044303797 -0.129464 0.016157989 0.053475935 -0.052980132 0.220513 0.09908127 0.131979689 0.217482507 0.084034 67 28-Jun-91 -0.068906605 -0.042071197 -0.165919289 -0.055072464 -0.054264 63 28-Feb-91 0.057324842 0.070468754 64 28-Mar-91 0.022891566 65 30-Apr-91 -0.067137808 66 31-May-91 0.108585857 68 31-Jul-91 -0.024539877 0.286885 69 30-Aug-91 0.078899086 -0.010135135 0.010752688 0.159863949 0.022184301 0.053191491 -0.033962265 0.156051 0.043988269 -0.066644408 -0.146464646 -0.016447369 -0.096419 -0.03846154 -0.060200669 0.189024 70 30-Sep-91 71 31-Oct-91 0.054775283 -0.005405406 Figure 30-1 Monthly stock returns. A 49 50 B 51 Date 52 30-Mar-90 Microsoft с GE D min max Intel GM
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (5 reviews)
To name the ranges containing the monthly returns for General Motors and Microsoft stocks i...View the full answer
Answered By
Brian Kiprono
Taking part in public speeches, blogging, writing essays
0.00
0 Reviews
10+ Question Solved
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted:
Students also viewed these Business questions
-
The spreadsheet file "Chapter 5 Problem 3.xlsx" (to find the student spreadsheets for Financial Analysis with Microsoft Excel, seventh edition, go to www.cengagebrain.com) contains monthly total...
-
The normal quantile plot of daily stock returns for General Motors during 19921993 (507 trading days) shows an anomaly, a flat spot at zero. (a) Whats happened? (b) Why does the anomaly not appear in...
-
Today is March 29, 2019, and you have just started your new job with a financial planning firm. In addition to studying for all your license exams, you have been asked to review a portion of a...
-
A manufacturer of packaging for companies that produce breakfast cereals is considering alternatives regarding the process it uses to pre-process carton paper used to make the packaging....
-
On October 1, 2009, Kemper International acquired a 90% interest in the equity of Spruco Manufacturing when the subsidiarys equity was 8,000,000 foreign currency (FC), including retained earnings...
-
Design a jib crane as shown in Figure P5-60 that will support a downward load of 6000 lb. Choose a common structural steel shape for all members. Use allowable stresses of 0.66Sy (Sy is the yield...
-
Fran Stein started an environmental consulting company and during the first month of operations (February 2012) the business completed the following transactions: a. Stein began the business with an...
-
Ross Corporation is a debtor in a reorganization proceeding under Chapter 11 of the Bankruptcy Code. By fair and proper valuation, its assets are worth $100,000. The indebtedness of the corporation...
-
If f(x) = (4x+1)(3x-2), then: a. f(2) = b. f'(2) = c. f" (2) = d. The values of x for which f(x) = 0 are e. The values of x for which f'(x) = 0 are
-
Fast Deliveries, Inc. (FDI), was organized in December last year and had limited activity last year. The resulting bala sheet at the beginning of the current year is provided below: Assets: Cash...
-
Create a range name that averages the last five years of sales data. Assume annual sales are listed in a single column.
-
Redo Problem 9 using XLOOKUP formulas. Data from in Problem 9 The file Grades.xlsx contains students grades on an exam. Suppose the curve is as follows: Use VLOOKUP formulas to return each students...
-
An ice cream company finds that at a price of $4.00, demand is 4000 units. For every $0.25 decrease in price, demand increases by 200 units. Find the price and quantity sold that maximize revenue.
-
Which of the following tracks the prices of goods and resources sellers use to create their products? a. GDP b. CPI c. PPI d. GNP
-
Identity theft is mainly a problem for senior citizens. True or False
-
The supply chain is the process by which products, information, and money move between a supplier and the consumer. True or False
-
Globalization poses risks to the U.S. economy because of security and patent protection concerns. True or False
-
A not-for-profit organization uses any revenue to reward the management team. True or False
-
What are some of the key aspects of performance that would enable a share follower like Yahoo to achieve the same level of profit as a share leader?
-
An environmentalist wants to determine if the median amount of potassium (mg/L) in rainwater in Lincoln County, Nebraska, is different from that in the rainwater in Clarendon County, South Carolina....
-
The Euro Watch Company assembles expensive wristwatches and then sells them to retailers throughout Europe. The watches are assembled at a plant with two assembly lines. These lines are intended to...
-
Many states supplement their tax revenues with state-sponsored lotteries. Most of them do so with a game called lotto. Although there are various versions of this game, they are all basically as...
-
For the example in Simple Decision Problem.xlsx, are there any probabilities that make the EMV criterion equivalent to the maximin criterion? Are there any probabilities that make the EMV criterion...
-
1. Create a new project named: LastnameCCE103Lab Exam 1 2. Create a new java class named: LastnameCCE103Lab Exam1_Frame1 3. Refer to the Design based on the image below: MY ORDERS ITEM NAME PRICE...
-
Why is addressing information asymmetry important especially in the moments of crisis? Briefly explain what information asymmetry is and explain why it is important to address it especially amid an...
-
Explain the purpose of database Define what database is Define what database management system is Explain how database applications make databases more useful Describe how data models are used for...
Study smarter with the SolutionInn App