Use this Calculator at your own risk. This is just an inofficial tool to illustrate possible payment scenarios.
Although I have made every effort to cover most scenarios, I do not assume any liability for the correctness of the information and assumptions.
Increased precision comes with increased complexity. There may be edge cases that can break the calculations.
In particular, I do not assume any liability for economic damages resulting from the use of this tool.
DO NOT BASE YOUR FINANCIAL DECISIONS SOLELY ON THIS CALCULATOR!
There are other calculators out there - I encourage you to compare and do your own math & research.
Kim Nilsson's calculator and comprehensive summary is the best place to start if you are not yet that familiar with the CR plan.
|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.
Diabolicus, July 8th 2022
|v2.1.3||Feb 6th 2021||added override IP ratio and adjust FP ratio back to ELSP ratio options|
|v2.1.4||Feb 7th 2021||added option to set discount for further OTC sales by the Trustee|
|tweaked defaults for remaining trustee costs and distribution costs|
|DRC held by undetermined claim holders now included in PBPB of claims|
|implemented Final Payment A and B disctinction|
|v2.1.5||Feb 8th 2021||sell of altcoins and inclusion of MtGox counter-claim against Coinlab now optional|
|fixed 2nd FP A and B amounts on Individual Claim tab|
|v2.1.6||Feb 9th 2021||percentages fixed for results lines 12 and 14 on Payments Overview Tab|
|v2.1.7||Feb 17th 2021||fixed 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.|
|added Statistics tab, to illustrate payout ratios for different claim sizes (calculation is not dynamic, but for a fixed scenario)|
|v2.1.8||Feb 17th 2021||Statistics graph is now updated dynamically according to settings on Payments Overview tab.|
|v2.1.9||Feb 18th 2021||Options 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.
|v2.1.10||Jul 8th 2022||balance sheet updated with June 14th Status Report numbers|
expected trustee fees adjusted
|v2.1.11||Oct 12th 2022||cash and deposits updated with Aug 31st value|
|v2.2||Nov 4th 2022||71% allotment rate for ELSP and IP locked in (=cash rate in fields Payments Overview E5 and E6 set to 29%)|
|added separate statistics for ELSP|
|set expected Conlab claim (field Payments Overview N9) to 0, as this still seems to be the trustee's expectation|
|ToDo List||calculate Coinlab delay damages more thoroughly|
|add option for MGIF substitute security|