Mortgage comparison XLS?
Simply, payback for the refi is the # of months (essentially) at which the reduced interest cost makes up for the upfront cost of the refi (as refis usually have closing costs). Lots of online calculators get this correct for ONE of my loan options but totally blow the rest by wide margins - when the rate is lower but the refi cost stays more or less the same, the PBP should get narrower but the online calcs are telling me its years out, which cannot be correct.
Yes I can do it manually (and have) but aside from endless google searches can someone put up a link to a good calculator XLS that also allows for comparisons? The best ones I've found are from Vertex24 .