GS-Test
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEFGHIJK
1
2
3
Big 5
4
AverageROICSales GrowthEPS GrowthBVPS Growth Free Cash Flow GrowthYears to Repay Debt
5
11.5%Invalid DataInvalid DataInvalid DataInvalid Data#VALUE!
6
LCI5#ERROR!Invalid DataInvalid DataInvalid Data
7
DeckSIRI9#ERROR!Invalid DataInvalid DataInvalid DataN/A
8
ExchangeUS
9
Sticker PricePayback Time
10
EPS (ttm)3.780.0EPS (ttm)3.79
11
Current Stock Price
12
Estimated EPS Growth#VALUE!---------------------------→19.0%
13
Historical BVPS Growth22.5%Estimated EPS Growth33.7%
14
User Input Growth19.0%User Input Growth8.6%
15
16
Historical PE0---------------------------→17Payback Time#N/AYears
17
PE from EPS Growth38.0
18
User Input PE17.0
19
20
10-Year EPS14.00* Please do NOT edit cells aside from B7, B8, E14, E18 and J14
21
Sticker Price#N/A
22
Template URLhttp://goo.gl/TY5iAEntry Price45.00Note: If you want a copy of this spreadsheet, click on File > Make a Copy
23
Version1.3Current Stock Price
24
Safety Factor2.00
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
Loading...
 
 
 
Stock
Sheet91
Big 5
Sticker Price
Copy of Stock
Sheet81
Stock List
Payback Time
10-year Statement
10-year Ratios
Sheet87
Sheet88
Sheet90
Sheet89
Sheet86
Sheet85
Sheet84
Sheet83
Sheet82
Estimates
Copy of Cash Flow
Stock Name
Stock Price
Sheet68
Noteworthy
Sheet69
Income Statement
Tutorial
Version History
Sheet80