cancel
Showing results for 
Search instead for 
Did you mean: 

An Excel spreadsheet I made to track student loan payoff progress

Regular Contributor

Re: An Excel spreadsheet I made to track student loan payoff progress

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...


Starting Score: EXP 615 | TU 610 | EQ 635
Current Score: EXP 719 (lender pull 10/15) | TU 707 | EQ 700 (lender pull 10/25)
Goal Score: 740
Message 11 of 13
Regular Contributor

Re: An Excel spreadsheet I made to track student loan payoff progress

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.

Message 12 of 13
Highlighted
Regular Contributor

Re: An Excel spreadsheet I made to track student loan payoff progress

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!


Starting Score: EXP 615 | TU 610 | EQ 635
Current Score: EXP 719 (lender pull 10/15) | TU 707 | EQ 700 (lender pull 10/25)
Goal Score: 740
Message 13 of 13