Please show work or cell references, this is a tough subject for me.

You are given the following data for stock ABC. Calculate ABC's intrinsic value and state whether it is overvalue or undervalued. Dividend (most recent): 1.60 Required return on the stock: 14.0% Dividend growth rate (next 2 years): 20.0% Dividend growth rate in years 3 and 4 15.0% Dividend growth rate in year 5 (and beyond): 6.0% Current market price of stock: $ 32.00 0 2. 4 5 Year Dividend PV(Dividend) trinsic Value at Year 4 P(4) PV(P(4)) Intrinsic Value Today P(0) Over-/under-valued