Date BTC_Price Weekly$Amt $Invst/Yr RunTotal$Invst BTC/Yr TotalBTC Total$Value
1/14/25 $59,999.40 $10.00 $520.00 $520.00 0.00900009 0.00900009 $540.00
1/14/26 $64,799.35 $12.00 $624.00 $1,144.00 0.01000010 0.01900019 $1,231.20
1/14/27 $69,983.30 $14.40 $748.80 $1,892.80 0.01111122 0.03011141 $2,107.30
1/15/28 $75,581.96 $17.28 $898.56 $2,791.36 0.01234580 0.04245721 $3,209.00
1/14/29 $81,628.52 $20.74 $1,078.27 $3,869.63 0.01371756 0.05617477 $4,585.46
1/14/30 $88,158.80 $24.88 $1,293.93 $5,163.56 0.01524173 0.07141650 $6,295.99
1/14/31 $95,211.51 $29.86 $1,552.71 $6,716.27 0.01693526 0.08835176 $8,412.10
1/15/32 $102,828.43 $35.83 $1,863.25 $8,579.52 0.01881695 0.10716871 $11,019.99
1/14/33 $111,054.70 $43.00 $2,235.90 $10,815.43 0.02090772 0.12807644 $14,223.49
1/14/34 $119,939.08 $51.60 $2,683.09 $13,498.51 0.02323081 0.15130724 $18,147.65
You can see that the first year or two don't really do anything, but the longer that you are in, the more that the value starts to compound upon itself, and even though over 10 years, we a bit more than a doubling in the price of BTC from $55k to $120k, we end up getting quite a bit of appreciation in our value since we would have had invested nearly $13.5k, yet the value of our holdings would be close to $18.2k.. and of course, we can play around with these kinds of numbers to try to figure out if there might be more aggressive or less aggressive investment scenarios but also we can make assessments if we consider the BTC price to go up a lot in value or a little bit in value, and we could have steady anticipated appreciation or maybe we might assume some years to be up and some to be down, yet we might ask ourselves for the purposes of projecting out future BTC price fluctuations does it help us to predict with a lot of granularity or might we be better served by keeping our projection more general and then just adjust it each year after it has played out?
In my understanding of this your table I see that the investment on DCA per week in the first year of the table was $10 per week composing to $520 per year because there are 52 weeks per year with the value of btc at $59k per btc. And the second year DCA method change from 10 to $12 per week at the value of $64k consecutively till the 10 years interval of $119k approximately $120k all is base on absumbtion. But I Think it would have been better for someone to invest higher when the value is low than waiting for the price to high before increasing the weekly DCA. For example according to the table at first year when btc was $59k, weekly DCA was $10. At second year when btc was $64k the DCA was 12, 14 17 to $51consecutively for the 10years interval. don't you think if this DCA was turned upside down, that more profit would be made? Just like DCAing $51 from the first year and going down to $10 in the 10th year. Because of someone can have a purchasing power of $51 dollar when btc is $120k per btc, I don't see any reason why such could not be done now it is bearly half of the value. I am just sudjesting not actually analysing, but want to also hear from you @JJG what do you think? Is it a wise investment approach?