DCF Calculator - v2.0
 Share
 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Click File > Make a copy.. to start using this spreadsheet
2
3
TickerIntrinsic Value
4
CPAAnalyze US listed companies by filling in their ticker symbol on the left#REF!
More spreadsheets on
5
valuespreadsheet.com
6
Company info
7
NameCopa Holdings, S.A.
8
Industry#N/A
9
Market Cap (mil)$4,748
10
ExchangeNYSE
11
12
Inputs
13
Cash and Short Term Investments
#REF!
14
Cash from Operating Activities#REF!
15
Capital Expenditures#REF!
16
Free cash flow (mil $)#REF!
17
Shares outstanding (mil)$42
18
Return on Equity#REF!
19
Growth rate95.70%
20
Margin of Safety25.00%
21
Conservative growth rate71.78%
22
Growth decline rate5.00%
23
Discount rate9.00%
24
Valuation last FCF12
25
26
Calculations
27
Year
FCF * Growth rate
NPV FCF
28
1#REF!#REF!
29
2#REF!#REF!
30
3#REF!#REF!
31
4#REF!#REF!
32
5#REF!#REF!
33
6#REF!#REF!
34
7#REF!#REF!
35
8#REF!#REF!
36
9#REF!#REF!
37
10#REF!#REF!
38
39
Total NPV FCF#REF!
40
Year 10 FCF value
#REF!
41
Cash on Hand#REF!
42
Total Debt$0.00
43
Company value:#REF!
44
45
Creation date:
46
11/25/2014 12:44:00
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
Loading...
 
 
 
DCF Valuation