can someone help me in solving this, and please provide me with the accurate formulas to use?

calculate for each company

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 3 companies?

Q4) what are the required return on your stocks based on the dividend growth model?

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 value of shares (p0) in the calculation.

Q7) Compare selected companies, indicate the best investment options and explain your choice?

Q8) what price should your companies charge for bonds if the face value is $1000, Maturity is 10 years and yield to maturity (YTM or bond's yield) is 12% for all companies?

Q9) how many bonds must your companies sell to raise the money it needs if Maturity is 10 years and Yield to maturity (YTM or bond's yield) is 12% for all companies?

Q10) How many Zero coupon bonds must your companies sell to raise the money it needs if maturity is 10 years and yield to maturity (YTM or bond's yield) is 12% for all companies?

Formatting Styles ipboard Font Alignment Table Styles Number Cells 1 - > A B C D E F G NAME 34 CSX Corporation Common Stock 35 Dexcom, Inc. Common Stock 36 DocuSign, Inc. Common Stock The company wants to raise funds for a new PO - current share g - dividend DO - just paid project from the sale of Coupon price growth rate annual dividend bonds. rate $ 109.49 2.050% $ 11.54 $ 5,737,129 7.40% $ 585.20 5.031% $ 74.26 $ 4,221,465 7.50% $ 285.65 4.030% $ 29.81 $ 3,811,479 7.60% Alignment Number Filter - Select Styles Cells P12 D 2 G H M N O According to the list of students on the DATA sheet, you should select five companies according to the numbers next to your name, and answer the following questions: T 4 5 01 02 93 B 94 9 Q5 10 06 11 97 12 13 Table 1 What is the expected dividend in Year 6 for your companies, taking into account the growth of the dividends shown in columnag-growth ratea? What is the rate of return if companies pay dividends at zero growth rate? What are the dividend yield for your 3 companies? What are the capital gains yield for your 3 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 use the current value of the shares (PO) in the calculation Compare selected companies, indicate the best investment options and explain your choice. 01 az 03 04 06 Heplace "Company 1. Company 2. Company 3* with the names of the selected companies CSX corporation 15 common stock Dexcom, Inc 16 common stock docusign, Inc 17 cuman stock 18 19 Do not delete or transferanything on this page Give the file your name 21 02 23 Notes: You should provide answers to 6 questions in Table 1. Write your answer to question 7 in the specified line 07 ob questions in Table 1. Write your answer to question 7 in the specified line 7 24 25 26 Q8 2709 What price should your companies charge for bonds if the face value is $1,000, Maturity is 10 years and Yield to maturity (YTM or bond's yield) is 12% for all companies? How many bonds must your companies sell to raise the money it needs if Maturity is 10 years and Yield to maturity (YTM or bond's yield) is 12% for all companies? How many ZERO coupon bonds must your companies sell to raise the money it needs if Maturity is 10 years and Yield to maturity (YTM or bond's yield) is 12% for all companies? 28 Q10 30 31 Table 2 08 010 Replace Company 1. Company 2. Company 3" with the names of the selected.companies. 33 Company 1 34 Company 2 35 Company Task Data Heady 1 Formatting Styles ipboard Font Alignment Table Styles Number Cells 1 - > A B C D E F G NAME 34 CSX Corporation Common Stock 35 Dexcom, Inc. Common Stock 36 DocuSign, Inc. Common Stock The company wants to raise funds for a new PO - current share g - dividend DO - just paid project from the sale of Coupon price growth rate annual dividend bonds. rate $ 109.49 2.050% $ 11.54 $ 5,737,129 7.40% $ 585.20 5.031% $ 74.26 $ 4,221,465 7.50% $ 285.65 4.030% $ 29.81 $ 3,811,479 7.60% Alignment Number Filter - Select Styles Cells P12 D 2 G H M N O According to the list of students on the DATA sheet, you should select five companies according to the numbers next to your name, and answer the following questions: T 4 5 01 02 93 B 94 9 Q5 10 06 11 97 12 13 Table 1 What is the expected dividend in Year 6 for your companies, taking into account the growth of the dividends shown in columnag-growth ratea? What is the rate of return if companies pay dividends at zero growth rate? What are the dividend yield for your 3 companies? What are the capital gains yield for your 3 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 use the current value of the shares (PO) in the calculation Compare selected companies, indicate the best investment options and explain your choice. 01 az 03 04 06 Heplace "Company 1. Company 2. Company 3* with the names of the selected companies CSX corporation 15 common stock Dexcom, Inc 16 common stock docusign, Inc 17 cuman stock 18 19 Do not delete or transferanything on this page Give the file your name 21 02 23 Notes: You should provide answers to 6 questions in Table 1. Write your answer to question 7 in the specified line 07 ob questions in Table 1. Write your answer to question 7 in the specified line 7 24 25 26 Q8 2709 What price should your companies charge for bonds if the face value is $1,000, Maturity is 10 years and Yield to maturity (YTM or bond's yield) is 12% for all companies? How many bonds must your companies sell to raise the money it needs if Maturity is 10 years and Yield to maturity (YTM or bond's yield) is 12% for all companies? How many ZERO coupon bonds must your companies sell to raise the money it needs if Maturity is 10 years and Yield to maturity (YTM or bond's yield) is 12% for all companies? 28 Q10 30 31 Table 2 08 010 Replace Company 1. Company 2. Company 3" with the names of the selected.companies. 33 Company 1 34 Company 2 35 Company Task Data Heady 1