professional documents
home
Profile
docsters
request
Blogs
Upload
about me
contact me
user photo
Andrew Belous
Software Developer
Software Developer
Docstoc Inc.
submit clear
Excel Spreadsheet

zero growth model valuation center doc

financial > Valuation

1. Zero Growth (Constant Dividend) Model A. Solving for Price: V = D/k, where D = dividend and k = required return What would an investor be willing to pay for a stock if she expected to receive a dividend of $2.50 each year indefinitely and her required return is 15%? D 2.50 $ k 15.00% V? 16.67 $ B. Solving for Return: k = D/V What rate of return would an investor expect if the current price of a stock is $119 and she expected the firm to pay a constant dividend of $4/year? V 119.00 $ D 4.00 $ k? 3.4% Valuation (Note: The tables below have been written using formulas which allow you to alter the information or assumptions.)or assumptions.)1. Constant Growth Model A. Solving for Price: V = D0(1+g)/k-g = D1/(k-g) , where D0 = current dividend, k = required return, and g = growth rate What would an investor be willing to pay for a stock if she just received a dividend of $2.50, her required return is 15%, and she expected dividneds to grow at a rate of 5% per year. D0 2.50 $ k 13.00% g 4.00% V? 28.89 $ B. Solving for Return: k = D0(1+g)/V + g = D1/V + g What is my expected return on a stock that costs $26.50, just paid a dividend of $2.50, and has an expected growth rate of 5%? D0 2.50 $ V 26.25 $ g 5.00% k? 15.00% Valuation (Note: The tables below have been written using formulas which allow you to alter the information or assumptions.)required return,1. Non-Constant Growth Model A. Solving for Price: This model involves the computation of year-to-year dividends which are then dicounted at the investors required rate of return. What would an investor be willing to pay for a stock if she just received a dividend of $2.50, her required return is 15%, and she expected dividneds to grow at a rate of 10% per year for the first two years, and then at a rate of 5% thereafter. Step 1: Compute the expected dividends during the first growth period. g 10.0% D0 2.50 $ D1 2.75 $ D2 3.03 $ Step 2: Compute the Estimated Value of the stock at the end of year 2 using the Constant Growth Model D2 3.03 $ k 15.00% g 5.00% V2? 31.76 $ Step 3: Compute the Present Value of all expected cash flows to find the price of the stock today. Cash PV at Flow 15% 1 D1 2.75 $ 2.39 $ 2 D2 3.03 $ 2.29 $ 3 V2? 31.76 $ 20.88 $ V0 ? 25.56 $ Valuation (Note: The tables below have been written using formulas which allow you to alter the informatins or assumptions.)Example: If the rate of return on U.S. T-blls is 5%, and the expected return for the S&P 500 is 15%, what would be the required return for Microsoft with a beta 1.5, and Florida Power and Light with a beta of 0.8?MSFT FPL rf 5.0% 5.0% rm 15.0% 15.0% B 1.5 0.8 Answer k? 20.0% 13.0% (Note: When evaluating the impact of changes in variables, keep in mind that changes in the risk-free rate must be accompanied equivalent changes in the market return. Required Return k = rf + (rm -Rf)B
rate this doc
email this doc
embed this doc
add to folder
digg reddit stumble delicious
flag this doc
898
32
not rated
0
10/16/2007
English
search termpage on Googletimes searched
Preview

Zero Growth Model - Valuation template

Rabia06 3/26/2008 | 295 | 25 | 0 | financial
Preview

choosing the right valuation model

andrew 10/16/2007 | 639 | 91 | 0 | financial
Preview

Discounted Dividend Valuation Model Template

Rabia06 3/26/2008 | 365 | 28 | 0 | financial
Preview

Template for Valuation Model for Tech Transfer Licensing

Rabia06 3/26/2008 | 152 | 9 | 0 | financial
Preview

Constant Growth Valuation Template.

Rabia06 3/26/2008 | 518 | 45 | 0 | financial
Preview

Philip_Morris_Valuation_Model

ay2002 12/22/2007 | 462 | 70 | 0 | financial
Preview

valuation model

lizzybee27925 1/21/2008 | 261 | 18 | 0 | financial
Preview

valuation model

sammyc2007 2/6/2008 | 119 | 6 | 0 | financial
Preview

Philip_Morris_Valuation_Model_Final

ay2002 12/22/2007 | 599 | 148 | 0 | financial
Preview

zero growth model valuation

cshieyiez 1/21/2008 | 249 | 26 | 0 | financial
Preview

Philip Morris Valuation Model[1]

cshieyiez 1/21/2008 | 227 | 23 | 0 | financial
Preview

Discounted Dividend Valuation Model

ocak 1/14/2008 | 167 | 12 | 0 | financial
Preview

Valuation model decision

anonymous 1/17/2008 | 202 | 18 | 0 | financial
Preview

Valuation model[1]

Mythri 1/23/2008 | 97 | 5 | 0 | financial
Preview

Valuation model[2]

Mythri 1/23/2008 | 91 | 4 | 0 | financial
Preview

VCSharp_2005_color

andrew 5/27/2008 | 95 | 1 | 0 |
Preview

VCSharp_2005_color

andrew 5/27/2008 | 48 | 0 | 0 |
Preview

VCSharp_2005_color

andrew 5/25/2008 | 45 | 0 | 0 |
Preview

Basic Game Theory and AI Search

andrew 5/22/2008 | 93 | 4 | 0 |
Preview

c-sharp language specification[1]

andrew 4/7/2008 | 157 | 15 | 0 | financial
Preview

Classifying and Modeling Exceptions through Object Process Methodology[1]

andrew 4/7/2008 | 174 | 5 | 0 | financial
Preview

Peace_in_Islam

andrew 4/1/2008 | 241 | 6 | 1 |
Preview

String Theory - A Quest for a Unified Theory

andrew 3/20/2008 | 216 | 10 | 0 | educational
Preview

intro to string theory

andrew 3/20/2008 | 196 | 8 | 0 | educational
Preview

Live Migration of Virtual Machines

andrew 2/22/2008 | 242 | 5 | 0 | technology
 
review this doc