Amortization Table - Calculate Your Own the Quick and Easy Way

Posted: Sep 02, 2009 |Comments: 0 |

Within the world of finance is a world of borrowing because using other people's money is how regular people get started in big business.

Borrowing is also how people who don't happen to have $400,000 at their disposal purchase nice new homes in nice neighborhoods. Without mortgages, very few people would own homes and the middle class wouldn't exist, as there would be two classes of people, the homeowners and those who rented from them.

The most important part of borrowing is knowing how much money you are paying back to the lender and how much money you are wasting on interest. Central to this knowledge is the understanding of what an amortization table is and how to use it.

What will the table tell us?

In short, amortization tables break monthly payments into two parts, the principal paid and the interest paid. So, it would behoove us if we knew what the total monthly payment was to begin with.

I know, it probably sounds like a cop out because we could calculate the payment, but that part of the equation will be left for another article.

In this example, the numbers may sound peculiar but we are going to use numbers that will make the example easy to follow. So, let's say we have a mortgage with a principle of $360,000. The interest rate will be a 1970's type 12%.


First we will take the amount of principal we have left to pay.

Then we have to multiply this amount by the number of months left to pay on the mortgage, in this case 360. If we didn't do this, we would just be seeing the amount of interest that would be paid if there were only one month left to pay the mortgage.

on month's payment=principal left/ number of months left x monthly interest x number of months left. Now, if you look at the formula you will see the term "number of months left" twice. Once it is a numerator (above the line) and once it is a denominator (below the line). Pretty easy, huh!

Begin calculating

$360,000 x .01= $3,600.

Next, we take the monthly payment we got from a mortgage calculator, which is $3,703.01, and we know the interest on the first payment is $3,600 so we will subtract it from $3,703.01, which will tell us the principal part of the first payment is $103.01. This is the first entry in our amortization table.

At this point, we know we no longer owe $360,000 on the mortgage because we have paid $103.01, so the principal left is now $360,000 - $103.01, or $359,896.99. We now multiply this number by .01 to get the interest part of the second payment. This is $3,598.97 and, since we know the total payment is $3,703.01, we will subtract $3,598.97 from it to get $104.04 which is the principal paid on the second payment.

There you have it. This, by the way, is something few people can say!

Even if you don't continue on making these calculations, you now know, from a very inside perspective, exactly what amortization is all about!

Read more detailed reviews at amortization table , prime interest rate, and best mortgage deals

Questions and Answers

Ask
200 Characters left
Rate this Article
  • 1
  • 2
  • 3
  • 4
  • 5
  • 0 vote(s)
    Feedback
    Print
    Re-Publish
    Source:  http://www.articlesbase.com/business-articles/amortization-table-calculate-your-own-the-quick-and-easy-way-1189711.html

    Article Tags:

    amortization table

    ,

    amortization tables

    ,

    amortization table mortgage

    ,

    loan amortization table

    ,

    amort

    What should you do if you are faced with foreclosure problems because of nonpayment's of your mortgage loans? There are many reasons why borrowers are delinquent in their payments. Reasons like illness, injury, separation or divorce, and loss of job.

    By: Jared D. Ingraml Finance> Mortgagel Nov 30, 2010
    Alberto Garcia

    The essential aspects of a negative amortization mortgage, don't fall victim to predatory lending or misguided information. Negative amortization can be a life saver or a total financial disaster if not used wisely.

    By: Alberto Garcial Business> Business Ideasl Jun 08, 2010
    Mike Lesmeister

    Several factors have created a "near-perfect" storm for investors who buy and hold rental properties. So what do investors face when they finally decide to make an offer on a foreclosure, bank REO, or short-sale property?

    By: Mike Lesmeisterl Finance> Investingl Mar 15, 2011

    Provides the top 45 most common mistakes made when seeking a loan.

    By: Paul Michaell Finance> Loansl Sep 23, 2009

    Anyone who has ever closed on a house knows the large amount of paperwork that must be signed. The process is stressful, and many people are not careful to look over all of the paperwork completely before signing on the dotted line. What many people do not realize is how many expenses may be added to the loan papers that careful reading and shopping around could have prevented.

    By: Brian Jenkinsl Finance> Mortgagel Jul 01, 2008 lViews: 729

    Best mortgage lenders need to be understood by borrower because borrower need to realize that there are other sources of capital beside their local bank. The best mortgage lenders can be found if you are looking for more than the typical 5 year fixed, 20 year amortization loan your bank quoted you and for this reason, you can make schedule with those best mortgage lenders.

    By: Felixl Finance> Mortgagel Jun 15, 2011

    In USA, one of the leading brands that offer diverse and high quality products promoting proper hygiene is Difresh USA. If you are looking for the best opportunity to grow and have the opportunity for a new business Difresh USA can help you for they are looking for Exclusive Local Distributors

    By: danieltorrisl Businessl May 31, 2012

    Getting clean and refresh doesn't sacrifice the place where you are for it should be a habit. Having a healthy body will allow you to do things right and good. And no matter where you are you should practice a healthy and proper hygiene even in little things you do.

    By: danieltorrisl Businessl May 31, 2012

    Maintaining a healthy and proper hygiene badly needs products that are truly effective and could truly answer our need for this. No matter where we are and at anytime we want to get clean we basically need these products right away and only Difresh USA can supply these in a very easy way

    By: danieltorrisl Businessl May 31, 2012

    The key reason why some firms thrive while some implode during an financial recession is still a puzzle to many people business-owning business owners. Some wrongly assume that all businesses should suffer via recessionary cycles. But the truth is that some companies are usually essentially recession-proof, and it is not necessarily because they are much larger, better known, or a lot more generously capitalized.

    By: danhoh75rel Businessl May 31, 2012

    Companies like Arch Coal (ACI) and Massey Energy (MEE) watched his or her stock climbed.

    By: pennystockegghead49l Businessl May 30, 2012

    During the 1980s, Buick was a brand that successfully straddled the fine line between luxury and performance. This GM division sold big, fluffy Park Avenues and LeSabres, while also selling the luxury/sport Riviera and the Regal. It was this last model, the Regal, which stunned the automotive world by winning Grand National awards during the early 1980s. Today, all four models have been terminated in favor of newer names including the Lucerne, LaCrosse, Terrazza, Rainier, and...

    By: Elliot Austinl Automotive> Carsl Sep 03, 2009

    Discuss this Article

    Author Box
    Articles Categories
    All Categories
    Quantcast