please I need this solved as soon as possible.
I will be waiting for your answer.
Thank you.
NAME 1 Maxim Integrated Products, Inc. Common Stock 2 Mercadolibre, Inc. Common Stock 3 Microchip Technology Incorporated Common Stock The company wants to DO - just paid raise funds for a new PO - current share E-dividend annual project from the sale of Coupon price growth rate dividend bonds. rate $ 101.66 1.544% $ 10.34 $ 1,839,323 10.10% $ 1,563.21 4.657% S 141.94 $ 5,914,838 10.20% $ 146.37 4.415% S 18.18S 2,609,339 10.3096 Qu 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? 02 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 capital gains yield for your 3 companies? 25 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 the shares (PO) in the calculation, Q7 Compare selected companies, indicate the best investment options and explain your choice. mwing Dile Foi Ali Nume Cri H Maxim into rated Products, Inc. Common Stock Marcadolibre, Inc. Common Stock Microchip Technoloxy Inc. Common Stock Do not delete or transfer anything on this per az Notes: You should provide answers to questions in Table 1. Write your answer to question in the specified line 7 28 What price should your companies charge for bonds if the face value is 51,000, Maturity is 10 years and Yield to maturity (YTM or bond's yield) is 12%. for all companies? 29 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? 1010 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