It's a little tricky with the way you have to pro-rate the 4 months differently than the 8 months. I would actually enter BOTH the beginning and ending balance as $2,014,065 so that any calculations based on average will be calculated to be $2,014,065 which takes into account the 4 months versus the 8 months and both homes.
