I have a model I developed that is of medium complexity, and I have an interesting problem that I am not sure how to resolve, thought I'd hit you guys up to see if anyone has dealt with this before.
Generally the model is fine, but it is broken on occasion when you change various assumptions (financing case, operating case) - but the break isn't truly a "break". The balance sheet will be off by decimal places, nothing substantial, but enough to flag the error switch. If you screw with the decimal places of generally any number (stub period seems the most easy to play with) the model will balance again. Something weird is going on with the rounding causing the model to unbalance, and I cannot figure out how to rectify it aside from just playing with the decimal places on the stub period every time the model shows an error. Generally this is fine for me, but for others that aren't familiar with it, the issue can cause some confusion.
Thoughts? I'd be happy to send it out if necessary.