3. You purchased 500 shares of The New Century Fund at NAV of $23.56 last year. The fund distributed $4.35 in dividends at the end of the year and the current NAV is $21.78. What is the adjusted closing price of your purchase?

4. A front load fund has 5% load and NAV of $19.8. What is the adjusted NAV it will be selling for? Verify your answer by taking 5% of an initial investment of $10,000 to buy the fund at $19.8 NAV.

Please show how to solve in excel