Company Data Analysis - PPT Only

Deonpalmgrove
GroupProject.xlsx

VZ

Verizon (VZ))
Quarter Date Revenue SG&A
1 3/30/90 3019.0 845.7
2 6/29/90 3076.0 849.1
3 9/28/90 3099.0 891.3
4 12/31/90 3105.0 964.0
5 3/29/91 2996.0 787.8
6 6/28/91 3081.0 842.1
7 9/30/91 3104.0 899.8
8 12/31/91 3099.0 989.3
9 3/31/92 3019.0 818.6
10 6/30/92 3149.0 921.3
11 9/30/92 3167.0 876.5
12 12/31/92 3254.0 1135.0
13 3/31/93 3163.0 871.7
14 6/30/93 3220.0 831.8
15 9/30/93 3290.0 875.2
16 12/31/93 3317.0 1041.0
17 3/31/94 3373.0 927.9
18 6/30/94 3394.0 918.7
19 9/30/94 3415.0 913.4
20 12/30/94 3609.0 1573.0
21 3/31/95 3450.0 1034.0
22 6/30/95 3564.0 1061.0
23 9/29/95 3261.0 1035.0
24 12/29/95 3265.0 5682.0
25 3/31/96 3208.0 788.0
26 6/30/96 3224.0 981.8
27 9/30/96 7377.0 2182.0
28 12/31/96 7405.0 2112.0
29 3/31/97 7416.0 2470.0
30 6/30/97 7708.0 2149.0
31 9/30/97 7374.0 2338.0
32 12/31/97 7696.0 2090.0
33 3/31/98 7651.0 2304.0
34 6/30/98 7928.0 2414.0
35 9/30/98 7910.0 2792.0
36 12/31/98 8077.0 2054.0
37 3/31/99 7967.0 2018.0
38 6/30/99 14510.0
39 9/30/99 14660.0
40 12/31/99 15260.0
41 3/31/00 14530.0
42 6/30/00 16770.0
43 9/30/00 16530.0
44 12/31/00 16870.0
45 3/31/01 16270.0
46 6/30/01 16910.0
47 9/30/01 17000.0
48 12/31/01 17010.0
49 3/31/02 16430.0 4945.0
50 6/30/02 16750.0 5793.0
51 9/30/02 17110.0 5204.0
52 12/31/02 16910.0 5883.0
53 3/31/03 16490.0 4292.0
54 6/30/03 16830.0 5673.0
55 9/30/03 17060.0 4891.0
56 12/31/03 17200.0 10070.0
57 3/31/04 17060.0 5675.0
58 6/30/04 17760.0 5000.0
59 9/30/04 18210.0 5132.0
60 12/31/04 12730.0 3539.0
61 3/31/05 18180.0 5214.0
62 6/30/05 18050.0 5110.0
63 9/30/05 18490.0 5195.0
64 12/31/05 15300.0 4061.0
65 3/31/06 21230.0 5873.0
66 6/30/06 21890.0 6353.0
67 9/30/06 22460.0 6384.0
68 12/31/06 22610.0 6345.0
69 3/31/07 22580.0 6343.0
70 6/30/07 23270.0 6320.0
71 9/30/07 23770.0 6349.0
72 12/31/07 23840.0 6955.0
73 3/31/08 23830.0 6401.0
74 6/30/08 24120.0 6528.0
75 9/30/08 24750.0 6879.0
76 12/31/08 24640.0 7090.0
77 3/31/09 26590.0 7561.0
78 6/30/09 26860.0 7871.0
79 9/30/09 27260.0 8111.0
80 12/31/09 27090.0 7174.0
81 3/31/10 26910.0 7698.0
82 6/30/10 26770.0 9970.0
83 9/30/10 26480.0 8407.0
84 12/31/10 26400.0 5291.0
85 3/31/11 26990.0 7284.0
86 6/30/11 27540.0 7373.0
87 9/30/11 27910.0 7689.0
88 12/31/11 28440.0 13280.0
89 3/31/12 28240.0 7700.0
90 6/30/12 28550.0 7877.0
91 9/30/12 29010.0 8366.0
92 12/31/12 30040.0 16010.0
93 3/31/13 29420.0 8148.0
94 6/30/13 29790.0 8047.0
95 9/30/13 30280.0 8037.0
96 12/31/13 31060.0 2857.0
97 3/31/14 30820.0 8332.0
98 6/30/14 31480.0 7550.0
99 9/30/14 31590.0 8277.0
100 12/31/14 33190.0 16860.0
101 3/31/15 31980.0 7939.0
102 6/30/15 32220.0 7974.0
103 9/30/15 33160.0 8309.0
104 12/31/15 34250.0 5764.0
105 3/31/16 32170.0 7600.0
106 6/30/16 30530.0 9775.0
107 9/30/16 30940.0 8226.0
108 12/31/16 32340.0 5968.0
109 3/31/17 29810.0 6908.0
110 6/30/17 30550.0 6039.0
111 9/30/17 31720.0 7632.0

