Monthly Compound Calculator.xlsx

	A	B	C	D	E	G	H	I	J	K	L	M
1						Date	Shares	Share Price	NAV Erosion/Appreciation	Distribution	Monthly Distribution	Total Value
2						1/1/2025	68,965.52	14.5	0	$ 0.16950769230769	$ 11,690.19	$ 1,000,000.00
3		<Insert Stock Name Here>				2/1/2025	69,771.74	14.50000	0	$ 0.16950769230769	$ 11,826.85	$ 1,011,690.19
4		Initial Princple	1,000,000			3/1/2025	70,587.38	14.50000	0	$ 0.16950769230769	$ 11,965.10	$ 1,023,517.03
5		Share Price	14.5			4/1/2025	71,412.56	14.50000	0	$ 0.16950769230769	$ 12,104.98	$ 1,035,482.14
6		Share Count	68,965.52			5/1/2025	72,247.39	14.50000	0	$ 0.16950769230769	$ 12,246.49	$ 1,047,587.11
7		Distribution	2.2036	$ 0.1695077		6/1/2025	73,091.97	14.50000	0	$ 0.16950769230769	$ 12,389.65	$ 1,059,833.60
8		NAV Erosion/Appreciation	0.00%	0.000%		7/1/2025	73,946.43	14.50000	0	$ 0.16950769230769	$ 12,534.49	$ 1,072,223.25
9		Months/Payments	13			8/1/2025	74,810.88	14.50000	0	$ 0.16950769230769	$ 12,681.02	$ 1,084,757.74
10						9/1/2025	75,685.43	14.50000	0	$ 0.16950769230769	$ 12,829.26	$ 1,097,438.76
11						10/1/2025	76,570.21	14.50000	0	$ 0.16950769230769	$ 12,979.24	$ 1,110,268.03
12						11/1/2025	77,465.33	14.50000	0	$ 0.16950769230769	$ 13,130.97	$ 1,123,247.26
13						12/1/2025	78,370.91	14.50000	0	$ 0.16950769230769	$ 13,284.47	$ 1,136,378.23
14	Total Net Premium	13.3509		Total Net Premium	2.2036	1/1/2026	79,287.08	14.50000	0	$ 0.16950769230769	$ 13,439.77	$ 1,149,662.71
15	Per Payment/monthly Yield	1.0269		Per Payment/monthly Yield	0.1695	2/1/2026	80,213.96	14.50000	0	$ 0.16950769230769	$ 13,596.88	$ 1,163,102.48
16	Distribution Rate	92.07%		Distribution Rate	7.40%	3/1/2026	81,151.68	14.50000	0	$ 0.16950769230769	$ 13,755.83	$ 1,176,699.36
17	Estimate of Yearly Premium	13.3509		Estimate of Yearly Premium	2.2036	4/1/2026	82,100.36	14.50000	0	$ 0.16950769230769	$ 13,916.64	$ 1,190,455.19
18						5/1/2026	83,060.13	14.50000	0	$ 0.16950769230769	$ 14,079.33	$ 1,204,371.84
19						6/1/2026	84,031.11	14.50000	0	$ 0.16950769230769	$ 14,243.92	$ 1,218,451.17
20						7/1/2026	85,013.45	14.50000	0	$ 0.16950769230769	$ 14,410.43	$ 1,232,695.09
21						8/1/2026	86,007.28	14.50000	0	$ 0.16950769230769	$ 14,578.90	$ 1,247,105.52
22						9/1/2026	87,012.72	14.50000	0	$ 0.16950769230769	$ 14,749.33	$ 1,261,684.42
23						10/1/2026	88,029.91	14.50000	0	$ 0.16950769230769	$ 14,921.75	$ 1,276,433.74
24						11/1/2026	89,059.00	14.50000	0	$ 0.16950769230769	$ 15,096.19	$ 1,291,355.49
25						12/1/2026	90,100.12	14.50000	0	$ 0.16950769230769	$ 15,272.66	$ 1,306,451.68
26						1/1/2027	91,153.40	14.50000	0	$ 0.16950769230769	$ 15,451.20	$ 1,321,724.34
27						2/1/2027	92,219.00	14.50000	0	$ 0.16950769230769	$ 15,631.83	$ 1,337,175.54
28						3/1/2027	93,297.06	14.50000	0	$ 0.16950769230769	$ 15,814.57	$ 1,352,807.37
29						4/1/2027	94,387.72	14.50000	0	$ 0.16950769230769	$ 15,999.44	$ 1,368,621.94
30						5/1/2027	95,491.13	14.50000	0	$ 0.16950769230769	$ 16,186.48	$ 1,384,621.39
31						6/1/2027	96,607.44	14.50000	0	$ 0.16950769230769	$ 16,375.70	$ 1,400,807.87
32						7/1/2027	97,736.80	14.50000	0	$ 0.16950769230769	$ 16,567.14	$ 1,417,183.57
33						8/1/2027	98,879.36	14.50000	0	$ 0.16950769230769	$ 16,760.81	$ 1,433,750.71
34						9/1/2027	100,035.28	14.50000	0	$ 0.16950769230769	$ 16,956.75	$ 1,450,511.52
35						10/1/2027	101,204.71	14.50000	0	$ 0.16950769230769	$ 17,154.98	$ 1,467,468.27
36						11/1/2027	102,387.81	14.50000	0	$ 0.16950769230769	$ 17,355.52	$ 1,484,623.25
37						12/1/2027	103,584.74	14.50000	0	$ 0.16950769230769	$ 17,558.41	$ 1,501,978.77
38						1/1/2028	104,795.67	14.50000	0	$ 0.16950769230769	$ 17,763.67	$ 1,519,537.18
39						2/1/2028	106,020.75	14.50000	0	$ 0.16950769230769	$ 17,971.33	$ 1,537,300.85
40						3/1/2028	107,260.15	14.50000	0	$ 0.16950769230769	$ 18,181.42	$ 1,555,272.18
41						4/1/2028	108,514.04	14.50000	0	$ 0.16950769230769	$ 18,393.96	$ 1,573,453.60
42						5/1/2028	109,782.59	14.50000	0	$ 0.16950769230769	$ 18,608.99	$ 1,591,847.57
43						6/1/2028	111,065.97	14.50000	0	$ 0.16950769230769	$ 18,826.54	$ 1,610,456.56
44						7/1/2028	112,364.35	14.50000	0	$ 0.16950769230769	$ 19,046.62	$ 1,629,283.10
45						8/1/2028	113,677.91	14.50000	0	$ 0.16950769230769	$ 19,269.28	$ 1,648,329.72
46						9/1/2028	115,006.83	14.50000	0	$ 0.16950769230769	$ 19,494.54	$ 1,667,599.00
47						10/1/2028	116,351.28	14.50000	0	$ 0.16950769230769	$ 19,722.44	$ 1,687,093.54
48						11/1/2028	117,711.45	14.50000	0	$ 0.16950769230769	$ 19,953.00	$ 1,706,815.98
49						12/1/2028	119,087.52	14.50000	0	$ 0.16950769230769	$ 20,186.25	$ 1,726,768.98
50						1/1/2029	120,479.67	14.50000	0	$ 0.16950769230769	$ 20,422.23	$ 1,746,955.23
51						2/1/2029	121,888.10	14.50000	0	$ 0.16950769230769	$ 20,660.97	$ 1,767,377.46
52						3/1/2029	123,312.99	14.50000	0	$ 0.16950769230769	$ 20,902.50	$ 1,788,038.43
53						4/1/2029	124,754.55	14.50000	0	$ 0.16950769230769	$ 21,146.86	$ 1,808,940.93
54						5/1/2029	126,212.95	14.50000	0	$ 0.16950769230769	$ 21,394.07	$ 1,830,087.78
55						6/1/2029	127,688.40	14.50000	0	$ 0.16950769230769	$ 21,644.17	$ 1,851,481.85
56						7/1/2029	129,181.10	14.50000	0	$ 0.16950769230769	$ 21,897.19	$ 1,873,126.02
57						8/1/2029	130,691.26	14.50000	0	$ 0.16950769230769	$ 22,153.17	$ 1,895,023.21
58						9/1/2029	132,219.06	14.50000	0	$ 0.16950769230769	$ 22,412.15	$ 1,917,176.38
59						10/1/2029	133,764.73	14.50000	0	$ 0.16950769230769	$ 22,674.15	$ 1,939,588.53
60						11/1/2029	135,328.46	14.50000	0	$ 0.16950769230769	$ 22,939.22	$ 1,962,262.68
61						12/1/2029	136,910.48	14.50000	0	$ 0.16950769230769	$ 23,207.38	$ 1,985,201.89
62						1/1/2030	138,510.98	14.50000	0	$ 0.16950769230769	$ 23,478.68	$ 2,008,409.27
63						2/1/2030	140,130.20	14.50000	0	$ 0.16950769230769	$ 23,753.15	$ 2,031,887.95
64						3/1/2030	141,768.35	14.50000	0	$ 0.16950769230769	$ 24,030.83	$ 2,055,641.10
65						4/1/2030	143,425.65	14.50000	0	$ 0.16950769230769	$ 24,311.75	$ 2,079,671.92
66						5/1/2030	145,102.32	14.50000	0	$ 0.16950769230769	$ 24,595.96	$ 2,103,983.67
67						6/1/2030	146,798.60	14.50000	0	$ 0.16950769230769	$ 24,883.49	$ 2,128,579.63
68						7/1/2030	148,514.70	14.50000	0	$ 0.16950769230769	$ 25,174.38	$ 2,153,463.12
69						8/1/2030	150,250.86	14.50000	0	$ 0.16950769230769	$ 25,468.68	$ 2,178,637.51
70						9/1/2030	152,007.32	14.50000	0	$ 0.16950769230769	$ 25,766.41	$ 2,204,106.18
71						10/1/2030	153,784.32	14.50000	0	$ 0.16950769230769	$ 26,067.62	$ 2,229,872.60
72						11/1/2030	155,582.08	14.50000	0	$ 0.16950769230769	$ 26,372.36	$ 2,255,940.22
73						12/1/2030	157,400.87	14.50000	0	$ 0.16950769230769	$ 26,680.66	$ 2,282,312.58
74						1/1/2031	159,240.91	14.50000	0	$ 0.16950769230769	$ 26,992.56	$ 2,308,993.24
75						2/1/2031	161,102.47	14.50000	0	$ 0.16950769230769	$ 27,308.11	$ 2,335,985.80
76						3/1/2031	162,985.79	14.50000	0	$ 0.16950769230769	$ 27,627.34	$ 2,363,293.91
77						4/1/2031	164,891.12	14.50000	0	$ 0.16950769230769	$ 27,950.31	$ 2,390,921.25
78						5/1/2031	166,818.73	14.50000	0	$ 0.16950769230769	$ 28,277.06	$ 2,418,871.56
79						6/1/2031	168,768.87	14.50000	0	$ 0.16950769230769	$ 28,607.62	$ 2,447,148.62
80						7/1/2031	170,741.81	14.50000	0	$ 0.16950769230769	$ 28,942.05	$ 2,475,756.24
81						8/1/2031	172,737.81	14.50000	0	$ 0.16950769230769	$ 29,280.39	$ 2,504,698.29
82						9/1/2031	174,757.15	14.50000	0	$ 0.16950769230769	$ 29,622.68	$ 2,533,978.68
83						10/1/2031	176,800.09	14.50000	0	$ 0.16950769230769	$ 29,968.98	$ 2,563,601.36
84						11/1/2031	178,866.92	14.50000	0	$ 0.16950769230769	$ 30,319.32	$ 2,593,570.34
85						12/1/2031	180,957.91	14.50000	0	$ 0.16950769230769	$ 30,673.76	$ 2,623,889.66
86						1/1/2032	183,073.34	14.50000	0	$ 0.16950769230769	$ 31,032.34	$ 2,654,563.41
87						2/1/2032	185,213.50	14.50000	0	$ 0.16950769230769	$ 31,395.11	$ 2,685,595.75
88						3/1/2032	187,378.68	14.50000	0	$ 0.16950769230769	$ 31,762.13	$ 2,716,990.87
89						4/1/2032	189,569.17	14.50000	0	$ 0.16950769230769	$ 32,133.43	$ 2,748,752.99
90						5/1/2032	191,785.27	14.50000	0	$ 0.16950769230769	$ 32,509.08	$ 2,780,886.43
91						6/1/2032	194,027.28	14.50000	0	$ 0.16950769230769	$ 32,889.12	$ 2,813,395.51
92						7/1/2032	196,295.49	14.50000	0	$ 0.16950769230769	$ 33,273.60	$ 2,846,284.62
93						8/1/2032	198,590.22	14.50000	0	$ 0.16950769230769	$ 33,662.57	$ 2,879,558.22
94						9/1/2032	200,911.78	14.50000	0	$ 0.16950769230769	$ 34,056.09	$ 2,913,220.79
95						10/1/2032	203,260.47	14.50000	0	$ 0.16950769230769	$ 34,454.21	$ 2,947,276.88
96						11/1/2032	205,636.63	14.50000	0	$ 0.16950769230769	$ 34,856.99	$ 2,981,731.09
97						12/1/2032	208,040.56	14.50000	0	$ 0.16950769230769	$ 35,264.47	$ 3,016,588.08
98						1/1/2033	210,472.59	14.50000	0	$ 0.16950769230769	$ 35,676.72	$ 3,051,852.56
99						2/1/2033	212,933.05	14.50000	0	$ 0.16950769230769	$ 36,093.79	$ 3,087,529.28
100						3/1/2033	215,422.28	14.50000	0	$ 0.16950769230769	$ 36,515.73	$ 3,123,623.07