{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

StockEquityValuation[1]

StockEquityValuation[1] - Financial Modeling Templates...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Financial Modeling Templates Equity Valuation http://spreadsheetml.com/finance/stockequityvaluation.shtml Copyright (c) 2009, ConnectCode All Rights Reserved. ConnectCode accepts no responsibility for any adverse affect that may result from undertaking our training. Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Pg ii Equity Valuation Version 1.0 Table of Contents 1. Equity Valuation .................................................................................................................... 1-1 1.1 Equity Valuation using the Dividend Discount Model ................................................ 1-1 2. Price of Stock with Zero Growth Dividend ......................................................................... 2-2 3. Price of Stock with Constant Growth Dividends (Gordon Model) ................................... 3-3 4. Price of Stock at Time N with Constant Growth Dividends (Terminal Value) ................. 4-4 4.1 Terminal Value ........................................................................................................... 4-4 5. Price of Stock with Two Stage Growth Dividends ............................................................. 5-6 5.1 Sum of Present values of Dividends in first stage High Constant Growth Period ..... 5-6 5.2 Terminal Value ........................................................................................................... 5-6 5.3 Sensitivity Analysis ..................................................................................................... 5-7 6. Price of Stock with Non Constant Growth Dividends ....................................................... 6-8 6.1 Sum of Present values of Dividends in Non Constant Growth Period ....................... 6-8 6.2 Terminal Value ........................................................................................................... 6-8 6.3 Sensitivity Analysis ..................................................................................................... 6-9
Background image of page 2