Finance and Credit Professional

Many times the interest portion of a mortgage, or other loan payment goes unnoticed. By using amortization spreadsheets you can easily see how much interest is being paid with each monthly payment. Also, you can see how much interest the payments are accumulating through the months and years.

Typically, an amortization spreadsheet will have five columns. The first will simply show the number of the month, the second will show interest paid that month, the third will show principal paid that month. Then, the forth column will show how much interest has been paid up until this payment and the fifth column will show how much principal has been paid altogether until the time of that corresponding payment.

Interest Vs. Principal

In the early going, the interest portion of each payment will be much larger than the principal portion. It is interesting to note that when an extra principal payment is made, it saves the payer from paying the interest on the corresponding payment. In other words, if a principal payment due on a particular payment is $100 and the interest due is $1,000, the person paying the mortgage can save $1,000 simply by paying the $100 before the payment is due.

Amortization Schedules or Spreadsheets

There are different formats, other than an amortization spreadsheet, which show how a loan is amortized.

These different formats are:

. Amortization tables

. Amortization schedules

. Amortization charts

They are all the same. In the case of amortization, charts, schedules and tables are all different words meaning the same thing.

Amortization spreadsheets are a little bit different. Typically, they are saved as an XLS file. Most times they are constructed using Microsoft Excel. Using this format the user has to use proper formulas in certain cells to build the spreadsheet.

Which Format is the Best One?

The advantage to a spreadsheet over a schedule is that in the spreadsheet, a different amount of principal paid can be entered in a "principal paid" cell and this entry will change the remainder of the spreadsheet. This is advantageous because you can see how much the remainder of a payment schedule will be altered by changing just one particular payment.

Amortization charts, schedules, and tables are static. Once they are printed out they are done. The advantage to them is they are made with either a computer program or an online Website. Since they are constructed in this manner almost instantaneously. They require no effort on the user's part. The user can simply print out and study it and see how much money he can save in interest by paying different corresponding principal payments.

The Significance of Amortization

In any event, seeing how a loan amortizes is very revealing. Once a person finds he or she can cut the wasted cost of interest greatly, he or she has learned a very important step to wealth building.

In general, paying down high interest debt is the very first step in turning around a budget of a struggling household. High interest debt of course, includes credit cards, and as anyone can easily see by studying amortization, the early payments on a mortgage.

However, until a borrower prints out an amortization table, schedule or chart, or builds an amortization spreadsheet for a particular mortgage or loan, he or she is inclined to go on wasting money unnecessarily on interest.

About The Author :

Ed Lathrop is a successful real estate investor. He has developed a Website that let's you print out your own amortization table at: Amortization Schedules Free. And, Ez Calculator includes a "Pay Credit Card Debt Quick" calculator at: Free Financial Calculator

Related News

Report reveals Herseth Sandlin's credit card debt (The Argus Leader)
WASHINGTON - South Dakota Rep. Stephanie Herseth Sandlin last year helped support the state's lucrative credit card industry, financial disclosure reports released Thursday show. In 2006, Herseth Sandlin owed between $15,001 and $50,000 on her Citibank credit card, her report shows. Her report a year ago showed the same. Citibank operates a credit card center in Sioux Falls and, with ...more

Stratos Announces Second-Quarter 2007 Financial Results (Broadcast Newsroom)
BETHESDA, MD, July 31 /PRNewswire-FirstCall/ - Stratos Global Corp. (TSX: SGB), the world's trusted leader in delivering vital voice, data, and IP communication services today announced financial results for the second quarter ended June 30, 2007. ...more

DGAP-News: STADA: Successful start in 2007 - Q1: -2- (wallstreet:online AG)
the reporting period (first quarter of 2006: EUR 35.6 million). Earnings before interest and taxes (EBIT) grew by 28% to EUR 49.0 million in the first quarter of 2007 (first quarter of 2006: EUR 38.3 million). ...more

Forex - Major currencies holding steady amid dearth of data (The Forex Market)
LONDON (Thomson Financial) - Major currencies traded in narrow ranges as the day wore on, with a dearth of data causing markets to hold out until later in the week. ...more

Major bailout is unlikely on sub-prime mortgages (The Hill)
With a wave of defaults steadily engulfing the sub-prime mortgage market, lawmakers returning from the August recess are facing mounting pressure to help keep troubled borrowers in their homes. ...more