How To Compute For Principal And Interest In Monthly Amortization Payments

Knowing your monthly amortization payments is a very crucial factor in knowing whether you will earn passive income from your real estate investment or not.

In a nutshell, your monthly rentals should be greater than your monthly amortization payments and all other expenses for you to have positive cash flow and passive income.

Many people know what amortization is, but there are also many who hear about it all the time, but donโ€™t really understand it, and are too shy to ask, what is amortization?

What is amortization?

In simple terms, amortization is the amount a borrower pays monthly to pay off his debt to a lender. The amount loaned is called the principal while the payment to the lender for the use of his money is called interest. ย The monthly amortization is a constant amount which is composed of payments for both interest and principal.

How is interest computed?You need to know your monthly amortization payments to determine your monthly cashflow

The interest is computed based on the diminishing balance of the principal loan amount. Diminishing balance means that the principal loan amount becomes smaller each time a portion of the principal is repaid.

How is the amortization divided between principal and interest?

Since the interest on the loan is usually on the diminishing loan balance, and the amortization amount is constant, a bigger portion of the amortization goes to interest compared to the principal during the early part of the loan term because the loan balance is still big at that time.

There may be times during the early years of the loan term that you may think that you have been paying for so many years already but when you look at the loan balance, only a small portion of the principal has been paid.

In contrast, during the latter part of the loan term, a bigger portion of the amortization will be going to the principal since the interest will be lower due to the already diminished loan balance.

How is the monthly amortization computed?

The formula for monthly amortization is:

Monthly amortizationย =ย Principal xย Amortization factor

For example, you want to buy a property priced at Php 1 Million. The downpayment is 20%, and the payment term is 20 years at an annual interest rate of 11.5%. What would be the monthly amortization you need to pay?

First, determine the Principal amount. Since the selling price is Php1,000,000 and the downpayment is 20% or Php200,000, the loan amount would be:

=Php1,000,000 โ€“ Php200,000

=Php800,000

Next, get the amortization factor. In the example, the payment term is 20 years and theย annual interest rate is 11.5%. The amortization factor, based on the corresponding Amortization Factor Table, is 0.0106642963.

*Check our complete list of amortization factors through this link:ย Amortization Factor Rates

Since you know the principal amount and the amortization factor, you can now compute the monthly amortization payment:

Monthly amortization = Php800,000 xย 0.0106642963

= Php8,531.43704

How is the amortization factor computed?

If you donโ€™t have internet access and you have a calculator, or you simply want to calculate manually, the formula is as follows:

Amortization factor=I/(1-(1+I)^-M)

where:

I = the monthly interest rate or annual interest rate divided by 12
M = the loan payment term in months

Source: Engineer Enrico Cruz of Urban Institute

Is there an easier way?

Of course, we all want the easier way! You will probably just use the above formula if you intentionally want to shake your brain.

The easiest way to get the amortization amount is to use an amortization or mortgage calculator. We have one here and you can find it on the following page:ย https://www.foreclosurephilippines.com/mortgagecalculator, or you can see it below (Jay embedded it in this page). Just plug in the following data:

  • The Selling Price , Loan balance or Principal amount.
  • The down payment, if any.
  • The payment term or how long you intend to pay the loan
  • The annual interest rate of the loan. You get this from the bank where you intend to buy the property or the bank where you intend to get financing.

Note: We are working with a wordpress plugin developer to develop our very own mortgage calculator with all the features we believe are essential. Something to look forward to… ๐Ÿ™‚

Update as of February 19, 2014: Jay just created his own mortgage calculator and you can access it from the link above, or you can see it in action below.

How can we compute which part of the amortization goes to the principal and which part goes to the interest?

Knowing how much of each monthly amortization goes to the principal and how much goes to the interest will make you want to finish paying your debt faster.

Basically, you just compute the monthly interest by multiplying the monthly interest rate by the diminishing loan balance. The monthly interest rate is derived by dividing the annual interest rate by 12 months.

