Trin-for-trin instruktioner
Gather Your Loan Details & Calculate Monthly Payment (M)
First, identify your principal loan amount (P), the annual interest rate, and the loan term in years. Convert the annual interest rate to a monthly rate 'i' by dividing it by 12 (e.g., 0.05 / 12). Convert the loan term to total months 'n' by multiplying years by 12 (e.g., 30 * 12 = 360). Then, use the formula M = P [ i(1 + i)^n ] / [ (1 + i)^n – 1] to find your fixed monthly payment.
Set Up Your Amortization Table Columns
Next, prepare your table with the following column headers: Payment Number, Beginning Balance, Monthly Payment, Interest Paid, Principal Paid, and Ending Balance. This structure will help you organize your calculations for each payment.
Calculate the First Payment's Interest and Principal
For Payment #1, your Beginning Balance is the original loan amount (P). Calculate the **Interest Paid** for this month by multiplying your Beginning Balance by the monthly interest rate (i). Then, determine the **Principal Paid** by subtracting the Interest Paid from your fixed Monthly Payment (M).
Determine the New Ending Balance
Now, calculate the **Ending Balance** for the current row by subtracting the Principal Paid from the Beginning Balance. This resulting Ending Balance is crucial, as it becomes the **Beginning Balance** for the *next* payment's row.
Repeat for Subsequent Payments
Continue filling out each row of your table. For each new payment, take the previous row's Ending Balance and use it as the current row's Beginning Balance. Recalculate the Interest Paid (based on the new Beginning Balance), then the Principal Paid, and finally the new Ending Balance. Repeat this process until your loan balance reaches $0.00 (or very close to it due to rounding) at the final payment number.
Review and Verify
Once your table is complete, take a moment to review your calculations. Ensure that the Ending Balance gradually decreases with each payment, and observe how the Interest Paid decreases while the Principal Paid increases over the loan's term. The final Ending Balance should ideally be $0.00.
Ever wondered how your loan payments break down between principal and interest? Creating an amortization table by hand is a fantastic way to understand the mechanics of your loan, whether it's a mortgage, car loan, or personal loan. While calculators offer instant results, doing it manually helps you truly grasp how interest is calculated and how your payments chip away at your debt over time. Let's dive in!
Prerequisites
Before we begin, make sure you're comfortable with basic arithmetic (addition, subtraction, multiplication, division) and working with percentages. A calculator for some intermediate steps (especially powers) will be helpful, but we'll focus on the logic.
The Heart of It: Your Monthly Payment Formula
The very first thing we need to know is your fixed monthly loan payment. This payment (excluding any escrow for taxes or insurance) covers both principal and interest. Here's the formula:
M = P [ i(1 + i)^n ] / [ (1 + i)^n – 1]
Let's break down what each letter means:
- M: Your fixed monthly loan payment.
- P: The principal loan amount (the original amount you borrowed).
- i: Your monthly interest rate. This is super important! If your annual interest rate is 5%, you divide it by 12 to get the monthly rate (e.g., 0.05 / 12 = 0.0041666667).
- n: The total number of payments over the life of the loan. If you have a 30-year loan, you multiply 30 years by 12 months/year (30 * 12 = 360 payments).
This formula gives you the exact amount you'll pay each month towards principal and interest.
Setting Up Your Amortization Table
An amortization table is like a detailed ledger for your loan. You'll need columns for:
- Payment Number: (1, 2, 3... up to 'n')
- Beginning Balance: The amount you owe at the start of each payment period.
- Monthly Payment: The fixed amount 'M' you calculated.
- Interest Paid: The portion of your monthly payment that goes towards interest.
- Principal Paid: The portion of your monthly payment that reduces your loan balance.
- Ending Balance: The amount you still owe after that payment.
Let's Work Through an Example!
Imagine you take out a loan with these details:
- Loan Amount (P): $100,000
- Annual Interest Rate: 5%
- Loan Term: 30 years
First, let's get our 'i' and 'n' ready:
- Monthly Interest Rate (i): 0.05 / 12 = 0.0041666667
- Total Payments (n): 30 years * 12 months/year = 360 payments
Now, let's calculate our monthly payment (M):
M = 100000 [ 0.0041666667(1 + 0.0041666667)^360 ] / [ (1 + 0.0041666667)^360 – 1] M = 100000 [ 0.0041666667 * (1.0041666667)^360 ] / [ (1.0041666667)^360 – 1] M = 100000 [ 0.0041666667 * 4.470129 ] / [ 4.470129 – 1] M = 100000 [ 0.0186255 ] / [ 3.470129 ] M = 100000 * 0.0053676 M = $536.76 (rounded)
Now, let's fill in the first few rows of our table:
| Payment # | Beginning Balance | Monthly Payment | Interest Paid | Principal Paid | Ending Balance |
|---|---|---|---|---|---|
| 1 | $100,000.00 | $536.76 | $416.67 | $120.09 | $99,879.91 |
(Calculation for row 1) Interest Paid = $100,000.00 * 0.0041666667 = $416.67 (rounded) Principal Paid = $536.76 (Monthly Payment) - $416.67 (Interest Paid) = $120.09 Ending Balance = $100,000.00 (Beginning Balance) - $120.09 (Principal Paid) = $99,879.91
| 2 | $99,879.91 | $536.76 | $416.17 | $120.59 | $99,759.32 |
(Calculation for row 2) Interest Paid = $99,879.91 * 0.0041666667 = $416.17 (rounded) Principal Paid = $536.76 - $416.17 = $120.59 Ending Balance = $99,879.91 - $120.59 = $99,759.32
Notice how the Interest Paid slightly decreases with each payment, and the Principal Paid slightly increases? This is the magic of amortization!
Common Pitfalls to Sidestep
- Using the Annual Interest Rate: Always remember to divide your annual rate by 12 to get the monthly rate ('i'). This is the most common mistake!
- Incorrect Number of Payments: Ensure 'n' is the total number of months, not years. Multiply years by 12.
- Rounding Errors: Especially when calculating 'i' and carrying it through the formula, use as many decimal places as your calculator allows for intermediate steps. Round only at the final monthly payment 'M' and then for each row's interest/principal.
- Forgetting the Shifting Balance: Remember that the interest for each payment is calculated on the remaining principal balance, not the original loan amount. This is why the principal portion of your payment grows over time.
When to Embrace the Calculator
While creating a few rows by hand is incredibly insightful, manually calculating all 360 payments for a 30-year mortgage would be quite a task! For:
- Long-term loans: (e.g., 15-30 year mortgages)
- Quick what-if scenarios: (e.g., 'What if I pay an extra $50 each month?')
- Instant results: When you just need the numbers without the deep dive.
...an online amortization calculator is your best friend. It performs these repetitive calculations instantly and accurately.
Understanding the manual process empowers you to use those calculators more intelligently, knowing exactly what's happening behind the scenes. Happy calculating!