Question: 1) Using year 2018 data, what was the common dividends paid per share? 2)The price of the stock at the beginning of 2018 was $56.81

 1) Using year 2018 data, what was the common dividends paid per share? 2)The price of the stock at the beginning of 2018

was $56.81 and you sold the stock at $68.14 at the end

of the year. What is the dividend yield (use your answer from

1) Using year 2018 data, what was the common dividends paid per share?

2)The price of the stock at the beginning of 2018 was $56.81 and you sold the stock at $68.14 at the end of the year. What is the dividend yield (use your answer from 3a above), capital gain(loss), and total percentage return?

3)If the dividend calculated in 3a above is expected to grow by 2.5% for the next three years, and then grow by 1% in perpetuity afterwards, and the expected return on the stock is 8%, what is the value of the stock today?

Excel File Edit 8 Sat May 8 3:24 AM ... AutoSave OFF Home Insert Draw Share Comments View Insert Format Tools Data Window Help A evo ... Starbucks Corporation NasdaqGS SBUX Final_Student (2).xls - Compatibility Mode Page Layout Formulas Data Review View Tell me A"" == sy. Wao Text General vD A Merge & Center Conditional Format Cell Formatting as Table Styles Font Alignment Number Styles Arial V Y Y Insert v Delete Format Paste Z Sort & Filter Sensitivity Find & Select Analyze Data Analysis Cells Editing Sensitivity Clipboard 155 A C D E H 1 L M N P R S S Pod alled ges-27-2015 BP-228 USO ON-11-2017 090 8-80-2150 USD 050 1, 1864 18 1,331 1. 1,8114 2121 1844 22012 24S 2 21 LE 18132 83T8 Balance Bano Shast u od: 10. 14 15 CM 16 ASSETS 17 Cadresas 1& Selama 18 Touch & BT Istre 20 21 Ass Recent 22 Charlie 2. To Roots 38 20 y 26 DE 27 De last, Cur I , 28 Oterom 29 Toes Currt A an 710 11 2011 6810 7180 Rc 34 763 1.4685 1 1 2014 1371 2N 1 1 ZEY 1, -0 1 ** SIJA w 267 410T ma 1971.4 277 1971 13 5234 26 12. BI.! 129713 ', ''J7, 31 CISTA 32 Deprecor Nie Preparty. Pan FA 9,341.4 16. 48 115640 664 4.6716 W 16 WA ICS ,I 14943 17120 5103 6834 1 2835 188 10A 3814 1.808 4169 16 1 LIGA 1992 4414 164 3108 14 TRT 1,0402 87 4122 10 11.12 14.112 3842 7925 BHD 10M? T20 3290 35 Lino- 36 Castil 37 ans 38 Ders Tax fact. LT 30 cterne Tomek 40 Teden 41 42 LIABLITES 43 table 44 Red Bp 46 Senin 46 Carlo LI Ltd 47 Crnom Towe 48 Usuwa 49 citer crede ater 50 Tot Cum Lube 52 Tombol 53 CM 54 User Nare 55 Dr. Taxis. Nor CUT 56 ateran- 57 TL white be 58 Cara 80 Pedir f1 Rei Income Statement 3225 9624 1173 1624 43410 12 0 6 100 LIMI 5,552 3.002.T SH 4.ZET 2008 21:33 8.8620 BU02 14 21 LITS 93.5 163 SATZ rs 272 1.7 117 117 7313 142LE TUR E SEG 0.7 15 1.3 41. GA 411 1.3 41.1 1 1, AT 6 SRAE Balance Sheet Cash Flow Stock Prices + PU + 100% NA tv X 4 W 8 X Excel File Edit View Insert Format Tools Data Window Help 8 Sat May 8 3:31 AM AutoSave OFF A evo ... Starbucks Corporation NasdaqGS SBUX Final_Student (2).xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Y Arial AI Y == General $9, Wrao Text Paste A Marge & Centar 2 Insert v Delete Format Cells Conditional Format Cell Formatting as Table Styles Styles Z Sort & Filter Find & Select Sensitivity Analyze Data Analysis Font Alignment Number Editing Sensitivity Clipboard 153 ts A E H L L M NO P R S 13 Income Statement For the local Purad Ending 14 15 CM 16 zmantha 12 martha EP-01-2014 us Red 12 months Bes-29.2015 Iran USD Red Redes 12 months Oct-12-2016 1:50 Reched 12 mare 02-11-2017 USD B-6-20 Lisa 157473 12 001 29116 313150 CY 2011 11,6TA 1927 *** w 47 11, 48 13 4M2 15 B.8502 3,2541 T.31.3 1.1006 1.1407 1492 1200 1.7764 340.7 1,011,4 10114 SOS 423 2,172 20120 HALI 9632 2,990.0 3,191.1 1991 3.EE 3. 10.1 164.1 TO (a. 153 727 (1708 27 117.8 122.71 ITOLE 182.51 $123 8814 2012 GA 19 18 de Toe Run Cod Orasbou Carolt 24 / Solo Geral dawn Ep 26 RAD POP 26 DARILA 27 de Oxi Exchange Other Operating Fun Total Opening how 32 33 otapete 34 and new come 36 Neneral Ear 36 37 rooi rok 38 Crewychoware 39 te Nari bap 40 EBT Ed. Ursula 41 42 km 43 grade Cher sale 44 inimortofodil 46 Genel Chadet wel 46 Can Lisa 47 www. 48 cter Usul Bars 49 ERTL Late 50 51 POSTANTE B2 Earnings from Cont. Opa 53 Earrings of Dhard Ops 55 Candlen i Aamur Charge 56 NA HC to Corrent 57 5e New WIE 59 Nether KO Income Statement 2999 maa 1282 3,37 5 SUTI. 4196 195 4.8400 13.7 1163 SK HI 289 14.1 1, 12 '' 25 2012 161.) 3.91 81 4.8176 6760 41836 1322 2012: 1,07 2793.3 2,061.T 1.22 49180 2249 206.7 2793 2018.: 2.884.5 45160 21721 1191 2214 0.1 MA TURE Balance Sheet Cash Flow Stock Prices + PU + 100% 8 atv 4 W X Excel File Edit View Insert Format Tools Data Window Help Sat May 8 3:29 AM ... AutoSave OFF GO ... Starbucks Corporation NasdaqGS SBUX Final_Student (2).xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Y Arial Y General sy. Wao Text AP A Paste B T 7 Marge & Centar Insert v Delete Format Cells Z Sort & Filter Conditional Format Cell Formatting as Table Styles Styles Sensitivity Find & Select Analyze Data Analysis Font Alignment Number Editing Sensitivity Clipboard 155 x B D E F G H I 1 K L M N 856.2 273.5 903.3 190.9 10.7529 6846 1,575.4 520.4 1,100.8 415.9 1,496.2 1.719,6 5163 8854 403.3 1.0239 1.5392 4414 7954 3828 143666. 302.4 3,541.6 1,0422 134.7 4122 24 1564 533.7 1,199.7 - 614.2 894.3 730.6 894.3 7025 891.0 1.179.3 1,034.7 2266 272.0 7945 239.8 3,030.7 259.0 9838 838.8 3,640.1 399.9 358.4 11712 982.4 4,546.6 3499 286.5 1,8429 1.180.8 6,6842 1.032.1 4. 220.7 2.048.3 2347.5 3 185 3 35 Long-len Investments 36 Goodal 37 Other Intangibles 38 Datamed Tax Assets, LT 39 Other Long-Termsels 40 Total Assets 41 42 LIABILITIES 43 Accounts Payable 44 Acored Exp 45 short term Borrowings 46 Curr. Port of LT Debi 47 aircome Taxes Payable 48 uneared Reverus, ment 49 Other Current Liabilia 50 Total Current Liabilities 51 52 Long-Tam Debt 53 Capital 54 unnamed Raverus, Non-Current 55 Det. Tex Liability Non-Om. 56 aihe: Non-rent Liabile 57 Total Liabilities 58 59 Corrman Stock 60 Additional Paid in Capital 61 Retained Earings 62 Treasury Stock 83 Comprehenshe Inc. and Other 84 Total Common Equity 65 66 Minority interest 67 88 Total Eqully 69 70 Total Liabilities And Equity 71 72 Supplemental Items 73 Total Share out on a Shant Date 74 75 Stock Price 78 Income Statement Balance Sheet 9 0902 53.8 6.7787 2702 1.106.7 22,980.6 8.9 385.3 5,479.2 43.1 657.6 6,596.5 14.7 675.0 8.4213 83 744.6 8.908.6 0.7 39.4 5,200.C 15 41.1 5,974.8 15 41.1 5.949.8 14 41.1 6.5622 41.1 1,457-4 25.3 5,272.0 (199.4) 5.818.0 (108.4) 5.884.0 (155.6 5.450.1 (3303) 1,189.5 1.7 1.8 6.7 6.9 6.3 5.273.7 5.819.8 5.890.7 5.457.0 1,175.8 10 7629 12.4101 142126. 14 ARA 241 1,499.1 1,455.1 1,480.5 1.431.6 1.306.1 $93.03 $56.47 $43.54 $51.06 $55.50 Cash Flow Stock Prices + 120% HNY etv 4 W Excel File Edit View Insert Format Tools Data Window Help 8 Sat May 8 3:32 AM ... AutoSave OFF GO ... Starbucks Corporation NasdaqGS SBUX Final_Student (2).xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial V Y AI Insert v == Y General $9, Wrao Text Delete Paste B Z Sort & Filter T A Sensitivity = = = Marge & Centar Conditional Format Cell Formatting as Table Styles Styles Find & Select Format Cells Analyze Data Analysis Font Alignment Number Editing Sensitivity Clipboard D1 A B D H J M M N R 8 T 12 Cash Flow 12 months Sep-29-2014 USD 12 months SZT-2013 USD Hoiated 12 month Od-69.296 - USD Red 12 months G-2017 12 months Sep-1-2018 USD US 2 BER1 27TA 21 24T 1 Perthale Period Ending 14 16 Carry 18 17 Nutinere 12 Deprecat. 19 ATICI 20 Depreciation Amor, Talal 22 Les From 2. Onftan front 24 On Wennery LIBRE 20 Ben Carrer 27 Tex wetter 37 7434 21.7 STA AT TRATI 151 11191 1911 2011 311 TV1 161 34.2121 18.14 130 (70.21 120.8 2181 ET 111 177 777 (140 3513 (1151 1113 1414 100 2971 11 113 2120 IKEA 100 11 1142 PER 140 44 18 14.15 (2843 BE7E 29 Charente 30 Charoen netewe 31 Charonne 32 Cheroin 33 Chorea in ONE Cash front en CE 37 Chop 38 CIAM do 30 most in a waste & EAN ct 40 Nil. Dw. In NGOs 21 www. 42 Cash front het IRAI VAC 137.7 1 2d1.a 31-42.1 11, 2017 (AHTI 2.1.34 977. 11132 (1910 15124 (10141 (311 2013 9124 184 18.1) 29 1270 334 T7.71 11, TOLI IESIE 3495 7413 3941 5521 THEZ Di (910. 1400D 44 Salle de boud 2 LANTA Telul Dubitaued 47 Salem Daddad 42 Lyon D. 49 Total Debt Repaid 51 mm FOOTBk 53 54 Carmel |Telu ottai 192 THUL? 12, 12,101.5 15 15.8 21.5 1:15 12.21 11, all. 171111 ILITI 11.11 M140 (174111 1975 19.) 11ATH 2011 (232 57 DP 54 Uhrey . Cuahtron inancing PC 61 F 1 wharem 2 Met Clinch 63 2011 18 126 (33.31 PET Income Statement Balance Shoot Cash Flow Stock Prices + 94% HYY tv A W Excel File Edit 8 Sat May 8 3:24 AM ... AutoSave OFF Home Insert Draw Share Comments View Insert Format Tools Data Window Help A evo ... Starbucks Corporation NasdaqGS SBUX Final_Student (2).xls - Compatibility Mode Page Layout Formulas Data Review View Tell me A"" == sy. Wao Text General vD A Merge & Center Conditional Format Cell Formatting as Table Styles Font Alignment Number Styles Arial V Y Y Insert v Delete Format Paste Z Sort & Filter Sensitivity Find & Select Analyze Data Analysis Cells Editing Sensitivity Clipboard 155 A C D E H 1 L M N P R S S Pod alled ges-27-2015 BP-228 USO ON-11-2017 090 8-80-2150 USD 050 1, 1864 18 1,331 1. 1,8114 2121 1844 22012 24S 2 21 LE 18132 83T8 Balance Bano Shast u od: 10. 14 15 CM 16 ASSETS 17 Cadresas 1& Selama 18 Touch & BT Istre 20 21 Ass Recent 22 Charlie 2. To Roots 38 20 y 26 DE 27 De last, Cur I , 28 Oterom 29 Toes Currt A an 710 11 2011 6810 7180 Rc 34 763 1.4685 1 1 2014 1371 2N 1 1 ZEY 1, -0 1 ** SIJA w 267 410T ma 1971.4 277 1971 13 5234 26 12. BI.! 129713 ', ''J7, 31 CISTA 32 Deprecor Nie Preparty. Pan FA 9,341.4 16. 48 115640 664 4.6716 W 16 WA ICS ,I 14943 17120 5103 6834 1 2835 188 10A 3814 1.808 4169 16 1 LIGA 1992 4414 164 3108 14 TRT 1,0402 87 4122 10 11.12 14.112 3842 7925 BHD 10M? T20 3290 35 Lino- 36 Castil 37 ans 38 Ders Tax fact. LT 30 cterne Tomek 40 Teden 41 42 LIABLITES 43 table 44 Red Bp 46 Senin 46 Carlo LI Ltd 47 Crnom Towe 48 Usuwa 49 citer crede ater 50 Tot Cum Lube 52 Tombol 53 CM 54 User Nare 55 Dr. Taxis. Nor CUT 56 ateran- 57 TL white be 58 Cara 80 Pedir f1 Rei Income Statement 3225 9624 1173 1624 43410 12 0 6 100 LIMI 5,552 3.002.T SH 4.ZET 2008 21:33 8.8620 BU02 14 21 LITS 93.5 163 SATZ rs 272 1.7 117 117 7313 142LE TUR E SEG 0.7 15 1.3 41. GA 411 1.3 41.1 1 1, AT 6 SRAE Balance Sheet Cash Flow Stock Prices + PU + 100% NA tv X 4 W 8 X Excel File Edit View Insert Format Tools Data Window Help 8 Sat May 8 3:31 AM AutoSave OFF A evo ... Starbucks Corporation NasdaqGS SBUX Final_Student (2).xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Y Arial AI Y == General $9, Wrao Text Paste A Marge & Centar 2 Insert v Delete Format Cells Conditional Format Cell Formatting as Table Styles Styles Z Sort & Filter Find & Select Sensitivity Analyze Data Analysis Font Alignment Number Editing Sensitivity Clipboard 153 ts A E H L L M NO P R S 13 Income Statement For the local Purad Ending 14 15 CM 16 zmantha 12 martha EP-01-2014 us Red 12 months Bes-29.2015 Iran USD Red Redes 12 months Oct-12-2016 1:50 Reched 12 mare 02-11-2017 USD B-6-20 Lisa 157473 12 001 29116 313150 CY 2011 11,6TA 1927 *** w 47 11, 48 13 4M2 15 B.8502 3,2541 T.31.3 1.1006 1.1407 1492 1200 1.7764 340.7 1,011,4 10114 SOS 423 2,172 20120 HALI 9632 2,990.0 3,191.1 1991 3.EE 3. 10.1 164.1 TO (a. 153 727 (1708 27 117.8 122.71 ITOLE 182.51 $123 8814 2012 GA 19 18 de Toe Run Cod Orasbou Carolt 24 / Solo Geral dawn Ep 26 RAD POP 26 DARILA 27 de Oxi Exchange Other Operating Fun Total Opening how 32 33 otapete 34 and new come 36 Neneral Ear 36 37 rooi rok 38 Crewychoware 39 te Nari bap 40 EBT Ed. Ursula 41 42 km 43 grade Cher sale 44 inimortofodil 46 Genel Chadet wel 46 Can Lisa 47 www. 48 cter Usul Bars 49 ERTL Late 50 51 POSTANTE B2 Earnings from Cont. Opa 53 Earrings of Dhard Ops 55 Candlen i Aamur Charge 56 NA HC to Corrent 57 5e New WIE 59 Nether KO Income Statement 2999 maa 1282 3,37 5 SUTI. 4196 195 4.8400 13.7 1163 SK HI 289 14.1 1, 12 '' 25 2012 161.) 3.91 81 4.8176 6760 41836 1322 2012: 1,07 2793.3 2,061.T 1.22 49180 2249 206.7 2793 2018.: 2.884.5 45160 21721 1191 2214 0.1 MA TURE Balance Sheet Cash Flow Stock Prices + PU + 100% 8 atv 4 W X Excel File Edit View Insert Format Tools Data Window Help Sat May 8 3:29 AM ... AutoSave OFF GO ... Starbucks Corporation NasdaqGS SBUX Final_Student (2).xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Y Arial Y General sy. Wao Text AP A Paste B T 7 Marge & Centar Insert v Delete Format Cells Z Sort & Filter Conditional Format Cell Formatting as Table Styles Styles Sensitivity Find & Select Analyze Data Analysis Font Alignment Number Editing Sensitivity Clipboard 155 x B D E F G H I 1 K L M N 856.2 273.5 903.3 190.9 10.7529 6846 1,575.4 520.4 1,100.8 415.9 1,496.2 1.719,6 5163 8854 403.3 1.0239 1.5392 4414 7954 3828 143666. 302.4 3,541.6 1,0422 134.7 4122 24 1564 533.7 1,199.7 - 614.2 894.3 730.6 894.3 7025 891.0 1.179.3 1,034.7 2266 272.0 7945 239.8 3,030.7 259.0 9838 838.8 3,640.1 399.9 358.4 11712 982.4 4,546.6 3499 286.5 1,8429 1.180.8 6,6842 1.032.1 4. 220.7 2.048.3 2347.5 3 185 3 35 Long-len Investments 36 Goodal 37 Other Intangibles 38 Datamed Tax Assets, LT 39 Other Long-Termsels 40 Total Assets 41 42 LIABILITIES 43 Accounts Payable 44 Acored Exp 45 short term Borrowings 46 Curr. Port of LT Debi 47 aircome Taxes Payable 48 uneared Reverus, ment 49 Other Current Liabilia 50 Total Current Liabilities 51 52 Long-Tam Debt 53 Capital 54 unnamed Raverus, Non-Current 55 Det. Tex Liability Non-Om. 56 aihe: Non-rent Liabile 57 Total Liabilities 58 59 Corrman Stock 60 Additional Paid in Capital 61 Retained Earings 62 Treasury Stock 83 Comprehenshe Inc. and Other 84 Total Common Equity 65 66 Minority interest 67 88 Total Eqully 69 70 Total Liabilities And Equity 71 72 Supplemental Items 73 Total Share out on a Shant Date 74 75 Stock Price 78 Income Statement Balance Sheet 9 0902 53.8 6.7787 2702 1.106.7 22,980.6 8.9 385.3 5,479.2 43.1 657.6 6,596.5 14.7 675.0 8.4213 83 744.6 8.908.6 0.7 39.4 5,200.C 15 41.1 5,974.8 15 41.1 5.949.8 14 41.1 6.5622 41.1 1,457-4 25.3 5,272.0 (199.4) 5.818.0 (108.4) 5.884.0 (155.6 5.450.1 (3303) 1,189.5 1.7 1.8 6.7 6.9 6.3 5.273.7 5.819.8 5.890.7 5.457.0 1,175.8 10 7629 12.4101 142126. 14 ARA 241 1,499.1 1,455.1 1,480.5 1.431.6 1.306.1 $93.03 $56.47 $43.54 $51.06 $55.50 Cash Flow Stock Prices + 120% HNY etv 4 W Excel File Edit View Insert Format Tools Data Window Help 8 Sat May 8 3:32 AM ... AutoSave OFF GO ... Starbucks Corporation NasdaqGS SBUX Final_Student (2).xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial V Y AI Insert v == Y General $9, Wrao Text Delete Paste B Z Sort & Filter T A Sensitivity = = = Marge & Centar Conditional Format Cell Formatting as Table Styles Styles Find & Select Format Cells Analyze Data Analysis Font Alignment Number Editing Sensitivity Clipboard D1 A B D H J M M N R 8 T 12 Cash Flow 12 months Sep-29-2014 USD 12 months SZT-2013 USD Hoiated 12 month Od-69.296 - USD Red 12 months G-2017 12 months Sep-1-2018 USD US 2 BER1 27TA 21 24T 1 Perthale Period Ending 14 16 Carry 18 17 Nutinere 12 Deprecat. 19 ATICI 20 Depreciation Amor, Talal 22 Les From 2. Onftan front 24 On Wennery LIBRE 20 Ben Carrer 27 Tex wetter 37 7434 21.7 STA AT TRATI 151 11191 1911 2011 311 TV1 161 34.2121 18.14 130 (70.21 120.8 2181 ET 111 177 777 (140 3513 (1151 1113 1414 100 2971 11 113 2120 IKEA 100 11 1142 PER 140 44 18 14.15 (2843 BE7E 29 Charente 30 Charoen netewe 31 Charonne 32 Cheroin 33 Chorea in ONE Cash front en CE 37 Chop 38 CIAM do 30 most in a waste & EAN ct 40 Nil. Dw. In NGOs 21 www. 42 Cash front het IRAI VAC 137.7 1 2d1.a 31-42.1 11, 2017 (AHTI 2.1.34 977. 11132 (1910 15124 (10141 (311 2013 9124 184 18.1) 29 1270 334 T7.71 11, TOLI IESIE 3495 7413 3941 5521 THEZ Di (910. 1400D 44 Salle de boud 2 LANTA Telul Dubitaued 47 Salem Daddad 42 Lyon D. 49 Total Debt Repaid 51 mm FOOTBk 53 54 Carmel |Telu ottai 192 THUL? 12, 12,101.5 15 15.8 21.5 1:15 12.21 11, all. 171111 ILITI 11.11 M140 (174111 1975 19.) 11ATH 2011 (232 57 DP 54 Uhrey . Cuahtron inancing PC 61 F 1 wharem 2 Met Clinch 63 2011 18 126 (33.31 PET Income Statement Balance Shoot Cash Flow Stock Prices + 94% HYY tv A W

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!