How to Compute XMIRR (with VBA-created Formula!)

Despite the arguable superiority of the Modified Investment Rate of Return (MIRR) in analyzing investments or capital budgeting decisions (a topic for a different time), the MIRR formula is the black sheep of the time-value-of-money family… and it would appear that Excel’s development team would agree! While Excel provides timing-sensitive formulas for the IRR and […]