**Mortgages: How They Work — Principal, Interest, Amortisation, Points**

Mortgages: How They Work — Principal, Interest, Amortisation, Points

A practical guide to understanding mortgage mechanics for homebuyers, investors, and builders.

What Is This?

A mortgage is a loan secured by real estate, where the borrower repays the lender over time with interest. You use it to buy property without paying the full price upfront, spreading costs over decades while building equity.

Why it matters today:
- Homeownership: Most people can’t afford a home outright—mortgages make it possible.
- Investment leverage: Real estate investors use mortgages to control assets worth far more than their cash.
- Financial planning: Understanding mortgages helps you optimize payments, save on interest, and avoid costly mistakes.

Why It Matters

Mortgages shape personal finance, real estate markets, and even economic policy. Poor mortgage decisions can lead to foreclosure, while smart ones build wealth. Key impacts: - Affordability: Monthly payments determine what you can buy.
- Interest costs: A 30-year mortgage can cost 2–3x the home’s price in interest.
- Refinancing: Lowering your rate by 1% can save tens of thousands over time.
- Tax implications: Mortgage interest may be deductible (varies by country).

Core Concepts

1. Principal

• The original loan amount (e.g., $300,000 for a home).
• Each payment reduces the principal, increasing your equity (ownership stake).
• Key insight: Early payments go mostly to interest; later payments chip away at principal faster.

2. Interest

• The cost of borrowing, expressed as an annual percentage rate (APR).
• Simple interest formula:
  Interest = Principal × Rate × Time (e.g., $300,000 × 4% × 1 year = $12,000 interest).
• Amortizing loans (like mortgages) use compound interest, recalculated monthly.

3. Amortisation

• The process of spreading loan payments over time, with each payment covering interest + principal.
• Amortisation schedule: A table showing how much of each payment goes to interest vs. principal.
• Early years: Mostly interest.
• Later years: Mostly principal.
• Example: On a $300,000, 30-year, 4% mortgage:
• First payment: $1,013 (interest) + $387 (principal) = $1,400.
• Last payment: $5 (interest) + $1,395 (principal) = $1,400.

4. Points (Discount Points)

• Upfront fees paid to the lender to lower your interest rate.
• 1 point = 1% of the loan amount (e.g., $3,000 on a $300,000 loan).
• Break-even point: Calculate how long it takes to recoup the cost via lower payments.
• Rule of thumb: If you’ll keep the loan longer than the break-even period, points are worth it.
• Example: Paying 1 point ($3,000) to drop your rate from 4% to 3.75% saves ~$45/month. Break-even = $3,000 ÷ $45 ≈ 67 months (5.5 years).

How It Works

1. Loan Structure

• Term: Length of the loan (e.g., 15, 20, or 30 years).
• Interest rate: Fixed (stays the same) or adjustable (changes with market rates).
• Payment frequency: Typically monthly, but some lenders offer biweekly (saves interest).

2. Amortisation in Action

1. Lender calculates your monthly payment using the amortisation formula:
   P = L [ r(1 + r)^n ] / [ (1 + r)^n – 1 ]
2. P = Monthly payment
3. L = Loan amount
4. r = Monthly interest rate (APR ÷ 12)
5. n = Number of payments (e.g., 360 for 30 years)
6. Each payment is split into:
7. Interest: Remaining principal × monthly rate
8. Principal: Total payment – interest
9. Remaining balance decreases over time, reducing future interest.

3. Points Calculation

• Lender offers a rate sheet (e.g., 4% with 0 points, 3.75% with 1 point).
• You decide whether to pay points based on:
• How long you’ll keep the loan.
• Your upfront cash availability.

Hands-On / Getting Started

Prerequisites

• Basic math (percentages, division).
• A mortgage calculator (e.g., Bankrate, Excel, or Python).
• Sample loan terms (e.g., $300,000, 30-year, 4% APR).

Step-by-Step: Build an Amortisation Schedule

Option 1: Excel/Google Sheets

1. Set up columns:
2. Payment # | Payment | Principal | Interest | Remaining Balance
3. First row:
4. Payment #: 1
5. Payment: =PMT(4%/12, 360, 300000) → $1,432.25
6. Interest: =300000 * (4%/12) → $1,000
7. Principal: =1432.25 - 1000 → $432.25
8. Remaining Balance: =300000 - 432.25 → $299,567.75
9. Drag formulas down for 360 rows.

Option 2: Python

import pandas as pd

def amortisation_schedule(principal, rate, years):
    monthly_rate = rate / 12
    payments = years * 12
    payment = principal * (monthly_rate * (1 + monthly_rate)payments) / ((1 + monthly_rate)payments - 1)

    schedule = []
    balance = principal
    for month in range(1, payments + 1):
        interest = balance * monthly_rate
        principal_paid = payment - interest
        balance -= principal_paid
        schedule.append([month, round(payment, 2), round(principal_paid, 2), round(interest, 2), round(balance, 2)])

    return pd.DataFrame(schedule, columns=["Month", "Payment", "Principal", "Interest", "Balance"])

# Example: $300,000, 4%, 30 years
schedule = amortisation_schedule(300000, 0.04, 30)
print(schedule.head())

Expected output:
| Month | Payment | Principal | Interest | Balance | |-------|---------|-----------|----------|-----------| | 1 | 1432.25 | 432.25 | 1000.00 | 299567.75 | | 2 | 1432.25 | 433.68 | 998.57 | 299134.07 |

Step-by-Step: Calculate Points Break-Even

