skinny.

Latest / ModeLoop: Financial Modelling in Excel

IRR vs XIRR in Excel: dates, periods and return checks

The return number depends on the cash-flow convention. Decide whether equal periods or actual dates describe the case.

Financial Modelling with AI: Part 3, lesson 9.

In this episode:

- Use IRR for evenly spaced cash flows.

- Use XIRR with the actual cash-flow dates.

- Check annualisation rather than multiplying a quarterly return by four.

Watch the companion video: https://www.youtube.com/watch?v=-rTxCKbiif8

Read the lesson: https://modeloop.net/Blog/P3E9-AI-in-Financial-Modelling-IRR-vs-XIRR-Which-Return-Number-Should-Your-Model-Trust

AI in Financial Modelling course…

Log in to save or queue this episode.

The skinny

The skinny isn't ready yet — notes appear once the transcript is processed.