Copy of mine-or-invest

	A	B	C	D	E	F	G	H	I	J	K	M	N	O	P	Q	R	S	U	V
1	Bitcoin Mining Profitability Estimate
2	Bitcoin Mining Profitability Estimate
3	Per Miner Figures						Facility Figures						State of Iowa Figures					Global Figures
4	Period		365	days			Site cost		100,000.00	dollars			Wind Elex Capacity		3.00E+09	watts		Hash rate	1.00E+20	H/sec
5	Initial BTC value		17000	dollars			Miner Container cost		20,000.00	dollars			Mining Fraction		0.1
6	BTC default change		50%	percent/period			Miners/container		180
7	Initial difficulty		2.50E+13	TH/Block			Miner Containers		3	containers
8	Reward/Block		6250	mBTC			Labor cost/container		100,000.00	dollars/year
9	Diff default change		100%	percent/period
10	Miner cost		7000	dollars			Miners		540	miners
11	Miner hash rate		110	TH/sec			Miners cost		3,780,000.00	dollars			Mining power		3.00E+08	watts
12	Power consumption		3300	watts			Containers cost		60,000.00	dollars			Miners		1.21E+05
13	Power cost		0.036	dollars/kWh			Capital cost		3,940,000.00	dollars			Hash rate		1.00E+19	H/sec
14	Time Utilized		0.75	fraction			Labor OPEX		300,000.00	dollars/period
15	Other costs		0	dollars/period			CAPEX		$126,126.62	dollars/period
16	Pool fees		0.01	fraction			Mining end AVG ROI		3.62%
17	Interest rate		0.05	fraction/period			BTC end AVG ROI		45.00%
18	Depreciation periods		4	periods
19	Utilized power cons.		2475	watts			Electrical Power		1.782	MW
20	Utilized hash rate		82.5	TH/sec			Walnut Windfarm		153	MW
21							Utilization of WWf		1.16%
22	Per Miner Projected Comparison Between Holding BTC vs Mining (Given Rate Of Changes of Both BTC value and Mining Difficulty)
23												Facility Projections
24	Period	BTC change	BTC value	Difficulty change	Difficulty	BTC mined	Dollar Value	Operating Costs	Net		BTC purchased	Facility Net	Cummulative Net	Cummulative ROI	AVG ROI	Principal Payment	Remaining Principal
25	1	0%	17000	0%	2.5000E+13	0.1514400	2,548.74	780.52	1,768.22		#REF!	528,712.07	528,712.07	18.42%	18.42%	-$914,126.62	$3,025,873.38
26	2	50%	25500	100%	5.0000E+13	0.0757200	1,911.55	780.52	1,131.04		0.0306085	184,632.74	713,344.81	23.11%	11.55%	-$959,832.95	$2,066,040.43
27	3	50%	38250	100%	1.0000E+14	0.0378600	1,433.66	780.52	653.15		0.0204056	-73,426.76	639,918.05	21.24%	7.08%	-$1,007,824.60	$1,058,215.83
28	4	50%	57375	100%	2.0000E+14	0.0189300	1,075.25	780.52	294.73		0.0136038	-266,971.39	372,946.66	14.47%	3.62%	-$1,058,215.83	$0.00
29	5	50%	86062.5	100%	4.0000E+14	0.0094650	806.44	780.52	25.92		0.0090692	-412,129.85	-39,183.19	4.01%	0.80%	#NUM!	#NUM!
30	6	50%	129093.75	100%	8.0000E+14	0.0047325	604.83	780.52	0.00		0.0060461	-426,126.62	-465,309.81	-6.81%	-1.13%	#NUM!	#NUM!
31	7	50%	193640.625	100%	1.6000E+15	0.0023663	453.62	780.52	0.00		0.0040307	-426,126.62	-891,436.44	-17.63%	-2.52%	#NUM!	#NUM!
32	8	50%	290460.9375	100%	3.2000E+15	0.0011831	340.22	780.52	0.00		0.0026872	-426,126.62	-1,317,563.06	-28.44%	-3.56%	#NUM!	#NUM!
33	9	50%	435691.4063	100%	6.4000E+15	0.0005916	255.16	780.52	0.00		0.0017914	-426,126.62	-1,743,689.68	-39.26%	-4.36%	#NUM!	#NUM!
34	10	50%	653537.1094	100%	1.2800E+16	0.0002958	191.37	780.52	0.00		0.0011943	-426,126.62	-2,169,816.30	-50.07%	-5.01%	#NUM!	#NUM!
35	11	50%	980305.6641	100%	2.5600E+16	0.0001479	143.53	780.52	0.00		0.0007962	-426,126.62	-2,595,942.92	-60.89%	-5.54%	#NUM!	#NUM!
36	12	50%	1470458.496	100%	5.1200E+16	0.0000739	107.65	780.52	0.00		0.0005308	-426,126.62	-3,022,069.54	-71.70%	-5.98%	#NUM!	#NUM!
37	13	50%	2205687.744	100%	1.0240E+17	0.0000370	80.73	780.52	0.00		0.0003539	-426,126.62	-3,448,196.16	-82.52%	-6.35%	#NUM!	#NUM!
38	14	50%	3308531.616	100%	2.0480E+17	0.0000185	60.55	780.52	0.00		0.0002359
39	15	50%	4962797.424	100%	4.0960E+17	0.0000092	45.41	780.52	0.00		0.0001573
40	16	50%	7444196.136	100%	8.1920E+17	0.0000046	34.06	780.52	0.00		0.0001048
41	17	50%	11166294.2	100%	1.6384E+18	0.0000023	25.54	780.52	0.00		0.0000699
42	18	50%	16749441.31	100%	3.2768E+18	0.0000012	19.16	780.52	0.00		0.0000466
43	19	50%	25124161.96	100%	6.5536E+18	0.0000006	14.37	780.52	0.00		0.0000311
44	20	50%	37686242.94	100%	1.3107E+19	0.0000003	10.78	780.52	0.00		0.0000207
45	21	50%	56529364.41	100%	2.6214E+19	0.0000001	8.08	780.52	0.00		0.0000138
46	22	50%	84794046.62	100%	5.2429E+19	0.0000001	6.06	780.52	0.00		0.0000092
47	23	50%	127191069.9	100%	1.0486E+20	0.0000000	4.55	780.52	0.00		0.0000061
48	24	50%	190786604.9	100%	2.0972E+20	0.0000000	3.41	780.52	0.00		0.0000041
49	25	50%	286179907.3	100%	4.1943E+20	0.0000000	2.56	780.52	0.00		0.0000027
50	26	50%	429269861	100%	8.3886E+20	0.0000000	1.92	780.52	0.00		0.0000018
51	27	50%	643904791.5	100%	1.6777E+21	0.0000000	1.44	780.52	0.00		0.0000012
52	28	50%	965857187.2	100%	3.3554E+21	0.0000000	1.08	780.52	0.00		0.0000008
53	29	50%	1448785781	100%	6.7109E+21	0.0000000	0.81	780.52	0.00		0.0000005
54	30	50%	2173178671	100%	1.3422E+22	0.0000000	0.61	780.52	0.00		0.0000004
55	31	50%	3259768007	100%	2.6844E+22	0.0000000	0.46	780.52	0.00		0.0000002
56	32	50%	4889652010	100%	5.3687E+22	0.0000000	0.34	780.52	0.00		0.0000002
57	33	50%	7334478016	100%	1.0737E+23	0.0000000	0.26	780.52	0.00		0.0000001
58	34	50%	11001717023	100%	2.1475E+23	0.0000000	0.19	780.52	0.00		0.0000001
59	35	50%	16502575535	100%	4.2950E+23	0.0000000	0.14	780.52	0.00		0.0000000
60	36	50%	24753863303	100%	8.5899E+23	0.0000000	0.11	780.52	0.00		0.0000000
61						0.3028801	10,194.62	28,098.58	3,873.06		#REF!
62
63
64			Mine and exchange each period:			Net income			3873
65						less miner purchase			#REF!
66						profit (loss)			#REF!
67
68			Mine and hold until end:			Total BTC mined			0.3028801
69						dollar value			7497451877
70						less operating costs			28099
71						less miner purchase			#REF!
72						profit (loss)			#REF!
73
74			Instead of mining, invest miner cost and monthly operating costs in BTC
75						Total BTC purchased			#REF!
76						dollar value			#REF!
77						less operating costs			28099	used to purchase BTC
78						less miner purchase			#REF!	used to purchase BTC
79						profit (loss)			#REF!
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100