Pls answer using excel with formulas displayed! TYSM

1) Analysts forecast that Dixie Chicks, Inc. (DCI) will pay a dividend of $4.00 a share now, continuing a long-term growth trend of 7.5% per year. If this trend is expected to continue indefinitely, and investors' required rate of return for DCl is 12% : a) What is the market value per share of DCl's common stock? b) What is the market value per share of DCI's common stock if required rate of return is 10% ? c) If there is expected to be non-constant growth of 33% for the first year, then 22% for the next year, then 11% for next year, finally stabilizing to a constant growth of 9% per year in the 4th year what is the market value per share with the original required rate of return