All these calculations are pretty useless in the long run - main variable is bitcoin price, then altcoin price, then difficulty.
Agree and Disagree -
Agree -
main variable is bitcoin price, then altcoin price, then difficulty I agree, I agree. I've said it before too.
Future prices are the biggest effect on return. Too often I see discussions about electric costs as the biggest driver, which is true only if you are 100% cash mining. Otherwise, while Kwh/$ has an effect of return, it's nothing compared to BTC and Alt prices.
Just go back to when I first posted this thread on April 24, BTC was $5,400. Today, as I write this, BTC is up over a 130% since then. That changes everything... My mining strategy has been spread across Spec/Cash/Swap to BTC. The Swap mining I did through last year and early this year looks really good at this moment. For me, my ROI on my mining strategy is working out very well. I know that some people have done better and others - not so well. Every miner their own path.
Disagree -
"All these calculations are pretty useless in the long run" - I posted this worksheet because I was tired of the posts that misrepresent the ROI on buying new GPUs. There has been tons of mis-information posted in other threads. So this isn't meant to be a absolute answer on what to do, but rather a starting point to what is the current market offering.
This analysis is/was created to take a snapshot in time, as one of many tools in deciding what to do. Mining and Crypto is a new asset class, there is risk and there is volatility. Today's 52% ROI will fluctuate, going negative or positive by a lot of %s. You really need to have a high tolerance for fluctuation if you are mining Crypto.
Mining isn't for everyone. Some are better off buying/investing/trading or just walking away.