FILL IN THE BLANKS (EOP total value, shares, and dividends) with AND without DRIP.

use excel for all calculations and provide all formulas for a thumbs up

DRIP Evaluation Initial number of shares 100 Initial stock price per share $100.00 Annual Dividend per share $2.00 Dividend annual growth rate 3% Stock price annual growth rate 5% Number of years 10 Without DRIP With DRIP EOP Total Value in dollars EOP Number of shares EOP Dividends paid 1) The total value without dividend reinvestment equals the final stock price multiplied by the initial number of shares added to the sum of all dividends paid. The number of shares is simply the initial number of shares. 2) The total value with dividend reinvestment equals the final stock price multiplied by the sum of the initial number of shares plus all dividend reinvestment shares. The number of shares is the initial number of shares plus all the shares purchased with reinvested dividends. 3) The dividends paid without dividend reinvestment is the sum of yearly dividends paid on the initial number of shares. 4) The dividends paid with dividend reinvestment is the sum of yearly dividends paid on the initial number of shares and the reinvested dividends shares. DRIP Evaluation Initial number of shares 100 Initial stock price per share $100.00 Annual Dividend per share $2.00 Dividend annual growth rate 3% Stock price annual growth rate 5% Number of years 10 Without DRIP With DRIP EOP Total Value in dollars EOP Number of shares EOP Dividends paid 1) The total value without dividend reinvestment equals the final stock price multiplied by the initial number of shares added to the sum of all dividends paid. The number of shares is simply the initial number of shares. 2) The total value with dividend reinvestment equals the final stock price multiplied by the sum of the initial number of shares plus all dividend reinvestment shares. The number of shares is the initial number of shares plus all the shares purchased with reinvested dividends. 3) The dividends paid without dividend reinvestment is the sum of yearly dividends paid on the initial number of shares. 4) The dividends paid with dividend reinvestment is the sum of yearly dividends paid on the initial number of shares and the reinvested dividends shares