Network Coin Tax Data Modelling

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Low coin appreciation and low yield example
2	Initial amount of coins held	1,000,000
3	Coin starting price	$1
4	Annual price appreciation	1.00%
5	Annual average yield	0.10%
6	Network coin tax rate	0.50%
7
8	Year	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
9	Coin price	$1.00	$1.01	$1.02	$1.03	$1.04	$1.05	$1.06	$1.07	$1.08	$1.09	$1.10	$1.12	$1.13	$1.14	$1.15	$1.16	$1.17	$1.18	$1.20	$1.21
10	Coins held	1,000,000	995,995	992,006	988,033	984,076	980,135	976,209	972,300	968,406	964,527	960,664	956,817	952,985	949,168	945,367	941,580	937,809	934,053	930,312	926,587
11	Total taxed amount	5,000	4,980	4,960	4,940	4,920	4,901	4,881	4,861	4,842	4,823	4,803	4,784	4,765	4,746	4,727	4,708	4,689	4,670	4,652	4,633
12	Yield generated	995	991	987	983	979	975	971	967	964	960	956	952	948	944	941	937	933	929	926	922
13	Total coins held year end	995,995	992,006	988,033	984,076	980,135	976,209	972,300	968,406	964,527	960,664	956,817	952,985	949,168	945,367	941,580	937,809	934,053	930,312	926,587	922,876
14	Total holdings value	$995,995	$1,001,926	$1,007,893	$1,013,894	$1,019,932	$1,026,006	$1,032,116	$1,038,262	$1,044,445	$1,050,664	$1,056,921	$1,063,215	$1,069,546	$1,075,915	$1,082,322	$1,088,767	$1,095,251	$1,101,773	$1,108,334	$1,114,934
15	Cost of rebuying taxed coins	$4,005	$8,074	$12,207	$16,407	$20,672	$25,004	$29,405	$33,874	$38,412	$43,021	$47,701	$52,454	$57,279	$62,178	$67,152	$72,201	$77,328	$82,531	$87,813	$93,175
16
17	Moderate coin appreciation & moderate yield example
18	Initial amount of coins held	1,000,000
19	Coin starting price	$1
20	Annual price appreciation	3.00%
21	Annual average yield	2.00%
22	Network coin tax rate	3.00%
23
24	Year	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
25	Coin price	$1.00	$1.03	$1.06	$1.09	$1.13	$1.16	$1.19	$1.23	$1.27	$1.30	$1.34	$1.38	$1.43	$1.47	$1.51	$1.56	$1.60	$1.65	$1.70	$1.75
26	Coins held	1,000,000	989,400	978,912	968,536	958,269	948,112	938,062	928,118	918,280	908,546	898,916	889,387	879,960	870,632	861,404	852,273	843,239	834,300	825,457	816,707
27	Total taxed amount	30,000	29,682	29,367	29,056	28,748	28,443	28,142	27,844	27,548	27,256	26,967	26,682	26,399	26,119	25,842	25,568	25,297	25,029	24,764	24,501
28	Yield generated	19,400	19,194	18,991	18,790	18,590	18,393	18,198	18,005	17,815	17,626	17,439	17,254	17,071	16,890	16,711	16,534	16,359	16,185	16,014	15,844
29	Total coins held year end	989,400	978,912	968,536	958,269	948,112	938,062	928,118	918,280	908,546	898,916	889,387	879,960	870,632	861,404	852,273	843,239	834,300	825,457	816,707	808,050
30	Total holdings value	$989,400	$1,008,280	$1,027,520	$1,047,127	$1,067,108	$1,087,471	$1,108,222	$1,129,369	$1,150,920	$1,172,881	$1,195,262	$1,218,070	$1,241,313	$1,265,000	$1,289,139	$1,313,738	$1,338,807	$1,364,354	$1,390,389	$1,416,920
31	Cost of rebuying taxed coins	$10,600	$21,720	$33,380	$45,600	$58,401	$71,803	$85,830	$100,505	$115,851	$131,892	$148,654	$166,164	$184,447	$203,533	$223,451	$244,229	$265,899	$288,493	$312,044	$336,586
32
33	High coin appreciation & low yield example
34	Initial amount of coins held	1,000,000
35	Coin starting price	$1
36	Annual price appreciation	5.00%
37	Annual average yield	1.00%
38	Network coin tax rate	4.00%
39
40	Year	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
41	Coin price	$1.00	$1.05	$1.10	$1.16	$1.22	$1.28	$1.34	$1.41	$1.48	$1.55	$1.63	$1.71	$1.80	$1.89	$1.98	$2.08	$2.18	$2.29	$2.41	$2.53
42	Coins held	1,000,000	969,600	940,124	911,544	883,833	856,965	830,913	805,653	781,162	757,414	734,389	712,063	690,417	669,428	649,077	629,345	610,213	591,663	573,676	556,237
43	Total taxed amount	40,000	38,784	37,605	36,462	35,353	34,279	33,237	32,226	31,246	30,297	29,376	28,483	27,617	26,777	25,963	25,174	24,409	23,667	22,947	22,249
44	Yield generated	9,600	9,308	9,025	8,751	8,485	8,227	7,977	7,734	7,499	7,271	7,050	6,836	6,628	6,427	6,231	6,042	5,858	5,680	5,507	5,340
45	Total coins held year end	969,600	940,124	911,544	883,833	856,965	830,913	805,653	781,162	757,414	734,389	712,063	690,417	669,428	649,077	629,345	610,213	591,663	573,676	556,237	539,327
46	Total holdings value	$969,600	$987,130	$1,004,978	$1,023,148	$1,041,646	$1,060,479	$1,079,653	$1,099,173	$1,119,046	$1,139,278	$1,159,876	$1,180,847	$1,202,197	$1,223,932	$1,246,061	$1,268,590	$1,291,526	$1,314,877	$1,338,650	$1,362,852
47	Cost of rebuying taxed coins	$30,400	$62,870	$97,522	$134,477	$173,860	$215,802	$260,443	$307,928	$358,410	$412,050	$469,018	$529,493	$593,660	$661,717	$733,871	$810,338	$891,349	$977,142	$1,067,970	$1,164,098
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