It is different from general loan payoff. I just found out that I haven't created a loan template that will simulate a loan with possibility of paying the loan off after specific period. In this site, you can find several loan spreadsheets that should help you evaluating your financial situation when you plan to purchase a new house or vehicles.