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 DocumentRight 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
Pg iii Equity Valuation Version 1.0 ConnectCode’s Financial Mode ling Templates Have you thought about how many times you use or reuse your financial models? Everyday, day after day, model after model and project after project. We definitely have. That is why we build all our financial templates to be reusable, customizable and easy to understand. We also test our templates with different scenarios vigorously, so that you know you can be assured of their
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/08/2011 for the course FIN 504 taught by Professor Dr.jiu during the Fall '10 term at Jones Intl..

Page1 / 12

StockEquityValuation[1] - Financial Modeling Templates...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online