Hey nice work, but do note that in some cases you are comparing apples and oranges with your metrics. It's always nice to have shortcuts, but things like "days to even out cost of share" are not comparable between a perpetual mining bond, a mining share, and a financial bond with principal payment at maturity.
Also note, BIB.GOAT was a bond, not a mining operation. It was secured by mining assets, but that is irrelevant to the analysis. Also, it has now matured and is worthless, so you should probably remove it from your list.
So let me get this straight. Describe the following as bonds or shares.
1. Someones sells 1MHash at PPS100% per bond/share indefinitelly with the ability to buy back whenever he wants. My guess: Perpetual mining bond.
2. Someone sells 1Mhash per bond/share minus expenses for electricity etc indefinitelly. My guess: share of a mining operation (I would describe it as "mining operation" on the spreadsheet).
3. Somone sells shares to his mining operation without any guarantee about dividents or power per share/bond. My guess: same as the previous one
Am I right on those?
Also what is the differences between bond and shares? As I get it shares NEVER have guarantees on the divident payments. If the company doesn't have profit, divident payments will not happen. On the other hand bond MAY have some guarantees on divident payments and MAY have a guarantee about buyback. For example "You buy this at 1BTC/bond, I'll be paying 0.01BTC per week in dividents and in 12 months I'll buy back the bond at 0.9BTC. Additinaly I reserve the right to buy back the bond at any time at 1.5BTC.". Now about this last one "the right to buy back whenever you want. How does it happen? I mean if there are no ask orders on the market how is the issuer going to buy back?
And one last thing. When you do an IPO, and the people bid on the initial value of the asset, do you have to sell all of the assets issued? For example if I want to issue and sell 100 bonds at 1BTC/each and 50 people bid 1.5BTC/bond while another 50 people bid 0.9BTC/bond, what will happen? I suppose I would still issue an ask order 100@1BTC/each and only 50 people would get bonds from me (BTW at what price? 1BTC or 1.5BTC? Would there be any difference in this process is I was issuing shares and not bonds?
So I'll change GIGAMINING etc into "perpetual mining bonds" and leave that that just share profits from mining as "mining operation".