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.

**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.**

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:**

= (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:**

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

= 164.7438

*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.

*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:**

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.

## 28 comments:

Excellent blog! Do you have any tips and hints for aspiring writers?

I'm hoping to start my own site soon but I'm a little lost on everything.

Would you advise starting with a free platform like Wordpress or go for a paid option?

There are so many choices out there that I'm completely confused .. Any ideas? Appreciate it!

Also visit my web site :: click here

Please let me know if you're looking for a article writer for your site. You have some really good posts and I feel I would be a good asset. If you ever want to take some of the load off, I'd absolutely love to write some articles for your blog

in exchange for a link back to mine. Please send me

an e-mail if interested. Cheers!

Feel free to visit my site ... see more

Hi there, i read your blog occasionally and i own a similar one and

i was just curious if you get a lot of spam remarks?

If so how do you reduce it, any plugin or anything you can suggest?

I get so much lately it's driving me crazy so any assistance is very much appreciated.

Here is my page; see more

It's awesome to pay a quick visit this web site and reading the views of all mates concerning this piece of writing, while I am also zealous of getting familiarity.

my homepage - Http://Hugedd.Com/Index.Php?Own=2181103

It's awesome to pay a quick visit this web site and reading the views of all mates concerning this piece of writing, while I am also zealous of getting familiarity.

Here is my web blog; Http://Hugedd.Com/Index.Php?Own=2181103

Excellent beat ! I would like to apprentice while you amend your website,

how can i subscribe for a blog web site? The account helped me a acceptable

deal. I had been a little bit acquainted of this your broadcast provided bright clear idea

my blog post - visit

hey there and thank you for your info – I have certainly picked up something

new from right here. I did however expertise some technical issues using this web site, as I experienced to

reload the web site a lot of times previous to I could get it to load properly.

I had been wondering if your hosting is OK? Not

that I am complaining, but sluggish loading instances times will very

frequently affect your placement in google and could

damage your high-quality score if advertising and marketing with Adwords.

Anyway I am adding this RSS to my email and can look out for

much more of your respective exciting content. Ensure that you update this again very soon.

Review my website: Female Masturbating clips

Wow, this piece of writing is nice, my sister is analyzing these kinds of things,

therefore I am going to convey her.

Feel free to surf to my homepage :: kiwibox.com

I know this if off topic but I'm looking into starting my own weblog and was wondering what all is required to get setup? I'm assuming having a blog like yours would

cost a pretty penny? I'm not very web smart so I'm not

100% certain. Any suggestions or advice would be greatly appreciated. Many thanks

Have a look at my web site: official website

Amazing issues here. I am very happy to look your post.

Thank you so much and I am looking ahead to contact you.

Will you please drop me a e-mail?

Also visit my weblog more helpful hints

Hi there Dear, are you really visiting this website on a

regular basis, if so afterward you will without doubt take fastidious know-how.

Feel free to visit my web-site ... www.23hq.com

I was able to find good info from your blog articles.

Also visit my blog post ... http://pornharvest.com/index.php?m=2718881

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

Every weekend i used to pay a quick visit this web page, for

the reason that i want enjoyment, as this this

web site conations really fastidious funny stuff too.

Take a look at my web site; visit website

We stumbled over here from a different website and thought I may as well check

things out. I like what I see so now i'm following you. Look forward to finding out about your web page for a second time.

My homepage; http://pornharvest.com/index.php?m=2339624

Yes! Finally something about texas 3a football playoffs 2012.

Here is my web-site :: more

Heya i am for the first time here. I found this board

and I find It truly useful & it helped me out much. I hope to give something back and

help others like you helped me.

My blog post: if you want big boobies then you want jenna doll the only thing that can

It's actually a great and helpful piece of info. I am satisfied that you just shared this helpful info with us. Please keep us up to date like this. Thanks for sharing.

my web site Watch this teenage female describe her profession because A chat host

Everyone loves what you guys are usually up too. This kind of clever

work and coverage! Keep up the amazing works guys I've included you guys to blogroll.

http://lmaocr.com/groups/payday-loan/

Here is my web blog :: payday loans online

Everyone loves what you guys are usually up too. This kind of clever work and coverage!

Keep up the amazing works guys I've included you guys to blogroll.

http://lmaocr.com/groups/payday-loan/

Feel free to visit my page ... payday loans online

I always used to study article in news papers but now as I

am a user of web thus from now I am using net for articles, thanks to

web.

Feel free to surf to my blog post visit website

I've been surfing online more than 2 hours today, yet I never found any interesting article like yours. It's pretty

worth enough for me. In my opinion, if all webmasters and

bloggers made good content as you did, the net will be a lot

more useful than ever before.

Look at my web page ... http://chatclimax.com/

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

usmilitarylendingcorp.com

electronic cigarette brands, electronic cigarettes, electronic cigarettes, best electronic cigarette, ecig, ecigs

It's been good to see your blog when I always look for such type of blogs. It’s great to discover the post here. here

This piece of writing has one outstanding quality that everybody can easily understand its single word.

quickpaydayloansus.com

I’m impressed with the special and informative contents that you just offer in such short timing.paydya loans in north carolina

I don’t suppose many of websites give this kind of information.how to get business credit

Post a Comment