Excel Magic Trick 510 Amortization Table That Changes When Year Input Is Changed

Hi

Exellent tutorial.

How can i have a formula within this table to calculate additional payments

e.g

I have borrowed 100,000 over 30 years interest 5.9%

I occasionally make extra payments every month (not fixed payment, basically make a payment of however much i can afford that month).

Thank you

cool

thank you

so each time i make an extra payment that month my number of years i have taken the loan out for reduces (because of the extra payments) and also my interest i would have paid over the 30 years also reduces.

How can i set up a formula so that i can track each time i make an extra payment, i want to be able to see exactly how much my total interest would be and exactly when my loan will finish.