Dividend Discount (Gordon Growth) Model
Product Description
This sophisticated model can be used for Stock (Intrinsic Value) Valuation purposes. The model supports:
• Non-Constant dividend growth/decline rates for up to 10 years (120 Payment Periods MAX), so that the application user does not need to assume that the constant dividend growth starts immediately;
• Different dividend payment frequencies (Annual, Semiannual, Quarterly, Monthly);
• Both, ordinary and due annuity types;
The application carries out not only needed calculations, but also presents users with detailed tables to track/see cash flows, periodic discount rates, and discounted cash flows.
The model supports four different theme colors (Olive Green, Dark Blue, Black, Dark Orange) for user convenience.
***NOTE: xlsm format requires MS Office 2007!
***NOTE: THIS IS A VBA PROJECT. PLEASE ENABLE MACROS BEFORE USING!!!
• Non-Constant dividend growth/decline rates for up to 10 years (120 Payment Periods MAX), so that the application user does not need to assume that the constant dividend growth starts immediately;
• Different dividend payment frequencies (Annual, Semiannual, Quarterly, Monthly);
• Both, ordinary and due annuity types;
The application carries out not only needed calculations, but also presents users with detailed tables to track/see cash flows, periodic discount rates, and discounted cash flows.
The model supports four different theme colors (Olive Green, Dark Blue, Black, Dark Orange) for user convenience.
***NOTE: xlsm format requires MS Office 2007!
***NOTE: THIS IS A VBA PROJECT. PLEASE ENABLE MACROS BEFORE USING!!!
Share Your Favorite Models on Other Social Networks:
= = = = = = = = = = =
Subscribe to Newsletter