Historic asset axed to provide ‘value for money’ as new report outlines the finances of the Royal Family over the past year