Tutorvo

IRR vs XIRR vs MIRR

Lesson 5 of 820 minLab

This lesson is part of the course

In this lesson

You calculate the café's return three ways: IRR on yearly periods, XIRR on the real dates and a modified IRR that reinvests the cash at a realistic rate.

Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.

Lessons in this course

  1. FV, PV and Excel's Sign ConventionLab15 min Locked
  2. PMT, IPMT, PPMT and an Amortisation TableLab20 min Locked
  3. RATE and NPER: Solve for the Rate and the TermLab15 min Locked
  4. NPV vs XNPV: Discounting Dated Cash FlowsLab20 min Locked
  5. IRR vs XIRR vs MIRRLab20 min Locked
  6. Depreciation: SLN, DB, DDB and SYDLab20 min Locked
  7. EFFECT, NOMINAL and Day-Count BasicsLab15 min Locked
  8. Capstone: Investment Comparison DashboardLab25 min Locked