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