Wondering if there are other solutions out there or different techniques regarding the “helper”-elements I had to include here, so please come forward 🙂
The goal-value is formulated in a way that it should be zero, as this is what the binary-search procedure is aiming at. In this case it’s the XNPV. Other cases could be Break-Even for example, where the accumulated sales match the accumulated costs. In that case you would write: Result = sales – costs .
Enjoy & stay queryious 🙂