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
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?
- 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.

To view everything, you probably need to reduce the zoom level a bit if you don't have dual screens or a 4K screen.
14
15
16
17
18
19
20
21
22
23
24
25
26
Diabolicus, February 8th 2021
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
50
ToDo Listcalculate Coinlab delay damages more thoroughly
51
add option for MGIF substitute security
52
53
54
55
56
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