ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1
PC -> Calculate your recovery by Clicking on the TOP MENU -> "File" -> "Make Copy". SMARTPHONE download & install Google Sheets from the Apple or Google Store, then top right corner -> 3 Dots -> Share & Export -> "Make Copy". Insert your Assets as seen on the stretto links on the right! ->To look for your official crypto claims/holdings click on the link below, go to -> Page 92 and click -> "Your first letter of your First Name", then Insert your cryptos according to Earn & Withhold, Custody and Loans..Go to Page 34 and Select the letter of your first name, then insert the deposit and withdrawals in each collumn in Dollars
2
https://cases.stretto.com/public/x191/11749/PLEADINGS/1174910062280000000017.pdfhttps://cases.stretto.com/public/x191/11749/PLEADINGS/1174910062280000000005.pdf
3
EARN & WITHHOLD ACCOUNTCelsius Custody Program (Just for The United States)LoansWithdrawals Preference (Coins you transferred in the last 90 days)Current Status:
4
Main Crypto CoinsPrice at FilingInsert Your EARN Coins As In The Above PDFInsert Your Withheld Coins As In The Above PDFMain Crypto CoinsInsert your CUSTODY CoinsCoins to be payedMain Crypto CoinsInsert Your Collateral from Loans still open(#)Insert your Loans size by coin in($)How Much ($) left after setoff[1] or paying the LoanDeposits in ($)Withdrawals in ($)We have effective date! the funds will be available for withdraw soon in Coinbase or Paypal! Make sure to log into Celsius app, update your documents and user information to match your accounts in Coinbase or Paypal so the distributions wrong smoothly and as fast as possible!Created by @RonPaulBot1234 at my spouse @CelsiusFacts request
5
1inch$0.581inch01inch$0.00Did you Voted Yes or Abstain for the Reorganization Plan? (In case you don't know leave as "I approved..")
6
AAVE$78.24AAVE0AAVE$0.00I approved or did not vote
7
ADA$0.43ADA0ADA$0.00Donations & Feedback appreciated: https://t.co/sqhNASPaJk
8
AVAX$18.49AVAX0AVAX$0.00If you withdrew more than what you deposit, 90 days prior to July 13th 2022, you might be forced to transfer 27,5% of that value if you rejected the plan or these widthdrawls were over 100,000$. Go to the stretto link on the orange Cel above, look for your name and add the withdrawals & deposits on the left collumns.
9
BADGER$3.29BADGER0BADGER$0.00
10
BAT$0.38BAT0BAT$0.00
11
BCH$100.54BCH0BCH$0.00
12
BNB$226.93BNB0BNB$0.00(Example of what you are looking for in the transfers PDF after finding your name, sum the withdrawals and put in the withdrawals collumn, then do the same for the deposits, you actually dont need to do it by coin)
13
BTC$19,881.00BTC0BTC$0.00
14
DASH$41.80DASH0DASH$0.00
15
DOGE$0.06DOGE0DOGE$0.00
16
DOT$6.36DOT0DOT$0.00
17
EOS$0.93EOS0EOS$0.00
18
ETC$14.13ETC0ETC$0.00
19
ETH$1,088.17ETH0ETH$0.00BTC Price89637.66ETH Price3128.6Aprox Allowed Claims$4,966,499,999
20
LINK$6.08LINK0LINK$0.00
21
LTC$48.76LTC0LTC$0.00Total Net WithdrawalsPay Clawback/WEPRESERVESLOC FundsHoldbacksTetherEQF
22
MANA$0.80MANA0MANA$0.00$0.00$132,000,000Total Reserves Value $84,000,000Total Value - Corporate Settlement% of Total Claims$29,500,000.00% of Total Claims
% of Total Claims
23
MATIC$0.61MATIC0MATIC$0.00BTC3071.696896$275,339,7221954.716207$175,216,187Total Reserves$120,519,0002.43%BTC686.48395423,544,452,351.7271.37%$337,485,7906.80%
24
PAUXG$1,738.830PAUXG0PAUXG$0.00Your Earn Claims+Witheld (What Celsius owns you)Opt to go to the Convenience ClassETH51222.35157$160,252,31832596.04191$101,978,748- Maintenance$70,519,0001.42%ETH11447.4194815658.211,403,565,304.1928.26%$307,069,0006.18%
25
SNX$2.470SNX0SNX$0.00$0.00Sum$435,592,040$277,194,935Sum$97,348,221.072228.01199,713,602.864.02%
26
SOL$34.24SOL0SOL$0.00$0.00% of Total Claims8.77%5.58%% of Total Claims1.96%Damages100,000,000.002.01%SUM12.98%
27
SUSHI$1.21SUSHI0SUSHI$0.00Your Withheld Claims Total USA Custody ClaimsCustody InKind SettlementCrypto(x2)$23,000,000% of Total Claims$428,730,441.828.63%
28
UMA$2.49UMA0UMA$0.00$0.00$0.00BTC535.220.97%$328,730,441.826.62%
29
UNI$6.01UNI0UNI$0.00ETH8925.1067130.56%
30
Stable Coins (USDC,USDT, DAI ... ) $1.00Stable Coins (USDC,USDT, DAI ... ) 0Stable Coins (USDC,USDT, DAI ... ) $0.00Total Collateral from Loans in ($) you will receiveSelect Payment of Loan (unchecked is setoff)Total Custody inKind Available to be WithdrawnFIAT - Corporate$117,000,0002.36%
31
XAUT$1,741.00XAUT0XAUT$0.00$0.00SUM$192,898,6133.88%
32
XLM$0.10XLM0XLM$0.00You dont have funds in the U.S.A. custody account
33
XRP$0.32XRP0XRP$0.00
34
Other CoinsOther CoinsOther CoinsCollateral from Loans still openedInsert your Loan size by coinReceived after paying the LoanOther Coins
35
BNT$0.45BNT0BNT$0.00Other CoinsCurrent Prices
36
BSV$50.99BSV0BSV$0.00Liabilities in #Assets in # Last Coin Report (+25k from Stakehound Eth Dec 2023)Price at CH11Assets Value @petitionLiabilities @petitionAssets Value todayPrices todayPrices at 67% (Ballot)Assets Value at 67% (Ballot)Liabilities if Priced todayIlliquid Fair Value Transfer to Mining1INCH111946700.0656
37
BTG$15.14BTG0BTG$0.00BTC104,00038,000$19,881.00$755,478,0002,067,624,000$1,632,973,620$42,972.99$27,690.00$1,052,220,000$4,469,190,960Core Scientific$59,663,000AVAX$1,371,756,405.5248
38
COMP$47.33COMP0COMP$0.00ETH1,034,000809,684$1,088.00$880,936,1921,124,992,000$2,086,555,668$2,577.00$1,846.00$1,494,676,664$2,664,618,000Rhodium$37,534,000BADGER3.805602762
39
CRV$1.03CRV0CRV$0.00Stables1,129,608,000576,524,000$1.00$576,524,0001,129,608,000$576,524,000$1.00$1.00$576,524,000$1,129,608,000Mawson$10,784,000BAT141302483.6
40
CVX$6.09CVX0CVX$0.00Total Dollarize Recovery (Your total recovery in the eyes of the court it shouldnt be over 105%)Expected Earn Recovery (Inludes Loans,Withhold)Convenience Earn Recovery (Only applies if you have under $5000)You didnt Opt Out of the 5% settlement in your claims MATIC244,115,000114,178,000$0.60$68,506,800146,469,000$63,353,123$0.555$0.87$99,334,860$135,450,329Luxor$750,000DASH116230916.5
41
KNC$1.26KNC0KNC$0.00(Does not apply to you, look at the Convenience recovery)EuroCanadian DollarADA259,415,00015,856,000$0.42$6,659,520108,954,300$15,741,650$0.99$0.37$5,866,720$257,544,160DOGE$11,862,009,303.9113
42
LPT$8.03LPT0LPT$0.00Total Claims in Dollars (Custody+Loan+Withhold+Earn)Receiving In Crypto Earn+Withhold [3] (Dollarized)Receiving In Crypto [1] (Dollarized)Convert dollars into other currencies€0.00$0.00DOT4,748,000612,000$6.36$3,892,32030,197,280$5,246,270$8.57$5.27$3,224,628$40,701,458Illiquid Value Going Back to CreditorsETC$637,237,970.5332
43
MKR$839.89MKR0MKR$0.00$0.00British PoundAustralian DollarLINK9,338,000314,000$6.07$1,905,98056,681,660$5,557,031$17.70$6.40$2,008,344$165,259,739Institutional Loans$33,462,000MANA$1,568,460,226.6044
44
OMG$1.72OMG0OMG$0.00Dollar Value of Mining stock (Ionic Digital) Receiving In Mining Stock & illiquid Distributions [4] (Dollarized)Total Convenience Claims (Dollarized)Add Holdbacks (Check to add hold back funds)£0.00$0.00LTC427,00099,000$48.75$4,826,25020,816,250$9,444,317$95.40$87.50$8,662,500$40,734,577Equities First Loans$162,682,000PAUXG13815609.39
45
ORBS$0.04ORBS0ORBS$0.00Not applicable, you receive more crypto instead.Does not apply!Swiss FrankDanish CrownAAVE125,0009,000$78.24$704,1609,780,000$1,521,966$169.11$63.20$568,800$21,138,422Osprey Trust$17,480,000SNX$93,968,759.3080
46
SGB$0.03SGB0SGB$0.00Post Emergence & Illiquid Value to be Received in Time (From a few months Up to 5 years)Total Value of Withdrawal Crypto +5% (Dollarized, Earn+Withhold+Loans)Total Value Being Received +5% (Dollarized, Earn+Withhold+Loans)(If you are in the earn class over 5k in claims, its likely that you could receive a lot more value to fully achieve a full dollarize claim, a few months after the intial distribution)CHF0.000.00 kr.DAI4,340,0009,084,000$1.00$9,084,0004,340,000$9,085,261$1.00$1.00$9,084,000$4,340,603QRDO Investment$13,068,000SUSHI183736528.2
47
UST$0.04UST0UST$0.00Not applicable, you receive more crypto instead.Does not apply!Philippine PesoSingapore DollarBCH51,0001,000$100.54$100,5405,127,540$504,621$504.62$112.00$112,000$25,735,684Locked MATIC$12,266,000UMA41643718.96
48
wdGLD$168.00wdGLD0wdGLD$0.00Total Value Being Received (Incl. Custody)You will receive 50% liquid crypto in BTC (Removes Custody)You will receive 50% liquid crypto in BTC (Removes Custody)The initial distribution of Liquid crypto will come soon, around January 31. You will be receiving in your Coinbase/Venmo account, 50% Eth + 50% BTC. Make sure your Celsius Account and Coinbase/Venmo have matching Email, Address and Name.₱0.00$0.00BNB83,0006,000$226.92$1,361,52018,834,360$3,935,192$655.87$305.00$1,830,000$54,436,822CoinRoutes$1,000,000XAUT13815609.39
49
XTZ$1.48XTZ0XTZ$0.00Does not apply!Hong Kong DollarPolish złotySOL918,000123,000$34.24$4,211,52031,432,320$30,713,699$249.70$20.30$2,496,900$229,229,073QRDO$430,000XRP$11,655,417,586.8794
50
YFI$5,742.18YFI0YFI$0.00How much did you lost by having you funds in Celsius Network? (InKind not Dollarized)You will receive 50% liquid crypto in ETH (Removes Custody)You will receive 50% liquid crypto in ETH (Removes Custody)$0.000.00 złUNI1,810,000301,000$6.01$1,809,01010,878,100$3,243,186$10.77$4.98$1,498,980$19,502,2171INCH$827,000BNT11577627.33
51
ZEC$53.54ZEC0ZEC$0.00Does not apply!Lock ConvenienceOn exit of bankruptcy convenience is locked and no extra recoveries are added. The hold backs which are a significant recovery will just go to earn.XLM97,468,0002,578,000$0.10$268,11210,136,672$1,310,817$0.51$0.09$230,473$49,558,843Orgenesis$202,000BSV$100,296,271.1527
52
ZRX$0.28ZRX0ZRX$0.00How much you lost in % by keeping your funds in Celsius Network? (InKind not Dollarized)Total Crypto Value Today if your Funds were kept in a safe placeTotal Loan Collateral Lost by dollarization at Today PricesEOS4,237,000.001,370,000$0.92$1,260,4003,898,040$1,119,183$0.8169$0.87$1,191,900$3,461,298Sarson Funds$250,000BTG33173207.56
53
TAUD$0.67TAUD0TAUD$0.00$0.00$0.00SRM03,548,000$0.04$151,5000$214,760$0.060.0687$243,748$0.000Avantgarde Finance$250,000COMP50.65573007
54
TCAD$0.77TCAD0TCAD$0.00[3] Creditor can select to withdraw in BTC or ETH, [4] Celsius will send the shares to the Creditor Stock broker TGBP$9,913,082$9,639,165.95$1.00$9,639,1669,913,082$12,879,612$1.341.24$11,952,566$13,245,611CegaPte$150,000CRV$358,279,552.5566
55
TGBP$1.19TGBP0TGBP$0.00Change Mining and Illiquid ValuationsOther$219,300,000.00$25,600,000.00$1.00$25,600,000219,300,000$25,600,000$1.001$25,600,000$219,300,000Pythagoras$100,000CVX35517877.76
56
THKD$0.13THKD0THKD$0.00Mining Valuation Used Apply Public Miners Growth Valuation From Jan-25 to TodayIlliquid Value & Post Emergence Transfers To transfer to Creditors
To transfer to Mining Co.
KNC25126065.14
57
$751,224,000.00Official Valuation$318,400,000Total$2,352,918,990$5,008,982,604$4,485,523,978$3,297,327,082.57$9,543,055,795$242,167,000$108,731,000LPT107243111.6
58
CEL [2]$0.25CEL *0CEL *$0.00Ionic Digital Price per Share$20.00Add December Stakehound Settlement AgreementBTC Price Not Locked89637.66Total W/o EF$188,216,000MKR$168,563,804.7561
59
Red or Green Cell means, if it is red the filling price is higher than current price this means you are getting a better deal by having your crypto stuck in CelsiusETH Price Not Locked3,128.56OMG14406884.95
60
[1] Setoff is when Celsius will subtract the collateral value at filling from your outstanding loans [2] CEL price is set at 0.25$ according to the court decisionDo not apply Stout Discount to Equities First Recovery (dont include unconverted BTC)Do not apply Stout Discount to Equities First Recovery & Include Unpaid BTCUser CalculationsORBS0.008159
61
(Equities First Loan is set at 75% and 0 of the BTC is recovered according to Stout valuation)Withhold Current ValueMining Stock Without Illiquid Mining AssetsCollateral Todays Value - Active LoansSGB0.008159
62
Add a potential Tether Clawback worth $252.3MTether did an ordely liquidation of the Loan Celsius had w/ them, keeping all Bitcoin & avoiding all priorities & procedures of bankruptcy, in this case getting a 100% return in kind & transfering all that crypto to them.$0.00$0.00$0.00UST30048759.07
63
Add Customer Clawbacks Recovery at Dont Add Customer ClawbacksEarn Current ValueIlliquid Assets to be distributed in time as seen on AG37 to AG55Custody Assets Todays ValueTotal Money Lost Worst CasewdGLD177.65
64
Customer clawbacks are likely not going to affect the recovery at the initial distribution but are likely to come after a few weeks or months. The litigation fund should go first after high networth USA Accounts and only then International high networth users. But as you will dealing with different National Bankrupcy Laws and since these international customers who withdrew respected and acted accordingly to the terms of service from Celsius, the likeness of international clawbacks in my opinion is very low. International Creditors are about 50% of all creditors, so recovering more than 50% is extremely optimistic in my opinion. The only leverage Celsius or the Trust has over these international users is if their holdings are bigger than what they withdrew.$0.00$0.00$0.00$3,926,840,794.40XTZ$746,077,000.2388
65
January Official Recovery Waterfall For Earn Over $5000Total Money Best CaseUnaccounted forYFI$68,928,203.5468
66
Stakehound Settlement AgreementCalculate the public miners growth since the Mining Valuation by Celsius from Nov 17Liquid Crypto DistributionsMining StockIlliquid Recoveries Over Time (could take over 3 years)Money Lost pre-CH11 *Money Lost from CH11ZEC132607906.1
67
Eth27,000.00Nov-17Today%57.92%14.94%6.41%You can force recoveries by replacing the percentages here ---->Value for EarnCryptoMiningIlliquid$3,643,151,740$283,689,054.00ZRX144525209.9
68
DOT90,000.00BTC$39,961.00$89,637.662.243Total Recovery
* doesnt include $776,029,999 nor the money raised in Nov 22
TAUD0.66459
69
MATIC47,900,000.00BTC x3$39,961.00$89,637.666.72938565179.3%79.27%57.92%14.94%6.41%TCAD0.726605
70
Fund Stakehound Litigation vs Fireblocks-$10,000,000Marathon Digital$16.27$11.520.708TGBP1.33617493
71
Total$86,928,437.815CleanSpark Inc$7.30$14.031.922
[5] Go to H79 to see the legal court document about the expected recoveries in November 17
Where did the rest of my money go?THKD0.128511414
72
Terawulf Inc$1.52$14.339.428Will I get any extra on top of these recoveries?The money was lost in various endevours, this happen due to incompetency and improper risk management, one of the biggest losses was the tether liquidation, the company didnt have enough liquidity to meet a margin call and could have lost between 40,000 to 47,000 BTC
73
Mawson Infrastructure Group$2.03$5.172.547
Yes, there will be a litigation fund to go after some 3rd party claims and insiders. There are also other illiquid assets that can over perform the current valuation given by appraisers, these recoveries will be distributed, after the crypto you will receive, this will happen in the coming months and years after your crypto distribution.
Here is a list of some of the most sizeable losses
74
Riot Platforms Inc$10.63$15.301.439Losses Before BankruptcyLosses After Bankruptcy
75
Tether BTC Liquidation, BTC Lost Assuming Liquidation @ 17,708
Bankruptcy Costs
76
Iris Energy4.0640.139.884ValueBTC Collateral
Total Value missing at filling current prices
Bankruptcy has cost so far 176M to creditors. (1)
77
HUT Mining7.4741.315.530$841,000,00047,492.66$2,040,901,546.76$216,378,781
78
Bitfarms2.072.741.324
Equities First defaulting and restructing payments
Creditors CEL Settlement
79
Cipher Mining2.3617.057.225Stable Coins DebtBtc DebtTotal Value missing at filling current pricesSince Celsius isnt giving a use case for CEL, it has a cost to estate. As the confirmation it is said to be 30M.
80
Bitdeer Tech6.610.651.614$313,000,0003436$460,655,193.64$30,000,000
81
Equities First Loan Without Stout Discount Average of All Miners4.162Mining+Illiquid MiningIlliquid-Mining Illiquid
Stakehound losing 35k Eth
Paying Non Performing Cryptos
82
BTC Owned To Celsius376596.89%4.76%Fireblocks was in charge of custodying and dealing with the stakehoundEth, when dealing with Stakehound, Stakehound lost the keys to around 38000 EthSome cryptos in Celsius have not performed to this day, so Celsius will pay their price they were at as they filled for bankruptcy.
83
Total Loan Dollarize$307,069,000Total BTC Worth$337,485,789.90Total Value of EQF$644,554,789.90"How can you observe a fund if you can't even observe your own pp?" - Biggus Dickus76.81%3.78%$90,195,000
84
8$1,050,000$350,000$270,000$700,000$250,000
Camcrews the original insipiration for this song:
KeyFi 30.000 Eth syphon
Lost in Conversions
85
9$1,050,000$350,000$270,000$700,000$250,000https://youtu.be/A4qU6t1ZH24?si=d81rcSgQdo258KVlKeyFi a company Alex Mashinsky contracted and later bought from a failed CEO Jason Stone, was found to be syphoning around 30000 EthCelsius started selling alt coins before the effective date, meaning they lost some appreaction as BTC and the crypto market started to recover.
86
10$1,050,000$350,000$270,000$700,000$250,000Celsius Network November 17 Recovery, for earn was 51% Crypto 7.2% Iliquid 17.5% StockBest CaseWorst CaseBest CaseWorst Case
87
11$1,050,000$350,000$270,000$700,000$250,000(I here sum the 17.5% to 7.2% but discriminate each in dollars, I use 565M as the mining valuation minus 225M from users, Sum all Illiquid Assets Incl. Other Mining Investments)Numbers and CalculationsTotal Mining+illiquid Mining % of Earn ValueTotal illiquid % Earn ValueCurrent ValueEthValue$0.00$0.00
88
12$1,050,000$350,000$270,000$700,000$250,000Initial LT FundingMining Illiquid TransfersConvenience Claims at Filling (w/ CEL $0.25) 96.89%6.90%$77,310,00030000$350,000,000
Loan Interest Lost assuming 5.6% Average
89
13$1,050,000$350,000$270,000$700,000$250,000$50,000,000$108,731,000$198,589,999.50Total Mining % of Earn ValueTotal illiquid-illiquid Mining % Earn Value
CEL Backed Loans under 50M
The company had 411M in loans when it filled for bankruptcy, if these loans where paying interest
90
14$1,050,000$350,000$270,000$700,000$250,000Administration CostsCreditor Litigation Fund Illiquid TransfersConvenience % Claims13.20%4.76%Around 50M of stable coins where lend with CEL as collateral, Celsius did not sold the CEL Collateral. Incurring this loss in stable coins.$30,688,000
91
15$1,050,000$350,000$270,000$700,000$250,000$75,000,000$242,167,0005.46%Custody Approximate Transfer Remaining$50,000,000
Sale of Rigs at 75% Discount
92
16$1,050,000$350,000$270,000$700,000$250,000Ionic Seed FundingAssets vs Non Dollarized LiabilityAll value $ (fair valuation)$156,000,000.0Luna CrashTotal SalePer RigLost value assuming price at 2950$
93
17$1,050,000$350,000$270,000$700,000$250,000$225,000,00045.99%$4,388,876,978According to Celsius Network in the Luna crash their damage due to exposure was just 15M. Celsius engaged in generating yield on the Luna protocol$1,342,727.00$497.31$6,622,273.00
94
18$1,050,000$350,000$270,000$700,000$250,000Mining Extra Cash BalanceMining Valuation without CashWithHold$15,800,000
95
19$1,050,000$350,000$270,000$700,000$250,000$97,545,000$428,679,000.00$13,328,690.003AC Default
96
20$1,050,000$350,000$270,000$700,000$250,000Total Cash Balance in IonicMining Cash + Mining ValueWithHold PrepaymentTotal Shares of IonicNon Cash Value * Illiquid MinerPrice per Share
Celsius gave undercollaterize loans to 3ACs which defaulted having a loss of 40M
1
97
21$1,050,000$350,000$270,000$700,000$250,000$322,545,000$751,224,000.00$1,999,303.5037,561,200.00$428,679,000.00$20.00$40,600,000
https://cases.stretto.com/public/x191/11749/PLEADINGS/1174912222380000000050.pdf
98
22$1,050,000$350,000$270,000$700,000$250,000Liquid Value Minus Expenses and reserve custody, withold, loans, ConvenienceEarn Claims + Convenience Claims CustodyCustody Approximate Value TodayEarn+Convenience Settlement Bonus 5% ClaimGrayScale
99
23$1,050,000$350,000$270,000$700,000$250,000$3,242,373,675$5,889,108,878$200,188,075.60$276,682,963.82$236,515,017Unknown if this loss was realized or Celsius still possess the grayscale shares which are now being traded at less of a discount.
100
24$1,050,000$350,000$270,000$700,000$250,000(all Liquid value for earn, loans, convenience, remaning withold, without custody, mining seeding & admin costs)Earn RecoveryLoansTotal Liquidity to Add Due to Loans Total Claims to Add$150,000,000