web analytics

How A Mortgage Amortization Calculator Works

The regular repayments you make on a loan or money owed is what is referred to as amortization. The interest is usually calculated on the outstanding payment. The amount you have not paid generates interest. Mortgages, however generates this amount monthly in most cases. It is therefore important to know how a mortgage amortization calculator works and what amount you will be paying. The mortgage calculator can be a very effective tool.

It is necessary for any informed investor or citizen to know how to create an amortization schedule. This will help you understand what your money is doing toward the repayment. The schedule shows how the repayment is broken down. The time period is in most cases annual.

In preparing this, we need to know he loan amount, the effective interest charged on the loan and the period it will take to clear the loan. We require the annuity. Annuity in this case refers to previously mentioned regular payments. Remember that compounding can be done periodically, that is monthly, quarterly or even biannually.

Mortgage Calculator Explained

Let us break down this calculation for easy understanding. We will calculate the numerator, that is the top part of a fraction, separately then the bottom. The top part is found as explained below.

In most cases, the rate will be given as a percentage. We need to change it into a workable form. We divide the percentage by a hundred. To the result we get, we add one and raise the whole thing to the repayment periods. We multiply by the principle amount or amount of the loan. Raising answer to periods means multiplying it by the number of times the period is.

The denominator is gotten by adding one to given rate and raising to the repayment period. After this, we subtract one on the answer. Next, the numerator is divided by the denominator. The result gives us the regular payments that will be paid for the period stipulated.

After getting all these, you can now create an amortization schedule. You can prepare one with five columns, one labeled end of year, the next for outstanding principle and then payment made. This is the annuity we just calculated. The fourth and fifth are for the interest charged and payment toward principle.

Using an example will make this concept easier to understand. Let us assume that you took a loan worth 50,000 dollars with a rate of 8 percent and repaid over five years. The numerator is calculated as explained. Divide rate by 100 to give us 0.08 and then add it to one to get 1.08. This is then multiplied by itself 5 times and then multiplied by 0.08 and 50,000. The result for the top part gives us 5,877.31.

Next we calculate the bottom part. Add one to the rate then raise it to 5. Subtract one from this result to give you 0.4693. To get the regular payments that will be made, we divide the numerator by the denominator. The result is 12,522.82 required to pay for five years. Calculate the interest at the end of the first year as usual to get 4,000. Payment toward loan repayment is gotten by subtracting 4,000 from the 12,522.82 earlier gotten. We get 8,522.82 and since the interest is calculated on outstanding balance we get this by subtracting 8,522.82 from the principle. Gives us 41,477.18 and do this process again until the final year. A mortgage calculator can be a great way to make these important financial decisions.

Sorry, comments are closed for this post.