Opening Mega Beedrill EX Premium Collection returns about $102.38 in card value against its $405.96 price — roughly $0.25 back per dollar spent. On current prices, you lose money on average by opening it.
See every card and pull rate in XY - Evolutions
How expected value is calculated — card value only, from published pull rates and daily market prices.