ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
3
4
Amazon
5
6
Year012345678910
7
Cash flow5,0006,3007,93810,00212,60215,87920,00825,20931,76440,02350,428
8
Discounted value05,8336,8067,9409,26310,80712,60814,70917,16120,02123,358
9
10
Terminal939,803
11
Discounted435,310
12
Inputs
13
Discount rate8%
14
Starting free cash flow ($ million)5,000
15
Forecast period growth26.0%
16
Terminal growth2.5%
17
18
Present value of forecast period128,507
19
Present value of terminal period435,310
20
Calculated Present Value ($ million)563,817
21
Market Value (end 2020)600,000
22
23
Upside / Downside-6.03%
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