Free Stock Equity Valuation Spreadsheet 1.0

License: Free ‎File size: 94.82 KB
‎Users Rating: 4.0/5 - ‎1 ‎votes

ABOUT Free Stock Equity Valuation Spreadsheet

This Stock Equity Valuation calculator and spreadsheet uses the Dividend Discount Model (DDM) for valuing the price of a stock for a company which pays out dividends. The Dividend Discount Model assumes that the price of a stock is equivalent to the sum of all of its future dividend payments discounted to the present value. The model is simple in theory but have various scenarios due to the different ways that dividends could be paid out. This spreadsheet allows you to value a stock using the Dividend Discount Model in the following scenarios: Price of Stock with Zero Growth Dividends Price of Stock with Constant Growth Dividends (Gordon Model)