How do I solve 3 and 4 of this problem using Excel? The correct answers are "15.59%" and "58.19%", but I don't know how to get them. I would specifically like to see how the IRR function in excel can be applied. Thanks!

You've uncovered the following per-share information about a certain mutual fund: . On the basis of this information, find the fund's holding period returns for 2017 , 2018, and 2019. (In all three cases, assume you buy the fund at the beginning of the year and sell it at the end of each year and none of the dividends and capital distributions are reinvested into the fund.) In addition, find the fund's average annual compound rate of return over the three-year period, 2017-2019. What would 2018 holding period return have been if the investor had initially bought 500 shares of the fund and reinvested both dividends and capital gains distrions ad shares of the fund at an average price of $52.00 per share? 1. The fund's HPR for 2017 is 1. (Round to two decimal places.) 2. The fund's HPR for 2018 is \%. (Round to two decimal places.) 3. The fund's HPR for 2019 is 2.19%. (Round to two decimal places.) 4. The fund's average annual compound rate of return over the three-year period, 2017-2019 is (Round to two decimal places.) 5. If the investor had initially bought 500 shares of the fund and reinvested both dividends and capital gains distributions into additional shares of the fund at an average price of $52.00 per share, the holding period return is o. (Round to two decimal places.)