 |
Amortization Mortgage Calculator - Simple Fixed Rate Loan
Here you can download free excel file with amortization mortgage calculator providing amortization schedule for a simple loan with fixed annual interest rate and monthly interest payments.
For the accounting purposes you can use this calculator to estimate outstanding liability related to the mortgage loan as of the end of each accounting period and estimate both current portion (payable within a year) and long-term portion (payable after a year) of this liability.
Also you can see how much interest should be paid each accounting period and use this data to accrue for the interest payable when it becomes due.
How to use amortization mortgage calculator?
The file inside includes certain place for the initial data entry, which is:
-
-
-
term of the loan in years
You just need to enter this data and amortization schedule will be provided together with a summary of the total payments related to the loan and total interest amount to be paid through the whole loan term.
Download amortization mortgage calculator 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
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:
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
Leave Amortization Mortgage Calculator and return to Home page
|
|
|
 |
|
| Sign Up For News |
|
 |
| Learning Material |
|
 |
| Explore Today |
|
|
|
| Accounting Software |
|
|
|
