Q1 What is the expected dividend in Year 5 for your companies, taking into account the growth of the dividends shown in column g - growth rate? Q2 What is the rate of return if companies pay dividends at zero growth rate? Q3 What are the dividend yield for your 5 companies? Q4 What are the capital gains yield for your 5 companies? Q5 What are the required returns on your stocks based on the dividend growth model? Q6 What will be the share prices of the selected companies in 3 years, taking into account the dividend growth model, if the required rate of return is 10%? Do not use the current price of the shares (P0) in the calculation. Q7 Compare selected companies, indicate the best investment options and explain your choice. Table 1 Company 1 Company 2 Company 3 Company 4 Company 5 Replace "Company 1, Company 2, Company 3, Company 4, Company 5" with the names of the selected companies.

6.96 SYMBOL NAME atvi Activision Blizzard, Inc. Common Stock adbe Adobe Inc. Common Stock amd Advanced Micro Devices, Inc. Common Stock alen Alexion Phamaceuticals, Inc Common Stock Align Technology, Inc. Common Stock BOOK Alphabet Inc. Class C Capital Stock googl Alphabet Inc. Class A Common Stock amen Amazon.com, Inc. Common Stock Amgen Inc. Common Stock ad Analog Devices, Inc. Common Stock anss ANSYS, Int. Common Stock aap! Adole Inc. Common Stock MARKET DO - just paid annual CAPITALIZATION PO - current price s-growth rate dividend 63,285,790,035 82.36 0.4% $ 216,607,228,628 $ 453.81 22% $ 38.53 196,765,754,285 $ 83.10 0.7% $ 7.33 122,520,024,003 $ 102.75 02%$ 8.00 24,386,054,122 $ 309.52 0.8% $ 27.32 1,032,474,794,657 $ 1,523.85 59% $ 127.78 1,081,291,309,932 $ 1,51987 36% $ 125.22 1,594,036,234,239 3,219.00 3.7%$ 294.11 142,329,444,263 243.01 14%$ 22.74 43,330,007,672 $ 11744 02% $ 9.66 27,226,072,254 31736 13%$ 29.56 1,960,078,894,620 S 457.41 1.0% 5 35.57 S $ amen $ 5 5 67.00 382.17 asml adp bidu bib min bang Applied Materials, Inc Common Stock 161.349, 123.875 ASML Holding N.V. New York Registry Shares 158,363,477,900 Autodesk Inc. Common Stock 52.388.02.02 Automatic Data Processing, Inc. Common Stock 60,048 958 452 Baidu, Inc. ADS 42.721.035.504 Biogen Inc. Common Stock 45.777 923, 274 BIOMarin Pharmaceutical Inc. Common Stock 121,669 463, 345 Booking Holdings in Common Rock 71,779,574,253 sroad.cominc Common Bock 132.149.147.552 Cadence Design Systems, Inc. Common Stock 30,533 518,850 CDW Corporation Common Rock 16.210 126,656 Cemer Corporation Common Stock 22.250.099.806 Charter Communications, Inc. Class A Common Stock N123 957 ESS 110 Check Point Software Technologies Ltd. Ordinary Share 1.7.337.243.377 Cintas Corporation Common Stock 33.222 147.862 139.55 125.80 287 35 119.49 2.750.00 5 5 5 s 5 5 S 5 5 5 5 $ 1.0% 3.75 20 0.55 0.1945 13S 115$ 2995 Os OSNS 0.19 $ 015 ZONS OS 1ANS 5.42 34.23 23.77 1187 9.78 21 18 10.09 17.08 2593 11 25 9.19 5.78 45.35 9.50 30.23 das CON 109 S2 113.62 72.86 504 97 123.66 32099 cher he $ cbus sh $ 5 CISCO Systems, Inc. Common Stock 177.716 447 142 Citrox Systems, Inc. Common Stock 17,057,295.903 cornizant Technology Solutions Corporation Class AC 85622 939715 Comcast Corporation Cass A Common Stock 198,849.419.727 Copart. Inc. De common stock 23.750.094.530 Costco Wholesale Corporation Common Stock 150,100,400,792 CSX Corporation Common Stock 57,371,290.550 Dexcom Inc. Common Stock 42.214,653910 DocuSign Inc. Common Stock 38.114 789.184 Dollar Tree Inc. Common Stock 23.929.631 383 eBay Inc. Common Stock 40,138,182.003 Electronic Arts Inc. Common Stock 140,561.512,567 Exelon Corporation Common Stock 36.387,975.439 Expedia Group, Inc. Common Stock 12.385.582 204 Facebook, Inc. Class A Common Stock 743.996.739 029 42 21 138.12 57 54 43.53 100.99 343 35 74.99 440.92 0.15$ 2.095 0.95 0.995 0.255 3.455 1.045 3.7% 5 3.50 11.09 5.01 4.09 7.91 30.86 6.74 51.03 cort 19.54 5 5 $ 5 s $ 5 5 4.99 ebay a 101.11 57.72 140.45 37.34 87.60 262.00 0.25$ 0.49 $ 1.695 1.6% 5 0.19 $ 0.895 11.61 2.40 6.91 us 5 21.80 $ 48.69 102 18 0.5% 2.495 sy ix Foxa ed dex im insy Fastenal Company Common Stock Fiserv, Inc. Common Stock Fox Corporation Class B Common Stock Fox Corporation Class A Common Stock Gilead Sciences, Inc. Common Stock IDEXX Laboratories, Inc. Common Stock illumina, Inc Common Stock incyte Corp. Common Stock lintel Corporation Common Stock Lintultinc Common Stock Intuitive Surgical Inc. Common Stock ID.com, Inc. American Depositary Shares KLA Corporation Common Stock Lam Research Corporation Common Stock 27 671,734,014 58.424,832, 198 15545.310337 25.457.596.741 86,895,040,136 32.694, 167292 51.702.980.000 21.318.786,806 208,099.290.000 50 320 180 433 81.215.960,720 104.163.381.287 33,677,612,614 S5092.079 480 5 5 s s 5 5 s s $ $ 5 S $ 25.56 69.41 384.39 354.13 97.48 0.7% 0.39 $ 1.395 1.995 2.8% 0.25 0.865 0.8% 4.35 10.58 195 1.86 5.81 35.74 34.90 10.41 d 306.01 694.00 68.42 216.63 379.08 27.11 57.99 5.91 22.45 35.45 2.4% 2.4 rex Room visk The Kraft Heinz Company common stock 149 927, 248,811 Trip.com Group Limited American Depositary Shares 16.777943058 Uita Beauty, Inc. Common Stock 12,618,328 201 vensgr, Inc. Common Stock 23 745,998.960 Ivensk Analytics, Inc. Common Stock 30,702.303,815 Vertex Pharmaceuticals incorporated Common Stock 71 326,374,743 Walgreens Boots Alliance, Inc. Common Stock 35 579,541 115 Westem Digital Corporation Common Stock 10.559.356,739 Workday, Inc. Class A Common Stock 43,531,400,000 xcel Energy Inc. Common Stock 36.879.029.741 linx, Inc. Common Stock 25 565016950 zoom Video Communications, Inc. Class A Common std 75,081,709,724 $ 5 $ 5 5 $ 5 5 5 s 5 5 36.02 28.29 224.08 206.75 189.07 274.00 40.98 35.60 185 24 70.20 105 10 271 30 0.15$ 0.9 0.695 0.395 2.0% 5 0.25 0.25 0.495 2.0% 5 0.8% O.SNIS 3.09.15 2.97 2.01 16.59 16.00 15.05 22.08 3.08 2.72 18.45 wa way 8.87 25.85 3 be 21.72 21.11 5 5 5 $ 5 5 354.87 95.72 2.2965 2.09 1.7 ONIS 0.595 1.26 1.26 34.14 7.37 5.89 mar mm 68.97 98.83 Liberty Global plc Class A Ordinary Shares Liberty Global plc Class C Ordinary Shares lululemon athletica Inc. Common Stock Mamott international Class A Common Stock Maxdm integrated Products, Inc. Common Stock Mercadolibre. Inc Common Stock Microchip Technology incompeted Common Stock Micron Technology, Inc. Common Stock Microsoft Corporation Common Stock Modema, Inc. Common Stock Mondelez international, Inc. Class A Common Stock Monster Beverage Corporation NetApp, Inc. Common Stock NetEase, Inc. American Depositary Shares Netflix, Inc. Common Stock INVIDIA Corporation Common Stock 12 893,965 013 12.531.541.686 45.206, 569413 31043, 438883 18.393, 227,758 59.146.384 155 26.093.388.590 SO 239,350.904 1.591.325,059,172 27,526,378,795 80,729.583.203 44.01.23.335 9.166 085,154 65,050, 518.294 212,723 298,931 303.490,200.000 1.193 24 103.35 45.12 210 14 69.50 56.52 83.45 41 31 474.57 483.75 500.00 s 5 5 5 5 $ S 5 5 3.235 0.15S 0.19 $ 0.395 0.795 0.25% 0.6 2.95 1.495 2.0% most ntap ntes 3.51 15.57 5.30 4.92 5.81 3.05 51.15 40.10 46.52 5 s orty Rear pep pcom LA NXP Semiconductors N.V. Common Stock O'Reilly Automotive, Inc. Common Stock PACCAR Inc. Common Stock Paychex, Inc. Common Stock PayPal Holdings, Inc. Common Stock PepsiCo, Inc. Common Stock QUALCOMM Incorporated Common Stock Regeneren Pharmaceuticals, Inc. Common Stock Ross Stores, Inc. Common Stock Seattle Genetics, Inc. Common Stock sinus XM Holdings Inc. Common Stock Skyworis Solutions, Inc. Common Stock Splunk Inc. Common Stock Starbucks Corporation Common Stock Synopsys, Inc. Common Stock T-Mobile us, Inc. Common Stock Take-Two Interactive Software, Inc. Common Stock Tesla, Inc. Common Stock Texas Instruments incorporated Common Stock 34.847 181,782 34 770.450.210 30,572.256.155 26,710 402 825 230,307,011.451 190 968 561 569 1.26 568,864,736 165.040.950.728 34570,566,076 28.156.133.048 25,020,036,775 24.402 301.950 30.979.446.225 92.292.550.000 30.189.407,025 1.46.970,911,582 20,033307 806 342,093,038,715 126,656,705, 760 5 $ S $ $ s $ 5 S 5 5 s 5 $ 5 5 S 124.80 469.46 88 51 74.45 197.00 138.81 112.98 520.73 97.13 161 82 6.01 146.41 195.00 79.10 200.21 115.37 175.21 1.908.49 1395 1395 0.45 Q2NS 0.795 0.9965 0.89S 0.89 1.395 2.995 2ons 0.395 14915 0.25 21905 125S 10%: 5 4.39 $ 0.195 15.50 43.47 6.75 6.10 16.47 11.99 9.84 5273 1034 1750 0.50 12.03 18 26 6.48 20.07 10.73 15 82 225.53 12.03 two SYMBOL atvi adbe land Jalan alan goog Igoogl aman amgn adi anss aap! amat Jasml adsk adp bidu bib bmen bang avgo cdns cdw cem chir chke ctas CSCO ctxs ctsh cmcsa cpnt cost CSX dxcm docu dit ebay lea lexc expe MARKET NAME CAPITALIZATION Activision Blizzard, Inc. Common Stock 63,285,790,035 Adobe Inc. Common Stock 216,607,228,628 Advanced Micro Devices, Inc. Common Stock 96 765,754,285 Alexion Pharmaceuticals, Inc. Common Stock 22 520 024.003 Align Technology, Inc. Common Stock 24 386,054,122 Alphabet Inc. Class C Capital Stock 1,032,474,794,657 Alphabet Inc. Class A Common Stock 1,031,291,309,932 Amazon.com, Inc. Common Stock 1,594,036,234,239 Amgen Inc, Common Stock 142,329,444,263 Analog Devices Inc, Common Stock 43,330,007,672 IANSYS, Inc. Common Stock 27 226,072 254 Apple Inc. Common Stock 1,960,078,894,620 Applied Materials, Inc. Common Stock 61.349,123.873 ASML Holding N.V. New York Registry Shares 158,363,477,900 Autodesk, Inc. Common Stock 52,388,015,602 Automatic Data Processing. Inc. Common Stock 60,048,968,462 Baidu, Inc. ADS 42,711,035,504 Biogen Inc. Common Stock 45.777 923 274 BioMarin Pharmaceutical Inc. Common Stock 21,669,463,346 Booking Holdings Inc. Common Stock 71,779,674 253 Broadcom Inc. Common Stock 132,849,842,681 Cadence Design Systems, Inc. Common Stock 30,533,518,880 CDW Corporation Common Stock 16,210,126,656 Cerner Corporation Common Stock 22,250,099,806 Charter Communications, Inc. Class A Common Stock 123,957,855,110 Check Point Software Technologies Ltd. Ordinary Share 17 337 143 377 Cintas Corporation Common Stock 33 222,147,862 Cisco Systems, Inc. Common Stock 177,716,447,142 Citrix Systems, Inc. Common Stock 17,057,296,903 Cognizant Technology Solutions Corporation Class A C36.622.939,715 Comcast Corporation Class A Common Stock 198,849,419,727 Copart, Inc. (DE) Common Stock 23,750,094,530 Costco Wholesale Corporation Common Stock 150,100,400,792 CSX Corporation Common Stock 57,371.290,650 Dexcom, Inc. Common Stock 42 214653,910 DocuSign, Inc. Common Stock 38,114,789.184 Dollar Tree Inc. Common Stock 23,929,631,583 eBay Inc. Common Stock 40,138,182,003 Electronic Arts Inc. Common Stock 40,561,512,667 Exelon Corporation Common Stock 36 387.975,439 Expedia Group, Inc. Common Stock 12,385,582,204 be 21.72 21.11 5 5 5 $ 5 5 354.87 95.72 2.2965 2.09 1.7 ONIS 0.595 1.26 1.26 34.14 7.37 5.89 mar mm 68.97 98.83 Liberty Global plc Class A Ordinary Shares Liberty Global plc Class C Ordinary Shares lululemon athletica Inc. Common Stock Mamott international Class A Common Stock Maxdm integrated Products, Inc. Common Stock Mercadolibre. Inc Common Stock Microchip Technology incompeted Common Stock Micron Technology, Inc. Common Stock Microsoft Corporation Common Stock Modema, Inc. Common Stock Mondelez international, Inc. Class A Common Stock Monster Beverage Corporation NetApp, Inc. Common Stock NetEase, Inc. American Depositary Shares Netflix, Inc. Common Stock INVIDIA Corporation Common Stock 12 893,965 013 12.531.541.686 45.206, 569413 31043, 438883 18.393, 227,758 59.146.384 155 26.093.388.590 SO 239,350.904 1.591.325,059,172 27,526,378,795 80,729.583.203 44.01.23.335 9.166 085,154 65,050, 518.294 212,723 298,931 303.490,200.000 1.193 24 103.35 45.12 210 14 69.50 56.52 83.45 41 31 474.57 483.75 500.00 s 5 5 5 5 $ S 5 5 3.235 0.15S 0.19 $ 0.395 0.795 0.25% 0.6 2.95 1.495 2.0% most ntap ntes 3.51 15.57 5.30 4.92 5.81 3.05 51.15 40.10 46.52 tmus ttwo tsla txn khc tcom ulta vrsn vrsk vrtx wba wdc wday xel xinx zm T-Mobile US, Inc. Common Stock 146,970,911,682 Take-Two Interactive Software, Inc. Common Stock 20,033,307,806 Tesla, Inc. Common Stock 342,093,038,715 Texas Instruments Incorporated Common Stock 126,656,705,760 The Kraft Heinz Company Common Stock 43,927,248,811 Trip.com Group Limited American Depositary Shares 16,777,943,058 Ulta Beauty, Inc. Common Stock 12,618,328,201 VeriSign, Inc. Common Stock 23,745,998,960 Verisk Analytics, Inc. Common Stock 30,702,303,815 Vertex Pharmaceuticals Incorporated Common Stock 71,326,374,743 Walgreens Boots Alliance, Inc. Common Stock 35,679,541,115 Western Digital Corporation Common Stock 10,669,356,739 Workday, Inc. Class A Common Stock 43,531,400,000 Xcel Energy Inc. Common Stock 36,879,029,741 Xilinx, Inc. Common Stock 25,565,016,960 Zoom Video Communications, Inc. Class A Common St 75,081,709,724 DO - just paid annual PO - current price g-growth rate dividend $ 82.36 0.4% $ 6.96 $ 453.81 2.2% $ 38.53 S 83.10 0.7% $ 7.33 $ 102.75 0.2% $ 8.00 $ 309.52 0.8% $ 27.32 $ 1,523.85 5.9% $ 127.78 $ 1,519.87 3.6% $ 125.22 $ 3,219.00 3.7% $ 294.11 $ 243.01 1.49 $ 22.74 $ 117.44 0.2% $ 9.66 $ 317.36 1.3% $ 29.56 $ 457.41 1.0% $ 35.57 $ 67.00 1.0% $ 5.42 $ 382.17 3.7% $ 34.23 $ 239.00 2.0% $ 23.77 $ 139.66 0.5% $ 11.87 $ 123.80 0.1% $ 9.78 $ 287.35 1.8%$ 21.18 $ 119.49 1.1% $ 10.89 $ 1,750.00 2.9%$ 137.08 $ 330.32 0.8%$ 28.93 $ 109.52 0.8% $ 11.26 $ 113.62 0.1% $ 9.19 $ 72.86 0.1% $ 5.78 $ 604.97 2.0% $ 48.38 $ 123.66 0.2% $ 9.60 $ 320.99 1.4% $ 30.23 $ 42.21 0.1% $ 3.50 S 138.12 2.0% $ 11.09 $ 67.54 0.9% $ 6.01 $ 43.53 0.9% $ 4.09 $ 100.99 0.2% $ 7.91 $ 343.35 3.4% $ 30.86 $ 74.99 1.0% $ 6.74 $ 440.92 3.7% $ 51.03 $ 210.50 2.8% $ 19.64 $ 101.11 0.2% $ 8.33 $ 57.72 0.4% $ 4.99 $ 140.45 1.6% $ 11.61 $ 37.34 1.6% $ 2.40 $ 87.60 0.1%$ 6.91 $ $ S $ $ $ $ $ $ $ S $ $ $ $ $ $ 262.00 48.69 102.18 25.71 25.56 69.41 384.39 354.13 97.48 49.08 308.01 694.00 68.42 216.63 379.08 21.72 21.11 354.87 95.72 68.97 1,193.24 103.36 45.12 210.14 69.50 56.52 83.45 41.31 474.57 483.75 500.00 124.80 469.46 88.61 74.45 197.00 138.81 112.98 620.73 97.13 161.82 6.01 146.41 195.00 79.10 200.21 0.8% $ 0.5% $ 2.4% $ 0.4% $ 0.7% $ 0.3% $ 1.3% $ 1.9% $ 2.8% $ 0.2% $ 0.8% $ 0.8% $ 1.4% $ 2.4% $ 2.4% $ 2.2% $ 2.0% $ 1.7% $ 0.3% $ 0.5% $ 3.4% $ 3.2% $ 0.1% $ 0.1% $ 0.3% $ 0.7% $ 0.2% $ 0.6% $ 2.9%) $ 1.4% $ 2.0% $ 1.3% $ 1.3% $ 0.4% $ 0.2% $ 0.7% $ 0.9% $ 0.8% $ 0.8% $ 3.3% $ 2.9%$ 2.0% $ 0.3% $ 1.4% $ 0.2% $ 2.1% $ 21.80 4.35 10.58 1.95 1.86 5.81 35.74 34.90 10.41 4.08 27.11 57.99 6.91 22.45 35.45 1.26 1.26 34.14 7.37 5.89 98.83 11.43 3.51 16.67 5.30 4.92 6.81 3.05 51.15 40.10 46.52 16.50 43.47 6.75 6.10 16.47 11.99 9.84 52.73 10.84 17.50 0.50 12.03 18.26 6.48 20.07 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 116.87 175.21 1,908.49 138.28 36.02 28.29 224.08 206.75 189.07 274.00 40.98 35.60 185.24 70.20 105.10 271.30 1.2%| $ 1.0%| $ 4.3%| $ 0.1% $ 0.1%| $ 0.9% $ 0.6%| $ 0.3%| $ 2.0%| $ 0.2%| $ 0.2% $ 0.4%| $ 2.0%| $ 0.8% $ 0.5%| $ 3.0%| $ 10.73 15.82 225.53 12.03 2.97 2.01 16.59 16.00 15.05 22.08 3.08 2.71 18.48 5.09 8.87 26.85 You should choose any 5 companies from sheet "Data" and answer the follo Q1 Q2 Q3 Q4 Q5 Q6 Q7 What is the expected dividend in Year 5 for your companies, taking into acco What is the rate of return if companies pay dividends at zero growth rate? What are the dividend yield for your 5 companies? What are the capital gains yield for your 5 companies? What are the required returns on your stocks based on the dividend growth What will be the share prices of the selected companies in 3 years, taking in Compare selected companies, indicate the best investment options and exp Table 1 Company 1 Company 2 Company 3 Company 4 Company 5 Q1 Q2 Q3 Q4 Q5 Q6 Q7 Notes: You should provide answers to 6 questions in Table 1. Write your answer to question 7 i 6.96 SYMBOL NAME atvi Activision Blizzard, Inc. Common Stock adbe Adobe Inc. Common Stock amd Advanced Micro Devices, Inc. Common Stock alen Alexion Phamaceuticals, Inc Common Stock Align Technology, Inc. Common Stock BOOK Alphabet Inc. Class C Capital Stock googl Alphabet Inc. Class A Common Stock amen Amazon.com, Inc. Common Stock Amgen Inc. Common Stock ad Analog Devices, Inc. Common Stock anss ANSYS, Int. Common Stock aap! Adole Inc. Common Stock MARKET DO - just paid annual CAPITALIZATION PO - current price s-growth rate dividend 63,285,790,035 82.36 0.4% $ 216,607,228,628 $ 453.81 22% $ 38.53 196,765,754,285 $ 83.10 0.7% $ 7.33 122,520,024,003 $ 102.75 02%$ 8.00 24,386,054,122 $ 309.52 0.8% $ 27.32 1,032,474,794,657 $ 1,523.85 59% $ 127.78 1,081,291,309,932 $ 1,51987 36% $ 125.22 1,594,036,234,239 3,219.00 3.7%$ 294.11 142,329,444,263 243.01 14%$ 22.74 43,330,007,672 $ 11744 02% $ 9.66 27,226,072,254 31736 13%$ 29.56 1,960,078,894,620 S 457.41 1.0% 5 35.57 S $ amen $ 5 5 67.00 382.17 asml adp bidu bib min bang Applied Materials, Inc Common Stock 161.349, 123.875 ASML Holding N.V. New York Registry Shares 158,363,477,900 Autodesk Inc. Common Stock 52.388.02.02 Automatic Data Processing, Inc. Common Stock 60,048 958 452 Baidu, Inc. ADS 42.721.035.504 Biogen Inc. Common Stock 45.777 923, 274 BIOMarin Pharmaceutical Inc. Common Stock 121,669 463, 345 Booking Holdings in Common Rock 71,779,574,253 sroad.cominc Common Bock 132.149.147.552 Cadence Design Systems, Inc. Common Stock 30,533 518,850 CDW Corporation Common Rock 16.210 126,656 Cemer Corporation Common Stock 22.250.099.806 Charter Communications, Inc. Class A Common Stock N123 957 ESS 110 Check Point Software Technologies Ltd. Ordinary Share 1.7.337.243.377 Cintas Corporation Common Stock 33.222 147.862 139.55 125.80 287 35 119.49 2.750.00 5 5 5 s 5 5 S 5 5 5 5 $ 1.0% 3.75 20 0.55 0.1945 13S 115$ 2995 Os OSNS 0.19 $ 015 ZONS OS 1ANS 5.42 34.23 23.77 1187 9.78 21 18 10.09 17.08 2593 11 25 9.19 5.78 45.35 9.50 30.23 das CON 109 S2 113.62 72.86 504 97 123.66 32099 cher he $ cbus sh $ 5 CISCO Systems, Inc. Common Stock 177.716 447 142 Citrox Systems, Inc. Common Stock 17,057,295.903 cornizant Technology Solutions Corporation Class AC 85622 939715 Comcast Corporation Cass A Common Stock 198,849.419.727 Copart. Inc. De common stock 23.750.094.530 Costco Wholesale Corporation Common Stock 150,100,400,792 CSX Corporation Common Stock 57,371,290.550 Dexcom Inc. Common Stock 42.214,653910 DocuSign Inc. Common Stock 38.114 789.184 Dollar Tree Inc. Common Stock 23.929.631 383 eBay Inc. Common Stock 40,138,182.003 Electronic Arts Inc. Common Stock 140,561.512,567 Exelon Corporation Common Stock 36.387,975.439 Expedia Group, Inc. Common Stock 12.385.582 204 Facebook, Inc. Class A Common Stock 743.996.739 029 42 21 138.12 57 54 43.53 100.99 343 35 74.99 440.92 0.15$ 2.095 0.95 0.995 0.255 3.455 1.045 3.7% 5 3.50 11.09 5.01 4.09 7.91 30.86 6.74 51.03 cort 19.54 5 5 $ 5 s $ 5 5 4.99 ebay a 101.11 57.72 140.45 37.34 87.60 262.00 0.25$ 0.49 $ 1.695 1.6% 5 0.19 $ 0.895 11.61 2.40 6.91 us 5 21.80 $ 48.69 102 18 0.5% 2.495 sy ix Foxa ed dex im insy Fastenal Company Common Stock Fiserv, Inc. Common Stock Fox Corporation Class B Common Stock Fox Corporation Class A Common Stock Gilead Sciences, Inc. Common Stock IDEXX Laboratories, Inc. Common Stock illumina, Inc Common Stock incyte Corp. Common Stock lintel Corporation Common Stock Lintultinc Common Stock Intuitive Surgical Inc. Common Stock ID.com, Inc. American Depositary Shares KLA Corporation Common Stock Lam Research Corporation Common Stock 27 671,734,014 58.424,832, 198 15545.310337 25.457.596.741 86,895,040,136 32.694, 167292 51.702.980.000 21.318.786,806 208,099.290.000 50 320 180 433 81.215.960,720 104.163.381.287 33,677,612,614 S5092.079 480 5 5 s s 5 5 s s $ $ 5 S $ 25.56 69.41 384.39 354.13 97.48 0.7% 0.39 $ 1.395 1.995 2.8% 0.25 0.865 0.8% 4.35 10.58 195 1.86 5.81 35.74 34.90 10.41 d 306.01 694.00 68.42 216.63 379.08 27.11 57.99 5.91 22.45 35.45 2.4% 2.4 rex Room visk The Kraft Heinz Company common stock 149 927, 248,811 Trip.com Group Limited American Depositary Shares 16.777943058 Uita Beauty, Inc. Common Stock 12,618,328 201 vensgr, Inc. Common Stock 23 745,998.960 Ivensk Analytics, Inc. Common Stock 30,702.303,815 Vertex Pharmaceuticals incorporated Common Stock 71 326,374,743 Walgreens Boots Alliance, Inc. Common Stock 35 579,541 115 Westem Digital Corporation Common Stock 10.559.356,739 Workday, Inc. Class A Common Stock 43,531,400,000 xcel Energy Inc. Common Stock 36.879.029.741 linx, Inc. Common Stock 25 565016950 zoom Video Communications, Inc. Class A Common std 75,081,709,724 $ 5 $ 5 5 $ 5 5 5 s 5 5 36.02 28.29 224.08 206.75 189.07 274.00 40.98 35.60 185 24 70.20 105 10 271 30 0.15$ 0.9 0.695 0.395 2.0% 5 0.25 0.25 0.495 2.0% 5 0.8% O.SNIS 3.09.15 2.97 2.01 16.59 16.00 15.05 22.08 3.08 2.72 18.45 wa way 8.87 25.85 3 be 21.72 21.11 5 5 5 $ 5 5 354.87 95.72 2.2965 2.09 1.7 ONIS 0.595 1.26 1.26 34.14 7.37 5.89 mar mm 68.97 98.83 Liberty Global plc Class A Ordinary Shares Liberty Global plc Class C Ordinary Shares lululemon athletica Inc. Common Stock Mamott international Class A Common Stock Maxdm integrated Products, Inc. Common Stock Mercadolibre. Inc Common Stock Microchip Technology incompeted Common Stock Micron Technology, Inc. Common Stock Microsoft Corporation Common Stock Modema, Inc. Common Stock Mondelez international, Inc. Class A Common Stock Monster Beverage Corporation NetApp, Inc. Common Stock NetEase, Inc. American Depositary Shares Netflix, Inc. Common Stock INVIDIA Corporation Common Stock 12 893,965 013 12.531.541.686 45.206, 569413 31043, 438883 18.393, 227,758 59.146.384 155 26.093.388.590 SO 239,350.904 1.591.325,059,172 27,526,378,795 80,729.583.203 44.01.23.335 9.166 085,154 65,050, 518.294 212,723 298,931 303.490,200.000 1.193 24 103.35 45.12 210 14 69.50 56.52 83.45 41 31 474.57 483.75 500.00 s 5 5 5 5 $ S 5 5 3.235 0.15S 0.19 $ 0.395 0.795 0.25% 0.6 2.95 1.495 2.0% most ntap ntes 3.51 15.57 5.30 4.92 5.81 3.05 51.15 40.10 46.52 5 s orty Rear pep pcom LA NXP Semiconductors N.V. Common Stock O'Reilly Automotive, Inc. Common Stock PACCAR Inc. Common Stock Paychex, Inc. Common Stock PayPal Holdings, Inc. Common Stock PepsiCo, Inc. Common Stock QUALCOMM Incorporated Common Stock Regeneren Pharmaceuticals, Inc. Common Stock Ross Stores, Inc. Common Stock Seattle Genetics, Inc. Common Stock sinus XM Holdings Inc. Common Stock Skyworis Solutions, Inc. Common Stock Splunk Inc. Common Stock Starbucks Corporation Common Stock Synopsys, Inc. Common Stock T-Mobile us, Inc. Common Stock Take-Two Interactive Software, Inc. Common Stock Tesla, Inc. Common Stock Texas Instruments incorporated Common Stock 34.847 181,782 34 770.450.210 30,572.256.155 26,710 402 825 230,307,011.451 190 968 561 569 1.26 568,864,736 165.040.950.728 34570,566,076 28.156.133.048 25,020,036,775 24.402 301.950 30.979.446.225 92.292.550.000 30.189.407,025 1.46.970,911,582 20,033307 806 342,093,038,715 126,656,705, 760 5 $ S $ $ s $ 5 S 5 5 s 5 $ 5 5 S 124.80 469.46 88 51 74.45 197.00 138.81 112.98 520.73 97.13 161 82 6.01 146.41 195.00 79.10 200.21 115.37 175.21 1.908.49 1395 1395 0.45 Q2NS 0.795 0.9965 0.89S 0.89 1.395 2.995 2ons 0.395 14915 0.25 21905 125S 10%: 5 4.39 $ 0.195 15.50 43.47 6.75 6.10 16.47 11.99 9.84 5273 1034 1750 0.50 12.03 18 26 6.48 20.07 10.73 15 82 225.53 12.03 two SYMBOL atvi adbe land Jalan alan goog Igoogl aman amgn adi anss aap! amat Jasml adsk adp bidu bib bmen bang avgo cdns cdw cem chir chke ctas CSCO ctxs ctsh cmcsa cpnt cost CSX dxcm docu dit ebay lea lexc expe MARKET NAME CAPITALIZATION Activision Blizzard, Inc. Common Stock 63,285,790,035 Adobe Inc. Common Stock 216,607,228,628 Advanced Micro Devices, Inc. Common Stock 96 765,754,285 Alexion Pharmaceuticals, Inc. Common Stock 22 520 024.003 Align Technology, Inc. Common Stock 24 386,054,122 Alphabet Inc. Class C Capital Stock 1,032,474,794,657 Alphabet Inc. Class A Common Stock 1,031,291,309,932 Amazon.com, Inc. Common Stock 1,594,036,234,239 Amgen Inc, Common Stock 142,329,444,263 Analog Devices Inc, Common Stock 43,330,007,672 IANSYS, Inc. Common Stock 27 226,072 254 Apple Inc. Common Stock 1,960,078,894,620 Applied Materials, Inc. Common Stock 61.349,123.873 ASML Holding N.V. New York Registry Shares 158,363,477,900 Autodesk, Inc. Common Stock 52,388,015,602 Automatic Data Processing. Inc. Common Stock 60,048,968,462 Baidu, Inc. ADS 42,711,035,504 Biogen Inc. Common Stock 45.777 923 274 BioMarin Pharmaceutical Inc. Common Stock 21,669,463,346 Booking Holdings Inc. Common Stock 71,779,674 253 Broadcom Inc. Common Stock 132,849,842,681 Cadence Design Systems, Inc. Common Stock 30,533,518,880 CDW Corporation Common Stock 16,210,126,656 Cerner Corporation Common Stock 22,250,099,806 Charter Communications, Inc. Class A Common Stock 123,957,855,110 Check Point Software Technologies Ltd. Ordinary Share 17 337 143 377 Cintas Corporation Common Stock 33 222,147,862 Cisco Systems, Inc. Common Stock 177,716,447,142 Citrix Systems, Inc. Common Stock 17,057,296,903 Cognizant Technology Solutions Corporation Class A C36.622.939,715 Comcast Corporation Class A Common Stock 198,849,419,727 Copart, Inc. (DE) Common Stock 23,750,094,530 Costco Wholesale Corporation Common Stock 150,100,400,792 CSX Corporation Common Stock 57,371.290,650 Dexcom, Inc. Common Stock 42 214653,910 DocuSign, Inc. Common Stock 38,114,789.184 Dollar Tree Inc. Common Stock 23,929,631,583 eBay Inc. Common Stock 40,138,182,003 Electronic Arts Inc. Common Stock 40,561,512,667 Exelon Corporation Common Stock 36 387.975,439 Expedia Group, Inc. Common Stock 12,385,582,204 be 21.72 21.11 5 5 5 $ 5 5 354.87 95.72 2.2965 2.09 1.7 ONIS 0.595 1.26 1.26 34.14 7.37 5.89 mar mm 68.97 98.83 Liberty Global plc Class A Ordinary Shares Liberty Global plc Class C Ordinary Shares lululemon athletica Inc. Common Stock Mamott international Class A Common Stock Maxdm integrated Products, Inc. Common Stock Mercadolibre. Inc Common Stock Microchip Technology incompeted Common Stock Micron Technology, Inc. Common Stock Microsoft Corporation Common Stock Modema, Inc. Common Stock Mondelez international, Inc. Class A Common Stock Monster Beverage Corporation NetApp, Inc. Common Stock NetEase, Inc. American Depositary Shares Netflix, Inc. Common Stock INVIDIA Corporation Common Stock 12 893,965 013 12.531.541.686 45.206, 569413 31043, 438883 18.393, 227,758 59.146.384 155 26.093.388.590 SO 239,350.904 1.591.325,059,172 27,526,378,795 80,729.583.203 44.01.23.335 9.166 085,154 65,050, 518.294 212,723 298,931 303.490,200.000 1.193 24 103.35 45.12 210 14 69.50 56.52 83.45 41 31 474.57 483.75 500.00 s 5 5 5 5 $ S 5 5 3.235 0.15S 0.19 $ 0.395 0.795 0.25% 0.6 2.95 1.495 2.0% most ntap ntes 3.51 15.57 5.30 4.92 5.81 3.05 51.15 40.10 46.52 tmus ttwo tsla txn khc tcom ulta vrsn vrsk vrtx wba wdc wday xel xinx zm T-Mobile US, Inc. Common Stock 146,970,911,682 Take-Two Interactive Software, Inc. Common Stock 20,033,307,806 Tesla, Inc. Common Stock 342,093,038,715 Texas Instruments Incorporated Common Stock 126,656,705,760 The Kraft Heinz Company Common Stock 43,927,248,811 Trip.com Group Limited American Depositary Shares 16,777,943,058 Ulta Beauty, Inc. Common Stock 12,618,328,201 VeriSign, Inc. Common Stock 23,745,998,960 Verisk Analytics, Inc. Common Stock 30,702,303,815 Vertex Pharmaceuticals Incorporated Common Stock 71,326,374,743 Walgreens Boots Alliance, Inc. Common Stock 35,679,541,115 Western Digital Corporation Common Stock 10,669,356,739 Workday, Inc. Class A Common Stock 43,531,400,000 Xcel Energy Inc. Common Stock 36,879,029,741 Xilinx, Inc. Common Stock 25,565,016,960 Zoom Video Communications, Inc. Class A Common St 75,081,709,724 DO - just paid annual PO - current price g-growth rate dividend $ 82.36 0.4% $ 6.96 $ 453.81 2.2% $ 38.53 S 83.10 0.7% $ 7.33 $ 102.75 0.2% $ 8.00 $ 309.52 0.8% $ 27.32 $ 1,523.85 5.9% $ 127.78 $ 1,519.87 3.6% $ 125.22 $ 3,219.00 3.7% $ 294.11 $ 243.01 1.49 $ 22.74 $ 117.44 0.2% $ 9.66 $ 317.36 1.3% $ 29.56 $ 457.41 1.0% $ 35.57 $ 67.00 1.0% $ 5.42 $ 382.17 3.7% $ 34.23 $ 239.00 2.0% $ 23.77 $ 139.66 0.5% $ 11.87 $ 123.80 0.1% $ 9.78 $ 287.35 1.8%$ 21.18 $ 119.49 1.1% $ 10.89 $ 1,750.00 2.9%$ 137.08 $ 330.32 0.8%$ 28.93 $ 109.52 0.8% $ 11.26 $ 113.62 0.1% $ 9.19 $ 72.86 0.1% $ 5.78 $ 604.97 2.0% $ 48.38 $ 123.66 0.2% $ 9.60 $ 320.99 1.4% $ 30.23 $ 42.21 0.1% $ 3.50 S 138.12 2.0% $ 11.09 $ 67.54 0.9% $ 6.01 $ 43.53 0.9% $ 4.09 $ 100.99 0.2% $ 7.91 $ 343.35 3.4% $ 30.86 $ 74.99 1.0% $ 6.74 $ 440.92 3.7% $ 51.03 $ 210.50 2.8% $ 19.64 $ 101.11 0.2% $ 8.33 $ 57.72 0.4% $ 4.99 $ 140.45 1.6% $ 11.61 $ 37.34 1.6% $ 2.40 $ 87.60 0.1%$ 6.91 $ $ S $ $ $ $ $ $ $ S $ $ $ $ $ $ 262.00 48.69 102.18 25.71 25.56 69.41 384.39 354.13 97.48 49.08 308.01 694.00 68.42 216.63 379.08 21.72 21.11 354.87 95.72 68.97 1,193.24 103.36 45.12 210.14 69.50 56.52 83.45 41.31 474.57 483.75 500.00 124.80 469.46 88.61 74.45 197.00 138.81 112.98 620.73 97.13 161.82 6.01 146.41 195.00 79.10 200.21 0.8% $ 0.5% $ 2.4% $ 0.4% $ 0.7% $ 0.3% $ 1.3% $ 1.9% $ 2.8% $ 0.2% $ 0.8% $ 0.8% $ 1.4% $ 2.4% $ 2.4% $ 2.2% $ 2.0% $ 1.7% $ 0.3% $ 0.5% $ 3.4% $ 3.2% $ 0.1% $ 0.1% $ 0.3% $ 0.7% $ 0.2% $ 0.6% $ 2.9%) $ 1.4% $ 2.0% $ 1.3% $ 1.3% $ 0.4% $ 0.2% $ 0.7% $ 0.9% $ 0.8% $ 0.8% $ 3.3% $ 2.9%$ 2.0% $ 0.3% $ 1.4% $ 0.2% $ 2.1% $ 21.80 4.35 10.58 1.95 1.86 5.81 35.74 34.90 10.41 4.08 27.11 57.99 6.91 22.45 35.45 1.26 1.26 34.14 7.37 5.89 98.83 11.43 3.51 16.67 5.30 4.92 6.81 3.05 51.15 40.10 46.52 16.50 43.47 6.75 6.10 16.47 11.99 9.84 52.73 10.84 17.50 0.50 12.03 18.26 6.48 20.07 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 116.87 175.21 1,908.49 138.28 36.02 28.29 224.08 206.75 189.07 274.00 40.98 35.60 185.24 70.20 105.10 271.30 1.2%| $ 1.0%| $ 4.3%| $ 0.1% $ 0.1%| $ 0.9% $ 0.6%| $ 0.3%| $ 2.0%| $ 0.2%| $ 0.2% $ 0.4%| $ 2.0%| $ 0.8% $ 0.5%| $ 3.0%| $ 10.73 15.82 225.53 12.03 2.97 2.01 16.59 16.00 15.05 22.08 3.08 2.71 18.48 5.09 8.87 26.85 You should choose any 5 companies from sheet "Data" and answer the follo Q1 Q2 Q3 Q4 Q5 Q6 Q7 What is the expected dividend in Year 5 for your companies, taking into acco What is the rate of return if companies pay dividends at zero growth rate? What are the dividend yield for your 5 companies? What are the capital gains yield for your 5 companies? What are the required returns on your stocks based on the dividend growth What will be the share prices of the selected companies in 3 years, taking in Compare selected companies, indicate the best investment options and exp Table 1 Company 1 Company 2 Company 3 Company 4 Company 5 Q1 Q2 Q3 Q4 Q5 Q6 Q7 Notes: You should provide answers to 6 questions in Table 1. Write your answer to question 7