(ALL WORK MUST BE DONE ON EXCEL AND SHOW YOUR FORMULAS, I MUST BE ABLE TO SEE YOUR CELL REFERENCES)
Company A, just paid a dividend of $3.00 on its stock. The growth rate in dividends is expected to be a constant 5 percent per year indefinitely. Investors require a 16 percent return on the stock for the first three years, a 14 percent return for the next three years, and then an 11 percent return thereafter. What is the current share price for Company A stock? (SHOW ALL YOUR WORK ON EXCEL)