For whatever reason this popped up in my mind, but the director of the 2016 Ghostbusters reboot (which had a similar budget as the D&D movie, around $150 million) made a comment on what that movie had to make at the box office to break even in an article:
With good intentions, he swears.
www.vulture.com
"As opening day approaches, Feig can’t help but think about the stakes of making a $150 million movie. “A movie like this has to at least get to like $500 million worldwide, and that’s probably low,” he says."
$500 million is a lowball estimate for how much a $150 million blockbuster needs to make.
Sony did eventually decide to make another Ghostbusters movie, but Ghostbusters Afterlife was a much lower budget film (only $75 million) and tried making a direct sequel to the original 2 films instead of a remake. Sony also owns the Ghostbusters franchise and stands to make money off of merchandise sales, unlike the D&D movie where only one of the production companies gets merchandise sales.