Adam Quasde asked:


If you have mortgages and loans you want to keep track it is advisable to calculate it. There are a few ways to do that. Two of these are through the spreadsheet application and the other through the use of loan calculators.

To calculate mortgage loan payments, you have to have the following:

Amount Interest Rate Payment Period

These are the basic needs in computing for your mortgage loan payments. There may be a few additions especially for the online loan calculators so it’s best that you have those as well.

In using spreadsheet application (Microsoft Excel in windows), you make use of the PMT and IPMT functions. The figures that you need to enter here are:

Rate – or the interest rate you have for the loan Per – the period of the payment being computed Nper – number of payment or the terms Pv – the total amount of the series of future payments is worth Fv – the cash value attained after the payment Type – Logical value. 1 = payment at the beginning of the period or 0 = omitted

In using the loan calculators, what you need are the three (3) items stated above. All you have to do is to enter the values and it will do the computing for you. There are other loan calculators that ask for other information such as location this is because there are some states that have additional costs to be added to your loan. Another feature in online loan calculators is the table of payments in breakdown.

This article is all about how to calculate your mortgage payments.



Andrea