"According to Brand Financee, a brand valuation consultancy, the capital value of the British Monarchy as a business is estimated at an enormous £67.5 billion. In 2017 alone, the annual contribution to the economy was £1.766 billion (Brand Finance)). These huge figures evidently bring a vast sum into the UK economy. This is done through a number of ways."
medium.com/illumination/how-much-money-does-the-royal-family-earn-the-uk-economy-5f41239c8957
Many other financial institutions say similar
That £102 million cost is a drop in the ocean to the billions of money that our Royal Family raise and attract into the country. Let alone the taxes Queen pays herself and amount of people they employ
Brand finance report estimates that the overall uplift of Royal family to the tourism sector is £550m, making the contribution to tourism, including merchandise sales, the largest of the benefits generated by the monarchy.