| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Capital Invested | Start Price | Start Share Position | End Price 24th Month | Shares End Market Value | NVDY Total Cash Paid 1st yr | NVDY Total Cash Paid 2nd yr | Avg Month Cash Paid Over 2yrs | Capital Liquidation Value | NVDY 2yr No DRIP Pre-Tax Return | Type "run" below to run the simulation. If error encountered delete and re-type "run" | ||||||||||||||||||||||||||||||||
2 | $10,000.00 | $20.01 | 500 | $14.43 | $7,211.39 | $6,812.39 | $7,868.27 | $611.69 | $21,892.05 | 118.9% | run | ||||||||||||||||||||||||||||||||
3 | reset | Capital Liquidation Value @ 100% DRIP | Capital Liquidation Value @ 80% DRIP | Income @ 80% DRIP | Capital Liquidation Value @ 60% DRIP | Income @ 60% DRIP | Capital Liquidation Value @ 40% DRIP | Income @ 40% DRIP | Capital Liquidation Value @ 20% DRIP | Income @ 20% DRIP | Capital Liquidation Value No DRIP | Income No DRIP | Date | Distribution Paid | Close Price | Total Shares | 80% DRIP Total Shares | 60% DRIP Total Shares | 40% DRIP Total Shares | 20% DRIP Total Shares | Total Distribution | NVDY Inception Share Price | Month | Distribution % of Share Price | Historical Monthly Return Volatility | Monthly Log Returns | Index of possible decay rates | Static Random Index Seed | |||||||||||||||
4 | Month 1 | $12,162.07 | $12,087.48 | $76.48 | $12,012.88 | $152.02 | $11,938.29 | $226.61 | $11,863.70 | $300.26 | $11,789.11 | $372.96 | 6/15/2023 | $0.75 | $23.59 | 515.56 | 512.40 | 509.24 | 506.07 | 502.91 | $384.76 | $20.01 | 1 | 3.16% | 10.17% | 0.1645907448 | -0.11 | ||||||||||||||||
5 | Month 2 | $12,578.33 | $12,403.07 | $101.32 | $12,229.02 | $199.80 | $12,056.19 | $295.46 | $11,884.56 | $388.34 | $11,714.14 | $478.46 | 7/17/2023 | $0.96 | $23.44 | 536.62 | 529.14 | 521.72 | 514.34 | 507.02 | $513.76 | Current Price | 2 | 4.08% | Rolling 3 Month Return Volatility | -0.006378928711 | -0.10 | ||||||||||||||||
6 | Month 3 | $12,145.60 | $11,890.27 | $88.67 | $11,638.52 | $173.59 | $11,390.34 | $254.83 | $11,145.69 | $332.47 | $10,904.55 | $406.60 | 8/14/2023 | $0.81 | $21.82 | 556.63 | 544.93 | 533.39 | 522.01 | 510.80 | $452.87 | $15.00 | 3 | 3.73% | 12.20% | -0.0716169843 | -0.09 | ||||||||||||||||
7 | Month 4 | $12,779.99 | $12,410.00 | $104.74 | $12,048.07 | $203.38 | $11,694.09 | $296.11 | $11,347.93 | $383.12 | $11,009.50 | $464.62 | 9/18/2023 | $0.93 | $22.03 | 580.12 | 563.32 | 546.89 | 530.83 | 515.11 | $539.34 | Fixed Weighted Monthly Geometric Decay Rate | 4 | 4.22% | 4.30% | 0.009578180409 | -0.08 | ||||||||||||||||
8 | Month 5 | $13,515.06 | $13,047.50 | $78.11 | $12,592.92 | $150.78 | $12,151.04 | $218.24 | $11,721.61 | $280.70 | $11,304.35 | $338.38 | 10/16/2023 | $0.68 | $22.62 | 597.48 | 576.81 | 556.72 | 537.18 | 518.20 | $404.56 | 3.34% | 5 | 2.99% | 5.24% | 0.02642930987 | -0.07 | ||||||||||||||||
9 | Month 6 | $13,392.57 | $12,881.38 | $48.60 | $12,386.38 | $93.46 | $11,907.16 | $134.77 | $11,443.34 | $172.69 | $10,994.50 | $207.40 | 11/16/2023 | $0.42 | $22.00 | 608.75 | 585.52 | 563.02 | 541.23 | 520.15 | $252.63 | Projected Distribution Based on Monte Carlo | 6 | 1.89% | 2.78% | -0.02779201733 | -0.07 | ||||||||||||||||
10 | Month 7 | $13,567.35 | $12,990.10 | $60.49 | $12,433.82 | $115.80 | $11,897.88 | $166.21 | $11,381.66 | $212.00 | $10,884.56 | $253.42 | 12/13/2023 | $0.51 | $21.78 | 622.93 | 596.42 | 570.88 | 546.28 | 522.57 | $315.89 | 5.08% | 7 | 2.33% | 2.76% | -0.01005033585 | -0.06 | ||||||||||||||||
11 | Month 8 | $14,218.93 | $13,539.28 | $76.36 | $12,888.01 | $145.37 | $12,264.10 | $207.50 | $11,666.56 | $263.18 | $11,094.45 | $312.84 | 1/9/2024 | $0.63 | $22.20 | 640.49 | 609.88 | 580.54 | 552.44 | 525.52 | $400.95 | 8 | 2.82% | 2.37% | 0.01910017137 | -0.05 | |||||||||||||||||
12 | Month 9 | $17,312.76 | $16,298.57 | $195.63 | $15,336.87 | $368.18 | $14,425.32 | $519.45 | $13,561.63 | $651.13 | $12,743.63 | $764.82 | 2/9/2024 | $1.53 | $25.50 | 678.93 | 639.16 | 601.45 | 565.70 | 531.83 | $1,039.04 | 9 | 6.00% | 7.88% | 0.1385861633 | -0.04 | |||||||||||||||||
13 | Month 10 | $20,518.61 | $18,981.45 | $360.63 | $17,546.07 | $666.73 | $16,206.57 | $923.74 | $14,957.36 | $1,136.72 | $13,793.10 | $1,310.29 | 3/8/2024 | $2.62 | $27.60 | 743.43 | 687.73 | 635.73 | 587.19 | 541.93 | $1,949.19 | 10 | 9.50% | 5.97% | 0.07913732056 | -0.04 | |||||||||||||||||
14 | Month 11 | $21,416.90 | $19,453.67 | $387.34 | $17,650.95 | $702.89 | $15,997.13 | $955.54 | $14,481.35 | $1,153.33 | $13,093.45 | $1,303.50 | 4/8/2024 | $2.61 | $26.20 | 817.44 | 742.51 | 673.70 | 610.58 | 552.72 | $2,132.13 | 11 | 9.96% | 9.75% | -0.05205636196 | -0.03 | |||||||||||||||||
15 | Month 12 | $22,012.64 | $19,816.79 | $184.66 | $17,818.89 | $332.08 | $16,002.94 | $447.36 | $14,354.09 | $535.02 | $12,858.57 | $599.10 | 5/8/2024 | $1.20 | $25.73 | 855.52 | 770.18 | 692.53 | 621.96 | 557.87 | $1,025.60 | 12 | 4.66% | 6.81% | -0.01810178447 | -0.02 | |||||||||||||||||
16 | Month 13 | $26,848.92 | $23,775.84 | $422.88 | $21,023.80 | $747.87 | $18,562.42 | $990.47 | $16,363.89 | $1,164.21 | $14,402.80 | $1,280.86 | 6/7/2024 | $2.56 | $28.82 | 931.61 | 824.98 | 729.49 | 644.08 | 567.80 | $2,387.71 | 13 | 8.89% | 8.74% | 0.1134119643 | -0.01 | |||||||||||||||||
17 | Month 14 | $28,479.89 | $24,812.47 | $436.33 | $21,579.97 | $758.97 | $18,735.21 | $988.38 | $16,235.65 | $1,142.02 | $14,042.98 | $1,234.73 | 7/8/2024 | $2.47 | $28.10 | 1,013.52 | 883.01 | 767.97 | 666.73 | 577.78 | $2,504.10 | 14 | 8.79% | 7.81% | -0.02530001423 | 0.00 | |||||||||||||||||
18 | Month 15 | $24,670.27 | $21,272.46 | $230.54 | $18,308.97 | $396.85 | $15,728.56 | $511.38 | $13,485.55 | $584.60 | $11,539.23 | $625.29 | 8/8/2024 | $1.25 | $23.09 | 1,068.44 | 921.28 | 792.94 | 681.19 | 584.04 | $1,336.83 | 15 | 5.42% | 15.52% | -0.196369953 | 0.00 | |||||||||||||||||
19 | Month 16 | $24,600.61 | $20,962.76 | $262.12 | $17,827.56 | $445.83 | $15,130.43 | $567.57 | $12,814.46 | $640.92 | $10,829.59 | $677.06 | 9/9/2024 | $1.35 | $21.67 | 1,135.24 | 967.36 | 822.68 | 698.22 | 591.35 | $1,538.02 | 16 | 6.25% | 8.98% | -0.06347080782 | 0.01 | |||||||||||||||||
20 | Month 17 | $29,482.02 | $24,909.53 | $220.33 | $21,003.07 | $371.55 | $17,671.92 | $468.93 | $14,836.85 | $524.94 | $12,428.79 | $549.68 | 10/11/2024 | $1.10 | $24.87 | 1,185.45 | 1,001.59 | 844.51 | 710.57 | 596.58 | $1,303.87 | 17 | 4.42% | 16.82% | 0.1377334423 | 0.02 | |||||||||||||||||
21 | Month 18 | $31,879.94 | $26,730.66 | $211.37 | $22,365.85 | $353.70 | $18,673.20 | $442.96 | $15,555.46 | $492.00 | $12,928.54 | $511.14 | 11/8/2024 | $1.02 | $25.87 | 1,232.31 | 1,033.27 | 864.55 | 721.81 | 601.29 | $1,260.41 | 18 | 3.95% | 10.06% | 0.03942173838 | 0.03 | |||||||||||||||||
22 | Month 19 | $31,627.44 | $26,274.04 | $254.39 | $21,778.87 | $421.73 | $18,012.06 | $523.19 | $14,862.18 | $575.59 | $12,233.88 | $592.25 | 12/6/2024 | $1.19 | $24.48 | 1,291.97 | 1,073.29 | 889.66 | 735.79 | 607.12 | $1,531.11 | 19 | 4.84% | 9.65% | -0.05522753855 | 0.04 | |||||||||||||||||
23 | Month 20 | $32,335.83 | $26,669.69 | $198.57 | $21,947.00 | $326.81 | $18,018.91 | $402.48 | $14,758.77 | $439.55 | $12,058.97 | $448.93 | 1/6/2025 | $0.90 | $24.13 | 1,340.07 | 1,105.25 | 909.53 | 746.74 | 611.64 | $1,203.78 | 20 | 3.72% | 4.75% | -0.01440057801 | 0.04 | |||||||||||||||||
24 | Month 21 | $26,344.92 | $21,545.22 | $189.80 | $17,579.10 | $309.72 | $14,308.91 | $378.16 | $11,618.56 | $409.41 | $9,410.29 | $414.49 | 1/31/2025 | $0.83 | $18.83 | 1,399.09 | 1,144.20 | 933.57 | 759.90 | 617.02 | $1,160.41 | 21 | 4.40% | 12.48% | -0.248004537 | 0.05 | |||||||||||||||||
25 | Month 22 | $27,634.61 | $22,231.10 | $395.06 | $17,837.77 | $633.98 | $14,274.51 | $761.00 | $11,391.71 | $809.75 | $9,065.47 | $805.50 | 2/28/2025 | $1.61 | $18.14 | 1,523.41 | 1,225.53 | 983.34 | 786.91 | 627.99 | $2,455.43 | 22 | 8.89% | 12.88% | -0.03733189798 | 0.06 | |||||||||||||||||
26 | Month 23 | $24,797.11 | $19,755.43 | $200.84 | $15,696.49 | $319.16 | $12,437.04 | $379.33 | $9,826.44 | $399.60 | $7,741.13 | $393.50 | 3/28/2025 | $0.79 | $15.49 | 1,600.85 | 1,275.37 | 1,013.33 | 802.91 | 634.37 | $1,260.51 | 23 | 5.08% | 10.57% | -0.1579247903 | 0.07 | |||||||||||||||||
27 | Month 24 | $24,172.78 | $19,087.14 | $177.25 | $15,029.72 | $279.14 | $11,801.14 | $328.76 | $9,239.01 | $343.18 | $7,211.39 | $334.83 | 04/25/2025 | $0.67 | $14.43 | 1,675.18 | 1,322.74 | 1,041.56 | 817.82 | 640.26 | $1,122.37 | 24 | 4.64% | 6.22% | -0.07088528164 | 0.08 | |||||||||||||||||
28 | Month 25 | $27,724.15 | $21,460.13 | $468.90 | $16,558.73 | $723.61 | $12,735.09 | $834.78 | $9,761.47 | $853.15 | $7,456.27 | $814.59 | 05/23/2025 | $1.63 | $14.92 | 1,858.19 | 1,438.35 | 1,109.83 | 853.56 | 654.25 | $3,028.84 | Simulated Values Begin | 25 | 10.92% | 9.58% | 0.03339322199 | 0.08 | ||||||||||||||||
29 | Month 26 | $29,302.01 | $22,287.94 | $393.55 | $16,893.81 | $607.32 | $12,759.25 | $700.63 | $9,600.98 | $716.04 | $7,196.95 | $683.68 | $1.37 | $14.40 | 2,034.71 | 1,547.66 | 1,173.09 | 885.99 | 666.68 | $2,783.58 | 26 | 9.50% | 10 | ||||||||||||||||||||
30 | Month 27 | $29,744.82 | $22,368.57 | $256.19 | $16,760.74 | $388.38 | $12,512.08 | $439.99 | $9,304.63 | $441.44 | $6,892.07 | $413.63 | $0.83 | $13.79 | 2,156.82 | 1,621.96 | 1,215.34 | 907.26 | 674.69 | $1,785.16 | 27 | 6.00% | 9 | ||||||||||||||||||||
31 | Month 28 | $30,194.32 | $22,449.48 | $257.12 | $16,628.71 | $385.32 | $12,269.70 | $431.47 | $9,017.42 | $427.81 | $6,600.12 | $396.11 | $0.79 | $13.21 | 2,286.27 | 1,699.84 | 1,259.10 | 929.04 | 682.78 | $1,812.13 | 28 | 6.00% | 9 | ||||||||||||||||||||
32 | Month 29 | $32,299.29 | $23,579.67 | $434.85 | $17,143.75 | $644.21 | $12,412.06 | $713.01 | $8,947.38 | $698.68 | $6,421.00 | $639.23 | $1.28 | $12.85 | 2,513.87 | 1,835.22 | 1,334.31 | 966.04 | 696.38 | $3,215.50 | 29 | 9.96% | 11 | ||||||||||||||||||||
33 | Month 30 | $35,498.67 | $25,696.67 | $218.67 | $18,523.95 | $317.96 | $13,296.22 | $345.31 | $9,501.76 | $331.89 | $6,759.31 | $297.73 | $0.60 | $13.53 | 2,624.60 | 1,899.89 | 1,369.57 | 983.06 | 702.51 | $1,563.60 | 30 | 4.40% | 21 | ||||||||||||||||||||
34 | Month 31 | $37,938.19 | $27,253.69 | $208.89 | $19,495.77 | $301.17 | $13,885.69 | $324.26 | $9,845.77 | $308.97 | $6,949.07 | $274.74 | $0.55 | $13.91 | 2,728.37 | 1,959.98 | 1,402.06 | 998.60 | 708.07 | $1,499.93 | 31 | 3.95% | 18 | ||||||||||||||||||||
35 | Month 32 | $41,098.41 | $29,311.97 | $211.93 | $20,816.55 | $303.21 | $14,718.43 | $323.93 | $10,359.66 | $306.25 | $7,257.74 | $270.19 | $0.54 | $14.52 | 2,829.94 | 2,018.35 | 1,433.38 | 1,013.47 | 713.34 | $1,529.99 | 32 | 3.72% | 20 | ||||||||||||||||||||
36 | Month 33 | $44,521.89 | $31,525.70 | $227.94 | $22,226.80 | $323.75 | $15,601.10 | $343.36 | $10,900.38 | $322.24 | $7,580.12 | $282.19 | $0.56 | $15.17 | 2,935.29 | 2,078.46 | 1,465.39 | 1,028.57 | 718.65 | $1,657.44 | 33 | 3.72% | 20 | ||||||||||||||||||||
37 | Month 34 | $48,230.53 | $33,906.62 | $245.15 | $23,732.60 | $345.68 | $16,536.71 | $363.95 | $11,469.32 | $339.06 | $7,916.81 | $294.72 | $0.59 | $15.84 | 3,044.56 | 2,140.36 | 1,498.12 | 1,043.88 | 724.00 | $1,795.50 | 34 | 3.72% | 20 | ||||||||||||||||||||
38 | Month 35 | $51,860.21 | $36,029.28 | $429.05 | $24,918.03 | $600.62 | $17,153.45 | $627.76 | $11,751.94 | $580.52 | $8,011.72 | $500.89 | $1.00 | $16.03 | 3,234.91 | 2,247.41 | 1,554.32 | 1,069.99 | 733.06 | $3,242.28 | 35 | 6.25% | 16 | ||||||||||||||||||||
39 | Month 36 | $55,424.11 | $38,212.37 | $292.89 | $26,225.30 | $405.13 | $17,913.93 | $418.33 | $12,177.42 | $382.14 | $8,236.65 | $325.65 | $0.65 | $16.48 | 3,362.80 | 2,318.50 | 1,591.19 | 1,086.91 | 738.85 | $2,191.26 | 36 | 3.95% | 18 | ||||||||||||||||||||
40 | Month 37 | $59,595.16 | $40,604.58 | $483.53 | $27,535.23 | $663.70 | $18,582.03 | $680.04 | $12,477.49 | $616.36 | $8,335.39 | $521.13 | $1.04 | $16.68 | 3,573.04 | 2,434.46 | 1,650.88 | 1,114.09 | 748.09 | $3,725.87 | 37 | 6.25% | 16 | ||||||||||||||||||||
41 | Month 38 | $64,080.10 | $43,146.55 | $513.80 | $28,910.59 | $696.85 | $19,275.06 | $705.40 | $12,784.95 | $631.55 | $8,435.31 | $527.37 | $1.06 | $16.88 | 3,796.43 | 2,556.22 | 1,712.81 | 1,141.95 | 757.44 | $4,006.26 | 38 | 6.25% | 16 | ||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||