Question

Hi could you please help with the equations, thank you!

Dividende 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. Date Jan 1 Feb 5 May 14 Aug 13 Nov 12 Dec 31 Price $32.09 $30.51 $29.87 $33.18 $36.49 $43.96 $0.18 $0.19 $0.21 $0.22 Return for the entire period is 26.78%. (Round to two decimal places.)

Answer 1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

L2T C D E Dividend Date 1-Jan 5-Feb 14-May 13-Aug 12-Nov 31-Dec Price $32.09 $30.51 $29.87 $33.18 $36.49 $43.96 $0.18 $0.19 $0.21 $0.22 Beginning Price Ending Price Total dividend received $32.09 $43.96 $0.80 Return for the entire period 39.48%

Cell reference -

D Date Price Dividend 0.18 0.19 43466 43501 43599 43690 43781 43830 32.09 30.51 29.87 33.18 36.49 43.96 0.21 0.22 Beginning Price Ending Price Total dividend received =C3 =C8 =SUM(D4:D7) Return for the entire period =((C11-C10)+C12)/C10

Hope this will help, please do comment if you need any further explanation. Your feedback would be highly appreciated.