Public S9 economics

	A	B	C	D	E	F	G	H	I
1	Instructions:
2	1. Don't ask me for edit authority, just take a COPY to your own drive
3	2. Put in your own figures in BLUE.
4
5
6	starting difficulty	2,874,674,234,415		https://btc.com/stats/diff
7	yearly difficulty factor	5.00	x	2017: 5.1x; 2016: 3.9x
8	btc initial value	10,000.00	USD
9	yearly btc value change	100.00	%
10	block reward	12.50	BTC	http://www.bitcoinblockhalf.com/
11	tx reward	1.15	BTC	https://poolprofit.io/en/
12	Pool fee	2.00	%	https://poolprofit.io/en/
13	hashrate	13.50	TH/s	https://shop.bitmain.com/antminer_s9_asic_bitcoin_miner.htm?flag=specifications
14	power consumption	1400	W	https://shop.bitmain.com/antminer_s9_asic_bitcoin_miner.htm?flag=specifications
15	electricity cost	5.00	c/kWh
16	hardware costs	3000	USD	S9 + PSU + shipping + taxes + cabling/racking/etc
17	period length	60	days	Changes the periods in the table below
18
19
20	daily difficulty factor	0.995600		This spreadsheet models the fortnighly difficulty change as a daily change
21	daily btc factor	1.001901		Average daily change in btc price
22	initial time/block	914565320	secs	Time to find a block using the initial values
23	initial time/block	10585	days	Time to find a block using the initial values
24	initial/day	0.001264	BTC
25	initial/day	12.64	USD
26	power cost	1.68	USD/day;	50.40	USD/mo;	613.20	USD/yr
27
28
29				average	/period
30	Periods	Start day	End day	USD/BTC	mined (BTC)	power (USD)	total (USD)	TTD (USD)
31	1	0	59	10,592.80	0.066770	100.80	606.48	606
32	2	60	119	11,871.22	0.051249	100.80	507.59	1114	Put in your own wild guesses at future USD/BTC values here or use the yearly % value change above
33	3	120	179	13,303.92	0.039335	100.80	422.52	1537
34	4	180	239	14,909.54	0.030192	100.80	349.34	1886
35	5	240	299	16,708.92	0.023173	100.80	286.40	2172
36	6	300	359	18,725.48	0.017786	100.80	232.26	2405
37	7	360	419	20,985.40	0.013652	100.80	185.69	2590
38	8	420	479	23,518.07	0.010478	100.80	145.63	2736
39	9	480	539	26,356.40	0.008042	100.80	111.17	2847
40	10	540	599	29,537.27	0.006173	100.80	81.53	2929
41	11	600	659	33,102.04	0.004738	100.80	56.04	2985
42	12	660	719	37,097.03	0.003637	100.80	34.11	3019
43	Totals				0.275225		3,018.74
44	ROI	18.74	USD	ROI over above periods
45	ROI	0.62	%	ROI over above periods
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100