Self-managed super funds: what happens upon death and what is the ideal setup?

When we setup our retirement plan, we rarely pay enough attention to the complications we can leave behind and how to optimise our death proceeds.