please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS

AI intelligence, a new artificial intelligent for medical devices company, is expected to experience short-term supernormal dividend growth rates of 40% in year 1, 30% in year 2 and 20% in year 3. After 3 years of supernormal growth, this company dividend is expected to grow at a constant rate of 5%. However, today due to an increased demand for medical devices, analysts have made an upward projection on its short-term growth rates to 55% in year 1, 40% in year 2 and 28% in year 3 and long-term constant growth rate of 6%. If the most recent dividend paid is $1 per share and its required return remains at 15%, approximately how much do you expect the change in AI intelligence stock price per share today (indicate an increase or a decrease in stock price and show your calculation steps)?

PLEASE HELP WITH EXCEL STEP-BY-STEP (IN FULL detail) much appreciated **IMPORTANT** I WANT TO LEARN