Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/11/IRR.xlsx

In this Microsoft Excel video tutorial I explain how to calculate the internal rate of return using the IRR function. IRR is used when the income is received over evenly spaced time periods such as every year or every month. XIRR is used when you receive income on specific dates over irregular periods.
MIRR is used when you when you want to include a discount rate (finance rate) and an income interest rate.

️Timestamps
00:00 Use IRR when the income is received over regular periods (every month or year)
00:43 Understanding the 'Guess' argument
01:31 Use XIRR when the income is received over irregular periods (specific dates)
02:45 Use MIRR when you want to specify a finance rate and a reinvest rate



#exceltutorial #exceltips