| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Only enter data into the grey boxes below. The rest auto-update. | |||||||||||||
2 | Created by Chainsaw | https://bitcointalk.org/index.php?action=profile;u=89959;sa=showPosts | ||||||||||||
3 | The Collectible Marketplace | I maintain a thread that aims to provide a centralized marketplace for buyers and sellers of limited edition Casascius coins. If you're interested in browsing or posting, check it out: | https://bitcointalk.org/index.php?topic=214589.0 | |||||||||||
4 | ||||||||||||||
5 | BTC Value at start point | 10000 | ||||||||||||
6 | Starting number of BTC | 10 | 13.37 | |||||||||||
7 | Start BTC withdraws at USD | 1,000.00 | Withdrawal Checkpoint | Net Non-BTC Value | Net USD Withdrawn | BTC Before Sell | BTC After Sell | Net BTC Value | USD Withdrawn Here | BTC to Sell | Total BTC Sold | TEMP rebuy target | 80% reinvest to BTC | |
8 | % gain increments | 20 | 6.6 | |||||||||||
9 | % to have in USD | 28 | 28 | $1,000 | $5,000 | $0 | 10.00 | 10.00 | $10,000 | $0 | 0.00 | 0.00 | $560 | 0 |
10 | Starting Net Non-BTC Value | 5000 | $1,200 | $5,000 | $0 | 10.00 | 10.00 | $12,000 | $0 | 0.00 | 0.00 | $672 | 0 | |
11 | REBUY at this % of sell | 0.56 | $1,440 | $5,000 | $432 | 10.00 | 9.70 | $14,400 | $432 | 0.30 | 0.30 | $806 | 0.4285714286 | |
12 | $1,728 | $5,432 | $1,214 | 9.70 | 9.25 | $16,762 | $782 | 0.45 | 0.75 | $968 | 0.6466666667 | |||
13 | $2,074 | $6,214 | $2,109 | 9.25 | 8.82 | $19,175 | $895 | 0.43 | 1.18 | $1,161 | 0.6164888889 | |||
14 | $2,488 | $7,109 | $3,133 | 8.82 | 8.40 | $21,937 | $1,024 | 0.41 | 1.60 | $1,393 | 0.5877194074 | |||
15 | $2,986 | $8,133 | $4,304 | 8.40 | 8.01 | $25,095 | $1,171 | 0.39 | 1.99 | $1,672 | 0.5602925017 | |||
16 | $3,583 | $9,304 | $5,644 | 8.01 | 7.64 | $28,709 | $1,340 | 0.37 | 2.36 | $2,007 | 0.5341455183 | |||
17 | $4,300 | $10,644 | $7,176 | 7.64 | 7.28 | $32,843 | $1,533 | 0.36 | 2.72 | $2,408 | 0.5092187275 | |||
18 | $5,160 | $12,176 | $8,930 | 7.28 | 6.94 | $37,573 | $1,753 | 0.34 | 3.06 | $2,889 | 0.4854551868 | |||
19 | $6,192 | $13,930 | $10,936 | 6.94 | 6.62 | $42,983 | $2,006 | 0.32 | 3.38 | $3,467 | 0.4628006115 | |||
20 | $7,430 | $15,936 | $13,230 | 6.62 | 6.31 | $49,173 | $2,295 | 0.31 | 3.69 | $4,161 | 0.4412032496 | |||
21 | $8,916 | $18,230 | $15,855 | 6.31 | 6.01 | $56,254 | $2,625 | 0.29 | 3.99 | $4,993 | 0.4206137646 | |||
22 | $10,699 | $20,855 | $18,859 | 6.01 | 5.73 | $64,354 | $3,003 | 0.28 | 4.27 | $5,992 | 0.4009851223 | |||
23 | $12,839 | $23,859 | $22,294 | 5.73 | 5.47 | $73,621 | $3,436 | 0.27 | 4.53 | $7,190 | 0.3822724832 | |||
24 | $15,407 | $27,294 | $26,225 | 5.47 | 5.21 | $84,222 | $3,930 | 0.26 | 4.79 | $8,628 | 0.3644331007 | |||
25 | $18,488 | $31,225 | $30,721 | 5.21 | 4.97 | $96,350 | $4,496 | 0.24 | 5.03 | $10,354 | 0.3474262226 | |||
26 | $22,186 | $35,721 | $35,865 | 4.97 | 4.74 | $110,225 | $5,144 | 0.23 | 5.26 | $12,424 | 0.3312129989 | |||
27 | $26,623 | $40,865 | $41,749 | 4.74 | 4.52 | $126,097 | $5,885 | 0.22 | 5.48 | $14,909 | 0.3157563923 | |||
28 | $31,948 | $46,749 | $48,481 | 4.52 | 4.30 | $144,255 | $6,732 | 0.21 | 5.70 | $17,891 | 0.301021094 | |||
29 | $38,338 | $53,481 | $56,183 | 4.30 | 4.10 | $165,028 | $7,701 | 0.20 | 5.90 | $21,469 | 0.2869734429 | |||
30 | $46,005 | $61,183 | $64,993 | 4.10 | 3.91 | $188,792 | $8,810 | 0.19 | 6.09 | $25,763 | 0.2735813489 | |||
31 | $55,206 | $69,993 | $75,072 | 3.91 | 3.73 | $215,978 | $10,079 | 0.18 | 6.27 | $30,915 | 0.2608142193 | |||
32 | $66,247 | $80,072 | $86,602 | 3.73 | 3.56 | $247,079 | $11,530 | 0.17 | 6.44 | $37,099 | 0.2486428891 | |||
33 | $79,497 | $91,602 | $99,793 | 3.56 | 3.39 | $282,658 | $13,191 | 0.17 | 6.61 | $44,518 | 0.2370395543 | |||
34 | $95,396 | $104,793 | $114,883 | 3.39 | 3.23 | $323,361 | $15,090 | 0.16 | 6.77 | $53,422 | 0.2259777084 | |||
35 | $114,475 | $119,883 | $132,146 | 3.23 | 3.08 | $369,925 | $17,263 | 0.15 | 6.92 | $64,106 | 0.215432082 | |||
36 | $137,371 | $137,146 | $151,895 | 3.08 | 2.94 | $423,195 | $19,749 | 0.14 | 7.06 | $76,928 | 0.2053785848 | |||
37 | $164,845 | $156,895 | $174,488 | 2.94 | 2.80 | $484,135 | $22,593 | 0.14 | 7.20 | $92,313 | 0.1957942509 | |||
38 | $197,814 | $179,488 | $200,335 | 2.80 | 2.67 | $553,850 | $25,846 | 0.13 | 7.33 | $110,776 | 0.1866571858 | |||
39 | $237,376 | $205,335 | $229,903 | 2.67 | 2.54 | $633,604 | $29,568 | 0.12 | 7.46 | $132,931 | 0.1779465172 | |||
40 | $284,852 | $234,903 | $263,729 | 2.54 | 2.43 | $724,843 | $33,826 | 0.12 | 7.57 | $159,517 | 0.1696423464 | |||
41 | $341,822 | $268,729 | $302,426 | 2.43 | 2.31 | $829,221 | $38,697 | 0.11 | 7.69 | $191,420 | 0.1617257035 | |||
42 | $410,186 | $307,426 | $346,695 | 2.31 | 2.20 | $948,629 | $44,269 | 0.11 | 7.80 | $229,704 | 0.154178504 | |||
43 | $492,224 | $351,695 | $397,339 | 2.20 | 2.10 | $1,085,231 | $50,644 | 0.10 | 7.90 | $275,645 | 0.1469835072 | |||
44 | $590,668 | $402,339 | $455,276 | 2.10 | 2.00 | $1,241,504 | $57,937 | 0.10 | 8.00 | $330,774 | 0.1401242768 | |||
45 | $708,802 | $460,276 | $521,556 | 2.00 | 1.91 | $1,420,281 | $66,280 | 0.09 | 8.09 | $396,929 | 0.1335851439 | |||
46 | $850,562 | $526,556 | $597,380 | 1.91 | 1.82 | $1,624,801 | $75,824 | 0.09 | 8.18 | $476,315 | 0.1273511705 | |||
47 | $1,020,675 | $602,380 | $684,123 | 1.82 | 1.74 | $1,858,773 | $86,743 | 0.08 | 8.26 | $571,578 | 0.1214081159 | |||
48 | $1,224,810 | $689,123 | $783,357 | 1.74 | 1.66 | $2,126,436 | $99,234 | 0.08 | 8.34 | $685,893 | 0.1157424038 | |||
49 | $1,469,772 | $788,357 | $896,880 | 1.66 | 1.58 | $2,432,643 | $113,523 | 0.08 | 8.42 | $823,072 | 0.1103410917 | |||
50 | $1,763,726 | $901,880 | $1,026,751 | 1.58 | 1.50 | $2,782,944 | $129,871 | 0.07 | 8.50 | $987,686 | 0.1051918407 | |||
51 | $2,116,471 | $1,031,751 | $1,175,323 | 1.50 | 1.43 | $3,183,687 | $148,572 | 0.07 | 8.57 | $1,185,224 | 0.1002828882 | |||
52 | $2,539,765 | $1,180,323 | $1,345,289 | 1.43 | 1.37 | $3,642,138 | $169,966 | 0.07 | 8.63 | $1,422,269 | 0.09560302004 | |||
53 | $3,047,718 | $1,350,289 | $1,539,731 | 1.37 | 1.30 | $4,166,606 | $194,442 | 0.06 | 8.70 | $1,706,722 | 0.09114154577 | |||
54 | $3,657,262 | $1,544,731 | $1,762,172 | 1.30 | 1.24 | $4,766,598 | $222,441 | 0.06 | 8.76 | $2,048,067 | 0.08688827364 | |||
55 | $4,388,714 | $1,767,172 | $2,016,645 | 1.24 | 1.18 | $5,452,988 | $254,473 | 0.06 | 8.82 | $2,457,680 | 0.08283348753 | |||
56 | $5,266,457 | $2,021,645 | $2,307,762 | 1.18 | 1.13 | $6,238,218 | $291,117 | 0.06 | 8.87 | $2,949,216 | 0.07896792478 | |||
57 | $6,319,749 | $2,312,762 | $2,640,799 | 1.13 | 1.08 | $7,136,521 | $333,038 | 0.05 | 8.92 | $3,539,059 | 0.07528275496 | |||
58 | $7,583,698 | $2,645,799 | $3,021,794 | 1.08 | 1.03 | $8,164,180 | $380,995 | 0.05 | 8.97 | $4,246,871 | 0.07176955973 | |||
59 | $9,100,438 | $3,026,794 | $3,457,653 | 1.03 | 0.98 | $9,339,822 | $435,858 | 0.05 | 9.02 | $5,096,245 | 0.06842031361 | |||
60 | $10,920,526 | $3,462,653 | $3,956,275 | 0.98 | 0.93 | $10,684,757 | $498,622 | 0.05 | 9.07 | $6,115,494 | 0.06522736564 | |||
61 | $13,104,631 | $3,961,275 | $4,526,698 | 0.93 | 0.89 | $12,223,362 | $570,424 | 0.04 | 9.11 | $7,338,593 | 0.06218342191 | |||
62 | $15,725,557 | $4,531,698 | $5,179,263 | 0.89 | 0.85 | $13,983,526 | $652,565 | 0.04 | 9.15 | $8,806,312 | 0.05928152889 | |||
63 | $18,870,669 | $5,184,263 | $5,925,797 | 0.85 | 0.81 | $15,997,154 | $746,534 | 0.04 | 9.19 | $10,567,574 | 0.05651505754 | |||
64 | $22,644,802 | $5,930,797 | $6,779,831 | 0.81 | 0.77 | $18,300,744 | $854,035 | 0.04 | 9.23 | $12,681,089 | 0.05387768819 | |||
65 | $27,173,763 | $6,784,831 | $7,756,847 | 0.77 | 0.73 | $20,936,051 | $977,016 | 0.04 | 9.27 | $15,217,307 | 0.05136339607 | |||
66 | $32,608,515 | $7,761,847 | $8,874,553 | 0.73 | 0.70 | $23,950,842 | $1,117,706 | 0.03 | 9.30 | $18,260,769 | 0.04896643759 | |||
67 | $39,130,218 | $8,879,553 | $10,153,209 | 0.70 | 0.67 | $27,399,764 | $1,278,656 | 0.03 | 9.33 | $21,912,922 | 0.04668133717 | |||
68 | $46,956,262 | $10,158,209 | $11,615,991 | 0.67 | 0.64 | $31,345,330 | $1,462,782 | 0.03 | 9.36 | $26,295,507 | 0.04450287477 | |||
69 | $56,347,514 | $11,620,991 | $13,289,413 | 0.64 | 0.61 | $35,859,057 | $1,673,423 | 0.03 | 9.39 | $31,554,608 | 0.04242607394 | |||
70 | $67,617,017 | $13,294,413 | $15,203,809 | 0.61 | 0.58 | $41,022,761 | $1,914,396 | 0.03 | 9.42 | $37,865,530 | 0.04044619049 | |||
71 | $81,140,421 | $15,208,809 | $17,393,877 | 0.58 | 0.55 | $46,930,039 | $2,190,068 | 0.03 | 9.45 | $45,438,636 | 0.0385587016 | |||
72 | $97,368,505 | $17,398,877 | $19,899,316 | 0.55 | 0.53 | $53,687,965 | $2,505,438 | 0.03 | 9.47 | $54,526,363 | 0.03675929553 | |||
73 | $116,842,206 | $19,904,316 | $22,765,537 | 0.53 | 0.50 | $61,419,032 | $2,866,221 | 0.02 | 9.50 | $65,431,635 | 0.03504386174 | |||
74 | $140,210,647 | $22,770,537 | $26,044,495 | 0.50 | 0.48 | $70,263,372 | $3,278,957 | 0.02 | 9.52 | $78,517,962 | 0.03340848152 | |||
75 | $168,252,776 | $26,049,495 | $29,795,622 | 0.48 | 0.46 | $80,381,298 | $3,751,127 | 0.02 | 9.54 | $94,221,555 | 0.03184941905 | |||
76 | $201,903,332 | $29,800,622 | $34,086,911 | 0.46 | 0.43 | $91,956,205 | $4,291,290 | 0.02 | 9.57 | $113,065,866 | 0.03036311283 | |||
77 | $242,283,998 | $34,091,911 | $38,996,147 | 0.43 | 0.41 | $105,197,898 | $4,909,235 | 0.02 | 9.59 | $135,679,039 | 0.02894616756 | |||
78 | $290,740,797 | $39,001,147 | $44,612,312 | 0.41 | 0.39 | $120,346,395 | $5,616,165 | 0.02 | 9.61 | $162,814,847 | 0.02759534641 | |||
79 | $348,888,957 | $44,617,312 | $51,037,205 | 0.39 | 0.38 | $137,676,276 | $6,424,893 | 0.02 | 9.62 | $195,377,816 | 0.02630756358 | |||
80 | $418,666,748 | $51,042,205 | $58,387,282 | 0.38 | 0.36 | $157,501,660 | $7,350,077 | 0.02 | 9.64 | $234,453,379 | 0.02507987728 | |||
81 | $502,400,098 | $58,392,282 | $66,795,771 | 0.36 | 0.34 | $180,181,899 | $8,408,489 | 0.02 | 9.66 | $281,344,055 | 0.023909483 | |||
82 | $602,880,118 | $66,800,771 | $76,415,082 | 0.34 | 0.33 | $206,128,093 | $9,619,311 | 0.02 | 9.67 | $337,612,866 | 0.02279370713 | |||
83 | $723,456,141 | $76,420,082 | $87,419,573 | 0.33 | 0.31 | $235,810,538 | $11,004,492 | 0.02 | 9.69 | $405,135,439 | 0.0217300008 | |||
84 | $868,147,369 | $87,424,573 | $100,008,712 | 0.31 | 0.30 | $269,767,255 | $12,589,139 | 0.01 | 9.70 | $486,162,527 | 0.02071593409 | |||
85 | $1,041,776,843 | $100,013,712 | $114,410,687 | 0.30 | 0.28 | $308,613,740 | $14,401,975 | 0.01 | 9.72 | $583,395,032 | 0.0197491905 | |||
86 | $1,250,132,212 | $114,415,687 | $130,886,545 | 0.28 | 0.27 | $353,054,119 | $16,475,859 | 0.01 | 9.73 | $700,074,039 | 0.01882756161 | |||
87 | $1,500,158,654 | $130,891,545 | $149,734,928 | 0.27 | 0.26 | $403,893,912 | $18,848,383 | 0.01 | 9.74 | $840,088,846 | 0.01794894207 | |||
88 | $1,800,190,385 | $149,739,928 | $171,297,478 | 0.26 | 0.24 | $462,054,635 | $21,562,550 | 0.01 | 9.76 | $1,008,106,616 | 0.01711132477 | |||
89 | $2,160,228,462 | $171,302,478 | $195,965,034 | 0.24 | 0.23 | $528,590,502 | $24,667,557 | 0.01 | 9.77 | $1,209,727,939 | 0.01631279629 | |||
90 | $2,592,274,154 | $195,970,034 | $224,184,719 | 0.23 | 0.22 | $604,707,535 | $28,219,685 | 0.01 | 9.78 | $1,451,673,526 | 0.01555153246 | |||
91 | $3,110,728,985 | $224,189,719 | $256,468,039 | 0.22 | 0.21 | $691,785,420 | $32,283,320 | 0.01 | 9.79 | $1,742,008,232 | 0.01482579428 | |||
92 | $3,732,874,782 | $256,473,039 | $293,400,157 | 0.21 | 0.20 | $791,402,520 | $36,932,118 | 0.01 | 9.80 | $2,090,409,878 | 0.01413392388 | |||
93 | $4,479,449,739 | $293,405,157 | $335,650,499 | 0.20 | 0.19 | $905,364,483 | $42,250,343 | 0.01 | 9.81 | $2,508,491,854 | 0.01347434076 | |||
94 | $5,375,339,687 | $335,655,499 | $383,984,891 | 0.19 | 0.18 | $1,035,736,969 | $48,334,392 | 0.01 | 9.82 | $3,010,190,224 | 0.01284553819 | |||
95 | $6,450,407,624 | $383,989,891 | $439,279,435 | 0.18 | 0.18 | $1,184,883,092 | $55,294,544 | 0.01 | 9.82 | $3,612,228,269 | 0.01224607975 | |||
96 | $7,740,489,149 | $439,284,435 | $502,536,394 | 0.18 | 0.17 | $1,355,506,258 | $63,256,959 | 0.01 | 9.83 | $4,334,673,923 | 0.01167459602 | |||
97 | $9,288,586,978 | $502,541,394 | $574,902,355 | 0.17 | 0.16 | $1,550,699,159 | $72,365,961 | 0.01 | 9.84 | $5,201,608,708 | 0.01112978154 | |||
98 | $11,146,304,374 | $574,907,355 | $657,689,014 | 0.16 | 0.15 | $1,773,999,837 | $82,786,659 | 0.01 | 9.85 | $6,241,930,450 | 0.01061039174 | |||
99 | $13,375,565,249 | $657,694,014 | $752,396,952 | 0.15 | 0.14 | $2,029,455,814 | $94,707,938 | 0.01 | 9.86 | $7,490,316,539 | 0.01011524012 | |||
100 | $16,050,678,299 | $752,401,952 | $860,742,833 | 0.14 | 0.14 | $2,321,697,451 | $108,345,881 | 0.01 | 9.86 | $8,988,379,847 | 0.009643195584 | |||