sigmaUSD_V5.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2	Fill in current values (or pick own values)	SigUSD circulating supply	132614		https://sigmausd.io/#/			Input initial values		This is a simple tool to try different scenarios for the sigmaUSD stablecoin contract. It is possible to change more than one variable at a time in the blue fields. The changes are assumed to happen between two points in time, in the given order. In reality, the changes are dynamic, and therefore the results are just ball-park estimates. * We leave the estimation of the accumulated fees up to the user. They can't be deduced from the other variables in this simple model. (There is an unknown amount of ERG entering and leaving the contract between the starting values on green and ending values on blue.) It should be at least 2% of steps 3 and 4 on blue.
3		SigRSV circulating supply	1093475191		https://sigmausd.io/#/			Choose changes
4		ERG to sigRSV ratio	832	0.00120192	sigRSV to ERG ratio			Do not change
5		ERG to sigUSD ratio	2.42	0.41322314	sigUSD to ERG ratio			Do not change
6	Adjust blue cells to expected changes	1. Amount of sigRSV purchased	1000000	1229	Cost in ERG (with fee)
7		2. Expected USD exhange rate to ERG	4.00	0.25000000	Expected sigUSD to ERG ratio
8		3. Change in SigUSD circulating supply	1000000
9		4. Change in SigRSV circulating supply	0	0	Change in SigRSV circulating supply in ERG (without fee)
10		5. Fees accumulated (in ERG)*	20000
11	Results	Redeemable sigRSV	1000000	1212	Redeemable sigRSV in ERG (fee deducted)
12		Profit in ERG	-17	1874	Profit in USD
13		Profit in holding ERG instead of sigRSV	0	1942	Profit in USD, if holding ERG instead of sigRSV
14
15		Changes in contract	sigRSV supply	sigRSV equity in ERG	sigRSV price in ERG	sigRSV price in USD	Fees in equity in ERG	Balancing equity in ERG	Liabilities in ERG	Liabilities in USD	Equity in USD	total reserve in USD	Reserve ratio
16	Step 0	Initial conditions	1093475191	1314273	0.0012019	0.0029087	0.000	0	54799	132614	3180541	3313155	2498%
17	Step 1a	buy sigRSV (fees go into contract)	1093475191	1314273	0.0012019	0.0029087	24.038	0	54799	132614	3180599	3313213	2498%
18	Step 1b	buy sigRSV (purchase goes into contract)	1094475191	1315475	0.0012019	0.0029087	24.038	0	54799	132614	3183508	3316122	2501%
19	Step 2a	Change in USD-ERG exchange rate	1094475191	1315475	0.0012019	0.0048078	24.038	0	33154	132614	5261996	5394610	4068%
20	Step 2b	Balancing liabilities and equity	1094475191	1315475	0.0012217	0.0048869	24.038	21646	33154	132614	5348579	5481193	4133%
21	Step 3	Change in SigUSD circulating supply	1094475191	1315475	0.0012217	0.0048869	24.038	21646	283154	1132614	5348579	6481193	572%
22	Step 4	Change in SigRSV circulating supply	1094475191	1315475	0.0012217	0.0048869	24.038	21646	283154	1132614	5348579	6481193	572%
23	Step 5	Fees accumulated (in ERG)	1094475191	1315475	0.0012400	0.0049600	20024	21646	283154	1132614	5428579	6561193	579%
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