sJBs's ROI Evaluation of Mining Equipment

[sjbs]

I had some more time again today to run some numbers regarding the selection of GPU's and other parts (PSU which is one one of the most critical aspects).

I also had numerous requests during the week to change or update something on my previous sheet... thus this time around I'm making my calcs available to all. It should at least give you some idea of what to look at when doing evaluations, and if the parameters are not important to you, just set them equal to zero.

What I did find interesting is that the Nvidia cards (1070, 1080 even 1080ti) did a lot better than I thought, and the 470/580 worse. Just because I took into consideration the mining machine capital and maintenance costs....

Any case, it makes for some real food for thought. Just remember, as a lot of you also correctly stated: the calcs are based on the assumptions, if you change that, you'll most likely get other results.

May I please just ask that if you find calc errors, please let me know.

Here is the link to the Google Sheets of sJBs Mining ROI Evaluation to try out yourself

GPU	Mining Rate	Mining Rate	New Cost	Buying Carbs Cost	Selling Carbs Cost	GPU Power Usage	Number of GPU's to be Installed per Motherboard	Recommended PSU	Actual PSU Selected	Investment	Profit After 1st Year	% Return on Investment after 1 year	Payback Days
$ per Day	R per Day	Rand	Rand	Rand	Watt
780	$1.00	R 13.63	R4 000	R2 500	R2 500	200	3	850	850	R4 000	-R9 471	-236.77%	1084
780TI	$1.10	R 14.99	R5 000	R3 000	R3 000	250	3	1000	1000	R5 000	-R10 287	-205.74%	1084
Titan	$1.40	R 19.08	R6 000	R4 500	R4 500	300	3	1150	1150	R6 000	-R10 108	-168.47%	1084
GTX 960	$1.17	R 15.90	R2 200	R2 000	R2 000	100	7	950	950	R2 200	-R 802	-36.47%	1084
GTX 970	$1.95	R 26.58	R4 899	R2 700	R2 700	150	6	1150	1150	R4 899	R 785	16.02%	827
GTX 980	$2.12	R 28.90	R9 800	R4 000	R4 000	220	4	1150	1150	R9 800	-R3 229	-32.95%	1084
GTX 980TI	$3.07	R 41.84	R9 500	R5 000	R5 000	250	3	1000	1000	R9 500	-R1 386	-14.59%	1084
GTX Titan X	$3.20	R 43.62	R10 000	R6 500	R6 500	300	3	1150	1150	R10 000	-R1 953	-19.53%	1084
GTX 1060-3GB	$1.75	R 23.85	R3 299	R2 900	R2 900	100	7	950	950	R3 299	R1 880	56.99%	116
GTX 1060-6GB	$1.89	R 25.76	R4 199	R3 500	R3 500	100	7	950	950	R4 199	R2 397	57.07%	136
GTX 1070	$3.07	R 41.84	R6 299	R5 500	R5 500	150	6	1150	1150	R6 299	R6 077	96.47%	63
GTX 1080	$3.77	R 51.39	R7 999	R7 000	R7 000	180	5	1150	1150	R7 999	R7 632	95.41%	62
GTX 1080TI	$4.61	R 62.83	R10 000	R10 000	R10 000	250	3	1000	1000	R10 000	R6 175	61.75%	29
GTX Titan Xp	$5.00	R 68.15	R12 999	R11 000	R11 000	300	3	1150	1150	R12 999	R6 402	49.25%	141
Radeon RX470-4GB	$1.75	R 23.85	R3 099	R2 600	R2 600	120	7	1100	1100	R3 099	R1 468	47.37%	176
Radeon RX470-8GB	$1.85	R 25.22	R4 149	R2 800	R2 800	130	7	1200	1200	R4 149	R1 514	36.48%	383
Radeon RX480-4GB	$1.90	R 25.90	R3 698	R3 000	R3 000	160	5	1050	1050	R3 698	-R 366	-9.89%	1000
Radeon RX480-8GB	$2.06	R 28.08	R4 200	R3 500	R3 500	160	5	1050	1050	R4 200	R 330	7.86%	786

 

