Awesome,
I did the calculation by hand using the statements method and it is inline with what I was expecting. I suspect the worksheet is not using zero for the months I didn't own the second place and jacking me over the 750K number, but I didn't bother trying to reverse engineer it.
Is there anyway to force the calculation so I don't have to wait for the update?
Leo
Statements provided by your lender.
If you receive monthly statements showing the closing balance or the average balance for the month, you can use either to figure your average balance for the year. You can treat the balance as zero for any month the mortgage wasn't secured by your qualified home. For each mortgage, figure your average balance by adding your monthly closing or average balances and dividing that total by the number of months the home secured by that mortgage was a qualified home during the year. If your lender can give you your average balance for the year, you can use that amount
