Tuesday, July 19, 2005

The Math Behind Loans

The other day, JLP at All Things Financial put up a post demonstrating how to calculate the present value of an annuity. In it, he demonstrated how you can use the present value formula to calculate how much you’d need to invest today at a given rate of interest in order to generate a fixed income for a number of periods.

I’d like to piggy-back on JLP’s post and show you another application where you can use this concept: to make a number of loan calculations. Once people find out I’m a finance professor, I often get questions about their mortgages. Here’s a somewhat lengthy example that shows how to use the present value of an annuity formula to do some calculations related to amortized loans (like mortgages). The following example demonstrates how to use the formula to calculate loan payments, how to calculate what the loan balance will be at any point in time, and also how to figure out how much of a given year’s payments goes towards principal and how much towards interest. It’s a bit involved, but it does work through all the basic calculations.

First, here are a few basic concepts that you need to know to go before you go further

  • On an amortized loan, payments are applied to both principal and interest (first towards interest and then principal).
  • The balance on an amortized loan goes down over time. In fact, the term “amortized” comes from the Latin word for death (i.e. the loan balance “dies off” over time).
  • The outstanding balance of an amortized loan at any point in time will be the Present Value of the remaining payments on the loan.

So, without further ado, let's look at a simple example that I give to students in my introductory finance class:

Assume you take out a $200,000 mortgage with a 30-year term, monthly payments, and an annual interest rate of 6%. (1) What’s the monthly payment on the loan? (2) What will the outstanding balance on the loan be in a year’s time (i.e. after you’ve made 12 payments)? (3) How much of your total payments in the first year will go towards principal (i.e. reduction of the loan balance), and (4) how much towards interest?

1) Calculating the monthly payment on the loan:

To calculate the monthly payment, you first must calculate the “Present Value of an Annuity” factor. The formula for this factor is

PV factor = 1/r – (1/r) x [1/(1+r)] ^ n

= (1/0.005) – (1/0.005) x (1/1.005)^360 = 166.7916.

NOTE: in the notation abve, “r” is the interest rate per month (since it’s a monthly loan), “n” is the number of periods covered by the loan (360 in this case, since it’s a 30-year loan and it’s paid monthly) and the “^n” means “raised to the nth power”.

When calculating a loan payment, you divide the present value factor into the $200,000 initial balance on the loan. This give us a payment of 200,000/166.7916 = $1,190.10 per month.

Note: this is for principal and interest only. Your actual payment may also include property taxes, insurance, and PMI, but those are separate from the “basic” payment on the loan.

2) Calculating the the outstanding balance on the loan be in one year’s time:

The loan balance after one year will be the present value of the remaining 348 payments (29 years times 12 months) of $1,190.10 that are still owed on the loan as of the end of the first year. To calculate this present value, first calculate the Present Value Factor using the formula from the previous section. However, after a year has goen by, “n” would be 348 instead of 360 (after a year's time, there are only 348 months remaining on the loan):

PV factor = (1/0.005) – (1/0.005) x (1/1.005)^348

= 164.7438

In step 1, we calculated the payment based on the outstanding balance. In that step, we divided the factor into the outstanding balance of $200,000 to get the monthly payment. Now, we’re going the opposite way – we know the payment, and we want to determine the outstanding balance. So, in this case we multiply the payment of $1,190.10 by the new present value factor to get an outstanding balance of 1,190.10 x 164.7438 = $197,543.98.

Note: after two years have gone by, the calculation would be based on “n” being 336 (28 years times 12 months per year). After two years in the mortgage, the present value factor would be 162.5688, and the outstanding balance would be $194,935.47.

3) Calculating how much of the total payments in the first year goes towards principal:

We began the first year with a balance of $200,000 on the loan and ended it with a balance of $197,543.98. The difference between these two numbers ($200,000 - $197,543.98) is the amount we paid towards principal during the first year. In other words, we paid off $2,456.02.

This might not seem like you've paid off a big chunk of the loan. After all, you pay almost $1200 per month, so paying off only $2,456 in a year’s time seems like a rip-off, right? Keep in mind that you’ve borrowed $200,000, and the interest on the loan is 0.5% per month (i.e. 6% per year, divided by 12). So, the interest owed on the loan in the first month is $1,000. This means that in the first month of the loan, since you paid “only” $1,199.10, the first $1,000 goes towards paying the interest on the $200,000, leaving $199.10 to go towards paying down the loan. In the second month of the loan, the amount of the payment going towards principal is a tiny bit more than $199.10, since your outstanding balance is a bit less than $200,000 (remember, you paid down the loan by $199.10 in the first month). So, looked at it this way, the $2,456 paid off in the first year doesn’t seem too far off the mark. It’s a bit more than the $199.10 you paid off in the first month times 12.

4) Calculating how much of the total payments in the first year goes towards interest:

To calculate the amount of interest paid in the first year, remember that all payments on an amortized loan go towards a combination of principal and interest. In the first year, you made total payments of $1,199.10 per month times 12 months, or $14,389.20. In Step 3, you calculated that the loan balance went down by $2,456.02 over the course of the year. So, of the $14,389.20 that you paid, $2,456.02 went towards principal repayment. This means that the remainder of $14,389.20 -$2,456.02= $11,933.18 went towards interest.