Verizon Revenue 1990 - 2017

Revenue 32962 33053 33144 33238 33326 33417 33511 33603 33694 33785 33877 33969 34059 34150 34242 34334 34424 34515 34607 34698 34789 34880 34971 35062 35155 35246 35338 35430 35520 35611 35703 35795 35885 35976 36068 36160 36250 36341 36433 36525 36616 36707 36799 36891 36981 37072 37164 37256 37346 37437 37529 37621 37711 37802 37894 37986 38077 38168 38260 38352 38442 38533 38625 38717 38807 38898 38990 39082 39172 39263 39355 39447 39538 39629 39721 39813 39903 39994 40086 40178 40268 40359 40451 40543 40633 40724 40816 40908 40999 41090 41182 41274 41364 41455 41547 41639 41729 41820 41912 42004 42094 42185 42277 42369 42460 42551 42643 42735 42825 42916 43008 3019 3076 3099 3105 2996 3081 3104 3099 3019 3149 3167 3254 3163 3220 3290 3317 3373 3394 3415 3609 3450 3564 3261 3265 3208 3224 7377 7405 7416 7708 7374 7696 7651 7928 7910 8077 7967 14510 14660 15260 14530 16770 16530 16870 16270 16910 17000 17010 16430 16750 17110 16910 16490 16830 17060 17200 17060 17760 18210 12730 18180 18050 18490 15300 21230 21890 22460 22610 22580 23270 23770 23840 23830 24120 24750 24640 26590 26860 27260 27090 26910 26770 26480 26400 26990 27540 27910 28440 28240 28550 29010 30040 29420 29790 30280 31060 30820 31480 31590 33190 31980 32220 33160 34250 32170 30530 30940 32340.000000000004 29810 30550 31720 Revenue 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 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 101 102 103 104 105 106 107 108 109 110 111 3019 3076 3099 3105 2996 3081 3104 3099 3019 3149 3167 3254 3163 3220 3290 3317 3373 3394 3415 3609 3450 3564 3261 3265 3208 3224 7377 7405 7416 7708 7374 7696 7651 7928 7910 8077 7967 14510 14660 15260 14530 16770 16530 16870 16270 16910 17000 17010 16430 16750 17110 16910 16490 16830 17060 17200 17060 17760 18210 12730 18180 18050 18490 15300 21230 21890 22460 22610 22580 23270 23770 23840 23830 24120 24750 24640 26590 26860 27260 27090 26910 26770 26480 26400 26990 27540 27910 28440 28240 28550 29010 30040 29420 29790 30280 31060 30820 31480 31590 33190 31980 32220 33160 34250 32170 30530 30940 32340.000000000004 29810 30550 31720

Population

