We have built a very detailed RE Development financial model and in our returns section, we can seem to the sum of the different variable by asset type to equal the total of the parts of the same variable. It is driving us mad! We're off by 0.40 and 0.70. We have used the ROUND function to see if that would allow us to get the value to equal each other. But no luck. ANY HELP, PLEASE.
We are using INDEX(MATCH ...) to get the values based on the terminal date.
The model is too big to load here so I need some direction on how to get you the example.
Bookmarks