Adjusted Dividend Discount Model (ADDM): A Comprehensive Guide

Adjusted Dividend Discount Model (ADDM): A Comprehensive Guide

The world of stock valuation boasts a plethora of models and strategies to help analysts and investors determine the worth of a stock. One of these models, which has gained traction over the years, is the Adjusted Dividend Discount Model (ADDM). This article delves deep into the ADDM, providing readers with a comprehensive understanding of how it works and its unique advantages.

Introduction to the Adjusted Dividend Discount Model (ADDM)

Before diving into the ADDM, it's essential to understand its predecessor – the Dividend Discount Model (DDM). The DDM is a valuation method that calculates the present value of expected dividends of a stock to determine its intrinsic value. However, DDM has its limitations, especially when dividends are irregular or non-constant. This is where the Adjusted Dividend Discount Model steps in, offering a more nuanced approach to dividend forecasting and stock valuation.

How Does the ADDM Work?

At its core, the ADDM adjusts future dividends by considering potential changes in dividend payouts. This can be due to various reasons, such as:

  • Reinvestment opportunities
  • Company's dividend policy changes
  • External economic conditions

The general formula for ADDM can be expressed as:

P0 = D0 * (1+ g) / (r-g)


  • P0 = Stock price today
  • D0 = Most recent adjusted dividend
  • g = Growth rate of dividends
  • r = Required rate of return or discount rate

Automating Adjusted Dividend Discount Model Valuation using Wisesheets

In the ever-evolving realm of finance, automation is key to improving efficiency and accuracy. Wisesheets, a powerful tool designed for financial analysis, allows users to automate the Adjusted Dividend Discount Model valuation, ensuring that analysts and investors can quickly and precisely ascertain a stock's intrinsic value.

Steps to Automate ADDM Valuation using Wisesheets:

a. Data Collection: Start by retrieving the most recent dividend data using the WISE function:

=WISE("TICKER", "adjusted dividend", "LQ")

Replace "TICKER" with the desired stock ticker. This will give you the most recent dividend (D₀).

b. Estimating Growth Rate (g): You can derive the dividend growth rate by comparing dividends from different periods. For a simple year-over-year growth:

=(WISE("TICKER", "adjusted dividend",2022) - WISE("TICKER", "adjusted dividend",2021)) / WISE("TICKER", "adjusted dividend",2021)

This formula provides the YoY dividend growth rate.

c. Input Required Rate of Return (r): Enter your required rate of return. This might be based on historical data, market expectations, or personal investment criteria.

d. Calculate Stock Price (P₀): Using the ADDM formula, automate the calculation:

=(WISE("TICKER", "adjusted dividend", "LQ") * (1 + [Cell with g])) / ([Cell with r] - [Cell with g])

Automatic DDM Valuation

Replace the cell references accordingly.

e. Visualize and Analyze: Wisesheets offers powerful visualization tools. Create graphs or charts to visualize dividend growth stock valuations over time or compare ADDM valuations with other methods.

f. Regular Updates: Make use of the refresh data button in Wisesheets to keep your data up-to-date, ensuring that your valuations remain accurate as new data comes in.


  • When dealing with companies that have irregular dividends, consider using a weighted average or other statistical methods to estimate the growth rate.
  • Always ensure to review and adjust the required rate of return based on market conditions and individual investment objectives.
  • Wisesheets functions can be linked together, allowing for more complex analyses and multi-security evaluations.

Advantages of ADDM

There are several reasons why analysts might prefer ADDM over the traditional DDM:

  • Flexibility: ADDM allows for the adjustment of the growth rate of dividends, making it adaptable to a broader range of scenarios.
  • Enhanced Accuracy: ADDM provides a more realistic valuation by accommodating non-constant dividends, especially for companies with irregular dividend policies.
  • Consideration of External Factors: The model can incorporate external conditions, such as macroeconomic factors, which might influence a company's dividend payout.

Limitations of ADDM

While ADDM addresses some of DDM's flaws, it's not without its challenges:

  • Complexity: ADDM might be more challenging to understand and implement compared to the straightforward DDM.
  • Assumptions: The model still relies on assumptions about future dividends, growth rates, and discount rates, making it susceptible to errors if these predictions are off.

Practical Applications of Adjusted Dividend Discount Model

One of the primary benefits of ADDM is its real-world applicability. Here's how it can be useful in practical scenarios:

  • Evolving Businesses: For companies that are transitioning their business models or moving through rapid growth phases, their dividend patterns might change, making ADDM a more suitable valuation tool.
  • Mature Companies with Irregular Dividends: Some mature businesses might have non-constant dividend policies due to varied reasons – from acquisitions to other major investments. ADDM helps in valuing such companies more accurately.
  • Macroeconomic Fluctuations: In periods of economic downturns or booms, the company's dividends might change. ADDM allows analysts to account for such variations.

Comparison with Other Valuation Models

While ADDM has its distinct advantages, it's one of many valuation models available to analysts. Let's see how it stacks up against others:

  • Discounted Cash Flow (DCF): Unlike ADDM, which focuses on dividends, DCF considers the company's entire cash flow. DCF is more comprehensive but requires more data and assumptions.
  • Price-to-Earnings (P/E) Ratio: A simpler method that compares a company's current market price to its earnings. While it's easier to calculate, it doesn't factor in future growth as intricately as ADDM.
  • Residual Income Model: This model values stock by looking at the excess profit after deducting required equity returns. It provides a different perspective than dividend-focused models.

Key Assumptions to Be Cautious Of

Every financial model rests on some assumptions, and ADDM is no different. Here are some assumptions and pitfalls to be wary of:

  • Constant Growth Rate: While ADDM adjusts dividends, the growth rate is often assumed constant after a certain period. This can be misleading for companies in fast-evolving industries.
  • Discount Rate: Determining the correct rate to discount future dividends is critical. A slight misjudgment can lead to significant valuation errors.
  • Future Dividends: The model heavily relies on the prediction of future dividends. If these projections are not accurate, the model can provide misleading results.


The Adjusted Dividend Discount Model offers a nuanced approach to stock valuation, especially for businesses with non-constant dividends. While it provides enhanced flexibility and applicability, it's essential to understand its assumptions and how it compares to other models. In the world of equity analysis, ADDM stands as a potent tool, but like all models, it's only as good as the data and assumptions feeding into it.

Guillermo Valles
 | Website

Hello! I'm a finance enthusiast who fell in love with the world of finance at 15, devouring Warren Buffet's books and streaming Berkshire Hathaway meetings like a true fan.

I started my career in the industry at one of Canada's largest REITs, where I honed my skills analyzing and facilitating over a billion dollars in commercial real estate deals.

My passion led me to the stock market, but I quickly found myself spending more time gathering data than analyzing companies.

That's when my team and I created Wisesheets, a tool designed to automate the stock data gathering process, with the ultimate goal of helping anyone quickly find good investment opportunities.

Today, I juggle improving Wisesheets and tending to my stock portfolio, which I like to think of as a garden of assets and dividends. My journey from a finance-loving teenager to a tech entrepreneur has been a thrilling ride, full of surprises and lessons.

I'm excited for what's next and look forward to sharing my passion for finance and investing with others!

Related Posts