Editing Sea Limited

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 29: Line 29:


=== Subsidiaries ===
=== Subsidiaries ===
Sea Limited, as mentioned, owns several subsidiaries including the digital entertainment company Garena, the e-commerce platform Shopee and the digital financial services company SeaMoney, therefore operating in 3 different markets. <ref>[https://www.sea.com/products/garena https://www.sea.com/products/]</ref>
Sea Limited, as mentioned, owns several subsidiaries including the digital entertainment company Garena, the e-commerce platform Shopee and the digital financial services company SeaMoney, therefore operating in 3 different markets. <ref>https://www.sea.com/products/garena</ref>


==== Garena ====
==== Garena ====
Line 266: Line 266:
* Impact of widespread health developments, including the COVID-19 pandemic, and responses thereto (such as voluntary and mandatory quarantines, shut downs, restrictions on travel and activities, and availability of effective vaccines or treatments).
* Impact of widespread health developments, including the COVID-19 pandemic, and responses thereto (such as voluntary and mandatory quarantines, shut downs, restrictions on travel and activities, and availability of effective vaccines or treatments).
* Impact of economies reopening further in response to the COVID-19 pandemic.
* Impact of economies reopening further in response to the COVID-19 pandemic.
=== Market Share Breakdown ===


== Financials ==
== Financials ==
Line 420: Line 422:
|}
|}


