Question: Using information from Yahoo! Finance, calculate the return on Apple stock between each dividend and for the 2018 calendar year assuming all dividends are reinvested.Use
Using information from Yahoo! Finance, calculate the return on Apple stock between each dividend and for the 2018 calendar year assuming all dividends are reinvested.Use the close price for prices since including dividends in your calculations. Work in excel. Stock price for 2018: 208.43 (Check figure: -.054)
Date Open High Low Close Adj Close** Volume Dec 01, 2018 184.46 184.94 146.59 157.74 156.46 898,922,500 Nov 08, 2018 0.73 Dividend Nov 01, 2018 219.05 222.36 170.26 178.58 176.52 961,326,400 Oct 01, 2018 227.95 233.47 206.09 218.86 216.33 789,748,500 Sep 01, 2018 228.41 229.67 215.30 225.74 223.14 678,972,000 Aug 10, 2018 0.73 Dividend Aug 01, 2018 199.13 228.87 197.31 227.63 224.22 700,318,900 Jul 01, 2018 183.82 195.96 183.42 190.29 187.44 393,691,400 Jun 01, 2018 187.99 194.20 180.73 185.11 182.33 527,624,500 May 11, 2018 0.73 Dividend May 01, 2018 166.41 190.37 165.27 186.87 183.36 620,976,300 Apr 01, 2018 166.64 178.94 160.63 165.26 162.16 666,154,300 Mar 01, 2018 178.54 183.50 164.94 167.78 164.63 713,727,700 Feb 09, 2018 0.63 Dividend Feb 01, 2018 167.17 180.62 150.24 178.12 174.07 927,894,300 Jan 01, 2018 170.16 180.10 164.70 167.43 163.62 659,679 400 "Close price adiusted for splits. **Adiusted close price adiusted for both dividends and splits. Date Open High Low Close Adj Close** Volume Dec 01, 2018 184.46 184.94 146.59 157.74 156.46 898,922,500 Nov 08, 2018 0.73 Dividend Nov 01, 2018 219.05 222.36 170.26 178.58 176.52 961,326,400 Oct 01, 2018 227.95 233.47 206.09 218.86 216.33 789,748,500 Sep 01, 2018 228.41 229.67 215.30 225.74 223.14 678,972,000 Aug 10, 2018 0.73 Dividend Aug 01, 2018 199.13 228.87 197.31 227.63 224.22 700,318,900 Jul 01, 2018 183.82 195.96 183.42 190.29 187.44 393,691,400 Jun 01, 2018 187.99 194.20 180.73 185.11 182.33 527,624,500 May 11, 2018 0.73 Dividend May 01, 2018 166.41 190.37 165.27 186.87 183.36 620,976,300 Apr 01, 2018 166.64 178.94 160.63 165.26 162.16 666,154,300 Mar 01, 2018 178.54 183.50 164.94 167.78 164.63 713,727,700 Feb 09, 2018 0.63 Dividend Feb 01, 2018 167.17 180.62 150.24 178.12 174.07 927,894,300 Jan 01, 2018 170.16 180.10 164.70 167.43 163.62 659,679 400 "Close price adiusted for splits. **Adiusted close price adiusted for both dividends and splits
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
