How to use this tool
Check the units, enter your values, and run the tool. Results follow the assumptions and method below.
Calculation method
Theoretical months without extra
rate == 0 ? balance/payment : -log(1-balance*(rate/1200)/payment)/log(1+rate/1200)Theoretical months with extra
rate == 0 ? balance/(payment+extra) : -log(1-balance*(rate/1200)/(payment+extra))/log(1+rate/1200)Number of payments with extra
ceil((rate == 0) ? balance/(payment+extra) : -log(1-balance*(rate/1200)/(payment+extra))/log(1+rate/1200))