At the start of the year you own 100 shares of a mutual fund in a taxable investment account. At the beginning of the tax year the fund NAV was $59.2 per share, and the end of year NAV is $58.8 per share. At the end of the year, the fund made distributions of $1.2 in qualified dividends, $3.0in short term capital gains, and $2.9 in long term capital gains. If your marginal income tax rate is 23 %, and your marginal capital gains tax rate is 12%, what is the final after-tax value of your holdings in the mutual fund?

Please show all work in Excel

The correct answer is $6,458.60