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 DCIs common stock?

b) What is the market value per share of DCIs 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?

Please upload excel workbook and show all the formulas