ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
To use this spreadsheet:
3
First, make your own copy (File -> Make a copy) so that you can edit values. (you must be logged into Google to do this)
4
Next, change cells with white background to whatever you think best suits your situation.
5
The Validator Details area has your validator's data in it, so use your own values -- the
6
numbers that start out in those cells are just samples and probably don't represent your values,
7
so change them to what you think you will achieve.
8
The Solana Economics area is based on observed values - change these only
9
if you know that different values are more likely (especially price), or if you want
10
to play around.
11
12
Validator DetailsDerived Values
13
Hardware Costs per Year$3,000.00
Validator Earnings Per Year Due to Third Party Stake Rewards Commission (SOL)
14
Network Costs per Year$3,000.001,280.00
15
Commission Charged2.00%
Validator Earnings Per Year Due to Self Stake Rewards Commission (SOL)
16
Third Party Stake (SOL)800,00016.00
17
Self Stake (SOL)200
Validator earnings from transaction fees (block rewards) per year (SOL)
18
724.34
19
Solana Economics
Voting fee costs per year (SOL)
20
Epochs per Year157329.70
21
Rewards APY8.00%
Gross Earnings per Year (SOL)
Total Costs per Year (SOL)
22
Voting Costs per Epoch (SOL)2.12,020.34645.49
23
SOL Price$19.00
24
Transaction Fee/Rent Factor0.000787
25
26
Per DayPer EpochPer Year
27
Gain/Loss (SOL)3.76418.7571,374.85
28
Gain/Loss (Dollars)$71.52$166.38$26,122.09
29
30
Break-Even Third Party Stake263,650
31
Break-Even Price$3.55
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