optimator (OP)
|
|
May 26, 2013, 02:28:41 AM |
|
I've create a spreadsheet to roughly estimate the coming mining difficulty. It estimates the anticipated hash rate of the network each month until December. I don't realistically expect anyone could have visibility past december. That being said, after December, the spreadsheet calculates a flat 10% growth per month. The idea is to determine what the break even cost (B/E) for a mining unit might be. For example, if you could obtain a 66 Gh/s unit starting in June, your 6 month profit would be estimated at 83 btc. Therefore, as long as you pay under 83 btc for the unit you will make a profit in 6 months. However, if you were to acquire the same unit in October, then your B/E price over 6 months would be 25 btc. I've chosen 6 months as the timeframe because I believe there is simply too much risk / variability past 6 months to accurately calculate a ROI. The spreadsheet calculates the anticipated hash rate, shows an anticipated network difficulty, and then calculates the estimated btc / day rate based on the network hash rate. I would welcome any discussion as to the formulas in the spreadsheet and the assumptions underlying when each company would bring their hash rate to the network. The spreadsheet can be accessed here. Cheers!
|
|
|
|
cdog
|
|
May 27, 2013, 09:42:53 AM |
|
Cool!
|
|
|
|
Mota
Legendary
Offline
Activity: 804
Merit: 1002
|
|
June 02, 2013, 11:25:52 AM |
|
Your spreadsheet is so full of errors it's unbelievable. Avalons Batch 2 and 3 will have approx. 43th each (72gh x 600 units, and that is with a +10gh bonus for a margin). not 156th or 130th. Where the heck did you get that numbers? Also: The hell?!? Are you really thinking that BFL can pull 58th per month out of their hats? That would be a great magic trick! Besides, I think if they have some th's ready, they are mining for themselves right now, so they would be in the current number. Then there is the Asic Chips: .... There are over 500.000 chips ordered, why do you add them in with only 85th? That should be a number between 150-200th. If all of them are okay and up and running in a ridiculously short amount of time.
Aaaaand: Unknown 500th?!? Where do they magically appear?
If you make a spreadsheet, at least get your numbers straight!!! (Knc miner numbers are also wrong. I alone have preordered over 1 th in mining equipment from them... If they deliver...)
|
|
|
|
yeemartin
Member
Offline
Activity: 95
Merit: 10
|
|
June 02, 2013, 06:36:48 PM |
|
yeah, his calculation is about 4x of the actual ghs. I estimated at the end of the year, difficulties is about 50m-100m. Currently 12m. Your spreadsheet is so full of errors it's unbelievable. Avalons Batch 2 and 3 will have approx. 43th each (72gh x 600 units, and that is with a +10gh bonus for a margin). not 156th or 130th. Where the heck did you get that numbers? Also: The hell?!? Are you really thinking that BFL can pull 58th per month out of their hats? That would be a great magic trick! Besides, I think if they have some th's ready, they are mining for themselves right now, so they would be in the current number. Then there is the Asic Chips: .... There are over 500.000 chips ordered, why do you add them in with only 85th? That should be a number between 150-200th. If all of them are okay and up and running in a ridiculously short amount of time.
Aaaaand: Unknown 500th?!? Where do they magically appear?
If you make a spreadsheet, at least get your numbers straight!!! (Knc miner numbers are also wrong. I alone have preordered over 1 th in mining equipment from them... If they deliver...)
|
|
|
|
optimator (OP)
|
|
June 03, 2013, 12:30:54 AM |
|
Your spreadsheet is so full of errors it's unbelievable. Avalons Batch 2 and 3 will have approx. 43th each (72gh x 600 units, and that is with a +10gh bonus for a margin). not 156th or 130th. Where the heck did you get that numbers? Also: The hell?!? Are you really thinking that BFL can pull 58th per month out of their hats? That would be a great magic trick! Besides, I think if they have some th's ready, they are mining for themselves right now, so they would be in the current number. Then there is the Asic Chips: .... There are over 500.000 chips ordered, why do you add them in with only 85th? That should be a number between 150-200th. If all of them are okay and up and running in a ridiculously short amount of time.
Aaaaand: Unknown 500th?!? Where do they magically appear?
If you make a spreadsheet, at least get your numbers straight!!! (Knc miner numbers are also wrong. I alone have preordered over 1 th in mining equipment from them... If they deliver...)
The reason I posted the spreadsheet is for help in vetting the numbers with the community. I appreciate your constructive feedback. My plan is to update the spreadsheet each month with new information as it appears. You will find the information you've provided on the "July" spreadsheet. You are correct avalon batch 2 & 3 are 600 units representing 43Th. For the avalon chips, I've updated the information based on the btc received, estimating the total chips at 760,000 and the effect as 215 Th. As a conservative estimate, for now, I'll leave the BFL prediction, although I may reduce it later this month based on the assumption that BFL chip sales indicate an inability to deliver units. The unknown factor represents what I anticipate to be asic projects that are privately in development that will not be announced to the public but will affect the network hash rate. Also, for knc miner, the November / December figures represent delivered (not ordered) units. Again, just an early estimate for now. Cheers!
|
|
|
|
yeemartin
Member
Offline
Activity: 95
Merit: 10
|
|
June 03, 2013, 02:58:42 AM |
|
Better change the title of this thread, it's misleading. Your spreadsheet is so full of errors it's unbelievable. Avalons Batch 2 and 3 will have approx. 43th each (72gh x 600 units, and that is with a +10gh bonus for a margin). not 156th or 130th. Where the heck did you get that numbers? Also: The hell?!? Are you really thinking that BFL can pull 58th per month out of their hats? That would be a great magic trick! Besides, I think if they have some th's ready, they are mining for themselves right now, so they would be in the current number. Then there is the Asic Chips: .... There are over 500.000 chips ordered, why do you add them in with only 85th? That should be a number between 150-200th. If all of them are okay and up and running in a ridiculously short amount of time.
Aaaaand: Unknown 500th?!? Where do they magically appear?
If you make a spreadsheet, at least get your numbers straight!!! (Knc miner numbers are also wrong. I alone have preordered over 1 th in mining equipment from them... If they deliver...)
The reason I posted the spreadsheet is for help in vetting the numbers with the community. I appreciate your constructive feedback. My plan is to update the spreadsheet each month with new information as it appears. You will find the information you've provided on the "July" spreadsheet. You are correct avalon batch 2 & 3 are 600 units representing 43Th. For the avalon chips, I've updated the information based on the btc received, estimating the total chips at 760,000 and the effect as 215 Th. As a conservative estimate, for now, I'll leave the BFL prediction, although I may reduce it later this month based on the assumption that BFL chip sales indicate an inability to deliver units. The unknown factor represents what I anticipate to be asic projects that are privately in development that will not be announced to the public but will affect the network hash rate. Also, for knc miner, the November / December figures represent delivered (not ordered) units. Again, just an early estimate for now. Cheers!
|
|
|
|
optimator (OP)
|
|
June 03, 2013, 03:17:48 AM |
|
Better change the title of this thread, it's misleading.
My idea was to create a spreadsheet that would be updated each month with the latest information. That information would come from the community and ideally would result in the prediction changing as new information was added or changed. Thus, the spreadsheet would serve as a guide to help estimate the profitability of equipment. The change I've made so far have resulted in the December estimate decreasing from 252 million to 226 million. I'd rather have the title of the thread reflect a stick in the ground when I first made the post rather than practicing revisionist history. In the mean time the spreadsheet will reflect the latest thinking. Then we'll see in December how close it was
|
|
|
|
kinitex
Member
Offline
Activity: 62
Merit: 10
|
|
June 03, 2013, 04:33:18 AM |
|
while 250,000,000 might be a stretch, 100,000,000 certainly is not come December. This is still an incredibly scary number
|
|
|
|
Mota
Legendary
Offline
Activity: 804
Merit: 1002
|
|
June 03, 2013, 03:00:51 PM |
|
I did all my calculations with 100mil as the worst diff for October. Most miners still get a lot of cash out of them at that point. If I remember correctly even a 60gh device gives you more than 1k a year at 250 mil...
|
|
|
|
btcfarseer.com
Newbie
Offline
Activity: 40
Merit: 0
|
|
June 04, 2013, 03:20:28 AM |
|
Hi guys, if u all interested in difficulty, why not make a profit by guessing future difficulty? I sincerely invite you guys to come and check out this website. http://btcfarseer.com
|
|
|
|
tinoki
Newbie
Offline
Activity: 56
Merit: 0
|
|
June 04, 2013, 04:57:37 AM |
|
I did an estimate of 230 million in Dec 2013?
|
|
|
|
FeedbackLoop
|
|
June 04, 2013, 03:57:07 PM |
|
Optimator, thanks for the spreadsheet. Great initiative!
Tinoki, are you stating? Can you post your numbers?
|
|
|
|
optimator (OP)
|
|
June 04, 2013, 06:20:40 PM |
|
Optimator, thanks for the spreadsheet. Great initiative!
Tinoki, are you stating? Can you post your numbers?
It's been an exciting week of announcements. I'll start to aggregate the additional information later this week. Information from KNC, bitfury, and, it's small, but there are also Avalon clones coming to market. I'll probably add these hashes while removing them from the "unknown".
|
|
|
|
Schrankwand
|
|
June 05, 2013, 12:33:16 PM |
|
MY personal bet is around 60-70 million, because of the hardware costs.
Taking BFLs price of a 50gh miner as a price point, which is the lowest price point there is at the moment, I suggest that an increase of 10 million actually costs about ~4 million dollars at the moment.
An increase to 250 million would therefore come with a buyin cost of around 250 million dollars.
Considering the amount of money people have spent on the smaller ASIC miners, FPGAs and preorders already, I would argue that for some time, this market will stall. Basically, at this point, unless another April 16 spike hits with thousands of newcomers, this market is saturated for some time with people paying absolute premiums for mining equipment.
I guess that 60 million, with an additional cost of 24 million dollars at BFL's price point is realistic until the end of the year. I might take 70-80 million, which would indicate an investment of around 32 additional millions of dollars.
But 250 is too heavy a price to take. Before generation 2 chips enter the market and the Bitcoin reaches somewhere around a STABLE 250, I doubt we will see anything beyond 120-130 million. Should both scenarios occur however, it is gonna become the next arms race.
It is a good idea to check back the actual costs of additional mining power. you will have ASIC miner ruin this calculation a little, since they have a $10.000 per added Terahash price point, but fortunately they are NOT giving this price to people yet.
|
|
|
|
stslimited
|
|
June 05, 2013, 12:37:53 PM |
|
hmm I should be shorting bitcoins then
with the size of blocks average 25.20 btc one can clearly see that more coins are being added than # of transactions to justify the size of the economy
the difficulty jump today is expected to be 28% so your spreadsheet makes too many assumptions
|
|
|
|
optimator (OP)
|
|
June 05, 2013, 01:30:17 PM |
|
MY personal bet is around 60-70 million, because of the hardware costs.
Taking BFLs price of a 50gh miner as a price point, which is the lowest price point there is at the moment, I suggest that an increase of 10 million actually costs about ~4 million dollars at the moment.
An increase to 250 million would therefore come with a buyin cost of around 250 million dollars.
Considering the amount of money people have spent on the smaller ASIC miners, FPGAs and preorders already, I would argue that for some time, this market will stall. Basically, at this point, unless another April 16 spike hits with thousands of newcomers, this market is saturated for some time with people paying absolute premiums for mining equipment.
I guess that 60 million, with an additional cost of 24 million dollars at BFL's price point is realistic until the end of the year. I might take 70-80 million, which would indicate an investment of around 32 additional millions of dollars.
But 250 is too heavy a price to take. Before generation 2 chips enter the market and the Bitcoin reaches somewhere around a STABLE 250, I doubt we will see anything beyond 120-130 million. Should both scenarios occur however, it is gonna become the next arms race.
It is a good idea to check back the actual costs of additional mining power. you will have ASIC miner ruin this calculation a little, since they have a $10.000 per added Terahash price point, but fortunately they are NOT giving this price to people yet.
Excellent points! I agree that at some point the market will stall until either a new gen of chips appear or the price increases. I've been trying to figure out how to calculate the "stalling point". If we take your figure of 60 Million as the difficulty and 12 million as the current difficulty the net increase is 48 million. 48 million represents about 80% of the 60 million network hash. To gain 80% of the network $24,000,000 was paid. At $120 / btc the network generates $432,000 per day in block reward. Investing $24M your payback would occur in about 55 days. It seems people would still invest at that point?? It is a good idea to check back the actual costs of additional mining power. Can you explain this a little more?
|
|
|
|
Schrankwand
|
|
June 05, 2013, 03:06:44 PM |
|
It is a good idea to check back the actual costs of additional mining power. In short terms: If you want to add hashing power, someone has to build it and someone has to pay for it. In USD, Yuan, Rubels or Euro. So if you add hashing power to the network, someone needs to have spent this money. That is why a calculation that simply adds 18% every month is unlikely. At some point, a linear increase is going to have such significant costs that it becomes unlikely, even if your hasing power becomes ridiculously bigger through new chips. I believe this is the point where not only mining, but also running full nodes should be valued by people. Getting paid for a) mining and b) confirming as a node will become very important for stability and security.
|
|
|
|
ryszardzonk
Newbie
Offline
Activity: 51
Merit: 0
|
|
July 11, 2013, 09:23:54 PM |
|
|
|
|
|
k9quaint
Legendary
Offline
Activity: 1190
Merit: 1000
|
|
July 11, 2013, 10:00:00 PM |
|
Woof. While Avalon has not released information how many chips have been ordered, a 135 box shipment would amount to over 2.1 million ASIC chips. Given that Avalon sells them in batches of 10,000 for 780 BTC, this lot alone is worth over 164,000 BTC ($14,700,000).The Kaiju have arrived.
|
Bitcoin is backed by the full faith and credit of YouTube comments.
|
|
|
optimator (OP)
|
|
July 12, 2013, 03:15:59 AM |
|
I haven't updated the End of July estimates with the latest info. I'll revisit the chips and I'm also looking at adding AMC / Bitfunder.
|
|
|
|
|