.

Required Question: Use XIRR function of xls for this purpose. Consider that an investor invested in IBM at the beginning of Aug 010.

Note: Please take data from the internet website( finbox,com/NYSE: IBM / -compare )

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 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