I'm having difficulty entering the correct formulas and solutions into EXCEL.

1) Analysts forecast that Dixie Chicks, Inc. (DCI) will pay a dividend of $3.00 a share now, continuing a long-term growth trend of 8% per year. If this trend is expected to continue indefinitely, and investors' required rate of return for DCI is 14%: a) What is the market value per share of DCI's common stock? b) What is the market value per share of DCI's common stock if required rate of return is 11%? c) If there is expected to be non-constant growth of 30% for the first year, then 24% for the next year, then 14% 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