As previously announced, I have been working on a series of spreadsheets that will allow investors to view all information pertaining to LabRatMining and how the Bitcoin network and exchange rates affect the company.
This spreadsheet was developed to add some clarity to the previously vague "Minimum of 100MH/s per bond."
I have taken into account all variables involved except reinvestment by the company as this quantity will vary over time. There are fixed costs involved in hosting the equipment as well as variable costs that will determine the amount that will be reinvested.
Below is some data that has been calculated given a scenario based around the following assumptions:
-BTC/USD = $90.00
-Expected Difficulty at the time of hardware deployment = 45,000,000
-The period of time you wish to measure in weeks = 26
-The percent increase in difficulty per adjustment = 14
Total hashrate in TH for LabRatMining given bond sales6.9 @16,500 bonds sold
8.4 @20,000 bonds sold
13.5 @30,000 bonds sold
18.6 @40,000 bonds sold
24.1 @50,000 bonds sold
29.5 @60,000 bonds sold
35.3 @70,000 bonds sold
41.2 @80,000 bonds sold
47.3 @90,000 bonds sold
53.5 @100,000 bonds sold
Individuals hashrate per bond based on bond sales313.86 @16,500 bonds sold
314.34 @20,000 bonds sold
337.22 @30,000 bonds sold
348.65 @40,000 bonds sold
360.86 @50,000 bonds sold
369.05 @60,000 bonds sold
378.71 @70,000 bonds sold
385.96 @80,000 bonds sold
394.57 @90,000 bonds sold
401.48 @100,000 bonds sold
Price per GH at given bond purchase price according to bond salesAverage of $42/GH/s (hosting and electric included.)
ProfitabilityAverage returns to be expected are likely to be in the range of 70-90% above and beyond the initial investment over 26 weeks.
Difficulty ProjectionsIn this calculator I have included the ability to use differing assumptions to estimate difficulty over 26 weeks. These values are included in formulas that may be used to estimate returns.
This calculator is complex and therefore comes with a README that can be used to explain the data and formulas.
This spreadsheet was made using Excel. You may download the spreadsheet to allow for input of your own assumptions. The fact that these were produced using Excel may cause some individuals to not have access to using the full potential of this calculator, but Google Docs has a built in spreadsheet viewer that will give you the full information based on the assumptions above.
Here is the link to access the complete spreadsheet and README:
https://drive.google.com/folderview?id=0BwZCh0jtSZkwR1A4RS04TkNUcVU&usp=sharing