93%C4) Sat 11:41 NE Lab #G - Various skills Home Review View Developer Tell me AutoSave ER OP Insert Draw Page Layout Formulas Data Calibri (Body A 3 BTU A General 1 Wrap Test 200 Merge & Center 29. Paste $ % ) WBO Conditional Format Formatting as Table Styles *821 Delete Forma Find Se A69 x fx 4) A sparkline creates a chart in one cell. Create a sparkline for dividends received. B D C Amor K Type F Declaration Date H Payment Date DIVIDEND RECEVED 1 TOTAL DIVIDEND 2 04 7/18/19 4000 4000 101 3 4 5 04 6 7 9/11 Cash 6/13/19 C 11419 Cash 11/29/A C 9/13/18 Cash 6/14/18 Cash 18 CM 11/30/17 Cash 417 Cash 01/13/17 Cash 3/13/17 Cash 11/29/16 Cash 9/13/16 C 6/13/16 Cash 3/11/16 Cash 11/27/15 Cash 9/11/15 C 6/11/15 Cash 8 9 10 G Record Date 9/10/13 6/14/19 3/15/19 11/30/18 16/18 1918 3/15/18 121/17 15/17 8/15/17 31517 13/16 0.39 0.39 0.39 0.37 0.37 0.37 0.37 0.35 0.35 0.36 0.35 0.30 0.30 0.33 4000 3900 3900 3900 3900 3700 3700 3700 3700 3500 3500 3500 3500 3300 3300 3300 11 12 4/25/19 221/19 10 NA TV1 1/2018 2/15/18 10/1917 7/21/17 4/2017 2/16/17 10/2016 7/21/16 420/10 2018 16 10-15 15 T15 4/30/15 4019 12/1018 TOUT 7/2/18 4/2/18 12/15/17 10/2/17 TIVIT 4/3/17 1215/16 10/3710 71/10 41/18 13 14 15 16 17 18 19 20 8/1555 315/16 12/1/15 /1915 115 12/15/15 10/1/15 7/1/15 Source - http://www.nasdaq.com/symbol/k/dividend history NNN 23 Above is the recent dividend history for Coca-Cola Company. Use the data to complete the questions below: 25 1) if you owned 10,000 shares of Coca-Cola stock since 4/1/2016, how much in dividends would you have collected? (Hint: Create a chart showing cash dividend per share, shares, total Leaming Objectives Fees & Credits Analysis + Select destination and press ENTER or choose Paste GANG MASSAGE 202009-2010-ON-2 - Your lab instructor is Trentin Carentz. carent.edu V 93%C4) Sat 11:41 NE Lab #G - Various skills Home Review View Developer Tell me AutoSave ER OP Insert Draw Page Layout Formulas Data Calibri (Body A 3 BTU A General 1 Wrap Test 200 Merge & Center 29. Paste $ % ) WBO Conditional Format Formatting as Table Styles *821 Delete Forma Find Se A69 x fx 4) A sparkline creates a chart in one cell. Create a sparkline for dividends received. B D C Amor K Type F Declaration Date H Payment Date DIVIDEND RECEVED 1 TOTAL DIVIDEND 2 04 7/18/19 4000 4000 101 3 4 5 04 6 7 9/11 Cash 6/13/19 C 11419 Cash 11/29/A C 9/13/18 Cash 6/14/18 Cash 18 CM 11/30/17 Cash 417 Cash 01/13/17 Cash 3/13/17 Cash 11/29/16 Cash 9/13/16 C 6/13/16 Cash 3/11/16 Cash 11/27/15 Cash 9/11/15 C 6/11/15 Cash 8 9 10 G Record Date 9/10/13 6/14/19 3/15/19 11/30/18 16/18 1918 3/15/18 121/17 15/17 8/15/17 31517 13/16 0.39 0.39 0.39 0.37 0.37 0.37 0.37 0.35 0.35 0.36 0.35 0.30 0.30 0.33 4000 3900 3900 3900 3900 3700 3700 3700 3700 3500 3500 3500 3500 3300 3300 3300 11 12 4/25/19 221/19 10 NA TV1 1/2018 2/15/18 10/1917 7/21/17 4/2017 2/16/17 10/2016 7/21/16 420/10 2018 16 10-15 15 T15 4/30/15 4019 12/1018 TOUT 7/2/18 4/2/18 12/15/17 10/2/17 TIVIT 4/3/17 1215/16 10/3710 71/10 41/18 13 14 15 16 17 18 19 20 8/1555 315/16 12/1/15 /1915 115 12/15/15 10/1/15 7/1/15 Source - http://www.nasdaq.com/symbol/k/dividend history NNN 23 Above is the recent dividend history for Coca-Cola Company. Use the data to complete the questions below: 25 1) if you owned 10,000 shares of Coca-Cola stock since 4/1/2016, how much in dividends would you have collected? (Hint: Create a chart showing cash dividend per share, shares, total Leaming Objectives Fees & Credits Analysis + Select destination and press ENTER or choose Paste GANG MASSAGE 202009-2010-ON-2 - Your lab instructor is Trentin Carentz. carent.edu V
