ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Discounted Cash Flow Example - Pretzels Unlimited - Present Value
2
3
YearCash FlowsPresent Value MultiplierPresent Value of Cash FlowComments $ 22.00 Current Market Price
4
2025 $ 2.00 0.893 $ 1.786 $2.00 dividend12% Required Rate of Return
5
2026 $ 2.20 0.797 $ 1.754 $2.20 dividend
We expect to receive the dividends as described and
6
2027 $ 2.30 0.712 $ 1.637 $2.30 dividend
we expect the stock price to be $27 at the end of 2027.
7
2028 $ 29.30 0.636 $ 18.621 $2.30 dividend + $27 proceeds from sale of stock
8
9
Total: $ 23.80 Present value of stock =SUM(discounted-cash-flows)
The "discounted-cash-flows" are in cells E4 through E7
10
11
Present Value Multiplier = 1 / (1+Rate)Time
Yes, this is potentially a good investment for us. We
12
calculate that the present value of the future cash
13
Note: Only enter numbers into the shaded cells. Unshaded cells are formulas.
flows from the dividends and the sale of the stock is
14
approximately $23.80. However, the market price is only
15
Q) Why is the spreadsheet's final value differ by a few cents from our manual calculation?
$22.00. We can buy $23.80 of value for only $22.
16
A) Because the spreadsheet's present value multipliers have more precision than our table.
17
But always remember, we are simply identifying good
18
potential investments. We must do much more research
19
and exercise sound judgment when selecting a company
20
a company to invest in.
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100