Masternode reward calc

	A	B	C	D	E	F	G	H	I	J	K	L
1
2	Block target time, second		90		Average miner's mining speed, kH/sec			7,5
3	Base block reward, KMC		10		Masternode cost		KMC	1000	$8,00
4	Blocks per day, expected*		960		Masternodes in Network			1000		1 KMC =	$0,01
5	KMC per day, expeted		24000		Network hash rate		kH/sec	80			< As a base you can use this:	=H4*40
6	* Last day there were 1030 blocks				Exchange rates		KMC/BTC	0,0000005			< To get here the fair value write:	=H5/H7/10000
7					Exchange rates		$/BTC	$16 000,00
8
9	Masternode reward	%	0,0%	3,5%	10,0%	20,0%	25,0%	30,0%	40,0%	50,0%
10	MN's reward per block	KMC	0,00000000	0,00035000	0,00100000	0,00200000	0,00250000	0,00300000	0,00400000	0,00500000
11	MN's reward per day	KMC	0,0	0,3	1,0	1,9	2,4	2,9	3,8	4,8
12	Miner's reward per block	KMC	0,93750000	0,90468750	0,84375000	0,75000000	0,70312500	0,65625000	0,56250000	0,46875000
13	Miner's reward per day	KMC	900,0	868,5	810,0	720,0	675,0	630,0	540,0	450,0
14
15	MN reward per day	$	$0,00	$0,00	$0,01	$0,02	$0,02	$0,02	$0,03	$0,04
16	Miner's reward per day	$	$7,20	$6,95	$6,48	$5,76	$5,40	$5,04	$4,32	$3,60
17
18	MN ROI	%	0,00%	-61,49%	-59,62%	-56,74%	-55,30%	-53,86%	-50,98%	-48,10%
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
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