using the Loan Calculator template in Excel, I am trying to calculate loan
payments with optional extra payments, over 5 years. However, every time I
input the optional extra payments, Excel shortens the loan term instead of
reducing the monthly payment amount (which is what I want).

Any suggestions?

--
Sue W.