Data Assignment 2 FIN204 CH7 (6 marks) Student NAME Student ID According to the list of students on the DATE sheet, you should select five companies according to the numbers next to your name, and answer the following 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 What is the rate of return of companies pay dividends at zero growth rate What are the dividend yield for your 5 companies What are the capital gains yield for your companies What are the required returns on your stocks based on the dividend growth model 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 no Compare selected companies, indicate the best investment options and explain your choice 101 102 103 104 los 06 Replace Company Company 2 Company 3 Company 4 Companys with the names of the Do not delete or transfer anything on this page Give the file your name should provide answers to 6 questions in Table 1 Write your answer to question in the specified line Q7 Font Paste Format Painter ctsh Clipboard fi X B33 42 21 138 12 67 54 43 53 100 99 343 35 74 99 440 92 210 50 101 11 57,22 140 45 4A B 31 28 CSCO 32 29 ctxs 33 30 cth 34 31 cmc 35 32 pm 36 33 cost $ $ $ $ $ S $ $ S $ $ S Cisco Systems, Inc Common Stock 177,716,447, 142 Citrix Systems, Inc Common Stock 17,057 296 903 Cognizant Technology Solutions Corporation Class A CC36,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,732 CSX Corporation Common Stock 57,371,290,650 Dexcoinc Common Stock 42,214,653,910 I fommon Stock 38,114,789,184 23,929,631 583 40,138,182,003 in 1 512,667 0 132S 2 200 s 1 001 1 001 $ 0 187 $ 3 729 1 100 $ 4 081 3 080$ 0 25455 0 407 1 716 1 716 $ 0 110 0 924 7 22 4 91 9 49 37 03 8 09 61 24 23 57 9 99 5 99 13 93 2 88 8 29 26 16 5 21 37 34 ws $ 87 60 Task Data Q1 102 103 104 los 06 107 Assignment 2 FIN204 CH7 (6 marks) Student NAME Student ID According to the list of students on the DATE sheet, you should select five companies according to the numbers next to your name, and answer the following 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 What is the rate of return it 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 model 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 Compare selected companies, indicate the best investment options and explain your choice 02 103 104 los 106 Table 1 101 Company 1 Company 2 Company Company 4 Companys Replace Company I Company 2 Company 3 Company 4 Company 5 with the names of the Do not delete or transfer anything on this page Give the file your name 107 Notes You should provide answers to 6 questions in Table 1 Write your answer to question in the specified line 07 Data Assignment 2 FIN204 CH7 (6 marks) Student NAME Student ID According to the list of students on the DATE sheet, you should select five companies according to the numbers next to your name, and answer the following 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 What is the rate of return of companies pay dividends at zero growth rate What are the dividend yield for your 5 companies What are the capital gains yield for your companies What are the required returns on your stocks based on the dividend growth model 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 no Compare selected companies, indicate the best investment options and explain your choice 101 102 103 104 los 06 Replace Company Company 2 Company 3 Company 4 Companys with the names of the Do not delete or transfer anything on this page Give the file your name should provide answers to 6 questions in Table 1 Write your answer to question in the specified line Q7 Font Paste Format Painter ctsh Clipboard fi X B33 42 21 138 12 67 54 43 53 100 99 343 35 74 99 440 92 210 50 101 11 57,22 140 45 4A B 31 28 CSCO 32 29 ctxs 33 30 cth 34 31 cmc 35 32 pm 36 33 cost $ $ $ $ $ S $ $ S $ $ S Cisco Systems, Inc Common Stock 177,716,447, 142 Citrix Systems, Inc Common Stock 17,057 296 903 Cognizant Technology Solutions Corporation Class A CC36,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,732 CSX Corporation Common Stock 57,371,290,650 Dexcoinc Common Stock 42,214,653,910 I fommon Stock 38,114,789,184 23,929,631 583 40,138,182,003 in 1 512,667 0 132S 2 200 s 1 001 1 001 $ 0 187 $ 3 729 1 100 $ 4 081 3 080$ 0 25455 0 407 1 716 1 716 $ 0 110 0 924 7 22 4 91 9 49 37 03 8 09 61 24 23 57 9 99 5 99 13 93 2 88 8 29 26 16 5 21 37 34 ws $ 87 60 Task Data Q1 102 103 104 los 06 107 Assignment 2 FIN204 CH7 (6 marks) Student NAME Student ID According to the list of students on the DATE sheet, you should select five companies according to the numbers next to your name, and answer the following 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 What is the rate of return it 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 model 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 Compare selected companies, indicate the best investment options and explain your choice 02 103 104 los 106 Table 1 101 Company 1 Company 2 Company Company 4 Companys Replace Company I Company 2 Company 3 Company 4 Company 5 with the names of the Do not delete or transfer anything on this page Give the file your name 107 Notes You should provide answers to 6 questions in Table 1 Write your answer to question in the specified line 07

Question