[Spontaneous.Spinach]

Thanks, you make life so much easier

Sent from my SM-G900H using Tapatalk

 

[Gendibal]

Interesting and informative! Thanks! Is this calculated for bitcoin or other currency?

 

[sjbs]

Interesting and informative! Thanks! Is this calculated for bitcoin or other currency?

It was based on Nicehash info, thus a combination of currencies.

 

[xyz0]

Radeon RX480-4GB $1.90 R 25.90 R3 698 R3 000 R3 000 160 5 1050 1050 R3 698 -R 366 -9.89% 1000

think this is a error
say you have it on 24/7
electricity for my house is 1.455/kW
card will use 0.16kW/H, cost is R0.2328 /H, a day cost R5.59
Rate-cost= profit
R25.90- R5.59= R20.31 (Profit)
R3 698/ R20.31= 182.07 Days (Break even)
365days - 182.07 Days= 182 days (remaining year)
182 days * R20.31 = R3715.15 (Profit after a year)

 

[sjbs]

No error, just assumptions.

Just changing the admin, internet and maintenance cost as well as room rent to zero and then changing depreciation from 200% (6 months) to 50% (2 years), will give you the following picture. It is important that you consider all the assumptions in the sheet; as it will impact your profitability at the end of the day....

 

[xyz0]

yes totally agree, all these are calculations as things can happen anytime
But logically think about the Rx 480s in the first post
View attachment 65172
it will take 1000 days to break even for rx480 4gb, and more than 2 years for rx 480 8gb(actually 110+- days)?
and also, it will take a month to break even with a 1080 ti? (@HNO3, we know your plan)

 

[b1nd3r512]

Very sorry but i think the math is all wrong here honestly.

1080ti paid of in 29 days???? So 3 cards with an average will generate roughly $13.93 x 29 days that you say it will take. = $401.

current Rate 1 US Dollar equals = 13.42 South African Rand.

$401 x R13.42 = R5382.35

That doesnt even pay for 1 in the 29days you have stated. It will more likely 2 months minimum to pay off 1 card. this is good for an understanding of what each card can do in $ and the power drain, but the calculations dont seem right to me. It could also be to early on a sunday and im pulling this out my ass.

 

[Maverick]

Also, I have an RX 570 that costs half that of the 1070 doing $3.20 as we speak and sitting at anything between 90 - 95W, the RX 470 is very similar to that from what I have read. And that will take me about 3 - 4 months to pay off. So some of those numbers are not spot on. But nice comparison none the less.

 

[Sola Scriptura]

Also, I have an RX 570 that costs half that of the 1070 doing $3.20 as we speak and sitting at anything between 90 - 95W, the RX 470 is very similar to that from what I have read. And that will take me about 3 - 4 months to pay off. So some of those numbers are not spot on. But nice comparison none the less.

Hey man, if I may ask, what brand and model RX570 are you running?

 

[Maverick]

Hey man, if I may ask, what brand and model RX570 are you running?

MSI gaming x 4gb with a bios mod on it.

Sent from my HUAWEI VNS-L31 using Tapatalk

 

[Sola Scriptura]

MSI gaming x 4gb with a bios mod on it.

Sent from my HUAWEI VNS-L31 using Tapatalk

cool thanks man!

 

[Erohann]

http://www.mycryptobuddy.com/Ethere...shrate=170&powerCost=0.13&poolFee=3&power=700

If I'm understanding this difficulty change thing right, in 24 months they would expect you to reach your bottleneck and returns < power cost. After 6 months you are making less than 25% what you did in your first month. Not to mention ROI...

This is only looking at ETH mining, I know there are a lot of other currencies to mine, new currencies come out, miners change, but accounting for the variables you can and looking at historic difficulty increases, I'm having some difficulty understanding this story...?