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.

Percentage Formula: Know How to Calculate Percentage in Excel along with Solved questions and examples and Download formula PDF list.