B
Bob April
Guest
I'm about halfway through a 15-year, fixed-rate mortgage. I have an amortization schedule from when the loan was originated. I would like to see how irregular prepayments to principal affect the amortization going forward. About $200 of my monthly payment goes to interest right now, and declines slightly by month. If I pay down the principal by, say, 5 thousand, how much of my future payments will then get divided between principal and interest? A spreadsheet would be great, if anyone has one.