Then, subtract the monthly interest from the monthly amortization to get the amount that is applied to the principal.

The amount that is applied to the principal each month is deducted from the principal balance (naturally) so the principal goes down by a certain amount every month.

To see the portion of the amortization which goes to the principal and interest, as well as the diminishing balance of the loan, you can make an amortization table using a simple excel file which will have rows starting at Month 0 and columns with the following headings:

Month

Monthly Amortization = Amortization factor x Beginning Balance at Month Zero

Interest = Previous Balance x Monthly Interest

Principal = Monthly Amortization – Interest

Balance= Previous Balance – Principal

Just input the formula to get the values, or you can download a sample excel sheet below:

Hope this helps.

~~~

Cherry Vi M. Saldua-Castillo

Real Estate Broker, Lawyer, and CPA
PRC Real Estate Broker License No. 3187
PRCย CPA Licenseย No. 0102054
Roll of Attorneys No. 55239

Text by Jay Castillo and Cherry Castillo. Copyright ยฉ 2008 โ€“ 2013 All rights reserved.

Full disclosure:ย Nothing to disclose.

PS. My husband Jay said he will create a sample amortization table to illustrate what I have written above, when he’s not too busy answering inquiries. Please watch for it!

Image courtesy:ย of renjith krishnanย /ย FreeDigitalPhotos

FREE CHECKLIST: IDENTIFY AND AVOID PROBLEMATIC FORECLOSED PROPERTIES BY DOING PROPER DUE DILIGENCE!
Avoid losing money, wasted time and effort caused by buying foreclosed properties that have too many problems, with our free 60-item Property Due Diligence Checklist. Grab your free copy now.
GET FREE CHECKLIST

8 thoughts on “How To Compute For Principal And Interest In Monthly Amortization Payments”

  1. I would like to understand when amort is applied on bonds and that bond is traded in secondary market. will the notional traded be after applying the factor or without factor applied. i am a bit confused when it comes to trading of an amort bonds. can you please explain.

  2. How can you get total interest paid? Given 5 years term, principal, amortization factor and annual interest

  3. Hi,
    In the US, they allow mortgage borrowers to pay additional amount directly to the principal aside from paying the monthly amortization. Do banks in the philippines allow this too if the borrower has extra funds to send in?

    1. Hi Cookie, yes, most banks do, but there are minimum payments that must be reached for excess payments to be credited directly to the principal. For example, BPI Family Savings Bank requires at least 6 months worth of excess payments.

      1. Can you please also teach us how to recompute remaining number of years to pay when advance payments on principal is made? Also, is it possible that monthly amortization be decreased instead while maintaining the original loan term/period?

  4. This is very helpful in computing the monthly amortization. But I wish you could add some plug-in that created a table that you mentioned above which tell us how much is the principal and interest amount on a monthly payment. These will really give as the actual knowledge where our amortization went when we started a loan and how we can speed-up the payment.

    1. Hi Alfred, yes, as mentioned in the blogpost, I will be deploying a customized plugin for this. We already deployed amortization calculators before that also generate amortization tables, but I decided to remove them because they either got messy formatting, they load slowly, they are incomplete, or they are simply inserting external links covertly (this is the danger with some free plugins out there). We are investing in a premium and custom plugin which we believe has all the features we need, which we will share with all our readers. Thanks for the comment, cheers!

Leave a Comment

Your email address will not be published. Required fields are marked *

Did you miss buying a foreclosed property because it was too late when you saw the listing/ auction schedule?

Here's the solution...

DON'T BE THE LAST TO KNOW!

GET UPDATES FOR FORECLOSED PROPERTIES VIA EMAIL

Join over 100,000 smart real estate investors who receive

updated foreclosed property listings, auction schedules,

and real estate investing tips via email, it's free!

No thanks / Already subscribed
x
We take privacy seriously and we'll never spam you.
Please refer to our Privacy Policy

Scroll to Top