Question

In: Finance

Collect the weekly share price data (adjusted close) of State street corporation and the price data...

Collect the weekly share price data (adjusted close) of State street corporation and the price data for the S&P500 market index for the period of one year. Calculate the weekly returns and graph the returns of the share prices and the index over the period (assume no dividends)

Solutions

Expert Solution

Share price of State Street corporation has risen from $58 to $65 during last week and the index has risen from 2931 to 3045 in the past week.

Weekly returns of state Street corporation has been around closer to 10% while the index has merely return close to 5% in the relevant duration.

The share comparatively shown an out performance with regard to the index because of a specific market event which was related to state Street corporation and it has seen its prices going up while the index has also been able to run on very high level of conviction on the upside because people are highly bullish on the economy after the event of coronavirus unfolded and they are buying in chunk, so, the index is showing very high rate of recovery and return.

The returns are highly reflective of the sentiments of the investor and the fundamentals of the company which has changed as well as the fundamental of index which is also sound because the American economy is back on the growth track as it is being protected by various economists.


Related Solutions

a) the question is how can i get the weekly share price?? Collect the weekly share...
a) the question is how can i get the weekly share price?? Collect the weekly share price data(adjusted close) of these companies: - Humana Inc (HUM) - Lennar Corporation Class A (LEN) And collect the price data for the S&P500 market index for the period of one year. Calculate the weekly returns and graph the returns of the share prices and the index over the period(assume no dividends). Interpret the graph. Hint: Download data from Yahoo. Finance and do calculations...
Listed below is the selling price for a share of PepsiCO Inc. at the close of...
Listed below is the selling price for a share of PepsiCO Inc. at the close of each year. Year             Price                            Year                Price 1990             12.9135                       2000                49.5625 1991             16.8250                       2001                48.6803 1992             20.6125                       2002                42.2211 1993             20.3024                       2003                46.6215 1994             18.3160                       2004                52.2019 1995             27.7538                       2005                59.8534 1996             29.0581                       2006                62.0002 1997             36.0155                       2007                77.5108 1998             40.6111                       2008                54.7719 1999             35.0230                       2009                60.8025 a. Plot the data. b. Use EXCEL’s Data Analysis add-in to determine the least squares trend equation. c. Discuss the regression...
The following data were taken from the adjusted trial balance of Kent Corporation. Kent Corporation Adjusted...
The following data were taken from the adjusted trial balance of Kent Corporation. Kent Corporation Adjusted Trial Balance Data December 31, 2009 Accounts Payable $12,000 Accounts Receivable 13,000 Accumulated Depreciation-Building 6,000 Accumulated Depreciation-Furniture & Fixtures 9,000 Building 60,000 Capital Stock 40,000 Cash 24,000 Copyrights 22,000 Dividends Declared 12,000 Furniture & Fixtures 15,000 Land 25,000 Note Payable (10%, due in 5 years) 40,000 Office Supplies 1,000 Prepaid Insurance 3,000 Retained Earnings (January 1, 2009) 23,000 Salaries Payable 2,000 Service Revenue 85,000...
Calculate the current price per share (P0) for Olson Corporation, given the following information. The data...
Calculate the current price per share (P0) for Olson Corporation, given the following information. The data all pertain to the year just ended.            Sales                                      = 100,000 units            Sales price per unit                      = $100.00            Variable cost per unit                     = $70.00            Fixed cost                                   = $100,000            Debt outstanding                         = $500,000            Interest rate on debt                  = 10 percent            Tax Rate                                    = 40 percent            Common stock shares                       outstanding                        = 100,000 shares            Beta                                              = 1.2            kRF                                            = 2 percent            kM                                                = 8 percent            Pay-out ratio                                = 30 percent            Growth rate in earnings                       and...
Obtain monthly adjusted close prices of Microsoft (symbol: MSFT) and Exxon Mobil Corporation (symbol: XOM) during...
Obtain monthly adjusted close prices of Microsoft (symbol: MSFT) and Exxon Mobil Corporation (symbol: XOM) during December 1989 – December 2019 from Yahoo Finance. Using Excel, compute monthly returns of each company during January 1990 – December 2019. Also, compute and report the arithmetic average and the standard deviation of each company’s returns. Compute and report the correlation coefficient between these two stock returns. Next, form a portfolio that combines Microsoft and Exxon Mobil Corporation with equal weight. Compute monthly...
The XYZ Data Corporation has assigned three perspective new apprentices to collect data on the corporation’s...
The XYZ Data Corporation has assigned three perspective new apprentices to collect data on the corporation’s current computer processing demands to determine which apprentice should be hired. The corporation knows that its data usage is modeled by a linear function, since each new client added has approximately the same computer processing requirement. Your supervisor at XYZ has assigned you the task of reviewing the data collected by the three apprentices to determine which apprentice collected the data accurately. Additionally, you...
The following is average weekly per pound price data for apple pears in the US (from...
The following is average weekly per pound price data for apple pears in the US (from usda.gov) starting May. Your employer wants you to determine forecasted average weekly price for all the weeks starting in May. Week of (2019 Calendar Year) Actual ($/lb) Naïve Previous Period ($/lb) Moving Average ($/lb) Weighted Moving Average ($/lb) Exponential Smoothing ($/lb) May 6 1.72 May 13 2.43 May 20 2.99 May 27 1.72 June 3 1.59 June 10 3.50 June 17 3.50 June 24...
If a corporation declares a 10% stock dividend, then the share price of the stock will...
If a corporation declares a 10% stock dividend, then the share price of the stock will most likely decline by about 9%. the share price of the stock will most likely increase by about 10%. the share price of the stock will most likely remain unchanged. each shareholder will get a 10% cash rebate off his or her next round lot purchase of the stock.
Given the weekly price and quantity (Q and P) data for Cool Stuff ice cream over...
Given the weekly price and quantity (Q and P) data for Cool Stuff ice cream over the past 12 weeks and the price of another ice-cream flavor (Po) as: Q 84 82 85 83 82 84 87 81 82 79 82 78 P 8.50 9.00 8.75 9.25 9.50 9.25 8.25 10.00 10.00 10.50 9.50 10.25 Po 5.25 6.00 6.00 6.50 6.25 6.25 5.25 7.00 7.25 7.25 6.75 7.25 a. Use excel regression to estimate the weekly demand for Cool Stuff...
Given the information below for Seger Corporation, compute theexpected share price at the end of...
Given the information below for Seger Corporation, compute the expected share price at the end of 2020 using price ratio analysis. Assume that the historical (arithmetic) average growth rates will remain the same for 2020. (Do not round intermediate calculations. Round your answers to 2 decimal places.)Year201420152016201720182019Price$78.90$84.80$83.50$81.00$102.50$117.90EPS4.395.105.906.607.158.15CFPS7.428.368.8010.2711.8913.16SPS61.5066.5065.9069.4080.6088.60Share PriceUsing PE ratioUsing P/CF ratioUsing P/S ratio
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT