Making XIRR() Work with Starting Values of Zero
The XIRR function in Excel doesn't work if the first value is a zero. How can we build a model that is flexible enough to account for values where there's a string of zeroes before the cash flows kick in? It's not hard if you know your way around an OFFSET function, and you remember that a number plus zero is the original number. Watch and enjoy...
---
Like this? Want more?
Sign up for our live Excel modeling training class here:
https://www.kahrrealestate.com/produc...
Sign up for our self-paced Case Study course here:
https://kahrrealestate.thinkific.com/...