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.

Intermediate Accounting: Reporting And Analysis

3rd Edition

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Chapter16: Retained Earnings And Earnings Per Share

Section: Chapter Questions

Problem 3E

See similar textbooks

Similar questions

Required information [The following information applies to the questions displayed below] Financial information for Forever 18 includes the following selected data: ($ in millions) Net income 2023 Dividends on preferred stock Average shares outstanding Stock price Req 28 2024 2-a. Calculate the price-earnings ratio in 2023 and 2024. 2-b. In which year is the stock priced lower in relation to reported earnings? Complete this question by entering your answers in the tabs below. Req 2b Numerator/Denominator 2824 Amounts $172 Calculate the price-earnings ratio in 2023 and 2024. (Enter your price-eamings ratio values to two decimal places. Enter your answers in millions (l.e. 5,550,000 should be entered as 5.55).) Price-Earnings Ratio Req2a $24 400 $11.82 2023 Req 2b > $185 $19 508 $10.77
! Required information [The following information applies to the questions displayed below.] Financial information for Forever 18 includes the following selected data: ($ in millions) Net income Dividends on preferred stock Average shares outstanding Stock price 2024 $156 $23 300 $11.87 2-a. Calculate the price-earnings ratio in 2023 and 2024. 2-b. In which year is the stock priced lower in relation to reported earnings? 2023 $188 $18 400 $10.82
1. Spark has paid the following dividends during 2021-2022: Date 9 April 2021 1 October 2021 8 April 2022 7 October 2022 The price of Spark shares at the start of 2021, 2022, and 2023 are Date 5 January 2021 5 January 2022 4 January 2023 (a) What is the HPR for 2021? What is the HPR for 2022? Dividend 12.5c 12.5c 12.5c 12.5c Price 4.80 4.49 5.34
Listen You purchased stock in Magneto Vision for $13 per share on January 1, 2022. Over the next year you received $2.22 per share in dividends. On December 31,2022 Magneto Vision is selling for $12.50 per share. What has been your total gross return (in percent) over the one-year period? 13.23% 113.23% 1.13% 13.00%
es XYZ stock price and dividend history are as follows: Beginning-of-Year Dividend Paid at Year-End Price $100 110 $ 4 4 90 95 Year 2018 2019 2020 2021 An investor buys three shares of XYZ at the beginning of 2018, buys another two shares at the beginning of 2019, sells one share at the beginning of 2020, and sells all four 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 2018 2019 2020 2021 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 4 4 Cash Flow $ Rate of return (300) (208) 110 396 3.15 % 2.33 % b-2. What is the dollar-weighted rate of return? (Hint: If your calculator cannot…
XYZ stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End 2018 $ 110 $ 3 2019 113 3 2020 100 3 2021 105 3 An investor buys four shares of XYZ at the beginning of 2018, buys another two shares at the beginning of 2019, sells one share at the beginning of 2020, and sells all five 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.) 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.) b-2. What is the dollar-weighted rate of return? (Hint: If your calculator cannot calculate internal rate of return, you will have to use a spreadsheet or trial and error.) (Negative value should be indicated by a minus…
XYZ stock price and dividend history are as follows: Dividend Paid at Year-End 5.5 Year 2010 2019 2020 2021 Beginning-of- Year Price 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. $130 144 120 125 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 Sime-weighted average retums Geometric time-weighted average returns Date 01/01/2018 01/01/2019 01/01/2020 01/01/2021 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.) Fale of retur % % Cash Flow b-2. What is the dollar-weighted rate of return? (Hint: If your calculator cannot calculate…
Stock Name Burrfoot Enterprises Majere Brothers Incorporated Uth Matar Limited Dividend Payments Per Year $ $ $ Stock Name Price, 1/1/2022 Burrfoot Enterprises Majere Holdings Uth Matar Limited Quarterly Dividend $ 20.50 115.00 $ 95.00 $ (Use cells A2 to D8 from the given information to complete this question.) Required: Using the information in the tables above, please calculate the dividend yield, the capital gains yield, and the holding period return for each stock. Dividend Yield $ 1.50 $ 0.85 $ Price, 12/31/2022 23.75 135.00 85.00 Capital Gains Yield Holding Period Return
SW Company provides the Equity & Liability information below for analysis. SW Company had net income of $396,800 in 2023 and $335,800 in 2022. Equity and Liabilities. Share capital-common (121,500 shares issued) Retained earnings (Note 1) Accrued liabilities. Notes payable (current) Accounts payable. Total equity and liabilities 2023 2022 $1,431,000 $1,431,000 398,000 8,700 79,700 56,400 $1,973,800 268,900 6,100 59,200 182,500 $1,947,700 Note 1: Cash dividends were paid at the rate of $1 per share in 2022 and $2 per share in 2023.
K 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. Return for the entire period is%. (Round to two decimal places.) Date Jan 1 Feb 5 May 14 Aug 13 Nov 12 Dec 31 Price $32.07 $29.54 $31.52 $30.69 $31.38 $41.26 ACCOR Dividend $0.21 $0.21 $0.22 $0.19
XYZ stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End 2018 $ 130 $ 2 2019 153 2 2020 128 2 2021 133 2 An investor buys five shares of XYZ at the beginning of 2018, buys another two shares at the beginning of 2019, sells one share at the beginning of 2020, and sells all six 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.) 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.) b-2. What is the dollar-weighted rate of return? (Hint: If your calculator cannot calculate internal rate of return, you will have to use a spreadsheet or trial and error.) (Negative value should be indicated by a minus…
Problem 1. The stockholders' equity section of Kookie Co. revealed the following information on December 31, 2022. Preference stock, P50 par Share premium – preference Ordinary stock, P15 par Share premium – ordinary Subscribed ordinary stock Retained earnings 2,300,000 805,000 5,250,000 2,750,000 150,000 1,900,000 400,000 Subscriptions receivable – ordinary (collectible next month) Required: Answer the following questions with supporting computations: 1. How much is the legal capital? 2. How much is the total paid in capital? 3. What is the amount of the stockholders' equity on 12/31/2022? 4. How many preference shares were issued? 5. How many ordinary shares were subscribed?