What you’ll learn
You can copy the code easily, but you can also learn how MIRRs work.
Just like with financial models, VBA formulas can be tough to perfect. For this XMIRR formula, we also made a manual calculation as something of a mathematical “proof”, and a check to confirm the accuracy of our function.
If you follow along with the Youtube video or the post, you’ll see the mechanics of how the MIRR formula works, and the VBA will be a lot easier to understand and replicate for other functions if you ever decide to go that route.