BE A WISE REAL ESTATE INVESTOR
Home » Real Estate Investing » How to calculate for the amortization factor

How to calculate for the amortization factor

In my previous post: How to compute for the monthly amortization payment without a mortgage calculator, Tyrone of Millionaire Acts asked through his comment: “How about if we don’t have access to the amortization factors table? Is there a way to compute it?”. The answer is yes, and I’ll illustrate how to do it through this post.

I got the following amortization factor formula when I reviewed for the November 2007 Real Estate Brokers Licensure Exam under Engineer Enrico Cruz:

Amortization-Factor-Formula

Where:

I = the monthly interest rate. You can easily get this by dividing the annual interest rate by 12

M = the loan payment term in months. Just multiply the loan term by 12.

Let us use the same example in my previous post.

A foreclosed property is being sold for Php 1 Million and you can purchase it with only 20% down payment, with a maximum payment term of 10 years, at an annual interest rate of 12%. What would be the amortization factor you will use to compute for the monthly amortization?

First, let us compute for the Monthly Interest Rate (I) and the Loan payment term in Months (M)

I = Annual Interest rate/12

= 12%/12
= 1%

M = 10 years x 12 months/year

= 120 months

Now we can compute for amortization factor using the formula above. I’ll just substitute the data below:

1%

Amortization Factor = ———————————–

-120

1 – ( 1 + 1% )

0.01

= ———————————–

-120

1 – ( 1+0.01 )

= 0.01434709

As you can see, we arrive at the same value for the amortization factor we used in my previous example. Of course I would only use the formula in excel as I would not want to compute this by hand, it would be very difficult to calculate for a number with a negative exponent like that in the example  right?! 🙂

I would still prefer to keep a copy of the amortization factor table in my wallet so I don’t need to bring my laptop with me everywhere. I can then compute by hand or use the calculator on my cellphone. By the way, I believe there is also a built-in function in excel that can do this calculation but I haven’t tried it yet.

Easy right?!

To our financial freedom!

Jay Castillo
Real Estate Investor
PRC Real Estate Broker License #: 3194

Text by Jay Castillo. Copyright © 2018 | All rights reserved.

P.S. – If you are a new visitor, please start here to learn more about foreclosure investing in the Philippines.

P.P.S – If you feel that anyone else you know might benefit from this post, please do share this to them and don’t forget to subscribe to e-mail alerts and get notified of new listings of bank foreclosed properties, public auction schedules, and real estate investing tips.

Photo of author
About Jay Castillo
People encounter problems and make mistakes when buying foreclosed properties, and Jay wants to help people avoid those problems/ mistakes. Jay encountered a lot of those, which is why he started this blog in 2008 to serve as a guide where he shares lessons learned, and how to overcome challenges you may encounter when investing foreclosed properties in the Philippines … [Read more]
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.
Share

Enrollment now open - How to Buy Foreclosed Properties (that are profitable!) training

00
Months
00
Days
00
Hours
00
Minutes
00
Seconds

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

X
I'm looking for foreclosed properties in...


Looking for an article?
Click here to search the blog
Share