PLEASE SHOW ANSWER IN EXCEL WITH FORMULAS*

Janicek Corp. is experiencing rapid growth. Dividends are expected to grow at 26 percent per year during the next three years, 16 percent over the following year, and then 6 percent per year indefinitely. The required return on this stock is 15 percent, and the stock currently sells for $74 per share. What is the projected dividend for the coming year?(Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16))