skinny.

Latest / ModeLoop: Financial Modelling in Excel

IRR vs XIRR vs NPV in Excel: Investment Return Calculations (P2E10)

NPV, IRR and XIRR are the Excel functions behind every investment return calculation, from DCF valuation and LBO equity returns to solar and wind project finance. This lecture shows how each works, when to use which, and the mistakes that silently break financial models.

In this episode:

The number one NPV mistake: the Period 0 cash flow

IRR: how it works and when it breaks down

Why XIRR, not IRR, is right for real transactions with irregular dates

Use cases: LBO equity IRR, project finance, DCF, capital budgeting

#NUM! errors, multiple IRRs and the reinvestment assumption

📖 Full blog post…

Log in to save or queue this episode.

The skinny

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