ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
1. If you do not have GuruFocus Tools installed, please install the add-on at https://www.gurufocus.com/google-sheets-add-on
2
2. You can download this template at https://drive.google.com/drive/folders/1f-uK_5VJvLffk1fXJqE7oxeDulMVkOAY.
3
Make sure to click File -> Make A Copy of this template into your Google Drive before using.
4
3. Enter the stock ticker in Cell B9. Do not change the formulas in any other cell.
5
4. This template retrieves historical price and fundamental data for the stock, including GF Score and its five ranking components.
6
You can add additional financial calculations in Cells G51 to H68.
7
Stock Summary Template
You can read more about our GF Score calculation here: https://www.gurufocus.com/term/gf_score/NAS:AAPL/GF-Score/Apple
8
9
10
Ticker:AAPLGF Score96/100
11
Current Price:USD 173.64
12
CompanyApple Inc
13
Sector#ERROR!
14
IndustryHardware
15
Predictability5
16
17
Profitability10/10
18
GF Value5/10
19
Momentum10/10
20
Financial strength7/10
21
Growth10/10
22
23
24
Financial strength7/10Profitability rank10/10GF Value rank5/10
25
Cash-to-debt0.57Operating margin %29.23Day's change %0.73
26
Cash-to-debt (10y low)0.4Operating margin % (10y low)24.15GF Value176.39
27
Cash-to-debt (10y high)2.44Operating margin % (10y high)30.48Price-to-GF-Value0.98
28
% above 10y low42.5% above 10y low21.04
29
% above 10y high76.64% above 10y high4.1
30
5-year Operating margin growth rate2.7
31
PE ratio29.19
32
Equity-to-asset0.18Net margin %24.68PE ratio (10y low)9.32
33
Equity-to-asset (10y low)
0.14Net margin % (10y low)20.91PE ratio (10y high)40.36
34
Equity-to-asset (10y high)
0.6Net margin % (10y high)25.88% above 10y low213.2
35
% above 10y low28.57% above 10y low18.03% above 10y high27.68
36
% above 10y high70% above 10y high4.64
37
38
Debt-to-equity1.81ROE %164.55PB ratio45.11
39
Debt-to-equity (10y low)
0.13ROE % (10y low)30.64PB ratio (10y low)2.71
40
Debt-to-equity (10y high)
2.37ROE % (10y high)175.46PB ratio (10y high)50.84
41
% above 10y low1292.31% above 10y low437.04% above 10y low1564.58
42
% above 10y high23.63% above 10y high6.22% above 10y high11.27
43
44
Debt-to-Ebitda0.86ROA %27.82PS ratio7.32
45
Debt-to-Ebitda (10y low)
0.3ROA % (10y low)13.87PS ratio (10y low)2.19
46
Debt-to-Ebitda (10y high)
1.51ROA % (10y high)28.36PS ratio (10y high)8.44
47
% above 10y low186.67% above 10y low100.58% above 10y low234.25
48
% above 10y high43.05% above 10y high1.9% above 10y high13.27
49
50
Growth rank10/10Momentum rank10/10You can add additional fields in the table below:
51
3-year revenue growth rate (per share)
206-1 month momentum %14.02
52
3-year revenue growth rate (10y high)
51.812-1 month momentum %33
53
3-year revenue growth rate (10y low)
-26.7Beta1.25
54
% above 10y low-61.39
55
% above 10y high174.911-week total return %1.9
56
1-week relative to S&P total return %2.23
57
58
3-year Ebitda growth rate (per share)
22.81-month total return %-8.34
59
3-year Ebitda growth rate (10y low)
-51.91-month relative to S&P total return %-2.46
60
3-year Ebitda growth rate (10y high)
149.7
61
% above 10y low-143.933-month total return %-9.65
62
% above 10y high84.773-month relative to S&P total return %-5.34
63
64
3-year EPS without NRI growth rate
27.26-month total return %5.13
65
3-year EPS without NRI growth rate (10y low)
-57.56-month relative to S&P total return %1.22
66
3-year EPS without NRI growth rate (10y high)
200
67
% above 10y low-147.312-month total return %19.57
68
% above 10y high86.412-month relative to S&P total return %7.22
69
70
71
Historical Price:
72
2018-10-0457
73
2018-10-0556.07
74
2018-10-0855.94
75
2018-10-0956.72
76
2018-10-1054.09
77
2018-10-1153.61
78
2018-10-1255.53
79
2018-10-1554.34
80
2018-10-1655.54
81
2018-10-1755.3
82
2018-10-1854.01
83
2018-10-1954.83
84
2018-10-2255.16
85
2018-10-2355.68
86
2018-10-2453.77
87
2018-10-2554.95
88
2018-10-2654.08
89
2018-10-2953.06
90
2018-10-3053.33
91
2018-10-3154.72
92
2018-11-0155.56
93
2018-11-0251.87
94
2018-11-0550.4
95
2018-11-0650.94
96
2018-11-0752.49
97
2018-11-0852.12
98
2018-11-0951.12
99
2018-11-1248.54
100
2018-11-1348.06