Discounted Dividend Valuation Excel Model Template
Originally published: 29/04/2019 15:47
Last version published: 30/04/2019 13:52
Publication number: ELQ-25815-2
View all versions & Certificate

Discounted Dividend Valuation Excel Model Template

A Discounted Dividend Valuation Model for calculating fair stock prices

This comprehensive model is a Discounted Dividend Valuation Model. The model assists in calculating a fair price for a company’s stock, considering various criteria.

The template is based on the Dividend Discount Model, or DDM. DDM is a method for valuing the price of a stock by using projected dividends and discounting them back to present value. The concept is that if the value obtained from the DDM is higher than the current market value of the stock, then the stock is undervalued, and vice-versa.

This template allows you to choose between 4 different model types:
-> One-Stage model
-> Two-Stage model
-> Three-Stage model
-> Manual model

You just need to choose your model type, input all appropriate data and the stock value will be calculated automatically. You can also calculate overall company value.

Let us do the work for you!

Feel free to contact our team in case you need support with budgeting your company. Our team provides financial modeling services to companies around the world. Actually, this is our core business. We have a lot of experience with creating budgets for service companies and know the specifics of the business. Just drop us a line via Private Message on our Author Channel.

If you require a budgeting template for a different industry, please have a look at similar budgeting templates here in our Eloquens Channel. If you can't find a template that suits your industry, you might consider ordering a customized budget template. Please contact us here:

This Best Practice includes
1 DDM excel sheet

Andrew Grigolyunovich, CFA, CFM, FMVA offers you this Best Practice for free!

download for free

Add to bookmarks



  • Rate this Downloadable Best Practice

    Write a review

  • Anuj Suri(last updated: 02/05/2021 18:18)
  • Dennis Conche(last updated: 29/07/2020 01:45)


More Best Practices from Andrew Grigolyunovich, CFA, CFM, FMVA

See all

Any questions on Discounted Dividend Valuation Excel Model Template?

The user community and author are here to help. Go ahead!

4.5 / 5 (2 votes)

please wait...