North by Northwest Airlines paid a dividend of $1.67 for the current year.They plan to increase the dividend by 8% next year,after which there are no further increases planned.If the required rate of return is 10%, what is the value of a share of the airline's stock?(round to nearest cent)

The answer is $18.04.

Please show how to find this answer using Excel formula format.