ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Disclaimer
2
Use this Calculator at your own risk. This is just an inofficial tool to illustrate possible payment scenarios.
3
Although I have made every effort to cover most scenarios, I do not assume any liability for the correctness of the information and assumptions.
4
Increased precision comes with increased complexity. There may be edge cases that can break the calculations.
5
In particular, I do not assume any liability for economic damages resulting from the use of this tool.
6
7
DO NOT BASE YOUR FINANCIAL DECISIONS SOLELY ON THIS CALCULATOR!
8
9
There are other calculators out there - I encourage you to compare and do your own math & research.
10
Kim Nilsson's calculator and comprehensive summary is the best place to start if you are not yet that familiar with the CR plan.
11
12
How To
13
To be able to use this calculator, you will have to make your own copy (File -> Make a copy)
Adjust zoom as well so you don't miss any columns to the right.

For the calculator to work correctly, a few parameters have to be set:
On the "Individual Claim" tab,
- enter the size of your personal claim (cash and crypto).
- To determine wether you are eligible to Priority Payments, you further need to confirm if you already filed your claim under bankruptcy or not.
On the "Payments Overview" tab, make assumptions for the following questions:
- What will be the size of the approved Coinlab claim, as well as other undetermined claims? (fields N2 and N3)
- How many creditors will choose the Early Exit Option? (0% - 90% - the last 10% being Fortress' claim)
- What percentage of the Final Payment will be paid out via Intermediate Payments? (0% - 100%)
- What will be the fiat to crypto ratios for ELSP and IP? (leave untouched if you don't know, or try different settings to get a feeling for best and worst case scenarios)
There are more parameters that can be set, but which don't have that much of an impact on the final outcome.

Cells highlighted in orange should be adjusted.
Cells highlighted in blue can be adjusted if you know what you do, but are better left alone if you are not sure.

For further questions contact me on the MGL forum.
14
15
16
17
18
19
20
21
22
23
24
25
26
Diabolicus, July 8th 2022
27
28
Donation address:
bitcoin:3LwmLAtnmyLXTLY6MinYhKXAY8N2bN3Toy
29
30
31
32
33
34
35
36
v2.1.3Feb 6th 2021added override IP ratio and adjust FP ratio back to ELSP ratio options
37
v2.1.4Feb 7th 2021added option to set discount for further OTC sales by the Trustee
38
tweaked defaults for remaining trustee costs and distribution costs
39
DRC held by undetermined claim holders now included in PBPB of claims
40
implemented Final Payment A and B disctinction
41
v2.1.5Feb 8th 2021sell of altcoins and inclusion of MtGox counter-claim against Coinlab now optional
42
fixed 2nd FP A and B amounts on Individual Claim tab
43
general cleanup
44
v2.1.6Feb 9th 2021percentages fixed for results lines 12 and 14 on Payments Overview Tab
45
v2.1.7Feb 17th 2021fixed an error on the Individual Claims tab in the fields B72 to B80 and J72 to J80 where the post base payment balance was erroneously in the denominator instead of the total approved claims amount when calculating percentages. The error was only obvious with very small claims, where SSP makes up a significant part of the total payments.
46
added Statistics tab, to illustrate payout ratios for different claim sizes (calculation is not dynamic, but for a fixed scenario)
47
v2.1.8Feb 17th 2021Statistics graph is now updated dynamically according to settings on Payments Overview tab.
48
v2.1.9Feb 18th 2021Options added to override crypto market rates with self defined values on the Payments Overview tab lines 25 and 27
Use these to model what happens if BTC price drops by 50% or shoots up to 200% etc.
This also affects the prices for further sales in row 141 following, so if you think sales will be made at different rates, than you have to offset via this setting.
Example: you think the trustee will sell at current rates, but when you receive your BTC they will be only worth half of what they are worth now, override market rates in lines 25 and 27 by half their current value, but increase sell prices to 200% in line 141.
49
v2.1.10Jul 8th 2022balance sheet updated with June 14th Status Report numbers
expected trustee fees adjusted
layout improvements
50
v2.1.11Oct 12th 2022cash and deposits updated with Aug 31st value
51
v2.2Nov 4th 202271% allotment rate for ELSP and IP locked in (=cash rate in fields Payments Overview E5 and E6 set to 29%)
52
added separate statistics for ELSP
53
set expected Conlab claim (field Payments Overview N9) to 0, as this still seems to be the trustee's expectation
54
55
ToDo Listcalculate Coinlab delay damages more thoroughly
56
add option for MGIF substitute security
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100