Transcribed Image Text
Problem ABC is a young starup company. Currently, they do notpay dividends. The first scheduled dividend will be paid at the endof year 3, with amount of $1.50. In the next 4 years, the dividendwill grow at 20% every year. After that, it will maintain asustainable growth rate of 6% forever. The required rate of returnis 15%. John hired you as an excel programmer. He asks you to writeonly one flexible excel program that has all of the followingrequirements respect to the change of input data: a) The amount ofstock price must be shown at “answer section” ( 1 point) b) Pleaseuse IF function to develop a fexible model displaying the stockprice and dividend for this model.