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