Mortgage Calculator Amortization - Exploring The Options

Here you can find mortgage calculator amortization providing three options of data to be included and giving calculations of payments on a monthly, quarterly or semiannual basis.

You can use these options to compare interest expenses, to calculate monthly and total payments for different repayment schedules.

The calculator also on the separate sheets provides amortization schedules for loans with quarterly and semiannual payment of interest. Just enter the data and get the schedules.

How to use mortgage calculator amortization?

To use the calculator properly, just enter the required data into the cells which are marked with certain color. Do not change any data on other cells. Since there are three possible options of the loan, for each of them you will need to enter:

  • amount of loan

  • annual interest rate

  • loan duration in years

Options are explored on the first sheet of the file. Amortization schedules are provided on the second and third sheets. There you again will need to enter the data about the loan.

Download mortgage calculator amortization 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 Mortgage Calculator Amortization and return to Home page