In my opinion, any formula for calculating this still doesn't make sense, logically we haven't even touched on $1 million, how could it be possible to get a price of $5 million so easily. But dreaming is indeed more beautiful than lamenting reality. LOL
The important thing we can do is to calculate a reasonable target and collect the bitcoins we can.
Yeah, if we speak logically then Bitcoin hasn't even touched $70k, but in predictions we avoid logic and see the things with analytics, and statistics. The Bitcoin has potential to grow much higher in value and we can't ignore that thing but for now it's not anywhere close to even $60k, but surely in future the scarcity principle will work with Bitcoin as well and the value will grow enormously. When the supply is low and the demand is high then the value will also rise, and that's something which is going to take place after each halving event. During each halving event the number of Bitcoin in a block reduces to half and that creates some scarcity and which works to increase the price of an asset. We should also keep that inflation that happens with fiat and that's why Bitcoin can grow much higher in value in future.
Yes, at least speculation can be calculated logically that with time and what kind of process Bitcoin can reach 5 million, perhaps it can be understood, but if it is just expectation it will be like nonsense.
The large demand will definitely make bitcoin very valuable. That is the market mechanism in general regarding goods, we understand that very well, including the scarcity which is the value of bitcoin as the reason people want to own bitcoin.
But have you ever thought that for bitcoin to make a significant movement there must be another trigger as a means for people to become more interested in bitcoin, such as in the previous cycle bitcoin was accepted as a means of payment for purchasing Tesla cars and that triggered a market reaction that caused a spike in prices.