Question 1- Texas Instruments (TXN) (please include your Excel spreadsheet file!) Actual data for Texas Instruments common stock! Suppose on December 31, 2011 you purchased TXN stock at $29.11 per share. You hold TXN until December 31, 2021 when you sold it at $188.47 per share. During this holding period, you received the following annual dividends per share. Year Annual DPS Year Annual DPS 2012 $0.72 2017 $2.12 2013 $1.07 2018 $2.63 2014 $1.24 2019 $3.21 2015 $1.40 2020 $3.72 2016 $1.64 2021 $4.21 Using the above TXN stock data and using Excel spreadsheet, determine the average annual return for your TXN investment. Question 2 TXN stock price on December 31, 2020 was $162.70 per share. Calculate the 2021 annual "holding period return" (HPR). Show all work. Question 3 Using the table above, determine the average annual growth rate for TXN dividends per share for the period 2012-2021. Show formula, input, & calculation. Excel is optional.

Question 1- Texas Instruments (TXN) (please include your Excel spreadsheet file!) Actual data for Texas Instruments common stock! Suppose on December 31, 2011 you purchased TXN stock at $29.11 per share. You hold TXN until December 31, 2021 when you sold it at $188.47 per share. During this holding period, you received the following annual dividends per share. Year Annual DPS Year Annual DPS 2012 $0.72 2017 $2.12 2013 $1.07 2018 $2.63 2014 $1.24 2019 $3.21 2015 $1.40 2020 $3.72 2016 $1.64 2021 $4.21 Using the above TXN stock data and using Excel spreadsheet, determine the average annual return for your TXN investment. Question 2 TXN stock price on December 31, 2020 was $162.70 per share. Calculate the 2021 annual "holding period return" (HPR). Show all work. Question 3 Using the table above, determine the average annual growth rate for TXN dividends per share for the period 2012-2021. Show formula, input, & calculation. Excel is optional.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

