In the cell , by using cell references to the given data, calculate the value of stock E. Stock E     Dividend expected next year  $              2.25 Dividend growth rate 8% Required return 20% Stock value

The following table shows your stock positions at the beginning of the year, the dividends that each stock paid during the year, and the stock prices at the end of the year. Company Johnson Controls Medtronic Direct TV Qualcomm Shares 450 300 600 200 Portfolio Return Dollar return Percentage return Beginning of Year Price $73.01 57.67 25.04 43.18 Dividend Per Share $1.19 0.43 % 0.40 What is your portfolio dollar return and percentage return? (Round your answers to 2 decimal places.) End of Year Price $85.97 53.61 24.49 39.02

what is your portfolio dollar return and percentage return?

In the cell, by using cell references to the given data, calculate the value of stock C. Stock C     Dividend expected next year  $              0.65 Dividend growth rate 10% Required return 14% Stock value

Vijay

naran

Use Excel for this question: A company announced that it will pay a $2.00 dividend, a $2.50 dividend, and a $3.70 dividend in years 1, 2, and 3, respectively. A year 3, the dividends are expected to grow at 6% every year. What is the price of this stock today, given an 7% rate of return? O $327.23 O $342.34 O $311.46 O $389.76

son.2

Retained earnings versus new common stock Using the data for a firm shown in the following table, calculate the cost of retained earnings and the cost of new common stock using the constant-growth valuation model. (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Projected dividend per price per share growth rate share next year Underpricing Flotation cost per share $2.00 Current market Dividend per share $1.75 $46.00 9% $2.30 a. The cost of retained earnings is %. (Round to two decimal places.) b. The cost of new common stock is %. (Round to two decimal places.)

Using the data in the following table, Date Jan 1 Feb 5 " Calculate the returns for each subperiod below: (Round to five decimal places. Enter dividend yield and capital gain yield as decimal numbers.) Capital Gain Yield Price 33.88 30.67 $ calculate the dividend yield and the capital gain yield from investing in the stock from January 1 to December 31. Dividend Dividend Yield 0.17 Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Stock and Dividend Data Price $33.88 $30.67 $29.49 $32.38 $39.07 $41.99 Date Jan 1 Feb 5 May 14 Aug 13 Nov 12 Dec 31 Print Done Dividend $0.17 $0.17 $0.17 $0.17 X