Variable Rate Loan Overpayment Calculator

[Betelgeuse]

I would like to model the impact of ad hoc lump some payments on a variable rate personal loan.

Is anyone aware of any online calculators or Excel sheets etc that would allow me to do this please?

Many thanks.

 

[RedOnion]

Try Karl's mortgage calculator drcalculator.com

But if you want more flexibility, an Excel model is the way to go. Happy to help you with one if you get stuck.

 

[Betelgeuse]

Try Karl's mortgage calculator drcalculator.com

Thank you, this does exactly what I wanted.

For anyone else using it from a non traditional mortgage perspective, I had to change the compound frequency in the loan settings section to match the personal loan product I'm looking at.

Also changed the term to months as opposed to years...