Calculator Amortization - Determining Loan Duration

Here you can find another calculator amortization, the purpose of which is not just present amortization schedule for the loan, but to estimate duration of the loan based on the regular payments to be paid. Payments include both repayment of principal and interest payments.

This calculator allows to estimate number of years for which the loan will be due. The calculator assumes payments are made on a monthly basis.

How to use calculator amortization?

To use this calculator properly, you will need to enter the following data:

  • amount of the loan

  • annual interest rate

  • monthly payment amount one (this will allow to compare two options - one with bigger monthly payment and another with lower monthly payment)

  • monthly payment amount two

The results to be provided to you will be number of months and years the loan will be due for both options. This calculator will not present amortization schedule. If you want to get that, use the appropriate calculator from the below list.

Download amortization calculator mortgage here

Other Resources

Below you can also find a list of all calculators you can download for free on our site:

Free Excel Calculator 1 - simple fixed rate mortgage

Free Excel Calculator 2 - fixed rate mortgage with extra payment

Free Excel Calculator 3 - comparing the options & amortization for quarterly and semiannual interest payments

Free Excel Calculator 4 - compare annuity & linear payments

Free Excel Calculator 5 - determining loan duration

Free Excel Calculator 6 - exploring refinancing options

Free Excel Calculator 7 - do it yourself in Excel

What to make more calculations? Explore 87 Business & Accounting Forms

Accounting Forms

Download 87 different accounting and business forms helping you to: prepare financial statements / calculate financial ratios / calculate break-even, depreciation, standard cost variances, and much more.

The package includes 5 Groups of different forms in 3 formats (Excel, PDF and filled in PDF). Essential for improving practical accounting knowledge and useful in accounting practice or business management. Important! You can view all the forms online before downloading.

Click here to learn more...


Featured Tutorials & Material Online

Exclusive Members Area - Lifetime Access, No Monthly Fees

Click here to learn more

What Is Inside:

High quality video and printable PDF material on financial accounting combining theory and practice, including:

Seminar Videos (4+ hours)

Two seminars on Bookkeeping Basics and Understanding Financial Statements. Together with videos you get access to PDF printouts of the videos and 50 questions exams to test your understanding.

Self-Study Materials (PDF)

1,500+ pages of PDF files organized by topic. Includes explanations, quizzes, cheat sheet, Q&A, and more:

  • More than 32 topics explained - 500 pages of crystal-clear explanations are included, each with easy-to-understand examples and illustrations.

  • Puzzles - 50+ crossword puzzles, 50+ word searches, and 30 word scrambles.

  • Cheat sheet - a "cheat sheet" of terminology, formulas, ratios, and more.

  • Dictionary - over 1,000 accounting terms defined.

  • Q & A - includes 600 questions and answers taken from the AccountingCoach Blog during 2006–2010.

Online Exams

1,660 interactive exam questions with answers, including Bookeeping Proficiency, Financial Accounting, Managerial and Cost Accounting, Financial Ratios and Video Seminars exams.

87 Business Forms

Professional business forms in Excel and PDF format, including filled in examples for better application.

Click here to learn more


What Next?

Subscribe to our RSS feed

Bookmark and Share


Leave Calculator Amortization and return to Home page