Just as a “seat of the pants” check to make sure that this is a reasonable figure, take the annual interest rate of 6% and multiply it times the initial balance of $200,000, and you’d get $12,000. The total interest paid over the first year’s time is actually a bit less than $12,000 because each payment decreases the outstanding balance a bit (remember – it’s an “amortized” loan, so the balance “dies off” over time). Therefore, since the interest owed each month is based on the outstanding balance, it goes down a bit each month, and the amount paid towards principal goes up.

So there you have it. Of course, most people don’t make loan calculations by hand – you’d use either a financial calculator or spreadsheet to do the calculations. But now (hopefully), you can see what goes on “behind the scenes) in a loan.

In a future post, I’ll show how to use the built-in functions of a spreadsheet like Microsoft Excel to do the same calculations in a much more efficient fashion.

47 comments:

Anonymous said...

Wow, this article is pleasant, my younger sister is analyzing such things, therefore I am going
to let know her.

Check out my web-site http://pornharvest.Com/index.php?m=2517678

Unknown said...

Hi guys, I really enjoyed your blog it was quite inspirational, keep posting! onlinepayloans

Unknown said...

It’s amazing in support of me to truly have a web site that is valuable meant for my knowledge. online loans

Unknown said...

In actual fact the blogging is spreading its wings fast. Your write up is the best example of it. pay day loans

Unknown said...


Are you looking for Finance?Are you looking for a Loan to enlarge your business? I think you have come to the right place, We offer Loans at low interest rate, Interested people should please visit at: www.omj.cahome financing

Unknown said...


شركة تنظيف منازل بجدة
شركة تنظيف خزانات بجدة
شركة تنظيف شقق بجدة
شركة كشف تسربات بجدة
شركة مكافحة حشرات بجدة
شركة رش مبيدات بجدة
شركة تنظيف منازل بمكة
شركة تنظيف خزانات بمكة
شركة مكافحة حشرات بمكة
شركة تنظيف شقق بالدمام
شركة تنظيف منازل بالدمام
شركة تنظيف خزانات بالدمام
شركة تنظيف كشف تسربات بالدمام
شركة نقل اثاث بمكة

Unknown said...


How mortgage loan rates are determined and what causes them to move is an absolute mystery to most folks - and those who think they know are usually wrong. As a former mortgage banker. I can tell you that a lot of people in the mortgage industry can't even give you an accurate answer to that question.
mortgage loans

Unknown said...

Hello, this is fastidious post I actually loved reading this.fha loan

donnajacob said...

I have been really impressed by going through this awesome blog. life insurance quotes

Unknown said...


Thank you so much... i didn’t have the knowledge in this now i get an idea about this.. thks a lot:-) credit card swipe for cash at low interest.

Unknown said...

Thanks for posting this math behind the loans and giving a such a simple explanation Loan Calculator

Unknown said...

I like your site and content. thanks for sharing the information keep updating, looking forward for more posts. Thanks no credit check loans

Gennie said...

It's a very helpful article,.
Thanks for the share,.
customer payments

steward said...

Thanks for this nice and informative post,.
Auto Loan Calculator

Unknown said...

I really love your write-ups guys continue the good work.

Loan

Unknown said...

Read your post and its really informative and keep updating with newer post on mortgage loan

Unknown said...

Read your blog its really informative and helpful keep updating with newer post on Home loan interest rates Housing loan interest

Unknown said...

Great blog, this could be the best blog I ever visited this month. Never stop to write something useful dude!.
Pawn My Handbag
Loan Against My Watch

Unknown said...

The blog is good enough, keep up writing such type of posts.
comfortsolutionstc.com

Unknown said...

This text may be value everyone’s attention. How will I learn more?
credit glory inquiry removal

charles said...

You have done in fact wonderful work by make such a great blog keep up the good work.
need a home equity loan with poor credit

Jack Reacher said...

For a change, the logic behind availing loans is mainly to deal with the financial uncertainties. Depending on the need and specific situation, one can apply for the loans with distinct ease. Big Loans are one such alternative, which in all likelihood will help you to sort out the large expenses.

Unknown said...

It’s really such nice information to get advantage from.
www.loansingapore.sg/moneylender

Unknown said...

congratulations guys, quality information you have given!!!
her latest blog

Unknown said...

Hello,

Have you been struggling financially? Have you been trying to get a loan at low rate? Do you need the help of a private lender to help you get loan? Do you need loan to finance your estate or refinance your mortgage? Have you been planning to start a new business or expand an existing one? Are you a student that have been thinking hard for where you can get a student loan? We also render auto loan to trucking companies and truck drivers. Our services are also reachable to those who are business men and women. We offer all kinds of loan and we make it easy to transfer no matter the amount you need and your location. We offer all these loan services at a very cheap rate of 3%. Do not be afraid to apply because we offer loan in all currencies. We are reachable at (rogerscapitals@gmail.com)

