please tell me what i have input into ROW G to get the answer in the yellow box.

3480200906954026406464405040543340605555 17 18 21 31 Excel Solution Using a Table: 37 Given: Definition Notation: Inputs: D D D The expected upcoming (end of period 1) dividend The expected upcoming (end of period 2) dividend The expected upcoming (end of period 3) dividend The required rate of return on the firm's common stock The expected future stock price at the Horizon time The present value of the stock share (market price) r PH $70.00 P. Finance Concept: Po-PV of expected future dividends P-D/(1+r) + D/(1+r)+...+(Divu +P)/(1+r)" Where H is the horizon or specific investment time period. In Words: The Present Value of a stock share depends on the stream of expected dividends. This is the generalized stock valuation model which is also how we value bonds. Year 1 Year 2 Year 3 Today 2.0% a Interest Rate $I$20 b Time 1 2 e Stock Price at year 3 $ 70.00 -- PH d Dividends $ 4.00 S 4.50 $ 5.00