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)

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.

jeff jeffy answered 1 year ago

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...

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...

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 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...

Titanic Corporation has 10 million share outstanding, selling currently at a price of $50 per share....

Titanic Corporation has 10 million share outstanding, selling currently at a price of $50 per share. The company expects earnings per share next year to be $7.50. The company retains one-third of each year's earnings and reinvests these funds in projects with an expected return of 15% (thus, ROE is 15%) What Rate of return do the shareholders require? Suppose that, unexpectedly, the company announces plans to retain an additional $3 per share for the next ten years. These additional...

Question