A closed-end funds NAV is $71 at the beginning of the year and $31 at the end of the year. At the beginning of the year the fund was selling at a 2% premium to NAV, at the end of the year it was selling at a 2% discount to NAV. The fund paid year-end distributions of income and capital gains of $1. What is the rate of the return to an investor, who bought the fund at the beginning of the year?

EXCEL PLEASE