Amortization Schedule

Amortization Schedule is a tabular presentation of the periodic payment amount, principal amount, interest, and the unpaid principal balance for each payment period. The purpose is to show the application of monthly payment towards principal and interest during the life of the loan. The schedule is built in such a manner that the loan amount is fully paid off by the end of the loan term.

Loan originators may provide you with an amortization schedule as part of their sales process.

The Amortization Schedule below is calculated for a $10,000 loan with 6% interest rate for a 1 year term.

$860.66

$327.97

Monthly Payment

Total Interest Paid

$10,327.97

12 Months

Total Payments

Period

Period |
Starting Balance |
Interest |
New Balance |
Periodic Payment |
Principal Reduction |
Unpaid Balance |
---|---|---|---|---|---|---|

1 | $10,000.00 | $50.00 | $10,500.00 | $860.66 | $810.66 | $9,189.34 |

2 | $9,189.34 | $45.95 | $9,235.28 | $860.66 | $814.72 | $8,374.62 |

3 | $8,374.62 | $41.87 | $7,593.61 | $860.66 | $818.79 | $7,555.83 |

4 | $7,555.83 | $37.78 | $6,766.61 | $860.66 | $822.89 | $6,732.94 |

5 | $6,732.94 | $33.66 | $5,935.47 | $860.66 | $827.00 | $5,905.94 |

6 | $5,905.94 | $29.53 | $5,100.18 | $860.66 | $831.13 | $5,074.81 |

7 | $5,074.81 | $25.37 | $4,260.71 | $860.66 | $835.29 | $4,239.52 |

8 | $4,239.52 | $21.20 | $3,417.05 | $860.66 | $839.47 | $3,400.05 |

9 | $3,400.05 | $17.00 | $3,417.05 | $860.66 | $843.66 | $2,556.39 |

10 | $2,556.39 | $12.78 | $2,569.17 | $860.66 | $847.88 | $1,708.50 |

11 | $1,708.50 | $8.54 | $1,717.05 | $860.66 | $852.12 | $856.38 |

12 | $856.38 | $4.28 | $860.66 | $860.66 | $856.38 | $0.00 |

Source :www.MortgagesAnalyzed.com

The amortization schedule contains the following columns for each period.

- Period: It is the period for which the calculations are made. You start with 1 and then keep adding 1 to each subsequent period.
- Starting Balance: It is the unpaid principal balance from the previous period. For the first period use the original loan amount.
- Interest: It is the periodic interest which is calculated by multiplying periodic rate with starting balance. Periodic rate is annual interest rate divided by the number of compounding periods. For mortgages, it is interest rate divided by 12.
- New Balance: It is the amount you owe if you want to pay off the loan at the end of the period. It equals Starting balance plus Interest.
- Periodic Payment: It is the monthly payment. It stays the same for each period.
- Principal Reduction: It is the amount of loan amount you pay down each period. It equals periodic payment minus interest.
- Unpaid Principal Balance (UPB): It is the loan amount you owe at the end of the loan period. It equals Starting Balance plus interest minus periodic payment. It may also be referred to as the ending balance.

Source :www.MortgagesAnalyzed.com

In case of adjustable rate mortgage (ARM) loan, a change in interest rate will change the amortization schedule and the monthly payment for all remaining periods. The amortization schedule that the loan originator gives you at the time of loan origination is based on the initial interest rate only. As a borrower, you should realize that if the rate goes up the payments may go up significantly and the amortization schedule will look quite different. In these cases you may want to ask the loan originator to provide you with an amortization schedule that is based on a higher interest rate, a rate that you believe is likely to be prevalent in the future. In fact, go further and ask for a schedule based on the highest rate allowed under the loan (rate cap) and see how the schedule looks for you.

Be aware of loans that have an introductory or initial rate. Some lenders create ingenious loan products where the initial interest rate is quite low and have low monthly payments. Once the initial rate expires, which is usually in a short period of time, the rate and monthly payments increases dramatically and makes the amortization schedule look quite unappealing. Ask the loan originator for the amortization schedule based on the rate that will be applicable when the introductory interest rate expires. This will give you a true picture of the loan that you are getting into.

Amortization Schedule

Purpose

Amortization schedule shows the application of monthly payment towards principal and interest during the life of the loan.

Use in Mortgages

Amortization schedule can be used to track the loan balance over the life of the loan.

Other Names

Amortization Table

Type

Statement

Provided By

Lender or Loan Originator

Provided To

Borrower

Notarization Required

No

Signed By

None

Life Cycle Stage

Sales

Recordkeeping

None required

Model Form

N.A.

Applicable Laws

None

Source :www.MortgagesAnalyzed.com

- Use the online amortization table calculator to create the amortization schedule for your loan.
- Download the amortization table calculator on a spreadsheet.

Updated: Aug 06, 2013

Share This Page:

It shows the application of monthly payment towards principal and interest during the life of the loan.

Finance

Know all there is to know about the US Mortgage Industry. We help you to make a well informed decision.

Finance
Loan Products

Confused about the choosing right loan product for you? We help you decide the loan product that suits your needs best.

Loan Products
Documents

Here you will find all there is to know about the forms, papers & documents required for Home Loan Mortgage and much more.

Documents
## Comments

comments powered by Disqus