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:




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.