One way to use Excel to show how the dividend discount model works is to set up a timeline that reflects the value of each year's dividends, going however far into the future you choose.