Amortizing a loan involves calculating the periodic payments that will pay off the loan principal over time. Creating a simple amortization schedule helps you understand how much interest you'll pay and how your principal balance decreases with each payment. Let's break down the process into simple steps.
Before we dive in, let's understand the basic terms. The loan principal is the initial amount you borrow, the interest rate is the percentage charged for borrowing this amount, and the loan term is the agreed period over which you'll repay the loan.
Setting Up the Amortization Schedule
The amortization schedule is a table that breaks down your loan into monthly (or other periodic) payments. It includes the payment number, the interest portion of the payment, the principal portion of the payment, and the remaining balance after the payment.
First, you'll need to determine your periodic payment amount. Use the formula for an annuity, which is:
PMT = P [ i(1 + i)^n ] / [ (1 + i)^n – 1 ]
where PMT is the periodic payment, P is the loan principal, i is the monthly interest rate (annual rate divided by 12), and n is the number of periods.
Calculating the Interest Portion
For each period, calculate the interest portion of the payment using the formula:
Interest = Principal Balance × Monthly Interest Rate
The monthly interest rate is the annual interest rate divided by 12. For example, if your annual interest rate is 6%, your monthly rate would be 0.5%.
Calculating the Principal Portion
The principal portion of the payment is the total payment minus the interest portion. You can calculate it with the following formula:
Principal Portion = PMT – Interest
Each payment reduces your principal balance. To find the new balance, subtract the principal portion from the previous balance:
Filling Out the Amortization Schedule
Start with the initial loan amount as the principal balance. Then, for each period:
- Calculate the interest for that period.
- Calculate the principal portion of the payment.
- Subtract the principal portion from the principal balance to get the new balance.
- Record the payment number, interest portion, principal portion, and new balance in your amortization schedule.
Continue this process until you've reached the end of the loan term.
Example of an Amortization Schedule
Let's say you have a $200,000 mortgage at a 6% interest rate, with a 30-year term. Your monthly payment would be around $1,267. The first few periods of the amortization schedule might look like this:
| Payment # | Interest | Principal | Balance |
|---|---|---|---|
| 1 | $1,000.00 | $267.00 | $199,733.00 |
| 2 | $995.33 | $271.67 | $199,461.33 |
You can see that in the beginning, the majority of your payment goes towards interest. Over time, the interest portion decreases, and the principal portion increases. This is why older mortgages have larger principal portions, meaning you're paying off your loan faster.
Creating an amortization schedule might seem complex, but it's a crucial tool for understanding your loan. It can help you plan for future costs and consider strategies like loan prepayments. Don't hesitate to use an online amortization schedule calculator for a quick and accurate result.