Saturday 23 April 2016

How to build a Mortgage Amortization Table in EXCEL

A mortgage amortization table splits monthly mortgage repayments into two elements, the principal paid and also the interest paid. Amortization details the process of separating mortgage repayments over the duration of the mortgage loan between interest paid and principal payment.

Home loans are usually front-loaded with interest. What this means is at the start of the mortgage you are paying out much more in interest than you are repaying on the original balance. This operates to your benefit at the end of the mortgage loan since the interest is computed on the outstanding balance. The smaller the outstanding balance, the much less you'll pay out in interest.

The mortgage amortization table provides you with a comprehensive picture of the home loan over its whole term. So you can see exactly how payments are applied, what remains when it comes to principle and interest payments as well as the bottom line on the amount of money you're paying to borrow money for your house. Needless to say, a mortgage amortization calculator will certainly cause you to think about shorter term mortgages with reduced rates of interest. Understanding how much money you're ultimately spending to have reduced repayments every month will actually help you think about the smarter long-term alternatives.

Typically with each monthly payment, you only pay back part of the amount of money initially borrowed plus interest on the decreasing balance of the principal. How much your monthly payments are is dependent, in part, on the principal, the rate of interest and the amount of time permitted for repayment. Amortization term is the amount of time necessary to amortize the home loan. The amortization period is the amount of time, generally, twenty-five years which it takes to totally repay a mortgage loan by means of repayment of the initial debt or principal and also the accrued interest.

To create a mortgage amortization table for your home loan use one of the many online amortization schedule calculators available. Amortization schedules can be calculated immediately online at one of these sites. One such site is Yahoo and see also Karl's Mortgage Calculator.

Another option for creating a mortgage amortization table is Microsoft Excel. If you have the program installed on you computer you can download an amortization template from the Microsoft site here.

A mortgage amortization table using Excel will give you a good idea of the monthly payments on a loan or mortgage and how much in interest you will pay over the term of the mortgage. Setting up this in Excel or any other spreadsheet application is quiet easy.

Now you can setup the formulas yourself or you can do what I do and download a simple template for Excel. With a template, it is just a matter of filling in the required information and you get an instant amortization table.  The information you need to hand includes the loan amount, the interest rate and the term of the loan in months.

Another option for creating a mortgage amortization table is Microsoft Excel. If you have the program installed on you computer you can download an amortization template from the Microsoft site here.


Here is a Mortgage Amortization Table for Excel Template you can download free.



If you wish to setup the Mortgage Amortization Table in Excel manually here is a video that will help you get started.



You need to keep in mind that a loan amortization table will only be accurate up to a point. You will need to get a detailed amortization table from your lenders like personalloansny or a major bank.

It is also advisable to get a quotation from a number of banks before taking up any loan offer.