Verizon Communications Inc.: Horizontal Analysis
Verizon Communications Inc.: Horizontal Analysis
Verizon Communications Inc.: Horizontal Analysis
Horiz
Inc
Income Statement (In Thousands $) 2016 (base year)
Ratio A
Ratio
Liquidity 2016
Current Ratio 87.00%
Acid-Test Ratio 83.04%
Cash Ratio 9.49%
Activity
Inventory Turnover 44
Fixed Asset Turnover 148.65%
Total Asset Turnover 51.59%
Debt
Times Interest Earned 9.46
Debt Ratio 90.16%
Debt-Equity Ratio 825.61%
Profitability
Gross Profit Margin 58.17%
Net Profit Margin 19.40%
Return on Investment/Asset 10.01%
Earnings per Share $57.65
Du Pont Analysis
Profit Margin 19%
Total Asset Turnover 0.52
Financial Leverage 10.16
Return on Equity 102%
Verizon Communications Inc.
Horizontal Analysis
Income Statement
Increase or Decrease
2017 2018
Variance Percentages
$ 126,034,000.00 $ 54,000.00 0.04% $ 130,863,000.00
$ 53,063,000.00 $ 362,000.00 0.69% $ 55,508,000.00
$ 72,971,000.00 $ (308,000.00) -0.42% $ 75,355,000.00
$ 22,147,000.00 $ (5,955,000.00) -21.19% $ 31,083,000.00
$ 50,824,000.00 $ 5,647,000.00 12.50% $ 44,272,000.00
$ 2,021,000.00 $ (1,768,000.00) -46.66% $ 2,364,000.00
$ 48,803,000.00 $ 7,415,000.00 17.92% $ 46,636,000.00
$ (4,733,000.00) $ (357,000.00) 8.16% $ -4,833,000.00
$ 44,070,000.00 $ 7,058,000.00 19.07% $ 51,469,000.00
$ 7,376,000.00 $ (5,193,000.00) -41.32% $ 4,877,000.00
$ 36,694,000.00 $ 12,251,000.00 50.12% $ 46,592,000.00
$ 36,694,000.00 $ 12,251,000.00 50.12% $ 46,592,000.00
$ 424,000.00 $ - 0.00% $ 429,000.00
$ 37,118,000.00 $ 12,251,000.00 49.27% $ 47,021,000.00
Balance Sheet
Increase or Decrease
2017 2018
Variance Percentages
$ 2,079,000.00 $ (801,000.00) -27.81% $ 2,745,000.00
$ 23,493,000.00 $ 5,980,000.00 34.15% $ 25,102,000.00
$ 1,034,000.00 $ (168,000.00) -13.98% $ 1,336,000.00
$ 3,307,000.00 $ (1,493,000.00) -31.10% $ 5,453,000.00
$ 29,913,000.00 $ 3,518,000.00 13.33% $ 34,636,000.00
$ 88,568,000.00 $ 3,817,000.00 4.50% $ 89,286,000.00
$ 88,417,000.00 $ 1,744,000.00 2.01% $ 94,130,000.00
$ 29,172,000.00 $ 1,967,000.00 7.23% $ 24,614,000.00
$ - $ (613,000.00) -100.00% $ -
$ 10,247,000.00 $ 240,000.00 2.40% $ 9,775,000.00
$ 10,826,000.00 $ 2,290,000.00 26.83% $ 12,388,000.00
$ 257,143,000.00 $ 12,963,000.00 5.31% $ 264,829,000.00
$ 33,037,000.00 $ 2,697,000.00 8.89% $ 37,930,000.00
$ 113,642,000.00 $ 8,209,000.00 7.79% $ 105,873,000.00
$ 22,112,000.00 $ (4,054,000.00) -15.49% $ 18,599,000.00
$ 31,232,000.00 $ (14,732,000.00) -32.05% $ 33,795,000.00
$ - $ (6,000.00) -100.00% $ -
$ 12,433,000.00 $ 194,000.00 1.59% $ 13,922,000.00
$ 179,419,000.00 $ (10,389,000.00) -5.47% $ 172,189,000.00
Ratio Analysis
Ratio Industry Average
2017 2018 2016 2017
90.54% 91.32% 97.00% 95.67%
87.41% 87.79% 89.00% 88.67%
6.29% 7.24% 30.37% 32.86%
51 42 14 13
142.30% 146.57% 156.23% 161.58%
49.01% 49.41% 46.07% 44.29%
29% 36% 2% 9%
0.49 0.49 1.40 0.98
5.75 4.84 3.63 3.60
82% 85% 28% 43%
Increase or Decrease
Variance Percentages
$ 4,883,000.00 3.88%
$ 2,807,000.00 5.33%
$ 2,076,000.00 2.83%
$ 2,981,000.00 10.61%
$ (905,000.00) -2.00%
$ (1,425,000.00) -37.61%
$ 5,248,000.00 12.68%
$ (457,000.00) 10.44%
$ 14,457,000.00 39.06%
$ (7,692,000.00) -61.20%
$ 22,149,000.00 90.61%
$ 22,149,000.00 90.61%
$ 5,000.00 1.18%
$ 22,154,000.00 89.09%
Increase or Decrease
Variance Percentages
$ (135,000.00) -4.69%
$ 7,589,000.00 43.33%
$ 134,000.00 11.15%
$ 653,000.00 13.60%
$ 8,241,000.00 31.22%
$ 4,535,000.00 5.35%
$ 7,457,000.00 8.60%
$ (2,591,000.00) -9.52%
$ (613,000.00) -100.00%
$ (232,000.00) -2.32%
$ 3,852,000.00 45.13%
$ 20,649,000.00 8.46%
$ 7,590,000.00 25.02%
$ 440,000.00 0.42%
$ (7,567,000.00) -28.92%
$ (12,169,000.00) -26.48%
$ (6,000.00) -100.00%
$ 1,683,000.00 13.75%
$ (17,619,000.00) -9.28%
$ 5,000.00 1.18%
$ 2,255,000.00 20.17%
$ 28,483,000.00 189.14%
$ (303,000.00) -11.34%
$ 277,000.00 -3.81%
$ (96,000.00) -21.38%
$ 57,000.00 3.78%
$ 30,678,000.00 127.65%
$ 20,649,000.00 8.46%
verage
2018
97.67%
91.00%
72.67%
15
156.91%
43.26%
4.16
66.81%
197.81%
56.00%
13.70%
5.45%
$ 93.37
14%
1.21
3.02
43%
Verizon Communicatio
Vertical Analysis
Comparative Income Stateme
Income Statement (In Thousands $) 2016
Ratio Analysis
Ratio
Liquidity 2016
Current Ratio 76.00%
Acid-Test Ratio 76.00%
Cash Ratio 8.08%
Activity
Inventory Turnover
Fixed Asset Turnover 131.13%
Total Asset Turnover 40.56%
Debt
Times Interest Earned 5.02
Debt Ratio 69.51%
Debt-Equity Ratio 214.54%
Profitability
Gross Profit Margin 53.00%
Net Profit Margin 8.08%
Return on Investment/Asset 3.28%
Earnings per Share $2.04
Du Pont Analysis
Profit Margin 8%
Total Asset Turnover 3.24
Financial Leverage 3.28
Return on Equity 86%
AT&T
Horizontal Analysis
Income Statement
Increase or Decrease
2017 2018
Variance Percentages
$ 160,546,000.00 $ (3,240,000.00) -1.98% $ 170,756,000.00
$ 77,810,000.00 $ 620,000.00 0.80% $ 79,419,000.00
$ 82,736,000.00 $ (3,860,000.00) -4.46% $ 91,337,000.00
$ 63,053,000.00 $ - 0.00% $ 65,241,000.00
$ 19,683,000.00 $ (3,860,000.00) -16.40% $ 26,096,000.00
$ 1,597,000.00 $ 516,000.00 47.73% $ 6,782,000.00
$ 21,280,000.00 $ (3,344,000.00) -13.58% $ 32,878,000.00
$ 6,300,000.00 $ 1,390,000.00 28.31% $ 7,957,000.00
$ 14,980,000.00 $ (4,734,000.00) -24.01% $ 24,921,000.00
$ (14,708,000.00) $ (21,187,000.00) -327.01% $ 4,920,000.00
$ 29,688,000.00 $ 16,453,000.00 124.31% $ 20,001,000.00
$ 29,688,000.00 $ 16,453,000.00 124.31% $ 20,001,000.00
$ 6,495,000.00 $ - 0.00% $ 7,621,000.00
$ 36,183,000.00 $ 16,453,000.00 83.39% $ 12,380,000.00
Balance Sheet
Increase or Decrease
2017 2018
Variance Percentages
$ 50,498,000.00 $ 44,710,000.00 772.46% $ 5,204,000.00
$ 16,522,000.00 $ (272,000.00) -1.62% $ 26,472,000.00
$ - $ - 0 $ -
$ 12,126,000.00 $ (3,661,000.00) -23.19% $ 19,751,000.00
$ 79,146,000.00 $ 40,777,000.00 106.28% $ 51,427,000.00
$ 125,222,000.00 $ 323,000.00 0.26% $ 139,186,000.00
$ 1,560,000.00 $ (114,000.00) -6.81% $ 6,245,000.00
$ 105,449,000.00 $ 242,000.00 0.23% $ 146,370,000.00
$ 114,276,000.00 $ (2,584,000.00) -2.21% $ 146,758,000.00
$ 18,444,000.00 $ 1,632,000.00 9.71% $ 41,878,000.00
$ 444,097,000.00 $ 40,276,000.00 9.97% $ 531,864,000.00
$ 81,389,000.00 $ 30,813,000.00 60.92% $ 64,420,000.00
$ 125,972,000.00 $ 12,291,000.00 10.81% $ 166,250,000.00
$ 43,207,000.00 $ (16,921,000.00) -28.14% $ 57,859,000.00
$ 52,668,000.00 $ (3,633,000.00) -6.45% $ 59,246,000.00
$ 221,847,000.00 $ (8,263,000.00) -3.59% $ 283,355,000.00
$ 6,495,000.00 $ - 0.00% $ 7,621,000.00
$ 89,563,000.00 $ (41,000.00) -0.05% $ 125,525,000.00
$ 50,500,000.00 $ 15,766,000.00 45.39% $ 58,753,000.00
$ (12,714,000.00) $ (55,000.00) 0.43% $ (12,059,000.00)
$ 7,017,000.00 $ 2,056,000.00 41.44% $ 4,249,000.00
$ 140,861,000.00 $ 17,726,000.00 14.40% $ 184,089,000.00
$ 444,097,000.00 $ 40,276,000.00 9.97% $ 531,864,000.00
ysis
Ratio
2017 2018
97.00% 80.00%
97.00% 80.00%
62.05% 145.10%
128.21% 122.68%
36.15% 32.11%
3.38 4.13
68.28% 65.39%
206.91% 181.23%
52.00% 53.00%
18.49% 11.71%
6.69% 3.76%
$4.57 $2.62
18% 12%
1.97 2.65
3.15 2.89
115% 90%
Increase or Decrease
Variance Percentages
$ 6,970,000.00 4.26%
$ 2,229,000.00 2.89%
$ 4,741,000.00 5.47%
$ 2,188,000.00 3.47%
$ 2,553,000.00 10.84%
$ 5,701,000.00 527.38%
$ 8,254,000.00 33.52%
$ 3,047,000.00 62.06%
$ 5,207,000.00 26.41%
$ (1,559,000.00) -24.06%
$ 6,766,000.00 51.12%
$ 6,766,000.00 51.12%
$ 1,126,000.00 17.34%
$ (7,350,000.00) -37.25%
Increase or Decrease
Variance Percentages
$ (584,000.00) -10.09%
$ 9,678,000.00 57.63%
$ - 0
$ 3,964,000.00 25.11%
$ 13,058,000.00 34.03%
$ 14,287,000.00 11.44%
$ 4,571,000.00 273.06%
$ 41,163,000.00 39.13%
$ 29,898,000.00 25.58%
$ 25,066,000.00 149.10%
$ 128,043,000.00 31.71%
$ 13,844,000.00 27.37%
$ 52,569,000.00 46.24%
$ (2,269,000.00) -3.77%
$ 2,945,000.00 5.23%
$ 53,245,000.00 23.14%
$ 1,126,000.00 17.34%
$ 35,921,000.00 40.09%
$ 24,019,000.00 69.15%
$ 600,000.00 -4.74%
$ (712,000.00) -14.35%
$ 60,954,000.00 49.50%
$ 128,043,000.00 31.71%
AT&T
Vertical Analysis
Comparative Income Statement
Income Statement (In Thousands $) 2016
Percentages
Total Revenue $ 163,786,000.00 100.00%
Cost of Goods and Services $ 77,190,000.00 47.13%
Gross Profit $ 86,596,000.00 52.87%
Selling, General, and Administration $ 63,053,000.00 38.50%
Operating Income $ 23,543,000.00 14.37%
Additional Income/Expense $ 1,081,000.00 0.66%
Earnings before Interest and Tax $ 24,624,000.00 15.03%
Interest Expense $ 4,910,000.00 3.00%
Earnings before Tax $ 19,714,000.00 12.04%
Income Tax $ 6,479,000.00 3.96%
Net Income $ 13,235,000.00 8.08%
Net Income Applicable to Common Stock Holders $ 13,235,000.00 8.08%
Common Stock $ 6,495,000.00 3.97%
Retained Earnings $ 19,730,000.00 12.05%
Balance Sheet
Balance Sheet (In Thousands $) 2016 (base year)
Percentages
Cash and cash Equivalents $ 5,788,000.00 1.43%
Net recievables $ 16,794,000.00 4.16%
Inventories $ - 0.00%
Other Current Assets $ 15,787,000.00 3.91%
Total Current Assets $ 38,369,000.00 9.50%
Net Fixed Assets $ 124,899,000.00 30.93%
Long-term Investments $ 1,674,000.00 0.41%
Goodwill $ 105,207,000.00 26.05%
Other intangible assets $ 116,860,000.00 28.94%
Other Assets $ 16,812,000.00 4.16%
Total Assets $ 403,821,000.00 100.00%
Current Liabilities $ 50,576,000.00 12.52%
Long-term debt $ 113,681,000.00 28.15%
Deferred taxes $ 60,128,000.00 14.89%
Other liabilites $ 56,301,000.00 13.94%
Total long-term liabilities $ 230,110,000.00 56.98%
Common Stock $ 6,495,000.00 1.61%
Additional paid in capital $ 89,604,000.00 22.19%
Retained Earnings $ 34,734,000.00 8.60%
Treasury Stock $ (12,659,000.00) -3.13%
Other Equity $ 4,961,000.00 1.23%
Total Equity $ 123,135,000.00 30.49%
Total liabilities and equity $ 403,821,000.00 100.00%
AT&T
cal Analysis
ve Income Statement
2017 2018
Percentages Percentages
$ 126,034,000.00 100.00% $ 130,863,000.00 100.00%
$ 53,063,000.00 42.10% $ 55,508,000.00 42.42%
$ 72,971,000.00 57.90% $ 75,355,000.00 57.58%
$ 22,147,000.00 17.57% $ 31,083,000.00 23.75%
$ 50,824,000.00 40.33% $ 44,272,000.00 33.83%
$ 2,021,000.00 1.60% $ 2,364,000.00 1.81%
$ 48,803,000.00 38.72% $ 46,636,000.00 35.64%
$ (4,733,000.00) -3.76% $ 4,833,000.00 3.69%
$ 44,070,000.00 34.97% $ 41,803,000.00 31.94%
$ 7,376,000.00 5.85% $ 4,877,000.00 3.73%
$ 36,694,000.00 29.11% $ 36,926,000.00 28.22%
$ 36,694,000.00 29.11% $ 36,926,000.00 28.22%
$ 424,000.00 0.34% $ 429,000.00 0.33%
$ 37,118,000.00 29.45% $ 37,355,000.00 28.55%
lance Sheet
2017 2018
Percentages Percentages
$ 50,498,000.00 11.37% $ 5,204,000.00 0.98%
$ 16,522,000.00 3.72% $ 26,472,000.00 4.98%
$ - 0.00% $ - 0.00%
$ 12,126,000.00 2.73% $ 19,751,000.00 3.71%
$ 79,146,000.00 17.82% $ 51,427,000.00 9.67%
$ 125,222,000.00 28.20% $ 139,186,000.00 26.17%
$ 1,560,000.00 0.35% $ 6,245,000.00 1.17%
$ 105,449,000.00 23.74% $ 146,370,000.00 27.52%
$ 114,276,000.00 25.73% $ 146,758,000.00 27.59%
$ 18,444,000.00 4.15% $ 41,878,000.00 7.87%
$ 444,097,000.00 100.00% $ 531,864,000.00 100.00%
$ 81,389,000.00 18.33% $ 64,420,000.00 12.11%
$ 125,972,000.00 28.37% $ 166,250,000.00 31.26%
$ 43,207,000.00 9.73% $ 57,859,000.00 10.88%
$ 52,668,000.00 11.86% $ 59,246,000.00 11.14%
$ 221,847,000.00 49.95% $ 283,355,000.00 53.28%
$ 6,495,000.00 1.46% $ 7,621,000.00 1.43%
$ 89,563,000.00 20.17% $ 125,525,000.00 23.60%
$ 50,500,000.00 11.37% $ 58,753,000.00 11.05%
$ (12,714,000.00) -2.86% $ (12,059,000.00) -2.27%
$ 7,017,000.00 1.58% $ 4,249,000.00 0.80%
$ 140,861,000.00 31.72% $ 184,089,000.00 34.61%
$ 444,097,000.00 100.00% $ 531,864,000.00 100.00%
T-Mo
Horizontal
Income Sta
Income Statement (In Thousands $) 2016 (base year) 2017
Ratio Analysis
Ratio
Liquidity 2016 2017
Current Ratio 158.00% 77.00%
Acid-Test Ratio 145.00% 64.00%
Cash Ratio 60.96% 13.51%
Activity
Inventory Turnover 1489.65% 1130.78%
Fixed Asset Turnover 179.01% 182.93%
Total Asset Turnover 56.90% 57.54%
Debt
Times Interest Earned 2.41 2.89
Debt Ratio 72.32% 64.50%
Debt-Equity Ratio 261.32% 201.78%
Profitability
Gross Profit Margin 58.00% 56.00%
Net Profit Margin 4.17% 11.17%
Return on Investment/Asset 2.37% 6.43%
Earnings per Share
Du Pont Analysis
Profit Margin 4% 11%
Total Asset Turnover 0.57 0.58
Financial Leverage 3.61 3.13
Return on Equity 9% 20%
T-Mobile
Horizontal Analysis
Income Statement
Increase or Decrease Increase or Decrease
2018
Variance Percentages Variance
$ 3,114,000.00 8.31% $ 43,310,000.00 $ 5,820,000.00
$ 1,158,000.00 7.00% $ 18,354,000.00 $ 1,804,000.00
$ 1,956,000.00 9.34% $ 24,956,000.00 $ 4,016,000.00
$ 622,000.00 3.53% $ 19,647,000.00 $ 2,026,000.00
$ 1,334,000.00 40.19% $ 5,309,000.00 $ 1,990,000.00
$ (663,000.00) -78.74% $ (35,000.00) $ (877,000.00)
$ 671,000.00 16.13% $ 5,274,000.00 $ 1,113,000.00
$ (59,000.00) -3.41% $ 1,357,000.00 $ (373,000.00)
$ 730,000.00 30.03% $ 3,917,000.00 $ 1,486,000.00
$ (2,242,000.00) -258.59% $ 1,029,000.00 $ 162,000.00
$ 2,972,000.00 190.03% $ 2,888,000.00 $ 1,324,000.00
$ 2,972,000.00 190.03% $ 2,888,000.00 $ 1,324,000.00
$ - 0 $ - $ -
$ 2,972,000.00 190.03% $ 2,888,000.00 $ 1,324,000.00
Balance Sheet
Increase or Decrease Increase or Decrease
2018
Variance Percentages Variance
$ (4,281,000.00) -77.84% $ 1,203,000.00 $ (4,297,000.00)
$ 361,000.00 9.34% $ 4,318,000.00 $ 452,000.00
$ 455,000.00 40.95% $ 1,084,000.00 $ (27,000.00)
$ (1,837,000.00) -49.12% $ 1,676,000.00 $ (2,064,000.00)
$ (5,302,000.00) -37.29% $ 8,281,000.00 $ (5,936,000.00)
$ 1,253,000.00 5.98% $ 23,359,000.00 $ 2,416,000.00
$ 290,000.00 29.47% $ 1,547,000.00 $ 563,000.00
$ - 0.00% $ 1,901,000.00 $ 218,000.00
$ 8,193,000.00 29.91% $ 35,757,000.00 $ 8,367,000.00
$ 238,000.00 35.31% $ 1,623,000.00 $ 949,000.00
$ 4,672,000.00 7.09% $ 72,468,000.00 $ 6,577,000.00
$ - 0.00% $ 10,267,000.00 $ 1,245,000.00
$ (9,711,000.00) -44.48% $ 12,124,000.00 $ (9,708,000.00)
$ (1,297,000.00) -17.17% $ 7,253,000.00 $ (301,000.00)
$ 8,864,000.00 95.86% $ 18,106,000.00 $ 8,859,000.00
$ (2,144,000.00) -5.55% $ 37,483,000.00 $ (1,150,000.00)
$ - 0 $ - $ -
$ (217,000.00) -0.56% $ 38,010,000.00 $ (836,000.00)
$ 4,536,000.00 -22.01% $ (12,954,000.00) $ 7,656,000.00
$ (3,000.00) 300.00% $ (6,000.00) $ (5,000.00)
$ 7,000.00 700.00% $ (332,000.00) $ (333,000.00)
$ 4,323,000.00 23.71% $ 24,718,000.00 $ 6,482,000.00
$ 2,179,000.00 3.31% $ 72,468,000.00 $ 6,577,000.00
Ratio
2018
81.00%
70.00%
11.72%
1693.17%
185.41%
59.76%
3.89
65.89%
190.57%
56.00%
6.67%
3.99%
7%
0.60
2.93
12%
Co
Increase or Decrease
Income Statement (In Thousands $)
Percentages
15.52% Total Revenue
10.90% Cost of Goods and Services
19.18% Gross Profit
11.50% Selling, General, and Administration
59.96% Operating Income
-104.16% Additional Income/Expense
26.75% Earnings before Interest and Tax
-21.56% Interest Expense
61.13% Earnings before Tax
18.69% Income Tax
84.65% Net Income
84.65% Net Income Applicable to Common Stock Holders
0 Common Stock
84.65% Retained Earnings
Increase or Decrease
Balance Sheet (In Thousands $)
Percentages
-78.13% Cash and cash Equivalents
11.69% Net recievables
-2.43% Inventories
-55.19% Other Current Assets
-41.75% Total Current Assets
11.54% Net Fixed Assets
57.22% Long-term Investments
12.95% Goodwill
30.55% Other intangible assets
140.80% Other Assets
9.98% Total Assets
13.80% Current Liabilities
-44.47% Long-term debt
-3.98% Deferred taxes
95.80% Other liabilites
-2.98% Total long-term liabilities
0 Common Stock
-2.15% Additional paid in capital
-37.15% Retained Earnings
500.00% Treasury Stock
-33300.00% Other Equity
35.55% Total Equity
9.98% Total liabilities and equity
T-Mobile
Vertical Analysis
Comparative Income Statement
2016 2017
Percentages Percentages
$ 37,490,000.00 100.00% $ 40,604,000.00 100.00%
$ 16,550,000.00 44.15% $ 17,708,000.00 43.61%
$ 20,940,000.00 55.85% $ 22,896,000.00 56.39%
$ 17,621,000.00 47.00% $ 18,243,000.00 44.93%
$ 3,319,000.00 8.85% $ 4,653,000.00 11.46%
$ 842,000.00 2.25% $ 179,000.00 0.44%
$ 4,161,000.00 11.10% $ 4,832,000.00 11.90%
$ 1,730,000.00 4.61% $ 1,671,000.00 4.12%
$ 2,431,000.00 6.48% $ 3,161,000.00 7.78%
$ 867,000.00 2.31% $ (1,375,000.00) -3.39%
$ 1,564,000.00 4.17% $ 4,536,000.00 11.17%
$ 1,564,000.00 4.17% $ 4,536,000.00 11.17%
$ - 0.00% $ - 0.00%
$ 1,564,000.00 4.17% $ 4,536,000.00 11.17%
Balance Sheet
2016 (base year) 2017
Percentages Percentages
$ 5,500,000.00 8.35% $ 1,219,000.00 1.73%
$ 3,866,000.00 5.87% $ 4,227,000.00 5.99%
$ 1,111,000.00 1.69% $ 1,566,000.00 2.22%
$ 3,740,000.00 5.68% $ 1,903,000.00 2.70%
$ 14,217,000.00 21.58% $ 8,915,000.00 12.63%
$ 20,943,000.00 31.78% $ 22,196,000.00 31.46%
$ 984,000.00 1.49% $ 1,274,000.00 1.81%
$ 1,683,000.00 2.55% $ 1,683,000.00 2.39%
$ 27,390,000.00 41.57% $ 35,583,000.00 50.43%
$ 674,000.00 1.02% $ 912,000.00 1.29%
$ 65,891,000.00 100.00% $ 70,563,000.00 100.00%
$ 9,022,000.00 13.69% $ 9,022,000.00 13.25%
$ 21,832,000.00 33.13% $ 12,121,000.00 17.81%
$ 7,554,000.00 11.46% $ 6,257,000.00 9.19%
$ 9,247,000.00 14.03% $ 18,111,000.00 26.61%
$ 38,633,000.00 58.63% $ 36,489,000.00 53.61%
$ - 0.00% $ - 0.00%
$ 38,846,000.00 58.95% $ 38,629,000.00 56.75%
$ (20,610,000.00) -31.28% $ (16,074,000.00) -23.61%
$ (1,000.00) 0.00% $ (4,000.00) -0.01%
$ 1,000.00 0.00% $ 8,000.00 0.01%
$ 18,236,000.00 27.68% $ 22,559,000.00 33.14%
$ 65,891,000.00 100.00% $ 68,070,000.00 100.00%
2018
Percentages
$ 43,310,000.00 100.00%
$ 18,354,000.00 42.38%
$ 24,956,000.00 57.62%
$ 19,647,000.00 45.36%
$ 5,309,000.00 12.26%
$ (35,000.00) -0.08%
$ 5,274,000.00 12.18%
$ 1,357,000.00 3.13%
$ 3,917,000.00 9.04%
$ 1,029,000.00 2.38%
$ 2,888,000.00 6.67%
$ 2,888,000.00 6.67%
$ - 0.00%
$ 2,888,000.00 6.67%
2018
Percentages
$ 1,203,000.00 1.66%
$ 4,318,000.00 5.96%
$ 1,084,000.00 1.50%
$ 1,676,000.00 2.31%
$ 8,281,000.00 11.43%
$ 23,359,000.00 32.23%
$ 1,547,000.00 2.13%
$ 1,901,000.00 2.62%
$ 35,757,000.00 49.34%
$ 1,623,000.00 2.24%
$ 72,468,000.00 100.00%
$ 10,267,000.00 14.17%
$ 12,124,000.00 16.73%
$ 7,253,000.00 10.01%
$ 18,106,000.00 24.98%
$ 37,483,000.00 51.72%
$ - 0.00%
$ 38,010,000.00 52.45%
$ (12,954,000.00) -17.88%
$ (6,000.00) -0.01%
$ (332,000.00) -0.46%
$ 24,718,000.00 34.11%
$ 72,468,000.00 100.00%
S
Horizon
Incom
Income Statement (In Thousands $) 2016 (base year)
Ratio Analysis
Ratio
Liquidity 2016
Current Ratio 57.00%
Acid-Test Ratio 46.00%
Cash Ratio 22.08%
Activity
Inventory Turnover 1326.09%
Fixed Asset Turnover 158.55%
Total Asset Turnover 40.75%
Debt
Times Interest Earned 0.15
Debt Ratio 74.95%
Debt-Equity Ratio 292.67%
Profitability
Gross Profit Margin 52.00%
Net Profit Margin -6.20%
Return on Investment/Asset -2.53%
Earnings per Share -$49.88
Du Pont Analysis
Profit Margin -6%
Total Asset Turnover 0.41
Financial Leverage 3.99
Return on Equity -10%
Sprint
Horizontal Analysis
Income Statement
Increase or Decrease
2017 2018
Variance Percentages
$ 33,347,000.00 $ 1,167,000.00 3.63% $ 32,406,000.00
$ 15,419,000.00 $ (136,000.00) -0.87% $ 13,403,000.00
$ 17,928,000.00 $ 1,303,000.00 7.84% $ 19,003,000.00
$ 16,164,000.00 $ (151,000.00) -0.93% $ 16,276,000.00
$ 1,764,000.00 $ 1,454,000.00 469.03% $ 2,727,000.00
$ (40,000.00) $ (58,000.00) -322.22% $ (59,000.00)
$ 1,724,000.00 $ 1,396,000.00 425.61% $ 2,668,000.00
$ 2,495,000.00 $ 313,000.00 14.34% $ 2,365,000.00
$ (771,000.00) $ 1,083,000.00 -58.41% $ 303,000.00
$ 435,000.00 $ 294,000.00 208.51% $ (7,062,000.00)
$ (1,206,000.00) $ 789,000.00 -39.55% $ 7,365,000.00
$ (1,206,000.00) $ 789,000.00 -39.55% $ 7,365,000.00
$ 40,000.00 $ - 0.00% $ 40,000.00
$ (1,166,000.00) $ 789,000.00 -40.36% $ 7,405,000.00
Balance Sheet
Increase or Decrease
2017 2018
Variance Percentages
$ 2,870,000.00 $ 229,000.00 8.67% $ 6,610,000.00
$ 5,444,000.00 $ 5,444,000.00 0 $ 2,354,000.00
$ 4,138,000.00 $ 3,039,000.00 276.52% $ 3,711,000.00
$ 1,064,000.00 $ (109,000.00) -9.29% $ 1,003,000.00
$ 601,000.00 $ (1,319,000.00) -68.70% $ 575,000.00
$ 14,117,000.00 $ 7,284,000.00 106.60% $ 14,253,000.00
$ 19,209,000.00 $ (1,088,000.00) -5.36% $ 19,925,000.00
$ - $ - 0 $ -
$ 6,579,000.00 $ 4,000.00 0.06% $ 6,586,000.00
$ 43,905,000.00 $ (637,000.00) -1.43% $ 43,774,000.00
$ 1,313,000.00 $ 585,000.00 80.36% $ 921,000.00
$ 85,123,000.00 $ 6,148,000.00 7.78% $ 85,459,000.00
$ 12,458,000.00 $ 495,000.00 4.14% $ 10,800,000.00
$ 35,878,000.00 $ 6,610,000.00 22.58% $ 37,463,000.00
$ 14,416,000.00 $ 457,000.00 3.27% $ 7,294,000.00
$ 3,563,000.00 $ (439,000.00) -10.97% $ 3,546,000.00
$ 53,857,000.00 $ 6,628,000.00 14.03% $ 48,303,000.00
$ 40,000.00 $ - 0.00% $ 40,000.00
$ 27,756,000.00 $ 193,000.00 0.70% $ 27,884,000.00
$ (8,584,000.00) $ (1,206,000.00) 16.35% $ (1,255,000.00)
$ - $ 3,000.00 -100.00% $ -
$ (404,000.00) $ 35,000.00 -7.97% $ (313,000.00)
$ 18,808,000.00 $ (975,000.00) -4.93% $ 26,356,000.00
$ 85,123,000.00 $ 6,148,000.00 7.78% $ 85,459,000.00
alysis
Ratio
2017 2018
113.00% 132.00%
105.00% 123.00%
23.04% 61.20%
1449.15% 1336.29%
173.60% 162.64%
39.18% 37.92%
0.69 4.46
77.90% 69.16%
345.17% 221.62%
54.00% 59.00%
-3.62% 22.73%
-1.42% 8.62%
-$30.15 $184.13
-4% 23%
0.39 0.38
4.53 3.24
-6% 28%
Increase or Decrease
Variance Percentages
$ 226,000.00 0.70%
$ (2,152,000.00) -13.83%
$ 2,378,000.00 14.30%
$ (39,000.00) -0.24%
$ 2,417,000.00 779.68%
$ (77,000.00) -427.78%
$ 2,340,000.00 713.41%
$ 183,000.00 8.39%
$ 2,157,000.00 116.34%
$ (7,203,000.00) 5108.51%
$ 9,360,000.00 469.17%
$ 9,360,000.00 469.17%
$ - 0.00%
$ 9,360,000.00 478.77%
Increase or Decrease
Variance Percentages
$ 3,969,000.00 150.28%
$ 2,354,000.00 0
$ 2,612,000.00 237.67%
$ (170,000.00) -14.49%
$ (1,345,000.00) -70.05%
$ 7,420,000.00 108.59%
$ (372,000.00) -1.83%
$ - 0
$ 11,000.00 0.17%
$ (768,000.00) -1.72%
$ 193,000.00 26.51%
$ 6,484,000.00 8.21%
$ (1,163,000.00) -9.72%
$ 8,195,000.00 28.00%
$ (6,665,000.00) -47.75%
$ (456,000.00) -11.39%
$ 1,074,000.00 2.27%
$ - 0.00%
$ 321,000.00 1.16%
$ 6,123,000.00 -82.99%
$ 3,000.00 -100.00%
$ 126,000.00 -28.70%
$ 6,573,000.00 33.23%
$ 6,484,000.00 8.21%
Sprint
Vertical Analysis
Comparative Income Statement
Income Statement (In Thousands $) 2016
Percentages
Total Revenue $ 32,180,000.00 100.00%
Cost of Goods and Services $ 15,555,000.00 48.34%
Gross Profit $ 16,625,000.00 51.66%
Selling, General, and Administration $ 16,315,000.00 50.70%
Operating Income $ 310,000.00 0.96%
Additional Income/Expense $ 18,000.00 0.06%
Earnings before Interest and Tax $ 328,000.00 1.02%
Interest Expense $ 2,182,000.00 6.78%
Earnings before Tax $ (1,854,000.00) -5.76%
Income Tax $ 141,000.00 0.44%
Net Income $ (1,995,000.00) -6.20%
Net Income Applicable to Common Stock Holders $ (1,995,000.00) -6.20%
Common Stock $ 40,000.00 0.12%
Retained Earnings $ (1,955,000.00) -6.08%
Balance Sheet
Balance Sheet (In Thousands $) 2016 (base year)
Percentages
Cash and cash Equivalents $ 2,641,000.00 3.34%
Short-Term Investments $ - 0.00%
Net recievables $ 1,099,000.00 1.39%
Inventories $ 1,173,000.00 1.49%
Other Current Assets $ 1,920,000.00 2.43%
Total Current Assets $ 6,833,000.00 8.65%
Net Fixed Assets $ 20,297,000.00 25.70%
Long-term Investments $ - 0.00%
Goodwill $ 6,575,000.00 8.33%
Other intangible assets $ 44,542,000.00 56.40%
Other Assets $ 728,000.00 0.92%
Total Assets $ 78,975,000.00 100.00%
Current Liabilities $ 11,963,000.00 15.15%
Long-term debt $ 29,268,000.00 37.06%
Deferred taxes $ 13,959,000.00 17.68%
Other liabilites $ 4,002,000.00 5.07%
Total long-term liabilities $ 47,229,000.00 59.80%
Common Stock $ 40,000.00 0.05%
Additional paid in capital $ 27,563,000.00 34.90%
Retained Earnings $ (7,378,000.00) -9.34%
Treasury Stock $ (3,000.00) 0.00%
Other Equity $ (439,000.00) -0.56%
Total Equity $ 19,783,000.00 25.05%
Total liabilities and equity $ 78,975,000.00 100.00%
Sprint
ical Analysis
ve Income Statement
2017 2018
Percentages Percentages
$ 33,347,000.00 100.00% $ 32,406,000.00 100.00%
$ 15,419,000.00 46.24% $ 13,403,000.00 41.36%
$ 17,928,000.00 53.76% $ 19,003,000.00 58.64%
$ 16,164,000.00 48.47% $ 16,276,000.00 50.23%
$ 1,764,000.00 5.29% $ 2,727,000.00 8.42%
$ (40,000.00) -0.12% $ (59,000.00) -0.18%
$ 1,724,000.00 5.17% $ 2,668,000.00 8.23%
$ 2,495,000.00 7.48% $ 2,365,000.00 7.30%
$ (771,000.00) -2.31% $ 303,000.00 0.94%
$ 435,000.00 1.30% $ (7,062,000.00) -21.79%
$ (1,206,000.00) -3.62% $ 7,365,000.00 22.73%
$ (1,206,000.00) -3.62% $ 7,365,000.00 22.73%
$ 40,000.00 0.12% $ 40,000.00 0.12%
$ (1,166,000.00) -3.50% $ 7,405,000.00 22.85%
alance Sheet
2017 2018
Percentages Percentages
$ 2,870,000.00 3.37% $ 6,610,000.00 7.73%
$ 5,444,000.00 6.40% $ 2,354,000.00 2.75%
$ 4,138,000.00 4.86% $ 3,711,000.00 4.34%
$ 1,064,000.00 1.25% $ 1,003,000.00 1.17%
$ 601,000.00 0.71% $ 575,000.00 0.67%
$ 14,117,000.00 16.58% $ 14,253,000.00 16.68%
$ 19,209,000.00 22.57% $ 19,925,000.00 23.32%
$ - 0.00% $ - 0.00%
$ 6,579,000.00 7.73% $ 6,586,000.00 7.71%
$ 43,905,000.00 51.58% $ 43,774,000.00 51.22%
$ 1,313,000.00 1.54% $ 921,000.00 1.08%
$ 85,123,000.00 100.00% $ 85,459,000.00 100.00%
$ 12,458,000.00 14.64% $ 10,800,000.00 12.64%
$ 35,878,000.00 42.15% $ 37,463,000.00 43.84%
$ 14,416,000.00 16.94% $ 7,294,000.00 8.54%
$ 3,563,000.00 4.19% $ 3,546,000.00 4.15%
$ 53,857,000.00 63.27% $ 48,303,000.00 56.52%
$ 40,000.00 0.05% $ 40,000.00 0.05%
$ 27,756,000.00 32.61% $ 27,884,000.00 32.63%
$ (8,584,000.00) -10.08% $ (1,255,000.00) -1.47%
$ - 0.00% $ - 0.00%
$ (404,000.00) -0.47% $ (313,000.00) -0.37%
$ 18,808,000.00 22.10% $ 26,356,000.00 30.84%
$ 85,123,000.00 100.00% $ 85,459,000.00 100.00%