Improving Construction S-Curves

Construction delays are one of the most common risks encountered in project finance or real estate finance, yet if you wanted to apply a scenario analysis to construction delays, you’d have to create a separate schedule for each case that changed the number of months involved. We’re going to show you a better way to […]

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 […]