1. Find the rate difference: 4% vs. 3.75%.
2. Calculate monthly savings:
3. 4% payment: =PMT(4%/12, 360, 300000) → $1,432.25
4. 3.75% payment: =PMT(3.75%/12, 360, 300000) → $1,389.35
5. Savings: $1,432.25 – $1,389.35 = $42.90/month
6. Break-even period:
7. Cost of 1 point: $3,000
8. Months to break even: $3,000 ÷ $42.90 ≈ 70 months (5.8 years)

Common Pitfalls & Mistakes

1. Ignoring the amortisation schedule
2. Mistake: Assuming all payments reduce principal equally.

3. Fix: Use a calculator to see how much goes to interest vs. principal.

4. Paying for points without calculating break-even

5. Mistake: Buying points to lower the rate, then selling/refinancing before recouping costs.

6. Fix: Only pay points if you’ll keep the loan past the break-even period.

7. Choosing a longer term to lower payments

8. Mistake: Opting for a 30-year loan to reduce monthly costs, ignoring higher total interest.

9. Fix: Compare total interest paid (e.g., 30-year vs. 15-year).

10. Not shopping around for rates

11. Mistake: Accepting the first offer without comparing lenders.

12. Fix: Get quotes from at least 3 lenders—rates can vary by 0.5% or more.

13. Overlooking prepayment penalties

14. Mistake: Paying extra to reduce principal, then getting charged a fee.
15. Fix: Check if your loan has prepayment penalties (common in subprime loans).

Best Practices

1. Pay extra toward principal
2. Even $100/month extra can shave years off your loan and save thousands in interest.

3. Example: On a $300,000, 30-year, 4% loan, paying an extra $200/month saves $48,000 in interest and pays off the loan 6 years early.

4. Refinance strategically

5. Rule of thumb: Refinance if you can lower your rate by 1%+ and recoup closing costs within 2–3 years.

6. Avoid: Refinancing into a longer term if you’re already halfway through your loan (resets amortisation).

7. Biweekly payments > monthly

8. Paying half the monthly amount every 2 weeks = 13 full payments/year (vs. 12).

9. Result: Pays off a 30-year loan in ~25 years with no extra cost.

10. Lock in rates when they drop

11. If rates fall after you apply but before closing, ask your lender to match the lower rate.

12. Understand APR vs. interest rate

13. Interest rate: Cost of borrowing.
14. APR: Includes fees (points, origination) → better for comparing loans.

Tools & Frameworks

Real-World Use Cases

1. First-Time Homebuyer

• Scenario: Buying a $400,000 home with 20% down ($80,000).
• Loan: $320,000, 30-year, 4.5% APR.
• Action:
• Compare fixed vs. adjustable rates.
• Calculate points break-even (e.g., 1 point = $3,200 for a 0.25% rate drop).
• Use an amortisation schedule to plan extra payments.

2. Real Estate Investor

• Scenario: Purchasing a rental property with a $250,000 mortgage.
• Goal: Maximize cash flow while minimizing interest.
• Action:
• Opt for a 15-year loan (lower rate, faster equity).
• Refinance if rates drop by 1%+.
• Pay extra principal to reduce term.

3. Homeowner Refinancing

• Scenario: Current loan: $200,000, 30-year, 5% APR (5 years in).
• Goal: Lower monthly payments.
• Action:
• Check remaining balance ($186,000).
• Compare new 30-year vs. 20-year terms.
• Calculate closing costs (e.g., 2% of loan = $3,720) vs. savings.

Check Your Understanding (MCQs)

Question 1

You take out a $300,000, 30-year mortgage at 4% APR. In the first payment, how much goes toward principal? - A) $1,000 - B) $432 - C) $1,432 - D) $300

Correct Answer: B) $432
Explanation:
- Monthly payment = $1,432.25 (calculated via PMT formula).
- First month’s interest = $300,000 × (4% ÷ 12) = $1,000.
- Principal = $1,432.25 – $1,000 = $432.25 (rounded to $432).

Why the Distractors Are Tempting:
- A) Confuses interest with principal.
- C) Assumes the full payment reduces principal.
- D) Random number unrelated to the calculation.

Question 2

You’re offered a $250,000 mortgage at 3.75% with 1 point or 4% with 0 points. The break-even period is 6 years. What should you do if you plan to sell in 5 years? - A) Take the 3.75% loan with 1 point.
- B) Take the 4% loan with 0 points.
- C) Negotiate for a lower rate.
- D) Pay extra toward principal.

Correct Answer: B) Take the 4% loan with 0 points.
Explanation:
- The break-even period (6 years) is longer than your planned ownership (5 years).
- Paying 1 point ($2,500) won’t save enough to justify the cost.

Why the Distractors Are Tempting:
- A) Assumes points are always worth it.
- C) Ignores the break-even math.
- D) Doesn’t address the question (extra payments are unrelated to points).

Question 3

On a $200,000, 30-year, 5% mortgage, you make biweekly payments (half the monthly amount every 2 weeks). How does this affect the loan term? - A) No change—it’s the same as monthly payments.
- B) Pays off the loan in ~25 years instead of 30.
- C) Increases total interest paid.
- D) Requires a prepayment penalty.

Correct Answer: B) Pays off the loan in ~25 years instead of 30.
Explanation:
- Biweekly payments = 26 half-payments/year (≈13 full payments).
- Extra payment/year accelerates principal reduction, shortening the term.

Why the Distractors Are Tempting:
- A) Assumes biweekly =