Data Assignment 2 FIN204 CH7 (6 marks) Student NAME Student ID According to the list of students on the DATE sheet, you should select five companies according to the numbers next to your name, and answer the following 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  What is the rate of return of companies pay dividends at zero growth rate  What are the dividend yield for your 5 companies  What are the capital gains yield for your companies  What are the required returns on your stocks based on the dividend growth model  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 no Compare selected companies, indicate the best investment options and explain your choice  101 102 103 104 los 06 Replace  Company Company 2  Company 3  Company 4  Companys  with the names of the Do not delete or transfer anything on this page  Give the file your name  should provide answers to 6 questions in Table 1  Write your answer to question in the specified line Q7  Font Paste Format Painter ctsh Clipboard fi X B33 42 21 138 12 67 54 43 53 100 99 343 35 74 99 440 92 210 50 101 11 57,22 140 45 4A B 31 28 CSCO 32 29 ctxs 33 30 cth 34 31 cmc 35 32 pm 36 33 cost $ $ $ $ $ S $ $ S $ $ S Cisco Systems, Inc  Common Stock 177,716,447, 142 Citrix Systems, Inc  Common Stock 17,057 296 903 Cognizant Technology Solutions Corporation Class A CC36,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,732 CSX Corporation Common Stock 57,371,290,650 Dexcoinc  Common Stock 42,214,653,910 I fommon Stock 38,114,789,184 23,929,631 583 40,138,182,003 in 1 512,667 0 132S 2 200  s 1 001  1 001  $ 0 187 $ 3 729  1 100 $ 4 081  3 080$ 0 25455 0 407  1 716  1 716 $ 0 110 0 924  7 22 4 91 9 49 37 03 8 09 61 24 23 57 9 99 5 99 13 93 2 88 8 29 26 16 5 21 37 34 ws $ 87 60 Task Data Q1 102 103 104 los 06 107 Assignment 2 FIN204 CH7 (6 marks) Student NAME Student ID According to the list of students on the DATE sheet, you should select five companies according to the numbers next to your name, and answer the following 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  What is the rate of return it 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 model  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 Compare selected companies, indicate the best investment options and explain your choice  02 103 104 los 106 Table 1 101 Company 1 Company 2 Company Company 4 Companys Replace  Company I  Company 2  Company 3  Company 4  Company 5  with the names of the Do not delete or transfer anything on this page  Give the file your name  107 Notes  You should provide answers to 6 questions in Table 1  Write your answer to question in the specified line 07  Data Assignment 2 FIN204 CH7 (6 marks) Student NAME Student ID According to the list of students on the DATE sheet, you should select five companies according to the numbers next to your name, and answer the following 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  What is the rate of return of companies pay dividends at zero growth rate  What are the dividend yield for your 5 companies  What are the capital gains yield for your companies  What are the required returns on your stocks based on the dividend growth model  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 no Compare selected companies, indicate the best investment options and explain your choice  101 102 103 104 los 06 Replace  Company Company 2  Company 3  Company 4  Companys  with the names of the Do not delete or transfer anything on this page  Give the file your name  should provide answers to 6 questions in Table 1  Write your answer to question in the specified line Q7  Font Paste Format Painter ctsh Clipboard fi X B33 42 21 138 12 67 54 43 53 100 99 343 35 74 99 440 92 210 50 101 11 57,22 140 45 4A B 31 28 CSCO 32 29 ctxs 33 30 cth 34 31 cmc 35 32 pm 36 33 cost $ $ $ $ $ S $ $ S $ $ S Cisco Systems, Inc  Common Stock 177,716,447, 142 Citrix Systems, Inc  Common Stock 17,057 296 903 Cognizant Technology Solutions Corporation Class A CC36,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,732 CSX Corporation Common Stock 57,371,290,650 Dexcoinc  Common Stock 42,214,653,910 I fommon Stock 38,114,789,184 23,929,631 583 40,138,182,003 in 1 512,667 0 132S 2 200  s 1 001  1 001  $ 0 187 $ 3 729  1 100 $ 4 081  3 080$ 0 25455 0 407  1 716  1 716 $ 0 110 0 924  7 22 4 91 9 49 37 03 8 09 61 24 23 57 9 99 5 99 13 93 2 88 8 29 26 16 5 21 37 34 ws $ 87 60 Task Data Q1 102 103 104 los 06 107 Assignment 2 FIN204 CH7 (6 marks) Student NAME Student ID According to the list of students on the DATE sheet, you should select five companies according to the numbers next to your name, and answer the following 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  What is the rate of return it 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 model  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 Compare selected companies, indicate the best investment options and explain your choice  02 103 104 los 106 Table 1 101 Company 1 Company 2 Company Company 4 Companys Replace  Company I  Company 2  Company 3  Company 4  Company 5  with the names of the Do not delete or transfer anything on this page  Give the file your name  107 Notes  You should provide answers to 6 questions in Table 1  Write your answer to question in the specified line 07

Accepted Answer

The Answer is in the image, click to view ...

Question

Data Assignment 2 FIN204 CH7 (6 marks) Student NAME Student ID According to the list of students on the DATE sheet, you should select five

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Financial Markets And Institutions

Students also viewed these Finance questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question