Hi Soniq and group members,
Here come part two of the report on my analysis of Soniq’s balance sheet and dividend payouts.
This verification and the report posed here is for Soniq’s balance sheet and transactions on the transactions up to Jan 31.
Here is the file posted by soniq which I have verified:
https://docs.google.com/spreadsheet/ccc?key=0AtH6ASvoAExHdF9IcFh3QmQ2dEt4Zk5qT3lRUDFDTVE&usp=drive_web&pli=1#gid=24 This is the excel file I have produced with verification calculations and results:
http://1drv.ms/1d0t1j2(1) I have looked at “Dividend Payment Balance Sheet” in soniq’s file
(Line 6) Total Mining income Received: 1332,890284
(Line 14) Total Expenses: 211,2304057
Total BTC to be paid out 1121,65987854(2) I have looked at “Ledger Jan 31_14” sheet in soniq’s file (and have copied original sheet into my file so I can color it)
Positive values (column D) consist of
• Mined coins that have been paid out
• Other stuff that has been paid out (refunded hosting payments, share price adjustments, private loans, 2% management fee)
(Negative values are the bitcoin transactions to users)
Let us take an example to clarify and we exemplify with a random user:
[img-]https://9ncosq.bn1302.livefilestore.com/y2pBKS5epy1p5mfG6g5fE6kYDkIbjb7kavouEbv829TQqf4V_mXss9Jo8BzFtZ_bNoD7H9aUIX-abR3PM_-iW7HFz8vRs06BD3-HxepI5NakDA/Capture.JPG?psid=1[/img]
The user he has been paid out:
0,66000000 Refunded hosting payment (line 368)
0,28645000 GB1 prorated share price adjustment (line 369)
4,28738914 Mined coins (lines 370-275 marked in green)I have applied a filter to sum
all mined coins that have been paid out (green lines).
The sum of the mined coins that have been paid out to all users is 1044,68000011 BTC.However, total BTC to be paid out is 1121,65987854 BTC
1121,65987854 - 1044,68000011 = 76,97987843
To conclude, up to Jan 31, there is still 76,97987843 BTC mining income received that Soniq has missed to pay out.I ran though this with dutu. I'm not going to post the convo, because we went down several trains of thought and went into several different issues. It's a complicated chat to follow.
Here's my analysis which ends up coming to the same conclusion. We cannot consider refunds, penalties, other nonmining payouts to be part of mining payouts.
Here's my math in sheet "Dividend Payment Balance Sheet" on lines 17 through 26:
https://docs.google.com/spreadsheet/ccc?key=0AtH6ASvoAExHdF9IcFh3QmQ2dEt4Zk5qT3lRUDFDTVE&usp=drive_web#gid=31We come to the exact same conclusion that mining income of 1044.68 has been paid out.
What absolutely complicates this matter is that the ledger has all these personal loans, and nonmining transactions going on... which leads to this (and some other) problems. More to come later.
This concludes and fixes the missing 76 BTC... the spreadsheet is now up to date and shows 128.752061356 to be paid out.