If you are interested in the loan, you are to fill the following details to start the loan process.
Borrower's Information.
1. Full Names :...................
2. Address :...................
3. State :...................
4. Country :...................
5. Telephone :...................
6. Gender :...................
7. Marital Status :...................
8. Occupation :...................
9. Monthly Income :...................
10. Loan Amount Needed :...................
11. Loan Duration :...................
12. Loan Purpose :...................
13. Have you applied before? :...................

You are expected to apply with the correct details so that we will send you the loan terms and conditions.

Regards,
Rogers.

Dr Purva Pius said...

DO YOU NEED FINANCIAL ASSISTANCE? Contact PCM FINANCE GROUP! for any kind of financial needs! Are you an investor, business minded, worker, student or do you need startup funds? We offer low interest rate (3%) annual, 1 to 25 years duration and easy access of loan funds within 24 to 48 hours. Minimum amount $10,000.00 to $100,000,000.00 maximum (USD, EUR, GBP). E-mail {urgentloan22@gmail.com}We Offer Loan At A Very Low Rate Of 3%. If Interested, Kindly Contact Us Now.email us now reply to email {urgentloan22@gmail.com}

Unknown said...

I am confident you've got a great enthusiast following there.
moneylender review

Helpadya said...

Hey your blog is very nice, such useful information you are sharing. I really like your blog the information is very accurate and if you want to know more about free ad posting service,www.helpadya.com there is another website with best information.

Unknown said...

Useful post about calculation..... Great!
Mortgage loans in Coimbatore

Unknown said...

Your way to enlighten everything on this blog is actually pleasant, everyone manage to efficiently be familiar with it, Thanks a great deal.
Blogger resource

Unknown said...

Dear Sir/Ma

I am Lauren Barghols an international loan agent, I want to officially inform you and or your company that we collaborate with highly reputable international banks to provide any kind of Loan (Bank Instrument) and most importantly CASH LOANs from One Million United States Dollars to Ten Billion United States Dollars and above at a very reasonable interest rate to all interested individuals and or companies both in Asia, Europe, America and Africa.

Only interested companies and or individuals who are willing to abide by our terms and conditions to securing this loans are expected to respond via our below alternative email address for our own security purpose and we hope you understand. Email: bargholsblauren@gmail.com

Sorry for the inconveniences.

Besst Regards
Lauren Barghols

Raghuvarma said...

This blog is nice enough. looking for a mortgage loan? Finfree offers best Mortgage loans in Hyderabad against the residential & commercial property at considerable interest rates with easy repayment options.

Cheap SR22 Quote said...

Appreciating the commitment you put into your site and detailed information you provide. It’s good to come across a blog every once in a while that isn’t the same outdated rehashed information. Excellent read!

Cheap SR22 Quote

c80003f3 said...

Very Nice Article.

Samuel
Microsoft Office Live Support

dentist near me said...

A very personalized approach I must say. And it works quite nicely which is a reflection of the writer's own personal aptitude. Keep it up.

Eve Holt said...

I highly recommend this article for those people who are looking for home loan in Dubai. Its briefly explain how numbers work in a Loan.

Dr Purva Pius said...

Hello Everybody,
My name is Mrs Sharon Sim. I live in Singapore and i am a happy woman today? and i told my self that any lender that rescue my family from our poor situation, i will refer any person that is looking for loan to him, he gave me happiness to me and my family, i was in need of a loan of $250, 000.00 to start my life all over as i am a single mother with 3 kids I met this honest and GOD fearing man loan lender that help me with a loan of $250, 000.00 SG. Dollar, he is a GOD fearing man, if you are in need of loan and you will pay back the loan please contact him tell him that is Mrs Sharon, that refer you to him. contact Dr Purva Pius, via email:(urgentloan22@gmail.com) Whats App +91-8929509036 Thank you.

Mortgage Intelligence-Oshawa said...

Everyone wants to build their own house but all people don't have enough money to fulfill it. Who have not sufficient balance to cover their house payment for them we are finding mortgage lenders, who able to give mortgage loans with low interest. Visit our site to know more details.

Mr Abdullah Ibrahim said...

We offer personal Business loans services around the world. We strive to provide high quality service and high customer satisfaction, while possible financial services. We pride ourselves on our commitment to our customers; We can give you personal loans, auto loans, business / investment loans, short term loans. You can contact us for an affordable loan now at 2% interest rate. Contact us now via E-mail: abdullahibrahimlender@gmail.com
WhatsApp Number +918929490461
Mr Abdullah Ibrahim

sunylopzzzz said...


Again this relies upon the lender but with some you'll borrow $150 for your first online advance and up to $750 within the future depending upon the approval of your application.
wisconsin payday loans

David Philip said...

Microsoft Office Live Chat

Yoon Soo said...

Award winning support MICROSOFT Support

Kristy said...

An absolute solution for all computer related issues

Felix Pole said...

Microsoft Windows Support

Sam Polo said...

Live Support for Office suite

John said...

It is in actual fact a nice and effective piece of info. I’m happy that you austerely shared this useful info with us. Please keep us informed like this. Thanks for sharing

Tino Best said...

Credit card data is not stored on the Phone Swipe application, the card reader or on your Smartphone. North American Bancard ISO