Estimate what a mutual fund investment may be worth after sales loads and ongoing expenses. The results separate principal, contributions, net return, and fees, then calculate the investment's after-fee annual IRR.
Formula
The gross annual return minus the expense ratio is converted to an equivalent monthly rate:
i = (1 + (return − expenses))^(1/12) − 1. Each contribution is reduced by the front-end load before it enters the fund. At redemption, the deferred charge applies to the lesser of principal or fund value.
Examples
Reference investment
$20,000 initially plus $1,000 monthly for five years, at 5% before a 0.5% expense ratio and a 2% sales load, ends near $90,077. Total contributed principal is $80,000 and net IRR is about 3.844%.
No fees
With the same deposits and return but no loads or expenses, the ending value rises to about $93,339.