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…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.