12-26-2012 08:22 PM
I have a question about amortization and the payment chart that Travis84 made.
If the payments in the early stages of paying off a loan pay more of the interest, would it make more sense to pay a higher amount at the beginning to aggressively tackle the interest? Then you could pay a lower amount once you are into more of the principal amount.
But the spreadsheet Travis84 made has the higher payments at the end...
I am just learning about amortization...
12-27-2012 03:24 PM
I will agree with you that the ideal way to pay off a loan is to pay as much as possible. Paying more in the early stages of a loan, will reduce the total interest paid. The reason I set the loan up that way is because the assumption is fresh out of college, you don't make as much, and can expect to get pay raises as you advance in your career. I also had it set up so my payment jumps 100.00 when my car is paid off, since I will have more money to put towards the loan.
I also saw a few recent request for this doccument. I don't know what happened to it. I don't have it on my computer to reupload either. My plan was very consertative, and I've been agressive with payments, so I am a bit more than 2 years ahead of my schedule, so I stopped using the spreadsheet about a year ago. With a bit of work in excel, anybody can use the pictures as a template to make a sheet customized to them.
12-27-2012 04:32 PM
Ahh that makes sense. I have seen student loan repayment plans that are graduated that way as well.
Best of luck to you Travis84 and thanks so much for sharing the good spreadsheet!
IMPORTANT INFORMATION: All FICO® Score products made available on myFICO.com include a FICO® Score 8, along with additional FICO® Score versions based on Experian or Equifax data (additional FICO® Score versions based on TransUnion data are not currently available on myFICO.com). Your lender or insurer may use a different FICO® Score than the versions you receive from myFICO, or another type of credit score altogether. Learn more
FICO, myFICO, Score Watch, The score lenders use, and The Score That Matters are trademarks or registered trademarks of Fair Isaac Corporation. Equifax Credit Report is a trademark of Equifax, Inc. and its affiliated companies. Many factors affect your FICO Score and the interest rates you may receive. Fair Isaac is not a credit repair organization as defined under federal or state law, including the Credit Repair Organizations Act. Fair Isaac does not provide "credit repair" services or advice or assistance regarding "rebuilding" or "improving" your credit record, credit history or credit rating. FTC's website on credit.