Answered step by step
Verified Expert Solution
Question
1 Approved Answer
not incomplete please do it you can get data from internet XIBM Historical Annual Stock Price Data Year Stock Price History of IBM Year Year
not incomplete please do it
you can get data from internet
XIBM Historical Annual Stock Price Data Year Stock Price History of IBM Year Year Open High Low Year Year Close Year 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 Average Stock Price Average Stock Price 126.0849 136.9904 143.8556 157.658 150.5149 155.3519 182.3041 194.1488 196.591 170.9261 Year Year Open High 135.42 156.76 115.21 151.36 154.25 169.12 167.19 181.95 135.95 168.51 162.06 174.4 185.53 197.77 196.35 215.8 186.3 211 147.48 194.56 Year Low 94.77 112.91 107.57 139.7 117.85 131.75 151.41 172.8 179.16 147.05 Year Close 124.64 134.04 113.67 153.42 165.99 137.62 160.44 187.57 191.55 183.88 Annual % Change Annual % Change -7.01% 17.92% -25.91% -7.57% 20.61% -14.22% -14.46% -2.08% 4.17% 25.29% XDividend History of IBM Ex-Div. Date Amount Type Yield Deel. Date Rec. Date Pay. Date 8/10/2020 9/10/2020 8/7/2020 $1.63 Quarter 5.20% 7/28/2020 5/7/2020 2/7/2020 11/7/2019 8/8/2019 5/9/2019 2/7/2019 11/8/2018 8/9/2018 5/9/2018 2/8/2018 11/8/2017 8/8/2017 5/8/2017 2/8/2017 11/8/2016 8/8/2016 5/6/2016 2/8/2016 11/6/2015 8/6/2015 5/6/2015 2/6/2015 11/6/2014 8/6/2014 5/7/2014 2/6/2014 11/6/2013 8/7/2013 5/8/2013 2/6/2013 11/7/2012 8/8/2012 5/8/2012 2/8/2012 11/8/2011 8/8/2011 $1.63 $1.62 $1.62 S1.62 S1.62 $1.57 S1.57 S1.57 $1.57 $1.50 $1.50 $1.50 $1.50 S1.40 $1.40 $1.40 $1.40 S1.30 S1.30 $1.30 $1.30 S1.10 $1.10 S1.10 $1.10 S0.95 S0.95 $0.95 S0.95 S0.85 S0.85 S0.85 S0.85 S0.75 S0.75 S0.75 Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter 5.40% 4.20% 4.70% 4.60% 4.80% 4.70% 5.10% 4.30% 4.40% 4.10% 4% 4.20% 3.90% 3.20% 3.60% 3.50% 3.80% 4.10% 3.80% 3.30% 3.10% 2.80% 2.70% 2.40% 2.30% 2.20% 2.10% 2% 1.90% 1.70% 1.80% 1.70% 1.70% 1.60% 2.40% 2.40% 4/28/2020 1/28/2020 10/29/2019 7/30/2019 4/30/2019 1/29/2019 10/30/2018 7/31/2018 4/24/2018 1/30/2018 10/31/2017 7/25/2017 4/25/2017 1/31/2017 10/25/2016 7/26/2016 4/26/2016 1/26/2016 10/27/2015 7/28/2015 4/28/2015 1/27/2015 10/28/2014 7/29/2014 4/29/2014 1/28/2014 10/29/2013 7/30/2013 4/30/2013 1/29/2013 10/30/2012 7/31/2012 4/24/2012 1/31/2012 10/25/2011 7/26/2011 5/8/2020 6/10/2020 2/10/2020 3/10/2020 11/8/2019 12/10/2019 8/9/2019 9/10/2019 5/10/2019 6/10/2019 2/8/2019 3/9/2019 11/9/2018 12/10/2018 8/10/2018 9/10/2018 5/10/2018 6/9/2018 2/9/2018 3/10/2018 11/10/2017 12/9/2017 8/10/2017 9/9/2017 5/10/2017 6/10/2017 2/10/2017 3/10/2017 11/10/2016 12/10/2016 8/10/2016 9/10/2016 5/10/2016 6/10/2016 2/10/2016 3/10/2016 11/10/2015 12/10/2015 8/10/2015 9/10/2015 5/8/2015 6/10/2015 2/10/2015 3/10/2015 11/10/2014 12/10/2014 8/8/2014 9/10/2014 5/9/2014 6/10/2014 2/10/2014 3/10/2014 11/8/2013 12/10/2013 8/9/2013 9/10/2013 5/10/2013 6/10/2013 2/8/2013 3/9/2013 11/9/2012 12/10/2012 8/10/2012 9/10/2012 5/10/2012 6/9/2012 2/10/2012 3/10/2012 11/10/2011 12/10/2011 8/10/2011 9/10/2011 Required: Use XIRR function of xls for this purpose. Consider that an investor invested in Google at the beginning of Aug 2010. Data can be sourced from XIBM Historical Annual Stock Price Data Year Stock Price History of IBM Year Year Open High Low Year Year Close Year 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 Average Stock Price Average Stock Price 126.0849 136.9904 143.8556 157.658 150.5149 155.3519 182.3041 194.1488 196.591 170.9261 Year Year Open High 135.42 156.76 115.21 151.36 154.25 169.12 167.19 181.95 135.95 168.51 162.06 174.4 185.53 197.77 196.35 215.8 186.3 211 147.48 194.56 Year Low 94.77 112.91 107.57 139.7 117.85 131.75 151.41 172.8 179.16 147.05 Year Close 124.64 134.04 113.67 153.42 165.99 137.62 160.44 187.57 191.55 183.88 Annual % Change Annual % Change -7.01% 17.92% -25.91% -7.57% 20.61% -14.22% -14.46% -2.08% 4.17% 25.29% XDividend History of IBM Ex-Div. Date Amount Type Yield Deel. Date Rec. Date Pay. Date 8/10/2020 9/10/2020 8/7/2020 $1.63 Quarter 5.20% 7/28/2020 5/7/2020 2/7/2020 11/7/2019 8/8/2019 5/9/2019 2/7/2019 11/8/2018 8/9/2018 5/9/2018 2/8/2018 11/8/2017 8/8/2017 5/8/2017 2/8/2017 11/8/2016 8/8/2016 5/6/2016 2/8/2016 11/6/2015 8/6/2015 5/6/2015 2/6/2015 11/6/2014 8/6/2014 5/7/2014 2/6/2014 11/6/2013 8/7/2013 5/8/2013 2/6/2013 11/7/2012 8/8/2012 5/8/2012 2/8/2012 11/8/2011 8/8/2011 $1.63 $1.62 $1.62 S1.62 S1.62 $1.57 S1.57 S1.57 $1.57 $1.50 $1.50 $1.50 $1.50 S1.40 $1.40 $1.40 $1.40 S1.30 S1.30 $1.30 $1.30 S1.10 $1.10 S1.10 $1.10 S0.95 S0.95 $0.95 S0.95 S0.85 S0.85 S0.85 S0.85 S0.75 S0.75 S0.75 Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter 5.40% 4.20% 4.70% 4.60% 4.80% 4.70% 5.10% 4.30% 4.40% 4.10% 4% 4.20% 3.90% 3.20% 3.60% 3.50% 3.80% 4.10% 3.80% 3.30% 3.10% 2.80% 2.70% 2.40% 2.30% 2.20% 2.10% 2% 1.90% 1.70% 1.80% 1.70% 1.70% 1.60% 2.40% 2.40% 4/28/2020 1/28/2020 10/29/2019 7/30/2019 4/30/2019 1/29/2019 10/30/2018 7/31/2018 4/24/2018 1/30/2018 10/31/2017 7/25/2017 4/25/2017 1/31/2017 10/25/2016 7/26/2016 4/26/2016 1/26/2016 10/27/2015 7/28/2015 4/28/2015 1/27/2015 10/28/2014 7/29/2014 4/29/2014 1/28/2014 10/29/2013 7/30/2013 4/30/2013 1/29/2013 10/30/2012 7/31/2012 4/24/2012 1/31/2012 10/25/2011 7/26/2011 5/8/2020 6/10/2020 2/10/2020 3/10/2020 11/8/2019 12/10/2019 8/9/2019 9/10/2019 5/10/2019 6/10/2019 2/8/2019 3/9/2019 11/9/2018 12/10/2018 8/10/2018 9/10/2018 5/10/2018 6/9/2018 2/9/2018 3/10/2018 11/10/2017 12/9/2017 8/10/2017 9/9/2017 5/10/2017 6/10/2017 2/10/2017 3/10/2017 11/10/2016 12/10/2016 8/10/2016 9/10/2016 5/10/2016 6/10/2016 2/10/2016 3/10/2016 11/10/2015 12/10/2015 8/10/2015 9/10/2015 5/8/2015 6/10/2015 2/10/2015 3/10/2015 11/10/2014 12/10/2014 8/8/2014 9/10/2014 5/9/2014 6/10/2014 2/10/2014 3/10/2014 11/8/2013 12/10/2013 8/9/2013 9/10/2013 5/10/2013 6/10/2013 2/8/2013 3/9/2013 11/9/2012 12/10/2012 8/10/2012 9/10/2012 5/10/2012 6/9/2012 2/10/2012 3/10/2012 11/10/2011 12/10/2011 8/10/2011 9/10/2011 Required: Use XIRR function of xls for this purpose. Consider that an investor invested in Google at the beginning of Aug 2010. Data can be sourced fromStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started