XYZ stock price and dividend history are as follows: Dividend Paid at Year-End $5 Year 2018 2019 2020 2021 Beginning-of- Year Price $ 130 144 120 125 An investor buys six shares of XYZ at the beginning of 2018, buys another three shares at the beginning of 2019, sells one share at the beginning of 2020, and sells all eight remaining shares at the beginning of 2021. Required: a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Do not round intermediate calculations. Round your answers to 2 decimal places.) Arithmetic time-weighted average returns Geometric time-weighted average returns 5 5 5 Date b-1. Prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2018, to January 1, 2021. (Negative amounts should be indicated by a minus sign.) Cash Flow % %
Consider the following price and dividend data for Quicksilver Inc.: Dividend ($) Price ($) $14.4 $13.51 $9.14 $10.74 $8.02 $7.72 Date December 31, 2020 January 26, 2021 April 28, 2021 July 29, 2021 October 28, 2021 December 30, 2021 Assume that you purchased Quicksilver's stock at the closing price on December 31, 2020 and sold it after the dividend had been paid at the closing price on January 26, 2021. Your capital gains rate (yield) for this period is closest to A. 0.88% OB. -5.42% $0.11 $0.11 $0.11 $0.11 OC.-6.18% OD. 0.8% ...
Stocks A and B have the following historical returns: 2017 2018 2019 2020 Year Stock A's Returns, "A Stock B's Returns, r 2016 (23.80%) 22.50 (17.70%) 24.50 ITT 14.25 (2.25) 25.00 24.00 (9.70) 14.60 % a. Calculate the average rate of return for each stock during the period 2016 through 2020. Round your answers to two decimal places. Stock A: Stock B: % b. Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would the realized rate of return on the portfolio have been each year? Round your answers to two decimal places. Negative values should be Indicated by a minus sign. Year Portfolio 2016 % 2017 % 2018 % 2019 % 2020 % What would the average return on the portfolio have been during this period? Round your answer to two decimal places. % c. Calculate the standard deviation of returns for each stock and for the portfolio. Round your answers to two decimal places. Standard Deviation Stock A % Stock B % Portfolio % d. Calculate the coefficient of…
Current Attempt in Progress Sandhill Co. had net income for 2025 of $611000. The average number of shares outstanding for the period was 209000 shares. The average number of shares under outstanding options, at an option price of $31 per share, is 12600 shares. The average market price of the common stock during the year was $36. What should Sandhill report for diluted earnings per share for the year ended 2025? O $2.90 O $2.76 O$2.92 O $2.78
XYZ's stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End 2019 $ 155 2020 185 2021 145 2022 155 Arithmetic average rate of return Geometric average rate of return An investor buys three shares of XYZ at the beginning of 2019, buys another two shares at the beginning of 2020, sells one share at the beginning of 2021, and sells all four remaining shares at the beginning of 2022. $ 3 3 3 Required: a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Round your year-by-year rates of return and final answers to 2 decimal places. Do not round other calculations.) % % Dollar-weighted rate of return wwww 3 % b. What is the dollar-weighted rat of return? (Hint. Carefully prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2019, to January 1, 2022. If your calculator cannot calculate IRR, you will have to use trial and error or a spreadsheet…
Function: SUM; Formula: Add, Subtract, Multiply, Divide; Cell Referencing Using Excel to Determine Weighted Average Number of Shares Outstanding PROBLEM Sven Limited had common shares outstanding on January 1, 2023. On March 1, 2023, Sven issued additional shares in exchange for equipment. On July 1, Sven repurchased and cancelled shares. On October 1, 2023, Sven declared a 3- for-1 stock split. Common shares outstanding, January 1, 2020 Shares issued in exchange for equipment Shares cancelled Stock split 42,000 20,000 10,000 3-for-1 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use cell references with a mathematical formula to the Problem area and work area as indicated. Calculate the weighted average number of shares outstanding for Laurin for the year ended December 31, 2023. Event Beginning balance Issued shares Reacquired shares Dates Outstanding Jan. 1-Mar. 1 Mar. 1-July 1 July 1-Dec.31 Shares Outstanding 42,000 Weighted average number…
See Table 2.5 LOADING... showing financial statement data and stock price data for Mydeco Corp. Suppose Mydeco's costs and expenses had been the same fraction of revenues in 2016-2019 as they were in 2015. What would Mydeco's EPS have been each year in this case? Calculate the new EPS for 2016-2019 below: (Round dollar amounts and number of shares to one decimal place. Round percentage amount and the EPS to two decimal places.)
Return on Common Stock You buy a share of The Ludwig Corporation stock for $18.40. You expect it to pay dividends of $1.08, $1.1491, and $1.2226 in Years 1, 2, and 3, respectively, and you expect to sell it at a price of $22.16 at the end of 3 years. a. Calculate the growth rate in dividends. Round your answer to two decimal places. % b. Calculate the expected dividend yield. Round your answer to two decimal places. % c. Assuming that the calculated growth rate is expected to continue, you can add the dividend yield to the expected growth rate to obtain the expected total rate of return. What is this stock's expected total rate of return? (Assume the market is in equilibrium with the required return equal to the expected return.) Do not round intermediate calculations. Round your answer to two decimal places. %
XYZ's stock price and dividend history are as follows: Year Beginning-of-Year Price 2019 2020 2021 2022 $88 108 78 88 Dividend Paid at Year-End $4 An investor buys three shares of XYZ at the beginning of 2019, buys another two shares at the beginning of 2020, sells one share at the beginning of 2021, and sells all four remaining shares at the beginning of 2022 Arithmetic average rate of return Geometric average rate of return Required: a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Round your year-by-year rates of return and final answers to 2 decimal places. Do not round other calculations.) Dollar-weighted rate of return 4 4 4 % % b. What is the dollar-weighted rate of return? (Hint Carefully prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2019, to January 1, 2022. If your calculator cannot calculate IRR, you will have to use trial and error or a spreadsheet program.) (Round your…
XYZ stock price and dividend history are as follows: Beginning-of-Year Dividend Paid at Year 2018 2019 Price $ 140 159 132 137 2020 2021 Year-End $ 4 4 4 4 An investor buys five shares of XYZ at the beginning of 2018, buys another three shares at the beginning of 2019, sells one share at the beginning of 2020, and sells all seven remaining shares at the beginning of 2021. Required: a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Do not round intermediate calculations. Round your answers to 2 decimal places.) Arithmetic time-weighted average returns Geometric time-weighted average returns % % b-1. Prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2018, to January 1, 2021. (Negative amounts should be indicated by a minus sign.) Date Cash Flow 01/01/2018 01/01/2019 01/01/2020 01/01/2021
Question 8 At the end of 2020, Diego Corporation reported a $40,000 balance in its common share account (stated value $5 per share). The treasury share account showed $720 (cost $6 per share). No dividends were paid during the first two years. During 2020 the company declared and paid a cash dividend at $1.50 per share. Calculate the total amount of the 2020 cash dividend.
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 Portfolio Return Shares 450 300 Dollar return Percentage return 600 200 What is your portfolio dollar return and percentage return? Note: Round your answers to 2 decimal places. Beginning of Year Price $ 73.01 57.67 25.04 43.18 % Dividend Per Share $ 1.19 .43 .40 End of Year Price $85.97 53.61 24.49 39.02

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS