Quickly Calculate Investment Return

If you're given an scenario where you have the present value of an investment and a future value of that investment with not periodic investments for five years, could you figure out a rate of return per year for that investment? There's a common business concept of Compounded Annual Growth Rate (CAGR) and and there's an Excel function called RRI that will help you calculate it