FRED Graph Observations
Federal Reserve Economic Data
Link: https://research.stlouisfed.org/fred2
Help: https://research.stlouisfed.org/fred2/help-faq
Economic Research Division
Federal Reserve Bank of St. Louis
Working Age Population 15 to 64
LFWA64TTUSQ647N
Frequency: Quarterly Not Seasoonally Adjusted
observation_date LFWA64TTUSQ647N Revenue Working Age Population 15-64
3/30/90 159722333 3019.0 159722333
6/29/90 160045333 3076.0 160045333
9/28/90 160454000 3099.0 160454000
12/31/90 160719667 3105.0 160719667
3/29/91 161026333 2996.0 161026333
6/28/91 161364000 3081.0 161364000
9/30/91 161788667 3104.0 161788667
12/31/91 162074667 3099.0 162074667
3/31/92 162369000 3019.0 162369000
6/30/92 162801000 3149.0 162801000
9/30/92 163261667 3167.0 163261667
12/31/92 163609333 3254.0 163609333
3/31/93 163956000 3163.0 163956000
6/30/93 164385000 3220.0 164385000
9/30/93 164864333 3290.0 164864333
12/31/93 165234000 3317.0 165234000
3/31/94 165582333 3373.0 165582333
6/30/94 165951333 3394.0 165951333
9/30/94 166439333 3415.0 166439333
12/30/94 166582667 3609.0 166582667
3/31/95 166903667 3450.0 166903667
6/30/95 167306333 3564.0 167306333
9/29/95 167753333 3261.0 167753333
12/29/95 168093000 3265.0 168093000
3/31/96 168607000 3208.0 168607000
6/30/96 169081333 3224.0 169081333
9/30/96 169575667 7377.0 169575667
12/31/96 170458000 7405.0 170458000
3/31/97 170924000 7416.0 170924000
6/30/97 171343333 7708.0 171343333
9/30/97 171851000 7374.0 171851000
12/31/97 172233667 7696.0 172233667
3/31/98 172728333 7651.0 172728333
6/30/98 173183333 7928.0 173183333
9/30/98 173785333 7910.0 173785333
12/31/98 174507667 8077.0 174507667
3/31/99 174988000 7967.0 174988000
6/30/99 175480000 14510.0 175480000
9/30/99 176100667 14660.0 176100667
12/31/99 178274333 15260.0 178274333
3/31/00 178789333 14530.0 178789333
6/30/00 179399667 16770.0 179399667
9/30/00 179977667 16530.0 179977667
12/31/00 180499333 16870.0 180499333
3/31/01 181074333 16270.0 181074333
6/30/01 181771000 16910.0 181771000
9/30/01 182338000 17000.0 182338000
12/31/01 182898000 17010.0 182898000
3/31/02 183448000 16430.0 183448000
6/30/02 184092000 16750.0 184092000
9/30/02 184609000 17110.0 184609000
12/31/02 185983333 16910.0 185983333
3/31/03 186586333 16490.0 186586333
6/30/03 187223667 16830.0 187223667
9/30/03 187864333 17060.0 187864333
12/31/03 187892333 17200.0 187892333
3/31/04 188434333 17060.0 188434333
6/30/04 189023667 17760.0 189023667
9/30/04 189642000 18210.0 189642000
12/31/04 190112667 12730.0 190112667
3/31/05 190664333 18180.0 190664333
6/30/05 191288667 18050.0 191288667
9/30/05 191991000 18490.0 191991000
12/31/05 192357667 15300.0 192357667
3/31/06 192876000 21230.0 192876000
6/30/06 193490000 21890.0 193490000
9/30/06 194082000 22460.0 194082000
12/31/06 194867667 22610.0 194867667
3/31/07 195352667 22580.0 195352667
6/30/07 195918333 23270.0 195918333
9/30/07 196417333 23770.0 196417333
12/31/07 195939667 23840.0 195939667
3/31/08 196354667 23830.0 196354667
6/30/08 196867000 24120.0 196867000
9/30/08 197345000 24750.0 197345000
12/31/08 197190000 24640.0 197190000
3/31/09 197548333 26590.0 197548333
6/30/09 198032667 26860.0 198032667
9/30/09 198442000 27260.0 198442000
12/31/09 198548333 27090.0 198548333
3/31/10 198896333 26910.0 198896333
6/30/10 199311667 26770.0 199311667
9/30/10 199736667 26480.0 199736667
12/31/10 199440000 26400.0 199440000
3/31/11 199802333 26990.0 199802333
6/30/11 200087667 27540.0 200087667
9/30/11 200225667 27910.0 200225667
12/31/11 201204333 28440.0 201204333
3/31/12 201357333 28240.0 201357333
6/30/12 201485333 28550.0 201485333
9/30/12 201614000 29010.0 201614000
12/31/12 201975000 30040.0 201975000
3/31/13 202173333 29420.0 202173333
6/30/13 202371000 29790.0 202371000
9/30/13 202551000 30280.0 202551000
12/31/13 202676667 31060.0 202676667
3/31/14 202858333 30820.0 202858333
6/30/14 203110333 31480.0 203110333
9/30/14 203303667 31590.0 203303667
12/31/14 203965000 33190.0 203965000
3/31/15 203965000 31980.0 203965000
6/30/15 204139000 32220.0 204139000
9/30/15 204443000 33160.0 204443000
12/31/15 204620000 34250.0 204620000
3/31/16 205157000 32170.0 205157000
6/30/16 205368000 30530.0 205368000
9/30/16 205636000 30940.0 205636000
12/31/16 205851000 32340.0 205851000
3/31/17 205330000 29810.0 205330000
6/30/17 205421000 30550.0 205421000
9/30/17 205644000 31720.0 205644000

Working Age Population and Verizon Revenue

