![]() |
| Loans (Photo credit: zingbot) |
Such as annual interest, downpayment, and number of years to pay. This is because a slight change in the interest or any other detail will cause a great effect on your monthly obligations or payments.
For your assistance, I have attached an excel file mortgage calculator. Just download the file and then input the following details:
1. Loan Amount - total amount to loaned
2. Annual interest rate - loan interest
3. Term Length - length of years-to-pay
4. First payment date
5. compound period and payment frequency - in the philippines, it is usually "monthly"
Example below:
My total loan amount is Php1,600,000.00 with interest rate of 4% and to be paid within 25 years.
From the diagram below, we can see that my monthly payment is Php 8,445.39.
This mortgage calculator is very easy-to-use plus it helps us foresee our monthly payments and since it's only in excel you won't need any complicated installation process. Plus you can compute your mortgage payments offline. You won't need to access the internet just to compute. Instead just open the file and enter the details.
To download mortgage calculator. Click here.
To download mortgage calculator. Click here.
P.S.
Don't forget to subscribe here. To get the latest foreclosed listing in Las Pinas!
Don't forget to subscribe here. To get the latest foreclosed listing in Las Pinas!







