More than $100 trillion in household wealth is expected to be passed down as part of the Great Wealth Transfer, the largest in U.S. history, according to a new report.