Revenue 159722333.33333299 160045333.33333299 160454000 160719666.66666701 161026333.33333299 161364000 161788666.66666701 162074666.66666701 162369000 162801000 163261666.66666701 163609333.33333299 163956000 164385000 164864333.33333299 165234000 165582333.33333299 165951333.33333299 166439333.33333299 166582666.66666701 166903666.66666701 167306333.33333299 167753333.33333299 168093000 168607000 169081333.33333299 169575666.66666701 170458000 170924000 171343333.33333299 171851000 172233666.66666701 172728333.33333299 173183333.33333299 173785333.33333299 174507666.66666701 174988000 175480000 176100666.66666701 178274333.33333299 178789333.33333299 179399666.66666701 179977666.66666701 180499333.33333299 181074333.33333299 181771000 182338000 182898000 183448000 184092000 184609000 185983333.33333299 186586333.33333299 187223666.66666701 187864333.33333299 187892333.33333299 188434333.33333299 189023666.66666701 189642000 190112666.66666701 190664333.33333299 191288 666.66666701 191991000 192357666.66666701 192876000 193490000 194082000 194867666.66666701 195352666.66666701 195918333.33333299 196417333.33333299 195939666.66666701 196354666.66666701 196867000 197345000 197190000 197548333.33333299 198032666.66666701 198442000 198548333.33333299 198896333.33333299 199311666.66666701 199736666.66666701 199440000 199802333.33333299 200087666.66666701 200225666.66666701 201204333.33333299 201357333.33333299 201485333.33333299 201614000 201975000 202173333.33333299 202371000 202551000 202676666.66666701 202858333.33333299 203110333.33333299 203303666.66666701 203965000 203965000 204139000 204443000 204620000 205157000 205368000 205636000 205851000 205330000 205421000 205644000 3019 3076 3099 3105 2996 3081 3104 3099 3019 3149 3167 3254 3163 3220 3290 3317 3373 3394 3415 3609 3450 3564 3261 3265 3208 3224 7377 7405 7416 7708 7374 7696 7651 7928 7910 8077 7967 14510 14660 15260 14530 16770 16530 16870 16270 16910 17000 17010 16430 16750 17110 16910 16490 16830 17060 17200 17060 17760 18210 12730 18180 18050 18490 15300 21230 21890 22460 22610 22580 23270 23770 23840 23830 24120 24750 24640 26590 26860 27260 27090 26910 26770 26480 26400 26990 27540 27910 28440 28240 28550 29010 30040 29420 29790 30280 31060 30820 31480 31590 33190 31980 32220 33160 34250 32170 30530 30940 32340.000000000004 29810 30550 31720

Working Age Population 15-64

Verizon Revenue

Verizon Revenue and Working Age Population

Working Age Population 15-64 3019 3076 3099 3105 2996 3081 3104 3099 3019 3149 3167 3254 3163 3220 3290 3317 3373 3394 3415 3609 3450 3564 3261 3265 3208 3224 7377 7405 7416 7708 7374 7696 7651 7928 7910 8077 7967 14510 14660 15260 14530 16770 16530 16870 16270 16910 17000 17010 16430 16750 17110 16910 16490 16830 17060 17200 17060 17760 18210 12730 18180 18050 18490 15300 21230 21890 22460 22610 22580 23270 23770 23840 23830 24120 24750 24640 26590 26860 27260 27090 26910 26770 26480 26400 26990 27540 27910 28440 28240 28550 29010 30040 29420 29790 30280 31060 30820 31480 31590 33190 31980 32220 33160 34250 32170 30530 30940 32340.000000000004 29810 30550 31720 159722333.33333299 160045333.33333299 160454000 160719666.66666701 161026333.33333299 161364000 161788666.66666701 162074666.66666701 162369000 162801000 163261666.66666701 163609333.33333299 163956000 164385000 164864333.33333299 165234000 165582333.33333299 165951333.33333299 166439333.33333299 166582666.66666701 166903666.66666701 167306333.33333299 167753333.33333299 168093000 168607000 169081333.33333299 169575666.66666701 170458000 170924000 171343333.33333299 171851000 172233666.66666701 172728333.33333299 173183333.33333299 173785333.33333299 174507666.66666701 174988000 175480000 176100666.66666701 178274333.33333299 178789333.33333299 179399666.66666701 179977666.66666701 180499333.33333299 181074333.33333299 181771000 182338000 182898000 183448000 184092000 184609000 185983333.33333299 186586333.33333299 187223666.66666701 187864333.33333299 187892333.33333299 188434333.33333299 189023666.66666701 189642000 190112666.66666701 190664333.33333299 191288666.66666701 191991000 192357666.66666701 192876000 193490000 194082000 194867666.66666701 195352666.66666701 195918333.33333299 196417333.33333299 195939666.66666701 196354666.66666701 196867000 197345000 197190000 197548333.33333299 198032666.66666701 198442000 198548333.33333299 198896333.33333299 199311666.66666701 199736666.66666701 199440000 199802333.33333299 200087666.66666701 200225666.66666701 201204333.33333299 201357333.33333299 201485333.33333299 201614000 201975000 202173333.33333299 202371000 202551000 202676666.66666701 202858333.33 333299 203110333.33333299 203303666.66666701 203965000 203965000 204139000 204443000 204620000 205157000 205368000 205636000 205851000 205330000 205421000 205644000