Editing Shopify Inc.

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.

Latest revision Your text
Line 471: Line 471:
=== Income statement ===
=== Income statement ===
{| class="wikitable"
{| class="wikitable"
|
|+
!Fiscal year is January-December. All values USD Millions.
!2022
!2022
!2021
!2021
Line 477: Line 478:
!2019
!2019
!2018
!2018
!
|-
|-
|'''Sales/Revenue'''
|Sales/Revenue
|5600
|5,600
|4612
|4,612
|2929
|2,929
|1578
|1,578
|1073
|1,073
|
|-
|-
|'''Sales Growth'''
|Sales Growth
|0.2142
|21.42%
|0.5743
|57.43%
|0.8563
|85.63%
|0.4705
|47.05%
| -
| -
|
|-
|-
|'''Cost of Goods Sold (COGS) incl. D&A'''
|Cost of Goods Sold (COGS) incl. D&A
|2883
|2,883
|2174
|2,174
|1426
|1,426
|729
|729
|488
|488
|
|-
|-
|'''COGS excluding D&A'''
|COGS excluding D&A
|2792
|2,792
|2108
|2,108
|1356
|1,356
|693
|693
|461
|461
|
|-
|-
|'''Depreciation & Amortization Expense'''
|Depreciation & Amortization Expense
|91
|91
|66
|66
Line 512: Line 518:
|36
|36
|27
|27
|
|-
|-
|'''Depreciation'''
|Depreciation
|36
|36
|42
|42
Line 519: Line 526:
|17
|17
|17
|17
|
|-
|-
|'''Amortization of Intangibles'''
|Amortization of Intangibles
|54
|54
|24
|24
Line 526: Line 534:
|19
|19
|10
|10
|
|-
|-
|'''COGS Growth'''
|Amortization of Deferred Charges
|0.3262
| -
|0.5246
|0.9556
|0.4931
| -
| -
| -
| -
| -
|
|-
|-
|'''Gross Income'''
|COGS Growth
|2717
|32.62%
|2438
|52.46%
|1504
|95.56%
|49.31%
| -
|
|-
|Gross Income
|2,717
|2,438
|1,504
|849
|849
|585
|585
|
|-
|-
|'''Gross Income Growth'''
|Gross Income Growth
|0.1144
|11.44%
|0.6214
|62.14%
|0.771
|77.10%
|0.4517
|45.17%
| -
| -
|
|-
|-
|'''Gross Profit Margin'''
|Gross Profit Margin
|0.4852
|48.52%
| -
| -
| -
| -
| -
| -
| -
| -
|
|-
|-
|'''SG&A Expense'''
|SG&A Expense
|3381
|3,381
|2110
|2,110
|1374
|1,374
|985
|985
|673
|673
|
|-
|-
|'''Research & Development'''
|Research & Development
|1472
|1,472
|847
|847
|531
|531
|344
|344
|226
|226
|
|-
|-
|'''Other SG&A'''
|Other SG&A
|1909
|1,909
|1264
|1,264
|844
|844
|641
|641
|447
|447
|
|-
|-
|'''SGA Growth'''
|SGA Growth
|0.602
|60.20%
|0.5355
|53.55%
|0.3954
|39.54%
|0.4644
|46.44%
| -
| -
|
|-
|-
|'''EBIT'''
|Other Operating Expense
| -664
| -
|328
| -
|129
| -
| -136
| -88
|-
|'''Unusual Expense'''
|3133
| -2778
| -99
| -
| -
| -
| -
|
|-
| colspan="1" rowspan="2" |EBIT
| colspan="1" rowspan="2" |-664
| colspan="1" rowspan="2" |328
| colspan="1" rowspan="2" |129
| colspan="1" rowspan="2" |-136
| colspan="1" rowspan="2" |-88
|
|-
|-
|'''Non Operating Income/Expense'''
|
|99
|-
|23
| colspan="1" rowspan="2" |Unusual Expense
| -2
| colspan="1" rowspan="2" |3,133
| -8
| colspan="1" rowspan="2" |-2,778
| -6
| colspan="1" rowspan="2" |-99
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
|
|-
|
|-
| colspan="1" rowspan="2" |Non Operating Income/Expense
| colspan="1" rowspan="2" |99
| colspan="1" rowspan="2" |23
| colspan="1" rowspan="2" |-2
| colspan="1" rowspan="2" |-8
| colspan="1" rowspan="2" |-6
|
|-
|
|-
|-
|'''Non-Operating Interest Income'''
|Non-Operating Interest Income
|79
|79
|15
|15
Line 610: Line 652:
|48
|48
|29
|29
|
|-
|Equity in Affiliates (Pretax)
| -
| -
| -
| -
| -
|
|-
|-
|'''Interest Expense'''
|Interest Expense
|3
|3
|3
|3
Line 617: Line 668:
| -
| -
| -
| -
|
|-
| colspan="1" rowspan="2" |Interest Expense Growth
| colspan="1" rowspan="2" |0.17%
| colspan="1" rowspan="2" |-61.55%
| colspan="1" rowspan="2" |0.00%
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
|
|-
|-
|'''Interest Expense Growth'''
|
|0.0017
| -0.6155
|0
| -
| -
|-
|-
|'''Gross Interest Expense'''
|Gross Interest Expense
|3
|3
|3
|3
Line 631: Line 686:
| -
| -
| -
| -
|
|-
|-
|'''Interest Capitalized'''
|Interest Capitalized
| -
| -
| -
| -
Line 638: Line 694:
| -
| -
| -
| -
|
|-
|-
|'''Pretax Income'''
| colspan="1" rowspan="2" |Pretax Income
| -3623
| colspan="1" rowspan="2" |-3,623
|3141
| colspan="1" rowspan="2" |3,141
|240
| colspan="1" rowspan="2" |240
| -96
| colspan="1" rowspan="2" |-96
| -65
| colspan="1" rowspan="2" |-65
|
|-
|-
|'''Pretax Income Growth'''
|
| -2.1536
|12.066
|3.5086
| -0.4843
| -
|-
|-
|'''Pretax Margin'''
| colspan="1" rowspan="2" |Pretax Income Growth
| -0.647
| colspan="1" rowspan="2" |-215.36%
| -
| colspan="1" rowspan="2" |1206.60%
| -
| colspan="1" rowspan="2" |350.86%
| -
| colspan="1" rowspan="2" |-48.43%
| -
| colspan="1" rowspan="2" |-
|
|-
|-
|'''Income Tax'''
|
| -162
|-
|226
| colspan="1" rowspan="2" |Pretax Margin
| -79
| colspan="1" rowspan="2" |-64.70%
|29
| colspan="1" rowspan="2" |-
| -
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
|
|-
|
|-
| colspan="1" rowspan="2" |Income Tax
| colspan="1" rowspan="2" |-162
| colspan="1" rowspan="2" |226
| colspan="1" rowspan="2" |-79
| colspan="1" rowspan="2" |29
| colspan="1" rowspan="2" |-
|
|-
|
|-
| colspan="1" rowspan="2" |Income Tax - Current Domestic
| colspan="1" rowspan="2" |1
| colspan="1" rowspan="2" |2
| colspan="1" rowspan="2" |-54
| colspan="1" rowspan="2" |63
| colspan="1" rowspan="2" |-
|
|-
|-
|'''Income Tax - Current Domestic'''
|
|1
|2
| -54
|63
| -
|-
|-
|'''Income Tax - Current Foreign'''
|Income Tax - Current Foreign
|24
|24
|33
|33
Line 680: Line 752:
|2
|2
| -
| -
|
|-
|-
|'''Income Tax - Deferred Domestic'''
| colspan="1" rowspan="2" |Income Tax - Deferred Domestic
| -180
| colspan="1" rowspan="2" |-180
|192
| colspan="1" rowspan="2" |192
|13
| colspan="1" rowspan="2" |13
| -14
| colspan="1" rowspan="2" |-14
| -
| colspan="1" rowspan="2" |-
|
|-
|-
|'''Income Tax - Deferred Foreign'''
|
| -7
| -1
| -57
| -22
| -
|-
|-
|'''Consolidated Net Income'''
| colspan="1" rowspan="2" |Income Tax - Deferred Foreign
| -3460
| colspan="1" rowspan="2" |-7
|2915
| colspan="1" rowspan="2" |-1
|320
| colspan="1" rowspan="2" |-57
| -125
| colspan="1" rowspan="2" |-22
| -65
| colspan="1" rowspan="2" |-
|
|-
|-
|'''Minority Interest Expense'''
|
|-
|Income Tax Credits
| -
| -
| -
| -
Line 708: Line 780:
| -
| -
| -
| -
|
|-
|-
|'''Net Income'''
|Equity in Affiliates
| -3460
|2915
|320
| -125
| -65
|-
|'''Net Income Growth'''
| -2.1872
|8.1223
|3.5593
| -0.9339
| -
| -
|-
|'''Net Margin'''
| -0.6179
| -
| -
| -
| -
| -
| -
| -
| -
|
|-
|-
|'''Net Income After Extraordinaries'''
|Other After Tax Income (Expense)
| -3460
| -
|2915
| -
|320
| -
| -125
| -65
|-
|'''Net Income Available to Common'''
| -3460
|2915
|320
| -125
| -65
|-
|'''EPS (Basic)'''
| -2.73
|2.34
|0.27
| -0.11
| -0.06
|-
|'''EPS (Basic) Growth'''
| -2.1688
|7.7504
|3.4181
| -0.8085
| -
| -
|-
|'''Basic Shares Outstanding'''
|1266
|1247
|1196
|1130
|1057
|-
|'''EPS (Diluted)'''
| -2.73
|2.29
|0.26
| -0.11
| -0.06
|-
|'''EPS (Diluted) Growth'''
| -2.1942
|7.8429
|3.343
| -0.8081
| -
| -
|
|-
|-
|'''Diluted Shares Outstanding'''
| colspan="1" rowspan="2" |Consolidated Net Income
|1266
| colspan="1" rowspan="2" |-3,460
|1274
| colspan="1" rowspan="2" |2,915
|1235
| colspan="1" rowspan="2" |320
|1130
| colspan="1" rowspan="2" |-125
|1057
| colspan="1" rowspan="2" |-65
|
|-
|-
|'''EBITDA'''
|
| -574
|394
|199
| -100
| -61
|-
|-
|'''EBITDA Growth'''
|Minority Interest Expense
| -2.4566
|0.9766
|2.9861
| -0.6525
| -
| -
|-
|'''EBITDA Margin'''
| -0.1024
| -
| -
| -
| -
| -
| -
| -
| -
|
|-
|-
|'''EBIT'''
| colspan="1" rowspan="2" |Net Income
| -664
| colspan="1" rowspan="2" |-3,460
|328
| colspan="1" rowspan="2" |2,915
|129
| colspan="1" rowspan="2" |320
| -136
| colspan="1" rowspan="2" |-125
| -88
| colspan="1" rowspan="2" |-65
|}
|
 
|-
=== Balance Sheet ===
|
{| class="wikitable"
|-
!Fiscal year is January-December. All values USD Millions.
| colspan="1" rowspan="2" |Net Income Growth
!2022
| colspan="1" rowspan="2" |-218.72%
!2021
| colspan="1" rowspan="2" |812.23%
!2020
| colspan="1" rowspan="2" |355.93%
!2019
| colspan="1" rowspan="2" |-93.39%
!2018
| colspan="1" rowspan="2" |-
|
|-
|
|-
| colspan="1" rowspan="2" |Net Margin
| colspan="1" rowspan="2" |-61.79%
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
|
|-
|
|-
|-
!Net Income before Extraordinaries
|Extraordinaries & Discontinued Operations
| -
| -
| -
| -
Line 830: Line 852:
| -
| -
| -
| -
|
|-
|-
!Cash & Short Term Investments
|Extra Items & Gain/Loss Sale Of Assets
|5053
| -
|7768
| -
|6388
|2455
|1970
|-
!Cash Only
|1649
|2503
|2704
|650
|411
|-
!Cash & Short Term Investments Growth
| -0.3495
|0.2161
|1.6018
|0.2465
| -
| -
| -
| -
|
|-
|-
!Cash & ST Investments / Total Assets
|Cumulative Effect - Accounting Chg
|0.4697
| -
|0.5823
| -
|0.8229
| -
|0.7036
| -
|0.8719
| -
|
|-
|-
!Total Accounts Receivable
|Discontinued Operations
|858
| -
|668
| -
|422
| -
|241
| -
|133
| -
|
|-
|-
!Accounts Receivables, Net
| colspan="1" rowspan="2" |Net Income After Extraordinaries
|203
| colspan="1" rowspan="2" |-3,460
|127
| colspan="1" rowspan="2" |2,915
|64
| colspan="1" rowspan="2" |320
|41
| colspan="1" rowspan="2" |-125
|24
| colspan="1" rowspan="2" |-65
|
|-
|-
!Accounts Receivables, Gross
|
|288
|175
|87
|54
|27
|-
|-
!Bad Debt/Doubtful Accounts
|Preferred Dividends
| -85
| -
| -48
| -
| -24
| -
| -12
| -
| -3
| -
|
|-
|-
!Other Receivables
| colspan="1" rowspan="2" |Net Income Available to Common
|655
| colspan="1" rowspan="2" |-3,460
|541
| colspan="1" rowspan="2" |2,915
|358
| colspan="1" rowspan="2" |320
|199
| colspan="1" rowspan="2" |-125
|109
| colspan="1" rowspan="2" |-65
|
|-
|-
!Accounts Receivable Growth
|
|0.2843
|0.5845
|0.7513
|0.8068
| -
|-
|-
!Accounts Receivable Turnover
| colspan="1" rowspan="2" |EPS (Basic)
|6.53
| colspan="1" rowspan="2" |-2.73
|6.9
| colspan="1" rowspan="2" |2.34
|6.95
| colspan="1" rowspan="2" |0.27
|6.56
| colspan="1" rowspan="2" |-0.11
|8.06
| colspan="1" rowspan="2" |-0.06
|
|-
|-
!Other Current Assets
|
|113
|-
|103
| colspan="1" rowspan="2" |EPS (Basic) Growth
|68
| colspan="1" rowspan="2" |-216.88%
|49
| colspan="1" rowspan="2" |775.04%
|26
| colspan="1" rowspan="2" |341.81%
| colspan="1" rowspan="2" |-80.85%
| colspan="1" rowspan="2" |-
|
|-
|-
!Prepaid Expenses
|
|48
|50
|25
|21
|13
|-
|-
!Miscellaneous Current Assets
|Basic Shares Outstanding
|65
|1,266
|53
|1,247
|43
|1,196
|28
|1,130
|13
|1,057
|
|-
|-
!Total Current Assets
| colspan="1" rowspan="2" |EPS (Diluted)
|6023
| colspan="1" rowspan="2" |-2.73
|8539
| colspan="1" rowspan="2" |2.29
|6878
| colspan="1" rowspan="2" |0.26
|2745
| colspan="1" rowspan="2" |-0.11
|2129
| colspan="1" rowspan="2" |-0.06
|
|-
|-
!Net Property, Plant & Equipment
|
|486
|302
|211
|246
|62
|-
|-
!Property, Plant & Equipment - Gross
| colspan="1" rowspan="2" |EPS (Diluted) Growth
|640
| colspan="1" rowspan="2" |-219.42%
|402
| colspan="1" rowspan="2" |784.29%
|311
| colspan="1" rowspan="2" |334.30%
|292
| colspan="1" rowspan="2" |-80.81%
|92
| colspan="1" rowspan="2" |-
|
|-
|
|-
|-
!Computer Software and Equipment
|Diluted Shares Outstanding
|40
|1,266
|24
|1,274
|24
|1,235
|18
|1,130
|14
|1,057
|
|-
|-
!Other Property, Plant & Equipment
| colspan="1" rowspan="2" |EBITDA
|225
| colspan="1" rowspan="2" |-574
|181
| colspan="1" rowspan="2" |394
|167
| colspan="1" rowspan="2" |199
|140
| colspan="1" rowspan="2" |-100
|77
| colspan="1" rowspan="2" |-61
|
|-
|-
!Accumulated Depreciation
|
|154
|100
|100
|46
|30
|-
|-
!Machinery & Equipment
| colspan="1" rowspan="2" |EBITDA Growth
|0
| colspan="1" rowspan="2" |-245.66%
| colspan="1" rowspan="2" |97.66%
| colspan="1" rowspan="2" |298.61%
| colspan="1" rowspan="2" |-65.25%
| colspan="1" rowspan="2" |-
|
|-
|
|-
| colspan="1" rowspan="2" |EBITDA Margin
| colspan="1" rowspan="2" |-10.24%
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
|
|-
|
|-
| colspan="1" rowspan="2" |EBIT
| colspan="1" rowspan="2" |-664
| colspan="1" rowspan="2" |328
| colspan="1" rowspan="2" |129
| colspan="1" rowspan="2" |-136
| colspan="1" rowspan="2" |-88
|
|-
|
|}
Balance Sheet
{| class="wikitable"
|+
!Fiscal year is January-December. All values USD Millions.
!2022
!2021
!2020
!2019
!2018
!
|-
|Net Income before Extraordinaries
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
|-
|-
!Computer Software and Equipment
|Cash & Short Term Investments
|17
|5,053
|15
|7,768
|15
|6,388
|11
|2,455
|8
|1,970
|
|-
|-
!Other Property, Plant & Equipment
|Cash Only
|136
|1,649
|85
|2,503
|85
|2,704
|35
|650
|23
|411
|
|-
|-
!Total Investments and Advances
|Short-Term Investments
|1953
| -
|3956
|173
| -
| -
| -
| -
|-
!Other Long-Term Investments
|1953
|3956
|173
| -
| -
| -
| -
|
|-
|-
!Intangible Assets
| colspan="1" rowspan="2" |Cash & Short Term Investments Growth
|2226
| colspan="1" rowspan="2" |-34.95%
|495
| colspan="1" rowspan="2" |21.61%
|448
| colspan="1" rowspan="2" |160.18%
|479
| colspan="1" rowspan="2" |24.65%
|64
| colspan="1" rowspan="2" |-
|
|-
|-
!Net Goodwill
|
|1836
|357
|312
|312
|38
|-
|-
!Net Other Intangibles
|Cash & ST Investments / Total Assets
|390
|46.97%
|138
|58.23%
|136
|82.29%
|167
|70.36%
|26
|87.19%
|
|-
|Total Accounts Receivable
|858
|668
|422
|241
|133
|
|-
|-
!Other Assets
|Accounts Receivables, Net
|27
|203
| -
|127
| -
|64
| -
|41
| -
|24
|
|-
|-
!Deferred Charges
|Accounts Receivables, Gross
|288
|175
|87
|54
|27
|27
|
|-
| colspan="1" rowspan="2" |Bad Debt/Doubtful Accounts
| colspan="1" rowspan="2" |-85
| colspan="1" rowspan="2" |-48
| colspan="1" rowspan="2" |-24
| colspan="1" rowspan="2" |-12
| colspan="1" rowspan="2" |-3
|
|-
|
|-
|Other Receivables
|655
|541
|358
|199
|109
|
|-
|Accounts Receivable Growth
|28.43%
|58.45%
|75.13%
|80.68%
| -
| -
| -
|
| -
| -
|-
|-
!Total Assets
|Accounts Receivable Turnover
|10757
|6.53
|13340
|6.9
|7763
|6.95
|3489
|6.56
|2259
|8.06
|
|-
|-
!Assets - Total - Growth
|Inventories
| -0.1936
|0.7185
|1.2247
|0.5447
| -
| -
|-
!Asset Turnover
|0.46
| -
| -
| -
| -
| -
| -
| -
| -
|
|-
|-
!Return On Average Assets
|Finished Goods
| -0.2872
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
|-
|-
!All values USD Millions.
|Work in Progress
|2022
| -
|2021
| -
|2020
| -
|2019
| -
|2018
| -
|
|-
|-
!ST Debt & Current Portion LT Debt
|Raw Materials
|18
| -
|16
| -
|10
| -
|9
| -
| -
|-
!Short Term Debt
|18
|16
|10
|9
| -
| -
|
|-
|-
!Accounts Payable
|Progress Payments & Other
|364
| -
|284
| -
|169
| -
|91
|61
|-
!Accounts Payable Growth
|0.2809
|0.6833
|0.864
|0.4773
| -
| -
|-
!Income Tax Payable
|57
|80
|74
|121
| -
| -
|
|-
|-
!Other Current Liabilities
|Other Current Assets
|417
|113
|323
|103
|186
|95
|77
|-
!Accrued Payroll
|68
|68
|72
|49
|62
|26
|32
|
|14
|-
|-
!Miscellaneous Current Liabilities
|Prepaid Expenses
|349
|48
|251
|50
|124
|25
|63
|21
|63
|13
|
|-
|-
!Total Current Liabilities
|Miscellaneous Current Assets
|856
|65
|703
|53
|438
|43
|316
|28
|139
|13
|
|-
|-
!Total Current Assets FOR CALCULATION PURPOSES ONLY
|Total Current Assets
|6023
|6,023
|8539
|8,539
|6878
|6,878
|2745
|2,745
|2129
|2,129
|
|-
|-
!Total Assets FOR CALCULATION PURPOSES ONLY
|Net Property, Plant & Equipment
|10757
|486
|13340
|302
|7763
|211
|3489
|246
|2259
|62
|-
|
!Inventories FOR CALCULATION PURPOSES ONLY
|-
| -
|Property, Plant & Equipment - Gross
|640
|402
|311
|292
|92
|
|-
|Buildings
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
|-
|-
!Cash & Short Term Investments FOR CALCULATION PURPOSES ONLY
|Land & Improvements
|5053
| -
|7768
| -
|6388
| -
|2455
| -
|1970
| -
|
|-
|-
!Current Ratio
|Machinery & Equipment
|7.04
|19
|12.15
| -
|15.69
| -
|8.68
| -
|15.35
| -
|-
|
!Quick Ratio
|7.04
|12.15
|15.69
|8.68
|15.35
|-
|-
!Cash Ratio
|Construction in Progress
|5.9
|11.05
|14.57
|7.76
|14.2
|-
!Long-Term Debt
|1378
|1158
|903
|143
| -
| -
|-
!Long-Term Debt excl. Capitalized Leases
|913
|911
|758
| -
| -
| -
| -
|-
!Non-Convertible Debt
|913
|911
|758
| -
| -
| -
| -
|
|-
|-
!Deferred Taxes
|Leases
| -25
|135
| -53
| -11
|1
|-
!
|
|
|
|
|
|-
!Deferred Taxes - Credit
|16
|183
| -
|9
|5
|-
!Deferred Taxes - Debit
|41
|48
|53
|19
|4
|-
!Other Liabilities
|268
|163
|21
|6
|24
|-
!Deferred Tax Liability-Untaxed Reserves
| -
| -
| -
| -
Line 1,250: Line 1,247:
| -
| -
| -
| -
|
|-
|-
!Other Liabilities (excl. Deferred Income)
|Computer Software and Equipment
|40
|24
|24
|18
|14
|
|-
|Leased Property
| -
| -
| -
| -
| -
| -
| -
| -
| -
|22
|
|-
|-
!Deferred Income
|Transportation Equipment
|268
|163
|21
|6
|2
|-
!Total Liabilities
|2518
|2207
|1362
|474
|168
|-
!Non-Equity Reserves
| -
| -
| -
| -
Line 1,278: Line 1,271:
| -
| -
| -
| -
|
|-
|-
!Total Liabilities / Total Assets
|Other Property, Plant & Equipment
|0.2341
|225
|0.1654
|181
|0.1755
|167
|0.1358
|140
|0.0745
|77
|
|-
|-
!Common Equity (Total)
|Accumulated Depreciation
|8239
|154
|11133
|100
|6401
|100
|3016
|46
|2091
|-
!Common Stock Par/Carry Value
|8747
|8040
|6115
|3256
|2216
|-
!Additional Paid-In Capital/Capital Surplus
|30
|30
|161
|
|261
|63
|75
|-
|-
!Retained Earnings
|Buildings
| -522
| -
|2938
| -
|15
| -
| -304
| -
| -188
| -
|
|-
|-
!Other Appropriated Reserves
|Land & Improvements
| -16
| -
| -6
| -
|9
| -
|1
| -
| -12
| -
|
|-
|-
!Common Equity / Total Assets
|Machinery & Equipment
|0.7659
|0
|0.8346
| -
|0.8245
|0.8642
|0.9255
|-
!Total Shareholders' Equity
|8239
|11133
|6401
|3016
|2091
|-
!Total Shareholders' Equity / Total Assets
|0.7659
|0.8346
|0.8245
|0.8642
|0.9255
|-
!Total Equity
|8239
|11133
|6401
|3016
|2091
|-
!Liabilities & Shareholders' Equity
|10757
|13340
|7763
|3489
|2259
|}
 
=== Cash flow statement ===
{| class="wikitable"
!Fiscal year is January-December. All values USD Thousands.
!2022
!2021
!2020
!2019
!2018
|-
!Net Income before Extraordinaries
| -3460418
|2914659
|319509
| -124842
| -64553
|-
!Net Income Growth
| -2.1872
|8.1223
|3.5593
| -0.9339
| -
| -
|-
!Depreciation, Depletion & Amortization
|90520
|66308
|70060
|35651
|27052
|-
!Depreciation and Depletion
|36172
|41828
|38192
|16779
| -
| -
|-
!Amortization of Intangible Assets
|54348
|24480
|31868
|18872
| -
| -
|
|-
|-
!Deferred Taxes & Investment Tax Credit
|Construction in Progress
| -186571
|190963
| -41998
| -37918
| -
| -
|-
!Deferred Taxes
| -186571
|190963
| -41998
| -37918
| -
| -
|-
!Investment Tax Credit
| -
| -
| -
| -
| -
| -
| -
|
| -
|-
!Other Funds
|3518292
| -2506578
|177719
|177549
|102914
|-
!Funds from Operations
| -38177
|665352
|525290
|50440
|65413
|-
|-
!Extraordinaries
|Leases
| -
| -
| -
| -
Line 1,442: Line 1,327:
| -
| -
| -
| -
|
|-
|-
!Changes in Working Capital
|Computer Software and Equipment
| -98271
|17
| -160924
|15
| -100332
|15
|20175
|11
| -56089
|8
|
|-
|-
!Receivables
|Leased Property
| -127908
| -
| -338377
| -
| -141867
| -
| -130392
| -
| -83343
| -
|
|-
|-
!Inventories
|Transportation Equipment
| -
| -
| -
| -
Line 1,463: Line 1,351:
| -
| -
| -
| -
|
|-
|-
!Accounts Payable
|Other Property, Plant & Equipment
|36541
|136
|138175
|85
|118588
|85
|84563
|35
|20641
|23
|
|-
|-
!Income Taxes Payable
|Total Investments and Advances
| -3941
|1,953
|45263
|3,956
| -105890
|173
|64648
| -
| -
| -
|
|-
|-
!Other Accruals
|LT Investment - Affiliate Companies
| -
| -
| -
| -
Line 1,484: Line 1,375:
| -
| -
| -
| -
|
|-
|-
!Other Assets/Liabilities
|Other Long-Term Investments
| -2963
|1,953
| -5985
|3,956
|28837
|173
|1356
| -
|6613
| -
|
|-
|-
!Net Operating Cash Flow
|Long-Term Note Receivable
| -136448
| -
|504428
|424958
|70615
|9324
|-
!Net Operating Cash Flow Growth
| -1.2705
|0.187
|5.018
|6.5735
| -
| -
|-
!Net Operating Cash Flow / Sales
| -0.0244
|0.1094
|0.1451
|0.0447
|0.0087
|-
!All values USD Thousands.
|2022
|2021
|2020
|2019
|2018
|-
!Capital Expenditures
| -50018
| -50788
| -41995
| -62397
| -41545
|-
!Capital Expenditures (Fixed Assets)
| -50018
| -50788
| -41733
| -56759
| -27950
|-
!Capital Expenditures (Other Assets)
| -
| -
| -
| -
| -262
| -5638
| -13595
|-
!Capital Expenditures Growth
|0.0152
| -0.2094
|0.327
| -0.5019
| -
| -
|
|-
|-
!Capital Expenditures / Sales
|Intangible Assets
| -0.0089
|2,226
| -0.011
|495
| -0.0143
|448
| -0.0395
|479
| -0.0387
|64
|
|-
|-
!Net Assets from Acquisitions
|Net Goodwill
| -1753748
|1,836
| -59627
|357
| -
|312
| -265512
|312
| -19397
|38
|
|-
|-
!Sale of Fixed Assets & Businesses
|Net Other Intangibles
| -
|390
| -
|138
| -
|136
|167
|26
|
|-
|Other Assets
|27
| -
| -
| -
| -
| -
| -
|
|-
|-
!Purchase/Sale of Investments
|Deferred Charges
|1243882
|27
| -2237375
| -1889853
| -241566
| -749691
|-
!Purchase of Investments
| -5646285
| -7987599
| -5611258
| -2718604
| -2447955
|-
!Sale/Maturity of Investments
|6890167
|5750224
|3721405
|2477038
|1698264
|-
!Other Uses
| -525538
| -
| -
| -
| -
| -
| -
| -
| -
|
|-
|-
!Other Sources
|Tangible Other Assets
|366855
| -
| -
| -
| -
| -
| -
| -
| -
|-
!Net Investing Cash Flow
| -718567
| -2347790
| -1931848
| -569475
| -810633
|-
!Net Investing Cash Flow Growth
|0.6939
| -0.2153
| -2.3923
|0.2975
| -
| -
|
|-
|-
!Net Investing Cash Flow / Sales
|Total Assets
| -0.1283
|10,757
| -0.5091
|13,340
| -0.6594
|7,763
| -0.3608
|3,489
| -0.7553
|2,259
|
|-
|-
!
| colspan="1" rowspan="2" |Assets - Total - Growth
|
| colspan="1" rowspan="2" |-19.36%
|
| colspan="1" rowspan="2" |71.85%
|
| colspan="1" rowspan="2" |122.47%
| colspan="1" rowspan="2" |54.47%
| colspan="1" rowspan="2" |-
|
|
|-
|
|
|-
|-
!All values USD Thousands.
|Asset Turnover
|2022
|0.46
|2021
|2020
|2019
|2018
|-
!Change in Capital Stock
|17549
|1649762
|2649400
|736351
|1072182
|-
!Repurchase of Common & Preferred Stk.
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
|-
|-
!Sale of Common & Preferred Stock
| colspan="1" rowspan="2" |Return On Average Assets
|17549
| colspan="1" rowspan="2" |-28.72%
|1649762
| colspan="1" rowspan="2" |-
|2649400
| colspan="1" rowspan="2" |-
|736351
| colspan="1" rowspan="2" |-
|1072182
| colspan="1" rowspan="2" |-
|
|-
|-
!Proceeds from Stock Options
|
| -
|1541168
|2578591
|688014
|1041688
|-
|-
!Other Proceeds from Sale of Stock
|
|17549
|
|108594
|
|70809
|
|48337
|
|30494
|
|
|-
|-
!Issuance/Reduction of Debt, Net
|All values USD Millions.
| -
|2022
| -
|2021
|907950
|2020
| -
|2019
| -
|2018
|
|-
|-
!Change in Current Debt
|ST Debt & Current Portion LT Debt
| -
|18
| -
|16
| -
|10
|9
| -
| -
|
|-
|Short Term Debt
|18
|16
|10
|9
| -
| -
|
|-
|-
!Change in Long-Term Debt
|Current Portion of Long Term Debt
| -
| -
| -
|907950
| -
| -
| -
| -
|-
!Issuance of Long-Term Debt
| -
| -
|907950
| -
| -
| -
| -
|
|-
|-
!Net Financing Cash Flow
|Accounts Payable
|17549
|364
|1649762
|284
|3557350
|169
|736351
|91
|1072182
|61
|
|-
|-
!Net Financing Cash Flow Growth
|Accounts Payable Growth
| -0.9894
|28.09%
| -0.5362
|68.33%
|3.8311
|86.40%
| -0.3132
|47.73%
| -
| -
|
|-
|-
!Net Financing Cash Flow / Sales
|Income Tax Payable
|0.0031
|57
|0.3577
|80
|1.2143
|74
|0.4666
|121
|0.999
| -
|
|-
|-
!Exchange Rate Effect
|Other Current Liabilities
| -16198
|417
| -7005
|323
|3221
|186
|1742
|95
| -1867
|77
|
|-
|-
!Miscellaneous Funds
|Dividends Payable
| -
| -
| -
| -
Line 1,736: Line 1,555:
| -
| -
| -
| -
|
|-
|-
!Net Change in Cash
|Accrued Payroll
| -853664
|68
| -200605
|72
|2053681
|62
|239233
|32
|269006
|14
|
|-
|-
!Free Cash Flow
|Miscellaneous Current Liabilities
| -186466
|349
|453640
|251
|383225
|124
|13856
|63
| -18626
|63
|
|-
|-
!Free Cash Flow Growth
|Total Current Liabilities
| -1.411
|856
|0.1837
|703
|26.6577
|438
|1.7439
|316
| -
|139
|
|-
|Total Current Assets FOR CALCULATION PURPOSES ONLY
|6,023
|8,539
|6,878
|2,745
|2,129
|
|-
|Total Assets FOR CALCULATION PURPOSES ONLY
|10,757
|13,340
|7,763
|3,489
|2,259
|
|-
|-
!Free Cash Flow Yield
|Inventories FOR CALCULATION PURPOSES ONLY
| -0.0042
| -
| -
| -
| -
| -
| -
| -
| -
| -
|}
|
 
=== Key Ratios ===
{| class="wikitable"
|'''Year'''
|'''Current'''
|'''2022'''
|'''2021'''
|'''2020'''
|'''2019'''
|'''2018'''
|'''2017'''
|'''2016'''
|'''2015'''
|-
|-
|Cash & Short Term Investments FOR CALCULATION PURPOSES ONLY
|5,053
|7,768
|6,388
|2,455
|1,970
|
|-
|Current Ratio
|7.04
|12.15
|15.69
|8.68
|15.35
|
|-
|Quick Ratio
|7.04
|12.15
|15.69
|8.68
|15.35
|
|
|83,120
|44,152
|1,72,966
|1,37,999
|45,858
|14,810
|10,027
|3,813
|1,965
|-
|-
|'''Market Cap Growth'''
|Cash Ratio
| -
|5.9
| -74.47%
|11.05
|25.34%
|14.57
|200.92%
|7.76
|209.65%
|14.2
|47.71%
|
|162.98%
|-
|94.04%
|Long-Term Debt
|1,378
|1,158
|903
|143
| -
|
|-
|Long-Term Debt excl. Capitalized Leases
|913
|911
|758
| -
| -
| -
|
|-
|-
|'''Enterprise Value'''
|Non-Convertible Debt
|78,693
|913
|40,495
|911
|1,66,371
|758
|1,32,523
| -
|43,555
| -
|12,865
|
|9,088
|3,420
|1,775
|-
|-
|'''PE Ratio'''
|Convertible Debt
| -31.87
| -
| -12.76
| -
|59.34
| -
|431.91
| -
| -367.33
| -
| -229.42
|
| -250.69
| -107.84
| -104.57
|-
|-
|'''PS Ratio'''
|Capitalized Lease Obligations
|14.02
| -
|7.88
| -
|37.51
| -
|47.11
| -
|29.06
| -
|13.8
|
|14.89
|-
|9.79
|Provision for Risks & Charges
|9.57
| -
| -
| -
| -
| -
|
|-
|-
|'''PB Ratio'''
| colspan="1" rowspan="2" |Deferred Taxes
|9.79
| colspan="1" rowspan="2" |-25
|5.36
| colspan="1" rowspan="2" |135
|15.54
| colspan="1" rowspan="2" |-53
|21.56
| colspan="1" rowspan="2" |-11
|15.21
| colspan="1" rowspan="2" |1
|7.08
|
|10.02
|9.29
|10.06
|-
|-
|'''EV/Sales Ratio'''
|
|13.33
|7.23
|36.07
|45.24
|27.6
|11.99
|13.5
|8.79
|8.65
|-
|-
|'''EV/EBITDA Ratio'''
|Deferred Taxes - Credit
| -31.89
|16
| -11.48
|183
|51.82
| -
|414.77
|9
| -723.93
|5
| -343.06
|
| -547.07
| -159.92
| -153.6
|-
|-
|'''EV/EBIT Ratio'''
|Deferred Taxes - Debit
| -30.16
|41
| -11.19
|48
|52.92
|53
|531.26
|19
| -454.57
|4
| -199.29
|
| -227.24
| -96.74
| -94.45
|-
|-
|'''EV/FCF Ratio'''
|Other Liabilities
| -1841.91
|268
| -217.17
|163
|343.09
|21
|346.05
|6
|5299.92
|24
| -399.28
|
| -555.5
| -279.92
| -336.12
|-
|-
|'''Debt / Equity Ratio'''
|Deferred Tax Liability-Untaxed Reserves
|0.17
| -
|0.17
| -
|0.11
|0.14
|0.05
|0.01
| -
| -
| -
| -
| -
| -
|
|-
|-
|'''Asset Turnover'''
|Other Liabilities (excl. Deferred Income)
|0.54
| -
|0.5
| -
|0.37
| -
|0.49
| -
|0.55
|22
|0.56
|
|0.71
|-
|1.06
|Deferred Income
|1.21
|268
|163
|21
|6
|2
|
|-
|Total Liabilities
|2,518
|2,207
|1,362
|474
|168
|
|-
|-
|'''Interest Coverage'''
|Non-Equity Reserves
| -720.52
| -1034.4
|900.11
|27.46
| -
| -
| -
| -
Line 1,921: Line 1,757:
| -
| -
| -
| -
|
|-
|-
|'''Return on Equity (ROE)'''
|Total Liabilities / Total Assets
| -22.50%
|23.41%
| -39.10%
|16.54%
|27.90%
|17.55%
|6.30%
|13.58%
| -4.90%
|7.45%
| -3.70%
|
| -4.70%
| -11.80%
| -14.30%
|-
|-
|'''Return on Assets (ROA)'''
|Preferred Stock (Carrying Value)
| -17.60%
| -
| -31.10%
| -
|23.50%
| -
|5.40%
| -
| -4.30%
| -
| -3.40%
|
| -4.20%
| -9.60%
| -11.10%
|-
|-
|'''Return on Capital (ROIC)'''
|Redeemable Preferred Stock
| -25.00%
| -
| -45.00%
| -
|31.40%
| -
|7.10%
| -
| -5.10%
| -
| -4.40%
| -5.80%
| -18.40%
| -32.20%
|}
 
== Valuation ==
{| class="wikitable"
!'''DCF'''
! '''2018'''
! '''2019'''
! '''2020'''
!'''2021'''
!'''2022'''
!'''2023'''
!'''2024'''
!'''2025'''
!'''2026'''
!'''2027'''
|
|
|-
|-
|'''Revenue'''
|Non-Redeemable Preferred Stock
|1,073
| -
|1,578
| -
|2,929
| -
|4,612
| -
|5,600
| -
|8,562
|13,090
|20,014
|30,599
|46,783
|
|
|-
|-
|% growth
|Preferred Stock issues for ESOP
| -
| -
| -
| -
| -
| -
|47.06%
|85.61%
|57.46%
|21.42%
|52.89%
|52.89%
|52.89%
|52.89%
|52.89%
|
|
|-
|-
|ESOP Guarantees - Preferred Stock
| -
| -
| -
| -
| -
|
|
|-
|Common Equity (Total)
|8,239
|11,133
|6,401
|3,016
|2,091
|
|
|-
|Common Stock Par/Carry Value
|8,747
|8,040
|6,115
|3,256
|2,216
|
|
|-
|Additional Paid-In Capital/Capital Surplus
|30
|161
|261
|63
|75
|
|
|-
| colspan="1" rowspan="2" |Retained Earnings
| colspan="1" rowspan="2" |-522
| colspan="1" rowspan="2" |2,938
| colspan="1" rowspan="2" |15
| colspan="1" rowspan="2" |-304
| colspan="1" rowspan="2" |-188
|
|
|-
|
|
|0
|-
|0
|ESOP Debt Guarantee
|0
| -
|0
| -
|0
| -
| -
| -
|
|
|-
|-
|'''EBIT'''
|Cumulative Translation Adjustment/Unrealized For. Exch. Gain
| -88
| -
| -136
| -
|129
| -
|328
| -
| -664
| -
|347
|367
|388
|410
|434
|
|
|-
|-
|% margin
|Unrealized Gain/Loss Marketable Securities
| -8.20%
| -
| -8.62%
| -
|4.40%
| -
|7.11%
| -
| -11.86%
| -
|5.76%
|5.76%
|5.76%
|5.76%
|5.76%
|
|
|-
|-
|Revaluation Reserves
| -
| -
| -
| -
| -
|
|
|-
| colspan="1" rowspan="2" |Other Appropriated Reserves
| colspan="1" rowspan="2" |-16
| colspan="1" rowspan="2" |-6
| colspan="1" rowspan="2" |9
| colspan="1" rowspan="2" |1
| colspan="1" rowspan="2" |-12
|
|
|-
|
|
|-
|Unappropriated Reserves
| -
| -
| -
| -
| -
|
|
|-
|Treasury Stock
| -
| -
| -
| -
| -
|
|
|
|-
|0
|Common Equity / Total Assets
|0
|76.59%
|0
|83.46%
|0
|82.45%
|0
|86.42%
|92.55%
|
|-
|Total Shareholders' Equity
|8,239
|11,133
|6,401
|3,016
|2,091
|
|
|-
|-
|'''Taxes'''
|Total Shareholders' Equity / Total Assets
|0
|76.59%
|29
|83.46%
| -79
|82.45%
|226
|86.42%
| -162
|92.55%
|231
|235
|240
|245
|250
|
|
|-
|-
|% of EBIT
|Accumulated Minority Interest
|0.00%
| -
| -21.32%
| -
| -61.24%
| -
|68.90%
| -
|24.40%
| -
|2.00%
|2.00%
|2.00%
|2.00%
|2.00%
|
|
|-
|-
|Total Equity
|8,239
|11,133
|6,401
|3,016
|2,091
|
|
|-
|Liabilities & Shareholders' Equity
|10,757
|13,340
|7,763
|3,489
|2,259
|
|
|}
Cash flow statement
{| class="wikitable"
|+
!
!
!
!
!
!
!
|-
!Fiscal year is January-December. All values USD Thousands.
!2022
!2021
!2020
!2019
!2018
|
|
|-
| colspan="1" rowspan="2" |Net Income before Extraordinaries
| colspan="1" rowspan="2" |-3,460,418.00
| colspan="1" rowspan="2" |2,914,659.00
| colspan="1" rowspan="2" |319,509.00
| colspan="1" rowspan="2" |-124,842.00
| colspan="1" rowspan="2" |-64,553.00
|
|
|-
|
|
|-
| colspan="1" rowspan="2" |Net Income Growth
| colspan="1" rowspan="2" |-218.72%
| colspan="1" rowspan="2" |812.23%
| colspan="1" rowspan="2" |355.93%
| colspan="1" rowspan="2" |-93.39%
| colspan="1" rowspan="2" |-
|
|
|0
|-
|0
|
|0
|-
|0
|Depreciation, Depletion & Amortization
|0
|90,520.00
|66,308.00
|70,060.00
|35,651.00
|27,052.00
|
|
|-
|-
|'''EBIAT'''
|Depreciation and Depletion
| -88
|36,172.00
| -165
|41,828.00
|208
|38,192.00
|102
|16,779.00
| -502
| -
|116
|132
|148
|166
|184
|
|
|-
|-
|Amortization of Intangible Assets
|54,348.00
|24,480.00
|31,868.00
|18,872.00
| -
|
|
|-
| colspan="1" rowspan="2" |Deferred Taxes & Investment Tax Credit
| colspan="1" rowspan="2" |-186,571.00
| colspan="1" rowspan="2" |190,963.00
| colspan="1" rowspan="2" |-41,998.00
| colspan="1" rowspan="2" |-37,918.00
| colspan="1" rowspan="2" |-
|
|
|-
|
|
|-
| colspan="1" rowspan="2" |Deferred Taxes
| colspan="1" rowspan="2" |-186,571.00
| colspan="1" rowspan="2" |190,963.00
| colspan="1" rowspan="2" |-41,998.00
| colspan="1" rowspan="2" |-37,918.00
| colspan="1" rowspan="2" |-
|
|
|-
|
|
|-
|Investment Tax Credit
| -
| -
| -
| -
| -
|
|
|-
| colspan="1" rowspan="2" |Other Funds
| colspan="1" rowspan="2" |3,518,292.00
| colspan="1" rowspan="2" |-2,506,578.00
| colspan="1" rowspan="2" |177,719.00
| colspan="1" rowspan="2" |177,549.00
| colspan="1" rowspan="2" |102,914.00
|
|
|-
|
|
|-
| colspan="1" rowspan="2" |Funds from Operations
| colspan="1" rowspan="2" |-38,177.00
| colspan="1" rowspan="2" |665,352.00
| colspan="1" rowspan="2" |525,290.00
| colspan="1" rowspan="2" |50,440.00
| colspan="1" rowspan="2" |65,413.00
|
|
|-
|
|
|-
|Extraordinaries
| -
| -
| -
| -
| -
|
|-
| colspan="1" rowspan="2" |Changes in Working Capital
| colspan="1" rowspan="2" |-98,271.00
| colspan="1" rowspan="2" |-160,924.00
| colspan="1" rowspan="2" |-100,332.00
| colspan="1" rowspan="2" |20,175.00
| colspan="1" rowspan="2" |-56,089.00
|
|-
|
|
|-
| colspan="1" rowspan="2" |Receivables
| colspan="1" rowspan="2" |-127,908.00
| colspan="1" rowspan="2" |-338,377.00
| colspan="1" rowspan="2" |-141,867.00
| colspan="1" rowspan="2" |-130,392.00
| colspan="1" rowspan="2" |-83,343.00
|
|
|-
|-
|'''D&A'''
|27
|36
|70
|66
|91
|93
|95
|96
|98
|100
|
|
|-
|-
|% of sales
|Inventories
|2.52%
| -
|2.28%
| -
|2.39%
| -
|1.43%
| -
|1.63%
| -
|1.93%
|1.93%
|1.93%
|1.93%
|1.93%
|
|
|-
|-
|Accounts Payable
|36,541.00
|138,175.00
|118,588.00
|84,563.00
|20,641.00
|
|
|-
| colspan="1" rowspan="2" |Income Taxes Payable
| colspan="1" rowspan="2" |-3,941.00
| colspan="1" rowspan="2" |45,263.00
| colspan="1" rowspan="2" |-105,890.00
| colspan="1" rowspan="2" |64,648.00
| colspan="1" rowspan="2" |-
|
|
|-
|
|
|-
|Other Accruals
| -
| -
| -
| -
| -
|
|
|-
| colspan="1" rowspan="2" |Other Assets/Liabilities
| colspan="1" rowspan="2" |-2,963.00
| colspan="1" rowspan="2" |-5,985.00
| colspan="1" rowspan="2" |28,837.00
| colspan="1" rowspan="2" |1,356.00
| colspan="1" rowspan="2" |6,613.00
|
|
|-
|
|
|0
|-
|0
| colspan="1" rowspan="2" |Net Operating Cash Flow
|0
| colspan="1" rowspan="2" |-136,448.00
|0
| colspan="1" rowspan="2" |504,428.00
|0
| colspan="1" rowspan="2" |424,958.00
| colspan="1" rowspan="2" |70,615.00
| colspan="1" rowspan="2" |9,324.00
|
|-
|
|-
| colspan="1" rowspan="2" |Net Operating Cash Flow Growth
| colspan="1" rowspan="2" |-127.05%
| colspan="1" rowspan="2" |18.70%
| colspan="1" rowspan="2" |501.80%
| colspan="1" rowspan="2" |657.35%
| colspan="1" rowspan="2" |-
|
|
|-
|-
|'''Capex'''
| -42
| -62
| -42
| -51
| -50
|(49)
|(48)
|(47)
|(46)
|(46)
|
|
|-
|-
|% of slaes
| colspan="1" rowspan="2" |Net Operating Cash Flow / Sales
| -3.87%
| colspan="1" rowspan="2" |-2.44%
| -3.93%
| colspan="1" rowspan="2" |10.94%
| -1.43%
| colspan="1" rowspan="2" |14.51%
| -1.11%
| colspan="1" rowspan="2" |4.47%
| -0.89%
| colspan="1" rowspan="2" |0.87%
| -1.84%
|
| -1.84%
|-
| -1.84%
| -1.84%
| -1.84%
|
|
|-
|-
Line 2,185: Line 2,166:
|
|
|
|
|0
|0
|0
|0
|0
|
|
|-
|-
|'''Changes in NWC'''
|All values USD Thousands.
|2022
|2021
|2020
|2019
|2018
|
|
| -56
|-
| -20
| colspan="1" rowspan="2" |Capital Expenditures
| -100
| colspan="1" rowspan="2" |-50,018.00
| -161
| colspan="1" rowspan="2" |-50,788.00
|(199)
| colspan="1" rowspan="2" |-41,995.00
|(304)
| colspan="1" rowspan="2" |-62,397.00
|(464)
| colspan="1" rowspan="2" |-41,545.00
|(710)
|(1,085)
|
|
|-
|-
|% of sales
|
|
| -3.55%
|-
| -0.68%
| colspan="1" rowspan="2" |Capital Expenditures (Fixed Assets)
| -2.17%
| colspan="1" rowspan="2" |-50,018.00
| -2.88%
| colspan="1" rowspan="2" |-50,788.00
| -2.32%
| colspan="1" rowspan="2" |-41,733.00
| -2.32%
| colspan="1" rowspan="2" |-56,759.00
| -2.32%
| colspan="1" rowspan="2" |-27,950.00
| -2.32%
| -2.32%
|
|
|-
|-
|
|
|-
| colspan="1" rowspan="2" |Capital Expenditures (Other Assets)
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-262
| colspan="1" rowspan="2" |-5,638.00
| colspan="1" rowspan="2" |-13,595.00
|
|
|-
|
|
|-
| colspan="1" rowspan="2" |Capital Expenditures Growth
| colspan="1" rowspan="2" |1.52%
| colspan="1" rowspan="2" |-20.94%
| colspan="1" rowspan="2" |32.70%
| colspan="1" rowspan="2" |-50.19%
| colspan="1" rowspan="2" |-
|
|
|-
|
|
|-
| colspan="1" rowspan="2" |Capital Expenditures / Sales
| colspan="1" rowspan="2" |-0.89%
| colspan="1" rowspan="2" |-1.10%
| colspan="1" rowspan="2" |-1.43%
| colspan="1" rowspan="2" |-3.95%
| colspan="1" rowspan="2" |-3.87%
|
|
|-
|
|
|-
| colspan="1" rowspan="2" |Net Assets from Acquisitions
| colspan="1" rowspan="2" |-1,753,748.00
| colspan="1" rowspan="2" |-59,627.00
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-265,512.00
| colspan="1" rowspan="2" |-19,397.00
|
|
|-
|
|
|-
|Sale of Fixed Assets & Businesses
| -
| -
| -
| -
| -
|
|
|-
| colspan="1" rowspan="2" |Purchase/Sale of Investments
| colspan="1" rowspan="2" |1,243,882.00
| colspan="1" rowspan="2" |-2,237,375.00
| colspan="1" rowspan="2" |-1,889,853.00
| colspan="1" rowspan="2" |-241,566.00
| colspan="1" rowspan="2" |-749,691.00
|
|
|-
|
|
|-
|-
|'''Unlevered FCF'''
| colspan="1" rowspan="2" |Purchase of Investments
| colspan="1" rowspan="2" |-5,646,285.00
| colspan="1" rowspan="2" |-7,987,599.00
| colspan="1" rowspan="2" |-5,611,258.00
| colspan="1" rowspan="2" |-2,718,604.00
| colspan="1" rowspan="2" |-2,447,955.00
|
|
| -135
|-
|256
|217
| -300
|359
|482
|661
|927
|1,324
|
|
|-
|-
|Sale/Maturity of Investments
|6,890,167.00
|5,750,224.00
|3,721,405.00
|2,477,038.00
|1,698,264.00
|
|
|-
| colspan="1" rowspan="2" |Other Uses
| colspan="1" rowspan="2" |-525,538.00
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
|
|
|-
|
|
|-
|Other Sources
|366,855.00
| -
| -
| -
| -
|
|-
| colspan="1" rowspan="2" |Net Investing Cash Flow
| colspan="1" rowspan="2" |-718,567.00
| colspan="1" rowspan="2" |-2,347,790.00
| colspan="1" rowspan="2" |-1,931,848.00
| colspan="1" rowspan="2" |-569,475.00
| colspan="1" rowspan="2" |-810,633.00
|
|-
|
|-
| colspan="1" rowspan="2" |Net Investing Cash Flow Growth
| colspan="1" rowspan="2" |69.39%
| colspan="1" rowspan="2" |-21.53%
| colspan="1" rowspan="2" |-239.23%
| colspan="1" rowspan="2" |29.75%
| colspan="1" rowspan="2" |-
|
|
|-
|
|
|-
| colspan="1" rowspan="2" |Net Investing Cash Flow / Sales
| colspan="1" rowspan="2" |-12.83%
| colspan="1" rowspan="2" |-50.91%
| colspan="1" rowspan="2" |-65.94%
| colspan="1" rowspan="2" |-36.08%
| colspan="1" rowspan="2" |-75.53%
|
|-
|
|-
|
|
|
|
|
|
|
|-
|All values USD Thousands.
|2022
|2021
|2020
|2019
|2018
|
|-
|Cash Dividends Paid - Total
| -
| -
| -
| -
| -
|
|-
|Common Dividends
| -
| -
| -
| -
| -
|
|-
|Preferred Dividends
| -
| -
| -
| -
| -
|
|-
|Change in Capital Stock
|17,549.00
|1,649,762.00
|2,649,400.00
|736,351.00
|1,072,182.00
|
|-
|Repurchase of Common & Preferred Stk.
| -
| -
| -
| -
| -
|
|-
|Sale of Common & Preferred Stock
|17,549.00
|1,649,762.00
|2,649,400.00
|736,351.00
|1,072,182.00
|
|-
|Proceeds from Stock Options
| -
|1,541,168.00
|2,578,591.00
|688,014.00
|1,041,688.00
|
|-
|Other Proceeds from Sale of Stock
|17,549.00
|108,594.00
|70,809.00
|48,337.00
|30,494.00
|
|-
|Issuance/Reduction of Debt, Net
| -
| -
|907,950.00
| -
| -
|
|-
|Change in Current Debt
| -
| -
| -
| -
| -
|
|-
|Change in Long-Term Debt
| -
| -
|907,950.00
| -
| -
|
|-
|Issuance of Long-Term Debt
| -
| -
|907,950.00
| -
| -
|
|-
|Reduction in Long-Term Debt
| -
| -
| -
| -
| -
|
|-
|Other Funds
| -
| -
| -
| -
| -
|
|-
|Other Uses
| -
| -
| -
| -
| -
|
|-
|Other Sources
| -
| -
| -
| -
| -
|
|-
|Net Financing Cash Flow
|17,549.00
|1,649,762.00
|3,557,350.00
|736,351.00
|1,072,182.00
|
|-
| colspan="1" rowspan="2" |Net Financing Cash Flow Growth
| colspan="1" rowspan="2" |-98.94%
| colspan="1" rowspan="2" |-53.62%
| colspan="1" rowspan="2" |383.11%
| colspan="1" rowspan="2" |-31.32%
| colspan="1" rowspan="2" |-
|
|-
|
|-
|Net Financing Cash Flow / Sales
|0.31%
|35.77%
|121.43%
|46.66%
|99.90%
|
|-
| colspan="1" rowspan="2" |Exchange Rate Effect
| colspan="1" rowspan="2" |-16,198.00
| colspan="1" rowspan="2" |-7,005.00
| colspan="1" rowspan="2" |3,221.00
| colspan="1" rowspan="2" |1,742.00
| colspan="1" rowspan="2" |-1,867.00
|
|-
|
|-
|Miscellaneous Funds
| -
| -
| -
| -
| -
|
|-
| colspan="1" rowspan="2" |Net Change in Cash
| colspan="1" rowspan="2" |-853,664.00
| colspan="1" rowspan="2" |-200,605.00
| colspan="1" rowspan="2" |2,053,681.00
| colspan="1" rowspan="2" |239,233.00
| colspan="1" rowspan="2" |269,006.00
|
|-
|
|-
| colspan="1" rowspan="2" |Free Cash Flow
| colspan="1" rowspan="2" |-186,466.00
| colspan="1" rowspan="2" |453,640.00
| colspan="1" rowspan="2" |383,225.00
| colspan="1" rowspan="2" |13,856.00
| colspan="1" rowspan="2" |-18,626.00
|
|-
|
|-
| colspan="1" rowspan="2" |Free Cash Flow Growth
| colspan="1" rowspan="2" |-141.10%
| colspan="1" rowspan="2" |18.37%
| colspan="1" rowspan="2" |2665.77%
| colspan="1" rowspan="2" |174.39%
| colspan="1" rowspan="2" |-
|
|-
|
|-
| colspan="1" rowspan="2" |Free Cash Flow Yield
| colspan="1" rowspan="2" |-0.42%
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
| colspan="1" rowspan="2" |-
|
|-
|
|}
{| class="wikitable"
|'''Year'''
|'''Current'''
|'''2022'''
|'''2021'''
|'''2020'''
|'''2019'''
|'''2018'''
|'''2017'''
|'''2016'''
|'''2015'''
|-
|
|83,120
|44,152
|1,72,966
|1,37,999
|45,858
|14,810
|10,027
|3,813
|1,965
|-
|'''Market Cap Growth'''
| -
| -74.47%
|25.34%
|200.92%
|209.65%
|47.71%
|162.98%
|94.04%
| -
|-
|'''Enterprise Value'''
|78,693
|40,495
|1,66,371
|1,32,523
|43,555
|12,865
|9,088
|3,420
|1,775
|-
|'''PE Ratio'''
| -31.87
| -12.76
|59.34
|431.91
| -367.33
| -229.42
| -250.69
| -107.84
| -104.57
|-
|'''PS Ratio'''
|14.02
|7.88
|37.51
|47.11
|29.06
|13.8
|14.89
|9.79
|9.57
|-
|'''PB Ratio'''
|9.79
|5.36
|15.54
|21.56
|15.21
|7.08
|10.02
|9.29
|10.06
|-
|'''EV/Sales Ratio'''
|13.33
|7.23
|36.07
|45.24
|27.6
|11.99
|13.5
|8.79
|8.65
|-
|'''EV/EBITDA Ratio'''
| -31.89
| -11.48
|51.82
|414.77
| -723.93
| -343.06
| -547.07
| -159.92
| -153.6
|-
|'''EV/EBIT Ratio'''
| -30.16
| -11.19
|52.92
|531.26
| -454.57
| -199.29
| -227.24
| -96.74
| -94.45
|-
|'''EV/FCF Ratio'''
| -1841.91
| -217.17
|343.09
|346.05
|5299.92
| -399.28
| -555.5
| -279.92
| -336.12
|-
|'''Debt / Equity Ratio'''
|0.17
|0.17
|0.11
|0.14
|0.05
|0.01
| -
| -
| -
|-
|'''Asset Turnover'''
|0.54
|0.5
|0.37
|0.49
|0.55
|0.56
|0.71
|1.06
|1.21
|-
|'''Interest Coverage'''
| -720.52
| -1034.4
|900.11
|27.46
| -
| -
| -
| -
| -
|-
|'''Return on Equity (ROE)'''
| -22.50%
| -39.10%
|27.90%
|6.30%
| -4.90%
| -3.70%
| -4.70%
| -11.80%
| -14.30%
|-
|'''Return on Assets (ROA)'''
| -17.60%
| -31.10%
|23.50%
|5.40%
| -4.30%
| -3.40%
| -4.20%
| -9.60%
| -11.10%
|-
|'''Return on Capital (ROIC)'''
| -25.00%
| -45.00%
|31.40%
|7.10%
| -5.10%
| -4.40%
| -5.80%
| -18.40%
| -32.20%
|}
== Valuation ==
{| class="wikitable"
|'''DCF'''
|'''2018'''
| '''2019'''
| '''2020'''
| '''2021'''
|'''2022'''
|'''2023'''
|'''2024'''
|'''2025'''
|'''2026'''
|'''2027'''
|
|-
|'''Revenue'''
|1,073
|1,578
|2,929
|4,612
|5,600
|8,562
|13,090
|20,014
|30,599
|46,783
|
|-
|% growth
| -
|47.06%
|85.61%
|57.46%
|21.42%
|52.89%
|52.89%
|52.89%
|52.89%
|52.89%
|
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
|'''EBIT'''
| -88
| -136
|129
|328
| -664
|347
|367
|388
|410
|434
|
|-
|% margin
| -8.20%
| -8.62%
|4.40%
|7.11%
| -11.86%
|5.76%
|5.76%
|5.76%
|5.76%
|5.76%
|
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
|'''Taxes'''
|0
|29
| -79
|226
| -162
|231
|235
|240
|245
|250
|
|-
|% of EBIT
|0.00%
| -21.32%
| -61.24%
|68.90%
|24.40%
|2.00%
|2.00%
|2.00%
|2.00%
|2.00%
|
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
|'''EBIAT'''
| -88
| -165
|208
|102
| -502
|116
|132
|148
|166
|184
|
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
|'''D&A'''
|27
|36
|70
|66
|91
|93
|95
|96
|98
|100
|
|-
|% of sales
|2.52%
|2.28%
|2.39%
|1.43%
|1.63%
|1.93%
|1.93%
|1.93%
|1.93%
|1.93%
|
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
|'''Capex'''
| -42
| -62
| -42
| -51
| -50
|(49)
|(48)
|(47)
|(46)
|(46)
|
|-
|% of slaes
| -3.87%
| -3.93%
| -1.43%
| -1.11%
| -0.89%
| -1.84%
| -1.84%
| -1.84%
| -1.84%
| -1.84%
|
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
|'''Changes in NWC'''
|
| -56
| -20
| -100
| -161
|0
|0
|0
|0
|0
|
|-
|% of sales
|
| -3.55%
| -0.68%
| -2.17%
| -2.88%
| -2.32%
| -2.32%
| -2.32%
| -2.32%
| -2.32%
|
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
|'''Unlevered FCF'''
|
| -135
|256
|217
| -300
|160
|178
|197
|218
|239
|
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
|Year count
|
|
|
|
|
|0.52
|1.52
|2.52
|3.52
|4.52
|
|-
|Discount factor
|
|
|
|
|
|0.94
|0.82
|0.72
|0.64
|0.56
|'''TV'''
|-
| colspan="2" |'''Present value of FCF'''
|
|
|
|
|150
|147
|143
|139
|134
|1442.206495
|}
{| class="wikitable"
| colspan="2" |'''WACC'''
|-
|'''Risk free rate  (5 year US Bond)'''
|4.17%
|-
|'''Market risk premium'''
|4.72%
|-
|'''Levered beta'''
|2.043
|-
|'''Cost of equity'''
|13.81%
|-
|'''Cost of debt'''
|4.72%
|-
|'''Share price'''
|65.02
|-
|'''Shares outstanding (latest reported)'''
|1,266.27
|-
|'''Market capitalization'''
|82332
|-
|'''Total debt'''
|1.40E+03
|-
|'''Total capital'''
|8.37E+04
|-
|'''% debt capital'''
|1.67%
|-
|'''% equity capital'''
|98.33%
|-
|'''Internally calculated WACC'''
|13.66%
|-
|'''Terminal growth rate'''
|'''4%'''
|}
{| class="wikitable"
|
|
|
|
|
|% of EV
|
|
|
|
|-
|-
|Year count
|'''Present vale of FCF'''
|
|712
|
|33.04%
|
|
|
|0.52
|1.52
|2.52
|3.52
|4.52
|
|-
|-
|Discount factor
|'''Present value of TV'''
|
|1442
|
|66.96%
|
|
|
|0.94
|0.82
|0.72
|0.64
|0.56
|'''TV'''
|-
|-
|'''Present value of FCF'''
|
|
|
|
|
|
|'''335'''
|'''396'''
|'''479'''
|'''591'''
|'''742'''
|'''7988.051624'''
|}
{| class="wikitable"
| colspan="2" |'''WACC'''
|-
!'''Risk free rate  (5 year US Bond)'''
|4.17%
|-
!'''Market risk premium'''
|4.72%
|-
!'''Levered beta'''
|2.043
|-
!'''Cost of equity'''
|13.81%
|-
!'''Cost of debt'''
|4.72%
|-
!'''Share price'''
|65.02
|-
!'''Shares outstanding (latest reported)'''
|1,266.27
|-
!'''Market capitalization'''
|82332
|-
!'''Total debt'''
|1396
|-
!'''Total capital'''
|83728
|-
!'''% debt capital'''
|1.67%
|-
!'''% equity capital'''
|98.33%
|-
!'''Internally calculated WACC'''
|13.66%
|-
!'''Terminal growth rate'''
|'''4%'''
|}
{| class="wikitable"
!
!
!'''% of EV'''
|-
!'''Present vale of FCF'''
|2544
|24.15%
|-
!'''Present value of TV'''
|7988
|75.85%
|-
!
|
|
|
|
|-
|-
!'''Enterprise value'''
|'''Enterprise value'''
|10,532
|2,154
|
|
|-
|-
!
|
|
|
|
|
|-
|-
!'''(-) Net Debt'''
|'''(-) Net Debt'''
| -252.00
| -252.00
|
|
|-
|-
!'''Equity Value'''
|'''Equity Value'''
|10784
|2406
|
|
|-
|-
!'''Shares'''
|'''Shares'''
|1,266
|1,266
|
|
|-
|-
!'''Share Price'''
|'''Share Price'''
|'''8.52'''
|'''''1.90'''''
|
|
|-
|-
!'''Current Share Price'''
|'''Current Share Price'''
|'''65.02'''
|'''''65.02'''''
|
|
|}
|}
Line 2,389: Line 3,169:
==== Sensitivity Analysis ====
==== Sensitivity Analysis ====
{| class="wikitable"
{| class="wikitable"
!
| rowspan="8" |TV
!
| colspan="8" |WACC
!
!
!
!WACC
!
!
!
|-
|-
!
|1.900
|8.516
|12.00%
|12.00%
|12.50%
|12.50%
Line 2,409: Line 3,181:
|15.00%
|15.00%
|-
|-
!
|2.5%
|2.5%
|$   9.054
|$   2.002
|$          8.561
|$          1.912
|$          8.116
|$          1.830
|$          7.590
|$          1.733
|$          7.344
|$          1.687
|$          7.007
|$          1.625
|$  6.698
|$  1.568
|-
|-
!Terminal
|3.0%
|3.0%
|$   9.465
|$   2.076
|$          8.925
|$          1.977
|$          8.440
|$          1.888
|$          7.870
|$          1.783
|$          7.604
|$          1.734
|$          7.242
|$          1.668
|$  6.911
|$  1.607
|-
|-
!Growth
|3.5%
|3.5%
|$   9.923
|$   2.159
|$          9.328
|$          2.050
|$          8.797
|$          1.953
|$          8.178
|$          1.839
|$          7.890
|$          1.786
|$          7.499
|$          1.714
|$  7.143
|$  1.648
|-
|-
!Rate
|4.0%
|4.0%
|$ 10.439
|$   2.252
|$          9.780
|$          2.132
|$          9.195
|$          2.025
|$                  8.517
|$                  1.900
|$          8.204
|$          1.843
|$          7.780
|$          1.765
|$  7.396
|$  1.694
|-
|-
!
|4.5%
|4.5%
|$ 11.023
|$   2.358
|$        10.288
|$          2.223
|$          9.639
|$          2.105
|$          8.894
|$          1.968
|$          8.551
|$          1.905
|$          8.089
|$          1.821
|$  7.672
|$  1.744
|-
|-
!
|5.0%
|5.0%
|$ 11.692
|$   2.478
|$        10.863
|$          2.327
|$        10.139
|$          2.195
|$          9.314
|$          2.044
|$          8.936
|$          1.975
|$          8.431
|$          1.882
|$  7.977
|$  1.799
|}
|}


Please note that all contributions to Stockhub may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see Stockhub:Copyrights for details). Do not submit copyrighted work without permission!
Cancel Editing help (opens in new window)