This handy little Amortization Template is just what you need if you want to calculate payments or payoff amounts on any type of loan. All you need to input is your original purchase price, your interest rate, and the years of the loan. The template will tell you your monthly payment, and for each month of the life of the loan, it will tell you how much of that payment goes to principal, how much goes to interest, and how much is left to still owe. It's great for planning out your investments, loans, mortgages, etc.
You can download it, for free, right now, right here. And if you have any questions, feel free to shoot me an email.
But if you want something with a little more horsepower, why don't you download my free Cost Benefit Analysis template? It does everything the Amortization template will do, and more. There is a free version, and a Pro (i.e., paid) version. Check out the free version right here.