Mortgage Calculator With Amortization - Refinancing Case

Here you can find free download of mortgage calculator with amortization providing refinancing consideration.

The calculator compares initial loan and potential refinancing, providing saving of interest and duration of total loan if it is refinanced in the middle of the period.

Initial data to be entered:

  • initial loan

  • annual interest rate of the initial loan

  • duration of initial loan in years

  • outstanding loan at the moment of refinancing

  • new annual interest rate

  • new duration of the loan in years

All calculations are done assuming that interest is paid on a monthly basis. Important to notice, that the this mortgage calculator with amortization provides only saving on interest. When decision on the refinancing should be made, you should take into account costs related to the refinancing. If there still is a saving, it is worth to consider the possible option.

The results also provide amortization schedules for the initial loan, for the partial payment of the initial loan until refinancing and new amortization schedule after the refinancing.

This calculator can also be used for the accounting purposes, estimating outstanding liabilities if the loan was refinanced.

Download mortgage calculator with 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 With Amortization and return to Home page