==== Last 5 years ====
==== All periods ====
{| class="wikitable"
{| class="wikitable"
! rowspan="2" |Year
! rowspan="2" |Year
Line 464: Line 466:




Revenues and gross profit are steeply increasing, but after applying operating expenses, the company reports an increasing loss every year. This is attributed to disproportionate increase of operating expenses year by year, which outweigh the increase in revenues.
Sea Limited's great investment in subsidies to local express delivery companies were one of the major operational expenses that kept Shopee, and by extension the entire company from being profitable until 2023.<ref>Here’s how Lazada lost its lead to Shopee in Southeast Asia (Part 2 of 2) | KrASIA (kr-asia.com)</ref> However, based on the most recent results, operational expenses were significantly reduced, Garena's revenues declined, and the most promising and profitable branch is Shopee.




Line 479: Line 477:


==== Method ====
==== Method ====
The forecasted values for revenues and EBITDA were calculated using straight line forecasting. The growth rates used for revenues were retrieved from Yahoo Finance and CIQ as predicted by analysts, and for EBITDA the average growth rate of the previous years was used.


==== Financial Forecasts ====
==== Financial Forecasts ====
{| class="wikitable"
! rowspan="2" |Year
! colspan="3" |Revenue ($thousands)
! colspan="3" |Gross Profit ($thousands)
|-
!Forecast
!'''Lower-bound value'''
!'''Upper-bound value'''
!Forecast
!'''Lower-bound value'''
!'''Upper-bound value'''
|-
|2024
|15,744,835
|13,081,969
|18,407,702
|6,489,624
|5,187,205
|7,792,042
|-
|2025
|18,910,452
|16,164,985
|21,655,918
|7,891,384
|6,434,652
|9,348,115
|-
|2026
|22,076,068
|19,249,784
|24,902,353
|9,293,143
|7,696,416
|10,889,871
|-
|2027
|25,241,685
|22,336,213
|28,147,156
|10,694,903
|8,969,007
|12,420,799
|-
|2028
|28,407,301
|25,424,142
|31,390,460
|12,096,663
|10,250,152
|13,943,173
|}
[[File:GProfit.png|none|thumb|736x736px|Gross profit historical (2018-2022) and forecasted (2023-2027) values for Sea Limited]] 
[[File:Revenues.png|none|thumb|726x726px|Revenue historical (2018-2022) and forecasted (2023-2027) values for Sea Limited]]
Revenues and gross profit are steeply increasing, but after applying operating expenses, the company reports an increasing loss every year. This is attributed to disproportionate increase of operating expenses year by year, which outweigh the increase in revenues.
Sea Limited's great investment in subsidies to local express delivery companies were one of the major operational expenses that keep Shopee, and by extension the entire company from being profitable.<ref>Here’s how Lazada lost its lead to Shopee in Southeast Asia (Part 2 of 2) | KrASIA (kr-asia.com)</ref>
== Risk Analysis ==
== Valuation ==
Cost of debt<ref>Cost of Debt (Pre-tax) For Sea Limited (SE) | finbox.com</ref>
beta<ref>Sea Limited (SE) Valuation Measures & Financial Statistics (yahoo.com)</ref>
{| class="wikitable"
{| class="wikitable"
!Year
!Income Statement
!2014
!2014
!2015
!2015
Line 499: Line 562:
!2027
!2027
|-
|-
|'''Revenues'''
|'''Revenue ($millions)'''
|160.756
|160.756
|292.124
|292.124
Line 508: Line 571:
|4375.664
|4375.664
|9955.19
|9955.19
|12449.71
|12449.705
|14317.16
|14317
|15748.88
|15749
|17323.76
|17324
|19056.14
|19056
|21914.56
|21915
|-
|-
|'''EBITDA'''
|% growth
| -69.3
|
| -52.1
|82%
| -160.3
|18%
| -460.5
|20%
| -904.9
|100%
| -769.6
|163%
| -1122.6
|101%
| -1304
|128%
| -704.2
|25%
|514.3483
|15%
|565.7832
|10%
|622.3615
|10%
|684.5976
|10%
|787.2873
|15%
|}
[[File:Revenuesf.png|none|thumb|576x576px|Revenues Historic (2014-2022) and Forecasted (2023-2027) Values for Sea Limited]]
[[File:EBITDA.png|none|thumb|573x573px|EBITDA Historic (2014-2022) and Forecasted (2023-2027) Values for Sea Limited]]
 
== Valuation ==
A Discounted Cash Flow (DCF) model was used for Sea Limited's valuation. The yearly revenue growth rate values estimated by Yahoo Finance and CIQ were used to predict revenues until 2027, while for the expenses, the average rates of previous years were used. The full table for the FCF calculation can be found on the Appendix. 
{| class="wikitable"
!WACC
!LTM
|-
|-
|'''Weights'''
|
|
|-
|Total Debt
|4262.053
|-
|Market Cap
|20026
|-
|Total
|24288.053
|-
|Wd
|18%
|-
|We
|82%
|-
|
|
|
|
|-
|'''Debt'''
|
|
|-
|Total Debt
|4262.053
|-
|Interest Expense
| -43.1
|-
|Rate
|1%
|-
|Effective Tax Rate
|5%
|-
|Rd(1-t)
|1.0%
|-
|
|
|
|
|-
|
|'''Equity'''
|
|
|
|
|
|
|
|
|
|-
|-
|Risk Free Rate
| '''Cost Of Goods Sold ($millions)'''
|4.2%
|124.573
|184.298
|232.598
|326.878
|812.21
|1570.458
|3026.759
|6059.455
|7264.428
|8590
|9449
|10394
|11434
|13149
|-
|-
|Beta
|% of revenue
|1.67
|77%
|-
|63%
|Market Rate
|67%
|10%
|79%
|-
|98%
|Re
|72%
|13.9%
|69%
|61%
|58%
|60%
|60%
|60%
|60%
|60%
|-
|-
|
|
|
|
|-
|'''Discount Rate'''
|'''11.60%'''
|-
|'''Perpetuity Growth Rate'''
|'''2.0%'''
|}
{| class="wikitable"
!Terminal Value
!
|-
|'''Perpetuity Growth'''
|
|
|-
|FCFn
|    1,665.98
|-
|Growth Rate
|2.0%
|-
|WACC
|12%
|-
|PG Terminal Value
|    17,698.7
|-
|
|
|
|
|-
|'''Exit Multiple'''
|
|
|-
|
|EBITDA
|
| -
|
|-
|EV/EBITDA Multiple
| -
|-
|Exit Multiple TV
| -
|-
|
|
|-
|'''Average'''
| '''    17,698.7'''
|}
{| class="wikitable"
!DCF
!
!2023
!2024
!2025
!2026
!2027
!Terminal Value
|-
|FCF
|
|     1,088.4
|     1,197.3
|     1,317.0
|     1,448.7
|     1,666.0
|          17,698.7
|-
|Net Present Value of FCF
|4780.26
|
|
|
|
Line 674: Line 658:
|
|
|-
|-
|Terminal Value
| '''Gross Profit ($millions)'''
|        17,698.69
|36.183
|
|107.826
|
|113.072
|
|87.312
|
|14.758
|
|604.92
|
|1348.905
|3895.735
|5185.277
|5727
|6300
|6930
|7622
|8766
|-
|-
|Present Value of TV
|10223.39
|
|
|
|
|
|
|
|
|
|-
|Enterprise Value
|15003.65
|
|
|
|
Line 700: Line 683:
|
|
|
|
|-
|Net Debt
| -1137.8
|
|
|
|
Line 710: Line 690:
|
|
|-
|-
|Equity Value
|'''Selling General & Admin  Exp. ($millions)'''
|16141.4
|112.958
|174.547
|294.187
|562.92
|940.63
|1355.408
|2430.581
|4817.611
|4706.835
|5441
|5985
|6583
|7241
|8328
|-
|% of revenue
|70%
|60%
|85%
|136%
|114%
|62%
|56%
|48%
|38%
|38%
|38%
|38%
|38%
|38%
|-
|
|
|
|
Line 718: Line 728:
|
|
|
|
|-
|Shares Out
|477
|
|
|
|
Line 727: Line 734:
|
|
|
|
|
|
|
|-
|'''Provision for bad debts($millions)'''
| -
| -
| -
| -
| -
| -
|57.509
|117.427
|513.69
|0
|0
|0
|0
|0
|-
|-
|'''Equity Value per Share'''
|% of revenue
|'''$            33.83'''
|
|
|
|
Line 736: Line 761:
|
|
|
|
|1.3%
|1.2%
|4.1%
|0.0%
|0.0%
|0.0%
|0.0%
|0.0%
|-
|-
|'''Current share price'''
|'''$            35.21'''
|
|
|
|
Line 745: Line 776:
|
|
|
|
|-
|'''Difference'''
| '''-3.9%'''
|
|
|
|
Line 754: Line 782:
|
|
|
|
|}
|
{| class="wikitable"
|
! colspan="7" |Sensitivity Analysis
|
|-
|-
| colspan="7" | '''Perpetuity Growth Rate'''
|'''R&D Exp($millions)'''
|11.053
|17.732
|20.809
|29.323
|67.529
|156.634
|353.785
|831.703
|1376.501
|1096
|1206
|1326
|1459
|1678
|-
|-
| rowspan="8" |'''WACC'''
|% of revenue
|$33.83
|7%
|'''1.0%'''
|6%
|'''1.5%'''
|6%
|'''2.0%'''
|7%
|'''2.5%'''
|8%
|'''3.0%'''
|7%
|-
|8%
|'''10.0%'''
|8%
|£37.17
|11%
|£38.73
|8%
|£40.48
|8%
|£42.47
|8%
|£44.74
|8%
|8%
|-
|-
|'''10.5%'''
|
|£35.23
|
|£36.60
|
|£38.13
|
|£39.86
|
|£41.81
|
|
|
|
|
|
|
|
|
|
|-
|-
|'''11.0%'''
|'''Depreciation & Amort. ($millions)'''
|£33.49
|0
|£34.70
|0
|£36.05
|0
|£37.55
|0
|£39.24
|92.882
|154.966
|268.959
|379.173
|435.88
|0
|0
|0
|0
|0
|-
|-
|'''11.6%'''
|% of revenue
|£31.62
|0%
|£32.67
|0%
|'''£33.83'''
|0%
|£35.12
|0%
|£36.56
|11%
|-
|7%
|'''12.0%'''
|6%
|£30.48
|4%
|£31.45
|4%
|£32.50
|0%
|£33.67
|0%
|£34.97
|0%
|0%
|0%
|-
|-
|'''12.5%'''
|
|£29.18
|
|£30.04
|
|£30.98
|
|£32.02
|
|£33.17
|
|
|
|
|
|
|
|
|
|
|-
|-
|'''13.0%'''
|'''Other Operating  Expense/(Income) ($millions)'''
|£27.99
| -0.7
|£28.76
| -3.1
|£29.61
| -2.1
|£30.53
| -3.5
|£31.55
| -9.8
|}
| -15.9
 
| -189.6
== Appendix ==
| -287.9
All data in financial statements were retrieved from Sea Limited's published annual reports since 2017.<ref><nowiki>https://www.sea.com/investor/annualreports</nowiki></ref>
| -279.2
 
| -228
=== Financial statements ===
| -251
 
| -276
==== Income Statement ====
| -303
{| class="wikitable"
| -349
!'''Year end  date'''
!31/12/2022
!31/12/2021
!31/12/2020
!31/12/2019
!31/12/2018
|-
|-
|Total  Revenue ($million)
|% of revenue
|12,449,705
|0%
|9,955,190
| -1%
|4,375,664
| -1%
|2,175,378
| -1%
|826,968
| -1%
| -1%
| -4%
| -3%
| -2%
| -2%
| -2%
| -2%
| -2%
| -2%
|-
|-
|Cost of Revenue ($million)
|
| -7,264,428
|
| -6,059,455
|
| -3,026,759
|
| -1,570,458
|
| -812,210
|
|-
|
|'''Gross Profit ($million)'''
|
|'''5,185,277'''
|
|'''3,895,735'''
|
|'''1,348,905'''
|'''604,920'''
|'''14,758'''
|-
|'''Operating Income/Expenses'''
|
|
|
|
Line 860: Line 930:
|
|
|-
|-
|Research and Development ($million)
|'''Total Operating Expenses ($millions)'''
| -1,376,501
|123.269
| -831,703
|189.216
| -353,785
|312.893
| -156,634
|588.746
| -67,529
|998.36
|-
|1496.152
|General and Admin. ($million)
|2652.23
| -1,437,612
|5478.795
| -987,868
|6317.842
| -599,706
|5213
| -385,865
|5734
| -240,781
|6307
|-
|6938
|Sales and marketing ($million)
|7979
| -3,269,223
|-
| -3,829,743
|
| -1,830,875
|
| -969,543
|
| -705,015
|
|
|
|
|
|
|
|
|
|
|
|
|-
|-
|Other Operating Income ($million)
|'''Operating Income / EBIT ($millions)'''
|279,184
|'''-87.1'''
|287,946
|'''-81.4'''
|189,645
|'''-199.8'''
|15,890
|'''-501.4'''
|9,799
|'''-983.6'''
|'''-891.2'''
|'''-1303.3'''
|'''-1583.1'''
|'''-1132.6'''
|'''514'''
|'''566'''
|'''622'''
|'''685'''
|'''787'''
|-
|-
|Provision for credit losses ($million)
|
| -513,690
|
| -117,427
|
| -57,509
|
| --
|
| --
|
|
|
|
|
|
|
|
|
|
|-
|-
|Goodwill ($million)
|'''EBITDA ($millions)'''
| -354,943
|'''-69.3'''
| --
|'''-52.1'''
| --
|'''-160.3'''
| --
|'''-460.5'''
| --
|'''-904.9'''
|'''-769.6'''
|'''-1122.6'''
|'''-1304'''
|'''-704.2'''
|'''514'''
|'''566'''
|'''622'''
|'''685'''
|'''787'''
|-
|-
|'''Total operating expenses ($million)'''
|
|'''-6,672,785'''
|
|'''-5,478,795'''
|
|'''-2,652,230'''
|
|'''-1,496,152'''
|
|'''-1,003,526'''
|
|
|
|
|
|
|
|
|
|
|-
|-
|'''Operating Loss ($million)'''
| '''Tax Expense ($millions)'''
|'''-1,487,508'''
|2.521
|'''-1,583,060'''
|11.73
|'''-1,303,325'''
|8.546
|'''-891,232'''
|10.745
|'''-988,768'''
|4.088
|-
|85.864
|Interest income/expense and others ($million)
|141.64
| -13,025
|332.865
| -132,124
|168.395
| -179,913
|26
| -477,387
|28
|34,888
|31
|34
|39
|-
|-
|'''Earnings/Losses Before Tax ($million)'''
|Effective tax rate
|'''-1,500,533'''
| -3%
|'''-1,715,184'''
| -14%
|'''-1,483,238'''
| -4%
|'''-1,368,619'''
| -2%
|'''-953,880'''
|0%
|-
| -10%
|Income Tax ($million)
| -11%
| -168,395
| -21%
| -332,865
| -15%
| -141,640
|5%
| -85,864
|5%
| -4,088
|5%
|5%
|5%
|}
{| class="wikitable"
!Cashflow  Statement
!2014
!2015
!2016
!2017
!2018
!2019
!2020
!2021
!2022
!2023
!2024
!2025
!2026
!2027
|-
|-
|Share of results of equity investees ($million)
|'''Depreciation & Amort.'''
|11,156
|0
|5,019
|0
|721
|0
| -3,239
|0
|3,066
|93
|155
|269
|379
|436
|0
|0
|0
|0
|0
|-
|-
|'''Net loss ($million)'''
|% of revenue
|'''-1,657,772'''
|0%
|'''-2,043,030'''
|0%
|'''-1,624,157'''
|0%
|'''-1,457,722'''
|0%
|'''-961,034'''
|11%
|7%
|6%
|4%
|4%
|0%
|0%
|0%
|0%
|0%
|-
|-
|Net income/loss attributable to non-controlling interests ($million)
|6,351
| -3,729
|6,101
| -5,077
| -207
|-
|'''Net Loss Applicable to Common Shareholders ($million)'''
|'''-1,651,421'''
|'''-2,046,759'''
|'''-1,618,056'''
|'''-1,462,799'''
|'''-961,241'''
|}
==== Cash Flow Statement ====
{| class="wikitable"
|'''Year  end date'''
|'''31/12/2022'''
|'''31/12/2021'''
|'''31/12/2020'''
|'''31/12/2019'''
|'''31/12/2018'''
|-
|Net Income ($ thousands)
|<nowiki>-1,657,772</nowiki>
|<nowiki>-2,043,030</nowiki>
|<nowiki>-1,624,157</nowiki>
|<nowiki>-1,457,722</nowiki>
|<nowiki>-961,034</nowiki>
|-
|'''Cash Flows-Operating Activities'''
|
|
|
|
|
|
|
|
|
|
|-
|
|Depreciation ($ thousands)
|
|428,344
|
|279,032
|
|169,067
|
|116,783
|54,902
|-
|Other Adjustments ($thousands)
|1,543,364
|696,427
|484,793
|628,741
|38,100
|-
|Operating cash flows before changes in working capital ($  thousands)
|313,936
|<nowiki>-1,067,571</nowiki>
|<nowiki>-970,297</nowiki>
|<nowiki>-712,198</nowiki>
|<nowiki>-868,032</nowiki>
|-
|'''Changes in Operating Activities'''
|
|
|
|
Line 1,017: Line 1,123:
|
|
|-
|-
|Accounts Receivable ($ thousands)
|'''Capital Expenditure'''
|98,981
| -19.3
|<nowiki>-37,066</nowiki>
| -25.8
|<nowiki>-174,767</nowiki>
| -17
|<nowiki>-86,546</nowiki>
| -67.4
|<nowiki>-38,524</nowiki>
| -177.3
| -239.8
| -336.3
| -772.2
| -924.2
| -1778
| -1955
| -2151
| -2366
| -2721
|-
|-
|Accounts Payable ($ thousands)
|#REF!
|43,311
|12%
|99,639
|9%
|50,860
|5%
|31,381
|16%
|29,733
|21%
|11%
|8%
|8%
|7%
|12%
|12%
|12%
|12%
|12%
|-
|-
|Changes in Inventories ($ thousands)
|
|1,441
|
|<nowiki>-62,735</nowiki>
|
|<nowiki>-38,528</nowiki>
|
|11,762
|
|<nowiki>-28,465</nowiki>
|
|
|
|
|
|
|
|
|
|
|-
|-
|Deferred revenue ($ thousands)
|'''Change in NWC'''
|<nowiki>-1,093,229</nowiki>
|0
|314,048
| -4
|1,162,399
|19.189
|637,214
| -158.2
|204,161
| -198.1
| -606.1
| -831
|3.412
|1163.028
| -2377
| -2615
| -2877
| -3164
| -3639
|-
|-
|Lease Liabilities ($ thousands)
|% of revenue
|385,911
|0%
|429,366
| -1%
|46,352
|6%
|70,901
| -38%
|<nowiki>--</nowiki>
| -24%
| -28%
| -19%
|0%
|9%
| -17%
| -17%
| -17%
| -17%
| -17%
|-
|-
|Other Operating Activities ($ thousands)
|<nowiki>-492,107</nowiki>
|<nowiki>-534,603</nowiki>
|<nowiki>-490,448</nowiki>
|<nowiki>-594,847</nowiki>
|<nowiki>-662,125</nowiki>
|-
|Net Cash Flow-Operating ($ thousands)
|<nowiki>-1,055,692</nowiki>
|208,649
|555,868
|69,865
|<nowiki>-495,220</nowiki>
|-
|'''Cash Flows-Investing Activities'''
|
|
|
|
Line 1,072: Line 1,208:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|}
{| class="wikitable"
!3SM
!2014
!2015
!2016
!2017
!2018
!2019
!2020
!2021
!2022
!2023
!2024
!2025
!2026
!2027
|-
|-
|Capital Expenditures ($ thousands)
|'''Revenue'''
|<nowiki>-924,178</nowiki>
|160.756
|<nowiki>-772,177</nowiki>
|292.124
|<nowiki>-336,274</nowiki>
|345.67
|<nowiki>-239,844</nowiki>
|414.19
|<nowiki>-177,343</nowiki>
|826.968
|-
|2175.378
|Investments($ thousands)
|4375.664
|<nowiki>-2,630,842</nowiki>
|9955.19
|<nowiki>-2,505,358</nowiki>
|12450
|<nowiki>-219,548</nowiki>
|14317
|<nowiki>-118,462</nowiki>
|15749
|<nowiki>-69,641</nowiki>
|17324
|-
|19056
|Other Investing Activities ($ thousands)
|21915
|1,126,211
|<nowiki>-489,738</nowiki>
|<nowiki>-331,090</nowiki>
|<nowiki>-4,913</nowiki>
|22,456
|-
|-
|Net Cash Flows-Investing ($ thousands)
|% growth
|<nowiki>-2,428,809</nowiki>
|0
|<nowiki>-3,767,273</nowiki>
|82%
|<nowiki>-886,912</nowiki>
|18%
|<nowiki>-363,219</nowiki>
|20%
|<nowiki>-224,528</nowiki>
|100%
|163%
|101%
|128%
|25%
|15%
|10%
|10%
|10%
|15%
|-
|-
|'''Cash Flows-Financing Activities'''
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Line 1,108: Line 1,284:
|
|
|-
|-
|Proceeds from issuance of convertible notes ($ thousands)
|'''EBIT'''
|<nowiki>--</nowiki>
| -87
|2,846,250
| -81
|1,141,362
| -200
|1,138,500
| -501
|564,938
| -984
|-
| -891
|Proceeds from issuance of shares ($ thousands)
| -1303
|50,211
| -1583
|4,050,055
| -1133
|2,970,248
|514
|1,538,802
|566
|4,574
|622
|-
|685
|Net Borrowings ($ thousands)
|787
|<nowiki>-68238</nowiki>
|114035
|<nowiki>-30609</nowiki>
|<nowiki>-2003</nowiki>
|<nowiki>-643</nowiki>
|-
|-
|Other Financing Activities ($ thousands)
|% margin
|418,283
| -54%
|391,249
| -28%
|<nowiki>-347,869</nowiki>
| -58%
|<nowiki>-95,704</nowiki>
| -121%
|<nowiki>-22,241</nowiki>
| -119%
| -41%
| -30%
| -16%
| -9%
|4%
|4%
|4%
|4%
|4%
|-
|-
|Net Cash Flows-Financing ($ thousands)
|
|400,256
|
|7,401,589
|
|3,733,132
|
|2,579,595
|
|546,628
|
|
|
|
|
|
|
|
|
|
|-
|-
|Effect of Exchange Rate ($million)
|'''EBITDA'''
|<nowiki>-143,511</nowiki>
| -87
|<nowiki>-58,218</nowiki>
| -81
|80,727
| -200
|25,025
| -501
|<nowiki>-12,546</nowiki>
| -891
| -736
| -1034
| -1204
| -697
|514
|566
|622
|685
|787
|-
|-
|'''Net Increase/Decrease in Cash Flow ($ thousands)'''
|% margin
|'''-3,227,756'''
| -54%
|'''3,784,747'''
| -28%
|'''3,482,815'''
| -58%
|'''2,311,266'''
| -121%
|'''-185,666'''
| -108%
| -34%
| -24%
| -12%
| -6%
|4%
|4%
|4%
|4%
|4%
|-
|-
|Cash flow at beginning of year ($ thousands)
|
|10838140
|
|7053393
|
|3570578
|
|1259312
|
|1,444,978
|
|-
|
|'''Cash flow at end of year ($ thousands)'''
|
|'''7,610,384'''
|
|'''10,838,140'''
|
|'''7,053,393'''
|
|'''3,570,578'''
|'''1,259,312'''
|}
 
 
 
==== Balance Sheet ====
{| class="wikitable sortable"
|+
!'''Year  end date'''
!'''31/12/2022'''
!'''31/12/2021'''
!'''31/12/2020'''
!'''31/12/2019'''
|-
|'''Current Assets'''
|
|
|
|
Line 1,189: Line 1,380:
|
|
|-
|-
|Cash and Cash Equivalents ($thousands)
|'''Taxes'''
|6,029,859
|3
|9,247,762
|12
|6,166,880
|9
|3,118,988
|11
|4
|86
|142
|333
|168
|26
|28
|31
|34
|39
|-
|-
|Short-Term Investments ($thousands)
|% of EBIT
|864,258
| -3%
|911,281
| -14%
|126,099
| -4%
|102,324
| -2%
|-
|0%
|Net Receivables ($thousands)
| -10%
|2322581
| -11%
|1,889,262
| -21%
|648,936
| -15%
|187,035
|5%
|5%
|5%
|5%
|5%
|-
|-
|Inventory ($thousands)
|
|109,668
|
|117,499
|
|64,219
|
|26,932
|
|-
|
|Other Current Assets ($thousands)
|
|3,361,646
|
|2,969,593
|
|1,932,870
|
|974,860
|
|-
|Total Current Assets ($thousands)
|12,688,012
|15,135,397
|8,939,004
|4,410,139
|-
|'''Long-Term Assets'''
|
|
|
|
Line 1,231: Line 1,428:
|
|
|-
|-
|Long-Term Investments ($thousands)
|'''EBIAT'''
|1,253,593
|'''-90'''
|1,052,861
|'''-93'''
|190,482
|'''-208'''
|113,797
|'''-512'''
|'''-988'''
|'''-977'''
|'''-1445'''
|'''-1916'''
|'''-1301'''
|'''489'''
|'''537'''
|'''591'''
|'''650'''
|'''748'''
|-
|-
|Fixed Assets ($thousands)
|
|1,387,895
|
|1,029,963
|
|386,401
|
|318,620
|
|-
|
|Goodwill ($thousands)
|
|230,208
|
|539,624
|
|216,278
|
|30,952
|
|
|
|
|
|-
|-
|Intangible Assets ($thousands)
|'''D&A'''
|65,019
|0
|52,517
|0
|39,773
|0
|15,020
|0
|93
|155
|269
|379
|436
|0
|0
|0
|0
|0
|-
|-
|Other Assets ($thousands)
|% of revenue
|1,132,843
|0%
|841,908
|0%
|583,829
|0%
|265,301
|0%
|-
|11%
|Deferred Asset Charges ($thousands)
|7%
|245,226
|6%
|103,755
|4%
|99,904
|4%
|70,340
|0%
|-
|0%
|Total Long-Term Assets ($thousands)
|0%
|4,314,784
|0%
|3,620,628
|0%
|1,516,667
|814,030
|-
|'''Total Assets ($thousands)'''
|'''17,002,796'''
|'''18,756,025'''
|'''10,455,671'''
|'''5,224,169'''
|-
|-
|'''Current Liabilities'''
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Line 1,285: Line 1,508:
|
|
|-
|-
|Accounts Payable ($thousands)
|'''Capital Expenditure'''
|258,648
| -19.3
|213,580
| -25.8
|121,637
| -17
|69,370
| -67.4
| -177.3
| -239.8
| -336.3
| -772.2
| -924.2
| -1777.51097
| -1955.26207
| -2150.78827
| -2365.8671
| -2720.74717
|-
|-
|Short-Term Debt / Current Portion of Long-Term Debt  ($thousands)
|% of revenue
|88,410
|12%
|100,000
|9%
|<nowiki>--</nowiki>
|5%
|1,258
|16%
|21%
|11%
|8%
|8%
|7%
|12%
|12%
|12%
|12%
|12%
|-
|-
|Accrued expenses and other payables ($thousands)
|
|1,396,613
|
|1,519,938
|
|2,033,461
|
|980,805
|
|-
|
|Escrow payables and advances from customers($thousands)
|
|1,862,325
|
|1,789,973
|
|161,379
|
|65,062
|
|-
|Deferred revenue ($thousands)
|1,535,083
|2,644,463
|2,150,165
|1,097,868
|-
|Other Current Liabilities ($thousands)
|1,794,613
|908,482
|169,425
|148,003
|-
|Total Current Liabilities ($thousands)
|6,935,692
|7,176,436
|4,636,067
|2,362,366
|-
|'''Long-term Liabilities'''
|
|
|
|
Line 1,333: Line 1,556:
|
|
|-
|-
|Accrued expenses and other payables ($thousands)
|'''Change in NWC'''
|87,072
|0
|76,234
| -4
|36,159
|19.189
|25,802
| -158.2
| -198.1
| -606.1
| -831
|3.412
|1163.028
| -2377.29657
| -2615.02623
| -2876.52885
| -3164.18174
| -3638.809
|-
|-
|Operating Lease Liabilities ($thousands)
|% of revenue
|756,818
|0%
|491,313
| -1%
|177,870
|6%
|144,000
| -38%
|-
| -24%
|Other Liabilities ($thousands)
| -28%
|107
| -19%
|107
|0%
|107
|9%
|1,334
| -17%
| -17%
| -17%
| -17%
| -17%
|-
|-
|Deferred Liability Charges ($thousands)
|
|73,533
|
|111,818
|
|344,823
|
|161,683
|
|
|
|
|
|
|
|
|
|
|
|-
|-
|Convertible notes ($thousands)
|'''Unlevered FCF'''
|3,338,750
|  
|3,475,708
|'''-109'''
|1,840,406
|'''-115'''
|1,356,332
|'''-245'''
|'''-421'''
|'''-874'''
|'''-456'''
|'''-681'''
|'''-2312'''
|'''1088'''
|'''1197'''
|'''1317'''
|'''1449'''
|'''1666'''
|}
{| class="wikitable"
!DCF
!
!2023
!2024
!2025
!2026
!2027
!Terminal Value
|-
|-
|Total long-term liabilities ($thousands)
|'''FCF'''
|4,256,280
|  
|4,155,180
| '''     1,088.4'''
|2,399,365
| '''     1,197.3'''
|1,689,151
| '''     1,317.0'''
| '''     1,448.7'''
| '''     1,666.0'''
| '''          17,698.7'''
|-
|-
|'''Total Liabilities ($thousands)'''
|PV of FCF
|'''11,191,972'''
|4780.26
|'''11,331,616'''
|
|'''7,035,432'''
|
|'''4,051,517'''
|
|
|
|
|-
|-
|'''Stock Holders Equity'''
|Terminal Value
|        17,698.69
|
|
|
|
|
|
Line 1,381: Line 1,657:
|
|
|-
|-
|Common Stocks ($thousands)
|NPV of TV
|281
|10223.39
|278
|
|225
|
|230
|
|
|
|
|-
|-
|Capital Surplus ($thousands)
|Enterprise Value
|14,559,690
|15003.65
|14,622,292
|
|8,526,571
|
|4,687,284
|
|
|
|
|-
|-
|Statutory reserves ($thousands)
|Net Debt
|12,490
| -1137.8
|6,144
|
|2,363
|
|46
|
|
|
|
|-
|-
|Accumulated deficit ($thousands)
|Equity Value
|<nowiki>-8,745,541</nowiki>
|16141.4
|<nowiki>-7,201,498</nowiki>
|
|<nowiki>-5,150,958</nowiki>
|
|<nowiki>-3,530,585</nowiki>
|
|
|
|
|-
|-
|Other Equity ($thousands)
|Shares Out
|<nowiki>-16,096</nowiki>
|477
|<nowiki>-2,807</nowiki>
|
|42,038
|
|15,677
|
|
|
|
|-
|-
|'''Total Equity ($thousands)'''
|Equity Value per Share
|'''5,810,824'''
|33.83
|'''7,424,409'''
|
|'''3,420,239'''
|
|'''1,172,652'''
|
|
|
|
|-
|-
|'''Total Liabilities & Equity ($thousands)'''
|Current share price
|'''17,002,796'''
|£35.21
|'''18,756,025'''
|
|'''10,455,671'''
|
|'''5,224,169'''
|
|
|
|
|-
|Difference
| -3.9%
|
|
|
|
|
|
|}
|}
==== Financial Ratios ====
{| class="wikitable"
{| class="wikitable"
!Year End Date
!WACC
!2022
!LTM
!2021
!2020
!2019
!2018
|-
|-
|Current  Ratio
|'''Weights'''
|183%
|
|211%
|193%
|187%
|N/A
|-
|-
|Quick Ratio
|Total Debt
|120%
|4262.053
|155%
|147%
|140%
|N/A
|-
|-
|Cash Ratio
|Market Cap
|87%
|20026
|129%
|133%
|132%
|N/A
|-
|-
|Gross Margin
|Total
|42%
|24288.053
|39%
|31%
|28%
|2%
|-
|-
|Operating Margin
|Wd
| -12%
|18%
| -16%
| -30%
| -41%
| -120%
|-
|-
|Pre-Tax Margin
|We
| -12%
|82%
| -17%
|-
| -34%
|
| -63%
|
| -115%
|-
|'''Debt'''
|
|-
|-
|Profit Margin
|Total Debt
| -13%
|4262.053
| -21%
| -37%
| -67%
| -116%
|-
|-
|Pre-Tax ROE
|Interest Expense
| -100%
| -43.1
| -45%
| -78%
| -382%
|N/A
|-
|-
|After Tax ROE
|Rate
| -111%
|1%
| -54%
|-
| -85%
|Effective Tax Rate
| -406%
|5%
|N/A
|-
|}
|Rd(1-t)
 
|1.0%
=== Valuation inputs ===
(Figures in $millions)
{| class="wikitable"
!1. Income Statement
!2014
!2015
!2016
!2017
!2018
!2019
!2020
!2021
!2022
!2023
!2024
!2025
!2026
!2027
|-
|-
|'''Revenue'''
|
|160.756
|
|292.124
|345.67
|414.19
|826.968
|2175.378
|4375.664
|9955.19
|12449.705
|14317
|15749
|17324
|19056
|21915
|-
|-
|% growth
|'''Equity'''
|
|
|82%
|-
|18%
|Risk Free Rate
|20%
|4.2%
|100%
|-
|163%
|Beta
|101%
|1.67
|128%
|-
|25%
|Market Rate
|15%
|10%
|10%
|-
|10%
|Re
|10%
|13.9%
|15%
|-
|-
|
|
|
|
|-
|'''Discount Rate'''
|11.60%
|-
|'''Perpetuity Growth Rate'''
|2.0%
|}
{| class="wikitable"
!Terminal  Value
!
|-
|'''Perpetuity Growth'''
|
|
|-
|FCFn
|    1,665.98
|-
|Growth Rate
|2.0%
|-
|WACC
|12%
|-
|Perpetuity Growth  TV
|    17,698.7
|-
|
|
|
|
|-
|'''Exit Multiple'''
|
|-
|EBITDA
| -
|-
|EV/EBITDA Multiple
| -
|-
|Exit Multiple TV
| -
|-
|
|
|
|
|-
|'''Average'''
| '''    17,698.7'''
|}
{| class="wikitable"
! colspan="8" |Sensitivity Analysis
|-
| colspan="8" |                        '''Perpetuity Growth Rate'''
|-
| rowspan="8" |'''WACC'''
|$33.83
|'''1.0%'''
|'''1.5%'''
|'''2.0%'''
|'''2.5%'''
|'''3.0%'''
|
|
|-
|'''5.0%'''
|£4.96
|£5.62
|£6.51
|£7.76
|£9.62
|
|
|-
|'''5.5%'''
|£4.35
|£4.86
|£5.51
|£6.38
|£7.60
|
|
|-
|'''6.0%'''
|£3.86
|£4.26
|£4.76
|£5.40
|£6.25
|
|
|-
|'''6.2%'''
|£3.69
|£4.05
|'''£4.50'''
|£5.08
|£5.83
|
|
|
|-
|
|'''6.5%'''
|£3.46
|£3.78
|£4.17
|£4.66
|£5.29
|
|
|-
|-
| '''Cost Of Goods Sold'''  
|'''7.0%'''
|124.573
|£3.12
|184.298
|£3.38
|232.598
|£3.70
|326.878
|£4.08
|812.21
|£4.56
|1570.458
|
|3026.759
|6059.455
|7264.428
|8590
|9449
|10394
|11434
|13149
|-
|% of revenue
|77%
|63%
|67%
|79%
|98%
|72%
|69%
|61%
|58%
|60%
|60%
|60%
|60%
|60%
|-
|-
|'''7.5%'''
|£2.84
|£3.06
|£3.31
|£3.62
|£4.00
|
|
|
|}
|
 
|
== Appendix ==
|
All data in financial statements were retrieved from Sea Limited's published annual reports since 2017.<ref><nowiki>https://www.sea.com/investor/annualreports</nowiki></ref>
|
 
|
=== Income Statement ===
|
{| class="wikitable"
|
!'''Year end  date'''
|
!31/12/2022
|
!31/12/2021
|
!31/12/2020
|
!31/12/2019
|
!31/12/2018
|
|-
|-
| '''Gross Profit'''
|Total  Revenue ($million)
|36.183
|12,449,705
|107.826
|9,955,190
|113.072
|4,375,664
|87.312
|2,175,378
|14.758
|826,968
|604.92
|-
|1348.905
|Cost of Revenue ($million)
|3895.735
| -7,264,428
|5185.277
| -6,059,455
|5727
| -3,026,759
|6300
| -1,570,458
|6930
| -812,210
|7622
|-
|8766
|'''Gross Profit ($million)'''
|'''5,185,277'''
|'''3,895,735'''
|'''1,348,905'''
|'''604,920'''
|'''14,758'''
|-
|-
|'''Operating Income/Expenses'''
|
|
|
|
Line 1,633: Line 1,949:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|-
|-
|'''Selling General & Admin  Exp.'''
|Research and Development ($million)
|112.958
| -1,376,501
|174.547
| -831,703
|294.187
| -353,785
|562.92
| -156,634
|940.63
| -67,529
|1355.408
|-
|2430.581
|General and Admin. ($million)
|4817.611
| -1,437,612
|4706.835
| -987,868
|5441
| -599,706
|5985
| -385,865
|6583
| -240,781
|7241
|8328
|-
|-
|% of revenue
|Sales and marketing ($million)
|70%
| -3,269,223
|60%
| -3,829,743
|85%
| -1,830,875
|136%
| -969,543
|114%
| -705,015
|62%
|56%
|48%
|38%
|38%
|38%
|38%
|38%
|38%
|-
|-
|
|Other Operating Income ($million)
|
|279,184
|
|287,946
|
|189,645
|
|15,890
|
|9,799
|
|
|
|
|
|
|
|
|
|-
|-
|'''Provision for bad debts'''
|Provision for credit losses ($million)
| -
| -513,690
| -
| -117,427
| -
| -57,509
| -
| --
| -
| --
| -
|57.509
|117.427
|513.69
|0
|0
|0
|0
|0
|-
|-
|% of revenue
|Goodwill ($million)
|#VALUE!
| -354,943
|#VALUE!
| --
|#VALUE!
| --
|#VALUE!
| --
|#VALUE!
| --
|#VALUE!
|-
|1.3%
|'''Total operating expenses ($million)'''
|1.2%
|'''-6,672,785'''
|4.1%
|'''-5,478,795'''
|0.0%
|'''-2,652,230'''
|0.0%
|'''-1,496,152'''
|0.0%
|'''-1,003,526'''
|0.0%
|0.0%
|-
|-
|
|'''Operating Loss ($million)'''
|
|'''-1,487,508'''
|
|'''-1,583,060'''
|
|'''-1,303,325'''
|
|'''-891,232'''
|
|'''-988,768'''
|
|
|
|
|
|
|
|
|
|-
|-
|'''R&D Exp'''
|Interest income/expense and others* ($million)
|11.053
| -13,025
|17.732
| -132,124
|20.809
| -179,913
|29.323
| -477,387
|67.529
|34,888
|156.634
|353.785
|831.703
|1376.501
|1096
|1206
|1326
|1459
|1678
|-
|-
|% of revenue
|'''Earnings/Losses Before Tax ($million)'''
|7%
|'''-1,500,533'''
|6%
|'''-1,715,184'''
|6%
|'''-1,483,238'''
|7%
|'''-1,368,619'''
|8%
|'''-953,880'''
|7%
|-
|8%
|Income Tax ($million)
|8%
| -168,395
|11%
| -332,865
|8%
| -141,640
|8%
| -85,864
|8%
| -4,088
|8%
|8%
|-
|-
|
|Share of results of equity investees ($million)
|
|11,156
|
|5,019
|
|721
|
| -3,239
|
|3,066
|
|-
|
|'''Net loss ($million)'''
|
|'''-1,657,772'''
|
|'''-2,043,030'''
|
|'''-1,624,157'''
|
|'''-1,457,722'''
|
|'''-961,034'''
|
|
|-
|-
|'''Depreciation & Amort.'''
|Net income/loss attributable to non-controlling interests ($million)
|0
|6,351
|0
| -3,729
|0
|6,101
|0
| -5,077
|0
| -207
|0
|0
|0
|0
|0
|0
|0
|0
|0
|-
|-
|% of revenue
|'''Net Loss Applicable to Common Shareholders ($million)'''
|0%
|'''-1,651,421'''
|0%
|'''-2,046,759'''
|0%
|'''-1,618,056'''
|0%
|'''-1,462,799'''
|0%
|'''-961,241'''
|0%
|}
|0%
 
|0%
=== Cash Flow Statement ===
|0%
{| class="wikitable"
|0%
|'''Year  end date'''
|0%
|'''31/12/2022'''
|0%
|'''31/12/2021'''
|0%
|'''31/12/2020'''
|0%
|'''31/12/2019'''
|'''31/12/2018'''
|-
|Net Income ($ thousands)
|<nowiki>-1,657,772</nowiki>
|<nowiki>-2,043,030</nowiki>
|<nowiki>-1,624,157</nowiki>
|<nowiki>-1,457,722</nowiki>
|<nowiki>-961,034</nowiki>
|-
|-
|
|'''Cash Flows-Operating Activities'''
|
|
|
|
|
|
|
|
|
|
|
|
|
Line 1,836: Line 2,079:
|
|
|-
|-
|'''Other Operating  Expense/(Income)'''
|Depreciation ($ thousands)
| -0.7
|428,344
| -3.1
|279,032
| -2.1
|169,067
| -3.5
|116,783
| -9.8
|54,902
| -15.9
| -189.6
| -287.9
| -279.2
| -228
| -251
| -276
| -303
| -349
|-
|-
|% of revenue
|Other Adjustments ($thousands)*
|0%
|1,543,364
| -1%
|696,427
| -1%
|484,793
| -1%
|628,741
| -1%
|38,100
| -1%
| -4%
| -3%
| -2%
| -2%
| -2%
| -2%
| -2%
| -2%
|-
|-
|Operating cash flows before changes in working capital ($  thousands)
|313,936
|<nowiki>-1,067,571</nowiki>
|<nowiki>-970,297</nowiki>
|<nowiki>-712,198</nowiki>
|<nowiki>-868,032</nowiki>
|-
|'''Changes in Operating Activities'''
|
|
|
|
Line 1,873: Line 2,106:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|-
|-
|'''Total Operating Expenses'''
|Accounts Receivable ($ thousands)
|123.269
|98,981
|189.216
|<nowiki>-37,066</nowiki>
|312.893
|<nowiki>-174,767</nowiki>
|588.746
|<nowiki>-86,546</nowiki>
|998.36
|<nowiki>-38,524</nowiki>
|1496.152
|-
|2652.23
|Accounts Payable ($ thousands)
|5478.795
|43,311
|6317.842
|99,639
|5213
|50,860
|5734
|31,381
|6307
|29,733
|6938
|-
|7979
|Changes in Inventories ($ thousands)
|1,441
|<nowiki>-62,735</nowiki>
|<nowiki>-38,528</nowiki>
|11,762
|<nowiki>-28,465</nowiki>
|-
|-
|
|Deferred revenue ($ thousands)
|
|<nowiki>-1,093,229</nowiki>
|
|314,048
|
|1,162,399
|
|637,214
|
|204,161
|
|-
|
|Lease Liabilities ($ thousands)
|
|385,911
|
|429,366
|46,352
|70,901
|<nowiki>--</nowiki>
|-
|Other Operating Activities ($ thousands) *
|<nowiki>-492,107</nowiki>
|<nowiki>-534,603</nowiki>
|<nowiki>-490,448</nowiki>
|<nowiki>-594,847</nowiki>
|<nowiki>-662,125</nowiki>
|-
|Net Cash Flow-Operating ($ thousands)
|<nowiki>-1,055,692</nowiki>
|208,649
|555,868
|69,865
|<nowiki>-495,220</nowiki>
|-
|'''Cash Flows-Investing Activities'''
|
|
|
|
Line 1,916: Line 2,163:
|
|
|-
|-
|'''Operating Income / EBIT'''
|Capital Expenditures ($ thousands)
| -87.1
|<nowiki>-924,178</nowiki>
| -81.4
|<nowiki>-772,177</nowiki>
| -199.8
|<nowiki>-336,274</nowiki>
| -501.4
|<nowiki>-239,844</nowiki>
| -983.6
|<nowiki>-177,343</nowiki>
| -891.2
|-
| -1303.3
|Investments($ thousands)
| -1583.1
|<nowiki>-2,630,842</nowiki>
| -1132.6
|<nowiki>-2,505,358</nowiki>
|514
|<nowiki>-219,548</nowiki>
|566
|<nowiki>-118,462</nowiki>
|622
|<nowiki>-69,641</nowiki>
|685
|-
|787
|Other Investing Activities ($ thousands)
|1,126,211
|<nowiki>-489,738</nowiki>
|<nowiki>-331,090</nowiki>
|<nowiki>-4,913</nowiki>
|22,456
|-
|Net Cash Flows-Investing ($ thousands)
|<nowiki>-2,428,809</nowiki>
|<nowiki>-3,767,273</nowiki>
|<nowiki>-886,912</nowiki>
|<nowiki>-363,219</nowiki>
|<nowiki>-224,528</nowiki>
|-
|-
|'''Cash Flows-Financing Activities'''
|
|
|
|
Line 1,937: Line 2,197:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|-
|-
|'''EBITDA'''
|Proceeds from issuance of convertible notes ($ thousands)
| -69.3
|<nowiki>--</nowiki>
| -52.1
|2,846,250
| -160.3
|1,141,362
| -460.5
|1,138,500
| -904.9
|564,938
| -769.6
|-
| -1122.6
|Proceeds from issuance of shares ($ thousands)
| -1304
|50,211
| -704.2
|4,050,055
|514
|2,970,248
|566
|1,538,802
|622
|4,574
|685
|787
|-
|-
|
|Net Borrowings ($ thousands)
|
|<nowiki>-68238</nowiki>
|
|114035
|
|<nowiki>-30609</nowiki>
|
|<nowiki>-2003</nowiki>
|
|<nowiki>-643</nowiki>
|
|-
|
|Other Financing Activities ($ thousands)
|
|418,283
|
|391,249
|
|<nowiki>-347,869</nowiki>
|
|<nowiki>-95,704</nowiki>
|
|<nowiki>-22,241</nowiki>
|
|
|-
|-
| '''Tax Expense'''
|Net Cash Flows-Financing ($ thousands)
|2.521
|400,256
|11.73
|7,401,589
|8.546
|3,733,132
|10.745
|2,579,595
|4.088
|546,628
|85.864
|-
|141.64
|Effect of Exchange Rate ($million)
|332.865
|<nowiki>-143,511</nowiki>
|168.395
|<nowiki>-58,218</nowiki>
|26
|80,727
|28
|25,025
|31
|<nowiki>-12,546</nowiki>
|34
|39
|-
|-
|Effective tax rate
|'''Net Increase/Decrease in Cash Flow ($ thousands)'''
| -3%
|'''-3,227,756'''
| -14%
|'''3,784,747'''
| -4%
|'''3,482,815'''
| -2%
|'''2,311,266'''
|0%
|'''-185,666'''
| -10%
|-
| -11%
|Cash flow at beginning of year ($ thousands)
| -21%
|10838140
| -15%
|7053393
|5%
|3570578
|5%
|1259312
|5%
|1,444,978
|5%
|-
|5%
|'''Cash flow at end of year ($ thousands)'''
|'''7,610,384'''
|'''10,838,140'''
|'''7,053,393'''
|'''3,570,578'''
|'''1,259,312'''
|}
|}
{| class="wikitable"
 
!2. Cashflow Statement
 
!2014
=== Balance Sheet ===
!2015
 
!2016
 
!2017
{| class="wikitable sortable"
!2018
|+
!2019
!'''Year end date'''
!2020
!'''31/12/2022'''
!2021
!'''31/12/2021'''
!2022
!'''31/12/2020'''
!2023
!'''31/12/2019'''
!2024
!2025
!2026
!2027
|-
|-
|'''Depreciation & Amort.'''
|'''Current Assets'''
|0
|
|0
|
|0
|
|0
|
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|-
|-
|% of revenue
|Cash and Cash Equivalents ($thousands)
|0%
|6,029,859
|0%
|9,247,762
|0%
|6,166,880
|0%
|3,118,988
|0%
|-
|0%
|Short-Term Investments ($thousands)
|0%
|864,258
|0%
|911,281
|0%
|126,099
|0%
|102,324
|0%
|0%
|0%
|0%
|-
|-
|
|Net Receivables ($thousands)
|
|2322581
|
|1,889,262
|
|648,936
|
|187,035
|
|-
|
|Inventory ($thousands)
|
|109,668
|
|117,499
|
|64,219
|
|26,932
|-
|Other Current Assets ($thousands)
|3,361,646
|2,969,593
|1,932,870
|974,860
|-
|Total Current Assets ($thousands)
|12,688,012
|15,135,397
|8,939,004
|4,410,139
|-
|'''Long-Term Assets'''
|
|
|
|
Line 2,077: Line 2,322:
|
|
|-
|-
|'''Capital Expenditure'''
|Long-Term Investments ($thousands)
| -19.3
|1,253,593
| -25.8
|1,052,861
| -17
|190,482
| -67.4
|113,797
| -177.3
|-
| -239.8
|Fixed Assets ($thousands)
| -336.3
|1,387,895
| -772.2
|1,029,963
| -924.2
|386,401
| -1778
|318,620
| -1955
| -2151
| -2366
| -2721
|-
|-
|% of revenue
|Goodwill ($thousands)
|12%
|230,208
|9%
|539,624
|5%
|216,278
|16%
|30,952
|21%
|11%
|8%
|8%
|7%
|12%
|12%
|12%
|12%
|12%
|-
|-
|
|Intangible Assets ($thousands)
|
|65,019
|
|52,517
|
|39,773
|
|15,020
|
|
|
|
|
|
|
|
|
|
|-
|-
|'''Change in NWC'''
|Other Assets ($thousands)
|0
|1,132,843
| -4
|841,908
|19.189
|583,829
| -158.2
|265,301
| -198.1
|-
| -606.1
|Deferred Asset Charges ($thousands)
| -831
|245,226
|3.412
|103,755
|1163.028
|99,904
| -2377
|70,340
| -2615
| -2877
| -3164
| -3639
|-
|-
|% of revenue
|Total Long-Term Assets ($thousands)
|0%
|4,314,784
| -1%
|3,620,628
|6%
|1,516,667
| -38%
|814,030
| -24%
| -28%
| -19%
|0%
|9%
| -17%
| -17%
| -17%
| -17%
| -17%
|}
{| class="wikitable"
!3. 3SM
!2014
!2015
!2016
!2017
!2018
!2019
!2020
!2021
!2022
!2023
!2024
!2025
!2026
!2027
|-
|-
|'''Revenue'''
|'''Total Assets ($thousands)'''
|160.756
|'''17,002,796'''
|292.124
|'''18,756,025'''
|345.67
|'''10,455,671'''
|414.19
|'''5,224,169'''
|826.968
|-
|2175.378
|'''Current Liabilities'''
|4375.664
|
|9955.19
|
|12450
|
|14317
|
|15749
|17324
|19056
|21915
|-
|-
|% growth
|Accounts Payable ($thousands)
|0
|258,648
|82%
|213,580
|18%
|121,637
|20%
|69,370
|100%
|163%
|101%
|128%
|25%
|15%
|10%
|10%
|10%
|15%
|-
|-
|
|Short-Term Debt / Current Portion of Long-Term Debt  ($thousands)
|
|88,410
|
|100,000
|
|<nowiki>--</nowiki>
|
|1,258
|
|
|
|
|
|
|
|
|
|
|-
|-
|'''EBIT'''
|Accrued expenses and other payables ($thousands)
| -87
|1,396,613
| -81
|1,519,938
| -200
|2,033,461
| -501
|980,805
| -984
|-
| -891
|Escrow payables and advances from customers($thousands)
| -1303
|1,862,325
| -1583
|1,789,973
| -1133
|161,379
|514
|65,062
|566
|622
|685
|787
|-
|-
|% margin
|Deferred revenue ($thousands)
| -54%
|1,535,083
| -28%
|2,644,463
| -58%
|2,150,165
| -121%
|1,097,868
| -119%
|-
| -41%
|Other Current Liabilities ($thousands)
| -30%
|1,794,613
| -16%
|908,482
| -9%
|169,425
|4%
|148,003
|4%
|-
|4%
|Total Current Liabilities ($thousands)
|4%
|6,935,692
|4%
|7,176,436
|4,636,067
|2,362,366
|-
|-
|'''Long-term Liabilities'''
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|-
|-
|'''EBITDA'''
|Accrued expenses and other payables ($thousands)
| -87
|87,072
| -81
|76,234
| -200
|36,159
| -501
|25,802
| -984
|-
| -891
|Operating Lease Liabilities ($thousands)
| -1303
|756,818
| -1583
|491,313
| -1133
|177,870
|514
|144,000
|566
|622
|685
|787
|-
|-
|% margin
|Other Liabilities ($thousands)
| -54%
|107
| -28%
|107
| -58%
|107
| -121%
|1,334
| -119%
|-
| -41%
|Deferred Liability Charges ($thousands)
| -30%
|73,533
| -16%
|111,818
| -9%
|344,823
|4%
|161,683
|4%
|4%
|4%
|4%
|-
|-
|
|Convertible notes ($thousands)
|
|3,338,750
|
|3,475,708
|
|1,840,406
|
|1,356,332
|
|-
|
|Total long-term liabilities ($thousands)
|
|4,256,280
|
|4,155,180
|
|2,399,365
|
|1,689,151
|-
|'''Total Liabilities ($thousands)'''
|'''11,191,972'''
|'''11,331,616'''
|'''7,035,432'''
|'''4,051,517'''
|-
|'''Stock Holders Equity'''
|
|
|
|
Line 2,318: Line 2,472:
|
|
|-
|-
|'''Taxes'''
|Common Stocks ($thousands)
|3
|281
|12
|278
|9
|225
|11
|230
|4
|86
|142
|333
|168
|26
|28
|31
|34
|39
|-
|-
|% of EBIT
|Capital Surplus ($thousands)
| -3%
|14,559,690
| -14%
|14,622,292
| -4%
|8,526,571
| -2%
|4,687,284
|0%
| -10%
| -11%
| -21%
| -15%
|5%
|5%
|5%
|5%
|5%
|-
|-
|
|Statutory reserves ($thousands)
|
|12,490
|
|6,144
|
|2,363
|
|46
|
|
|
|
|
|
|
|
|
|
|-
|-
|'''EBIAT'''
|Accumulated deficit ($thousands)
| -90
|<nowiki>-8,745,541</nowiki>
| -93
|<nowiki>-7,201,498</nowiki>
| -208
|<nowiki>-5,150,958</nowiki>
| -512
|<nowiki>-3,530,585</nowiki>
| -988
| -977
| -1445
| -1916
| -1301
|489
|537
|591
|650
|748
|-
|-
|
|Other Equity ($thousands)
|
|<nowiki>-16,096</nowiki>
|
|<nowiki>-2,807</nowiki>
|
|42,038
|
|15,677
|
|-
|
|'''Total Equity ($thousands)'''
|
|'''5,810,824'''
|
|'''7,424,409'''
|
|'''3,420,239'''
|
|'''1,172,652'''
|
|
|
|
|-
|-
|'''D&A'''
|'''Total Liabilities & Equity ($thousands)'''
|0
|'''17,002,796'''
|0
|'''18,756,025'''
|0
|'''10,455,671'''
|0
|'''5,224,169'''
|0
|}
|0
 
|0
=== Financial Ratios ===
|0
{| class="wikitable"
|0
!Year End Date
|0
!2022
|0
!2021
|0
!2020
|0
!2019
|0
!2018
|-
|Current  Ratio
|183%
|211%
|193%
|187%
|N/A
|-
|-
|% of revenue
|Quick Ratio
|0%
|120%
|0%
|155%
|0%
|147%
|0%
|140%
|0%
|N/A
|0%
|-
|0%
|Cash Ratio
|0%
|87%
|0%
|129%
|0%
|133%
|0%
|132%
|0%
|N/A
|0%
|0%
|-
|-
|
|Gross Margin
|
|42%
|
|39%
|
|31%
|
|28%
|
|2%
|
|
|
|
|
|
|
|
|
|-
|-
|'''Capital Expenditure'''
|Operating Margin
| -19.3
| -12%
| -25.8
| -16%
| -17
| -30%
| -67.4
| -41%
| -177.3
| -120%
| -239.8
| -336.3
| -772.2
| -924.2
| -1777.51097
| -1955.26207
| -2150.78827
| -2365.8671
| -2720.74717
|-
|-
|% of revenue
|Pre-Tax Margin
|12%
| -12%
|9%
| -17%
|5%
| -34%
|16%
| -63%
|21%
| -115%
|11%
|-
|8%
|Profit Margin
|8%
| -13%
|7%
| -21%
|12%
| -37%
|12%
| -67%
|12%
| -116%
|12%
|12%
|-
|-
|
|Pre-Tax ROE
|
| -100%
|
| -45%
|
| -78%
|
| -382%
|
|N/A
|
|
|
|
|
|
|
|
|
|-
|-
|'''Change in NWC'''
|After Tax ROE
|0
| -111%
| -4
| -54%
|19.189
| -85%
| -158.2
| -406%
| -198.1
|N/A
| -606.1
| -831
|3.412
|1163.028
| -2377.29657
| -2615.02623
| -2876.52885
| -3164.18174
| -3638.809
|-
|% of revenue
|0%
| -1%
|6%
| -38%
| -24%
| -28%
| -19%
|0%
|9%
| -17%
| -17%
| -17%
| -17%
| -17%
|-
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|-
|'''Unlevered Free Cash Flow'''
|
|'''-109'''
|'''-115'''
|'''-245'''
|'''-421'''
|'''-967'''
|'''-611'''
|'''-950'''
|'''-2692'''
|'''1088'''
|'''1197'''
|'''1317'''
|'''1449'''
|'''1666'''
|}
|}
__INDEX__
__INDEX__
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)