I NEED HELP WITH CREATING THE GORDON CONSTANT GROWTH MODEL FOR WALMART IN EXCEL

BELOW IS AN EXAMPLE OF THE GORDON CONSTANT GROWTH MODEL:

T a b I a 9 . 1 Analysis of a Constant Growth Stock Dividend In Year I. 0.. ll Column 1 Intrinsic lm (and [nice] i Var I. l'. . in Calm J \"Harm! yield (manna in Column 4 Capital :Iins yield (constant) in Clllll 5 Total relurn (mum!) In COIIN'II 6 IN 0! HM Haunted at 13.7% h Cd.\" 7 D. = SLISOIUJIBJ) 8., - $1.15 I (0J3? 0.883) Dividend yield. Yclr l: SLZS ($23.06 Cap gains yield. War I: (514.98 - 523.06}! 823.0(- 'l'oul return. Year 1: 5.4 V. + 8.3 9'. ' pf D. discounted II 5.7% Dividcml Capital Ton] dividend yield ulna yield mum \"13.79:. 4 (5) (6) T) 5.4% 8.3 '2'. \".794. 5.4% 8.3% IJJ'X- SLIM 5.4% 8.3 '3'- l3.T'/o $0.99 5.4% 8.3 '1- IJ.T% 80.95 5.4% 8.3 V- L139\"- $0.90 5.4% 8.3 '31- I337?!- $0.86 5.4% 8.3% \".794 80.82 5.4% 8.3 '5'. \"3% 50.78 5.4% 8.3 V. \"37% $0.74 5.4% 8.3 '16 \"3% 50.7] Sum-twummm-r.==vuuumnols ' Bonnet\": haumntyu'lhuuk. ween-III hm foundthnluforl.ul'._.ll +3). For ank, l', - $23.I6(I.II3) - $21.97. This \"In diners fun: the one [I the table the to I renal-c dimue. Yul Iholllln'l worry about mndlls diucncu. E! [I I! I! I! a In IE [H II! IE IE IE! [B E! E] E E! El E E! El [E] E! En El E] El E i 'Ymmymmmeum\"m\"muublauemmtmduyamsimplydit mmedbyrmmdmg.