The following table contains prices and dividends for a stock. All prices are after the dividend has been paid. If you bought the stock on January 1 and sold it on December 31, what is your realized return? Hint: Make sure to round all intermediate calculations to at least five decimal places. (Click on the following icon in order to copy its contents into a spreadsheet.) Jan 1 Price 9.76 Dividend Mar 31 10.76 0.16 Jun 30 10.26 0.16 Sep 30 10.86 0.16 Dec 31 10.76 0.16 Your realized return is %. (Round to one decimal place.)

Using the data in the table to the right, calculate the return for investing in the stock from January 1 to December 31. Prices are after the dividend has been paid (Click on the following icon in order to copy its contents into a spreadsheet.) Return for the entire period is 29 22 %. (Round to two decimal places.) Date Jan 1 Feb 5 May 14 Aug 13 Nov 12 Dec 31 Price $33.57 $29.72 $29.95 $30.94 $36.07 $40.72 Dividend $0.18 $0.21 $0.18 $0.22 SEZON

Using the data in the following table, E, calculate the return for investing in this stock from January 1 to December 31. Prices are after the dividend has been paid. The return for investing in this stock from January 1 to December 31 is ☐ %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Stock Price Dividend Jan 1 $49.96 Mar 31 $51.07 $0.59 Jun 30 $49.52 $0.58 Sep 30 $52.02 $0.77 Dec 31 $52.39 $0.77 Print Done - X

Using the data in the following table, calculate the return for investing in this stock from January 1 to December 31. Prices are after the dividend has been paid. 1% The return for investing in this stock from January 1 to December 31 is %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Stock Price Dividend Jan 1 $50 12 Mar 31 $51.08 $0.52 Jun 30 $49 48 $0.55 Sep 30 $52.02 $0.78 Dec 31 $52.46 $0.72 Print Done

You are given the following set of data: HISTORICAL RATES OF RETURN Year NYSE Stock X 1 - 26.5% - 22.0% 2 37.2 15.0 3 23.8 10.0 4 - 7.2 4.0 5 6.6 11.8 6 9 20.5 30.6 18.9 17.6 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet a. Use a spreadsheet (or a calculator with a linear regression function) to determine Stock X's beta coefficient. Do not round intermediate calculations. Round your answer to two decimal places. Beta = b. Determine the arithmetic average rates of return for Stock X and the NYSE over the period given. Calculate the standard deviations of returns for both Stock X and the NYSE. Do not round intermediate calculations. Round your answers to two decimal places. NYSE Stock X Average return,π Avg % % Standard deviation, σ % % c. Assume that the situation during Years 1 to 7 is expected to prevail in the future (i.e., x = TX, Average ↑ M = TM,…

Using the data in the following table, calculate the return for investing in the stock from January 1 to December 31. Prices are after the dividend has been paid. The realized return for the entire period is%. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Stock and Dividend Data Price $31.49 $29.52 $30.58 $31.41 $36.79 $43.08 Date Jan 1 Feb 5 May 14 Aug 13 Nov 12 Dec 31 Dividend $0.17 $0.22 $0.21 $0.21 - X

Consider the following information on the stock market in a small economy. Shares Company Outstanding Price, beginning of year Price, end of year 1 100 10 2 1,000 points 3 10,000 $ 100 $ 20 $ 3 $ 94 $ 25 $ 6 Help Save & Exit Submit eBook References Instructions: Enter your responses rounded to one decimal place. a. Compute a price-weighted stock price index for the beginning of the year and the end of the year. What is the percentage change? The percentage change is | %. b. Compute a value-weighted stock price index for the beginning of the year and the end of the year. What is the percentage change? (Note: The value of a firm is calculated by multiplying the number of its shares by the prices of those shares.) The percentage change is %.

Using the data in the following table, calculate the return for investing in the stock from January 1 to December 31. Prices are after the dividend has been paid The realized return for the entire period is% (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Stock and Dividend Data Price $32,74 $29.75 $29.19 $32.13 $36.55 $40 64 Date Jan 1 Feb 5 May 14 Aug 13 Nov 12 Dec 31 k Print Done Dividend $0.21 $0.21 $0.22 $0.18 - X

1. Stock WatcherMark Martin has created a basic stock watcher worksheet that he uses to report on gains or losses from when he purchased the stock and the last recorded date and price. Mark has given you a snapshot of his spreadsheet (see Figure T2.20) that you can use to re-create this spreadsheet for yourself. Here are some basic steps to follow:1. Create a new workbook.2 . Enter all the information provided in Figure T2.20 .  3. Apply the Currency format to the respective columns.4. The date should be entered as a function. Hint: Use the NOW function.5. Enter a formula for the Gain/Loss (%) column. Hint: You should subtract the Last columnfrom the Purchase column, and then divide by the Purchase column.6 . Format for percent in the Gain/Loss (%) column.

7. You invest $7,873 in stock and receive $102, $123, $121, and $155 in dividends over the following 4 years. At the end of the 4 years, you sell the stock for $11,900. What was the IRR on this investment? Review Only Click the icon to see the Worked Solution (Calculator Use). Click the icon to see the Worked Solution (Spreadsheet Use). The IRR on this investment is %. (Round to the nearest whole percent.)