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:
1. Amount
2. Interest Rate
3. 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.
by Leina Moray
No comments:
Post a Comment