I'm looking for a tool/spreadsheet that will give me the following information. Inputs: Total loan, # of years/months financed, finance rate. Output: each total monthly payment, $ paid each payment in interest, $ paid each payment in principle. I'd also like to change the variables and recalculate (i.e if I increased my monthly payment by x amount, how many months would it take down to pay the loan or if I financed at x rate, how much would my monthly payments be). I know there are a few sites that do have mortgage and loan estimates with the variables I mentioned, but I'd like something customizable where I can easily see every single payment. thanks.
2007-12-06 09:21:03 · 6 answers · asked by frisco 2 in Business & Finance ➔ Personal Finance
What you are looking for is called an "amortization schedule".
Try this one.
http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html
It looks like you should be able to easily change what your payments are and see how that impacts your loans.
I might have to download this for myself too!
2007-12-06 09:30:07 · answer #1 · answered by Stacia Z 3 · 0⤊ 0⤋
1
2016-09-27 19:48:39 · answer #2 · answered by Geneva 3 · 0⤊ 0⤋
If you use Microsoft Excel, there is a general template called loan amortization. It's quite easy to understand and use. If it doesn't give you all the functionality you want, it gives you a good starting point for modifications.
2007-12-06 10:37:04 · answer #3 · answered by mplsundin 4 · 0⤊ 0⤋
hsh.com free down loads for mortgage loans but will work with any loan type term amount rate etc
2007-12-06 09:25:06 · answer #4 · answered by Anonymous · 0⤊ 0⤋
you are looking for a n "amortization schedule:" and can be found on the web by typing in amortizastion!!!
2007-12-10 04:02:40 · answer #5 · answered by Anonymous · 0⤊ 0⤋
www.bankrate.com/brm/popcalc2.asp
www.mortgage101.com/Calculators/Amortization.asp?p=mtg101
what you want to see is the amortization schedule
2007-12-06 09:30:24 · answer #6 · answered by Anonymous · 0⤊ 0⤋