data 58,59 and 60 to answer the questions

answer should be on excel please show steps and equations on excel

albasis According to the list of students on the DATA sheet you should ct five companies according to the numbers next to your time, and we the following What is the expected dividend in Year for your companies, taking into account the growth of the dividende shown in column-y-growth rate? What is the rate of return it companies pay dividends at zero growth rate? What are the dividend ind for your companion? What are the capital gains yield for your 3 companies What are the required returns on your stocks and on the dividend growth model? what will be the share prices of the lected companies in a you, taking into account the dividend growth model, if the required rate of return is 101.7 Do no Compare selected companies, indicate the best investment options and explain your choice. 04 09 Jor los 103 100 los 1 eftete ar transfer anything on this page 12 New power in the citie 01 09 When should your companies charge for bonds if the face value $1.000 Milway in 10 years and to maturity (VTM or body is for a How many honda must your companies all to raise the money needs i Maturity has 10 years and Yield to matury (VTM or bondel is 125 for all compar How many ZERO cupon bone must your companies to raise the money in Motory 10 years and Yield to maturity IVTM or bonde yield 12% INLOGGET 58 Liberty Global ple Class C Ordinary Shares 59 lululemon athletica in Common Stock 60 Marriott International Class A Common Stock NIKE UMR 19443 OMR 4730331 OMR 136 436 1150 276390 120 OMR OMR 30.342 OMR 12,433 OMIKUT OMR 1.184.169 OMR 4,620,656.341 OMR3,104343.88 990 10.00 albasis According to the list of students on the DATA sheet you should ct five companies according to the numbers next to your time, and we the following What is the expected dividend in Year for your companies, taking into account the growth of the dividende shown in column-y-growth rate? What is the rate of return it companies pay dividends at zero growth rate? What are the dividend ind for your companion? What are the capital gains yield for your 3 companies What are the required returns on your stocks and on the dividend growth model? what will be the share prices of the lected companies in a you, taking into account the dividend growth model, if the required rate of return is 101.7 Do no Compare selected companies, indicate the best investment options and explain your choice. 04 09 Jor los 103 100 los 1 eftete ar transfer anything on this page 12 New power in the citie 01 09 When should your companies charge for bonds if the face value $1.000 Milway in 10 years and to maturity (VTM or body is for a How many honda must your companies all to raise the money needs i Maturity has 10 years and Yield to matury (VTM or bondel is 125 for all compar How many ZERO cupon bone must your companies to raise the money in Motory 10 years and Yield to maturity IVTM or bonde yield 12% INLOGGET 58 Liberty Global ple Class C Ordinary Shares 59 lululemon athletica in Common Stock 60 Marriott International Class A Common Stock NIKE UMR 19443 OMR 4730331 OMR 136 436 1150 276390 120 OMR OMR 30.342 OMR 12,433 OMIKUT OMR 1.184.169 OMR 4,620,656.341 OMR3,104343.88 990 10.00