## Loan Comparison/Refinancing CalculatorThis calculator allows you to do some interesting comparison of loans. You can compare loans with different balances, rates and payments and see how much interest you save as the loan progresses. This is good for comparing loans for a refinance to see how long it will take to recoup closing costs. For each loan I also have payment buttons that will calculate the standard 30 and 15 year payments for any loan. For an existing loan first put your original loan amount and rate in the first two fiedlds for loan #1, and then hit which term you specified in your original loan. You can then go back and change the balance to your current balance or any amount you want. To compare the two loans I also highlight which column makes you the most money, either refinancing and compounding your monthly savings (ATCCS), or not refinancing and takeing the closing costs and investing those (CCC). The point when ATCCS surpasses CCC is the point at which the refinancing starts saving you real money. |

LegendCCS = Compounded Cumulative Savings ATCCS = After-Tax Compounded Cumulative Savings CCC = Compounded Closing Costs | ||||||||

Month | Balance #1 | Interest #1 | Balance #2 | Interest #2 | Int. Diff. | CCS | ATCCS | CCC |
---|