Equity Valuation in R
Cliff Ang
Senior Vice President, Compass Lexecon
There are two types of stocks firms issue: preferred stocks and common stocks
Many preferred and common stocks pay dividends
Constant Dividend Stream
$ V = div_{t+1} / k $
Suppose $div_{t+1}$ = $ \$50 $ and $k$ = 6.25%.
div <- 50
k <- 0.0625
div / k
800
Dividend with Constant Growth
$ V = div_{t+1} / (k - g) $
Suppose $div_{t+1}$ = $ \$50 $, $k$ = 6.25%, and $g$ = 2%.
div <- 50
k <- 0.0625
g <- 0.02
div / (k - g)
1176.471
Mathematically:
$$ V = 0 + (div_{T+1} / (k - g)) * (1 / (1 + k)^{T}) $$
Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ... |
---|---|---|---|---|---|---|---|---|
Dividends | 0 | 0 | 0 | 0 | 0 | $50 | $51 | ... |
div6 <- 50
g <- 0.02
k <- 0.0625
0 + (div6 / (k - g)) * (1 / (1 + k)^6)
817.7253
Equity Valuation in R