A financial analyst is examining the relationship between stock prices and earnings per share. She chooses...

Question

Question

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Correlation between x and y as considered as array 1 and array 2. so excel would be used to find correlation between x and y

- Bring data in to excel sheet.

- use excel formula in cell B18 , highlighted in the below image

0.864 is a correlation coefficient

Add a comment

Answer 2

Similar Homework Help Questions

A financial analyst is examining the relationship between stock prices and earnings per share. She chooses...

A financial analyst is examining the relationship between stock prices and earnings per share. She chooses fifteen publicly traded companies at random and records for each the company's current stock price and the company's earnings per share reported for the past 12 months. Her data are given below, with x denoting the earnings per share from the previous year, and y denoting the current stock price (both in dollars). Based o these data, she com putes the leastsquares rearessionline to...
A financial analyst is examining the relationship between stock prices and earnings per share. She chooses...

A financial analyst is examining the relationship between stock prices and earnings per share. She chooses fifteen, publicly traded companies at random and records for each the company's current stock price and the company's earnings per share reported for the past 12 months. Her data are given below, with X denoting the earnings per share from the previous year and y denoting the current stock price (both in dollars). A scatter plot of her data is shown in Figure 1....
Dividends per Share The following financial data is from Hi-Tech Instruments' financial statements (thousands of dollars,...

Dividends per Share The following financial data is from Hi-Tech Instruments' financial statements (thousands of dollars, except earnings per share.) 2016 Sales revenue Cost of goods sold Net income Dividends Earnings per share $210,000 125,000 8,800 3,100 4.40 Hi-Tech Instruments, Inc. Balance Sheet (Thousands of Dollars) Dec. 31, 2016 Dec. 31, 2015 Assets Cash $18,300 $18,000 Accounts receivable (net) 46,000 41,000 Inventory 39,500 43,700 Total current assets 103,800 102,700 Plant assets (net) 52,600 50,500 Other assets 15,600 13,800 Total assets...

14) (6 pts) ABC company current stock price is $50. The most recent Earnings per Share...

14) (6 pts) ABC company current stock price is $50. The most recent Earnings per Share reported was $3.00 (assume this EPS number was just reported yesterday). You expect the company's Earnings to increase by 10% next year and 6% the following year. In two years you are expecting the company's stock will trade at a P/E multiple of 22. Your required rate of return for ABC is 10%. If you expect the company to maintain a 30% dividend payout...
B is Earnings per share on common stock Current Position Analysis The following data were taken from...

B is Earnings per share on common stock Current Position Analysis The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Previous Year Year Current assets: Cash $535,000 $448,000 Marketable securities 619,500 504,000 Accounts and notes 253,50D 158,000 receivable (net) Inventories 887,000 590,700 Prepaid expenses 457,000 271,300 Total current assets $2,752,000 $2,072,000 Qument liabilities: Accounts and notes payable (short-term) Accrued liabilities Total currerit liabilities $371,200 268,800 $640,000 $392,000 169,000 $550,000...
The primary financial goal of a corporation is to maximize: shareholders wealth. earnings per share. stock...

The primary financial goal of a corporation is to maximize: shareholders wealth. earnings per share. stock price. Both a & c All of the above QUESTION 2 The ____ is the largest stock exchange in the world. American Stock Exchange Chicago Stock Exchange New York Stock Exchange Tokyo Stock Exchange QUESTION 3 You are considering the purchase of a 15-year $1,000 face value bond that would pay an coupon payment of $90 annually. If you required a return of 12%,...

Markus Company's common stock sold for $3.50 per share at the end of this year. The...

Markus Company's common stock sold for $3.50 per share at the end of this year. The company paid a common stock dividend of $0.63 per share this year. It also provided the following data excerpts from this year's financial statements Ending Beginning Balance Balance $ 35,000 $ 34,000 $ 70,000 55,000 $60,700 $ 70,000 $ 165,700 159,000 557000 $586,800 $ 67,500 $ 55,500 152,000 $ 136,800 $ 133,000 $ 133,000 $405,000 $450,000 Total liabilities and stockholders' equity $ 557,000 $586,800...
Barbara Bailey does not believe in analyst predictions. She feels that the company could maintain a...

Barbara Bailey does not believe in analyst predictions. She feels that the company could maintain a constant annual growth rate in dividends per share of 6% in the future or possibly 8% for the next two years and 6% thereafter. Bailey is basing her estimates on an established long-term investment plan into the Latin American, European and Canadian Markets. By venturing into these markets the risk of the firm will increase. The company estimates that the risk premium will increase...
GRUBHUB INC. Notes to Consolidated Financial Statements (Continued) 14. Earnings per Share Attributable to Common Stockholders...

GRUBHUB INC. Notes to Consolidated Financial Statements (Continued) 14. Earnings per Share Attributable to Common Stockholders Basic earnings per share is computed by dividing net income attributable to common stockholders by the weighted average number of common shares outstanding during the period without consideration for common stock equivalents. Diluted net income per share attributable to common stockholders is computed by dividing net income by the weighted average number of common shares outstanding during the period and potentially dilutive common stock...

I need answers 1-15 Markus Company's common stock sold for $2.75 per share at the end...

I need answers 1-15 Markus Company's common stock sold for $2.75 per share at the end of this year. The company paid a common stock dividend of $0.55 per share this year. It also provided the following data excerpts from this year's financial statements: Ending Beginning Balance Balance Cash $ 35,000 $ 30,000 Accounts receivable $ 60,000 $ 50,000 Inventory $ 55,000 $ 60,000 Current assets $ 150,000 $ 140,000 Total assets $ 450,000 $ 460,000 Current liabilities $ 60,000...

A financial analyst is examining the relationship between stock prices and earnings per share. She chooses...

Homework Answers