Amortization Schedule and Mortgage Concepts

Overview: The amortization schedule lays out every payment that must be made, tracks how the loan balance changes over time, and splits each payment into the principal and interest components.
- Goal: to go from the initial balance (e.g., 350,000) down to zero, showing how balance, principal, and interest evolve each period.
- Key output: a table where each row corresponds to a payment period with columns for time, payment, interest, principal, and ending balance.
Core idea: for each period, the interest component is based on the beginning balance, and the principal component reduces the balance.
- Notation:
- Beginning balance for period t: $B_{t-1}$
- Payment amount (level payment): $P_t$
- Interest for period t: $It = B{t-1} \, i{eff}$ , where $i{eff}$ is the effective nominal annual rate adjusted for the period.
- Principal for period t: $ext{Pr}t = Pt - I_t$
- Ending balance: $Bt = B{t-1} - ext{Pr}_t$
- Note: the rate used to compute interest depends on the payment frequency (annual vs monthly, etc.).
Example initial setup (as described in the transcript):
- Beginning balance: $B_0 = 350{,}000$
- First payment: $P_1 = 86{,}000$
- Principal portion of first payment: $ext{Pr}_1 = 60{,}000$
- Interest portion of first payment: $I1 = P1 - ext{Pr}_1 = 26{,}000$
- Ending balance after first payment (as stated): $B_1 = 289{,}000$
- Observed: the transcript notes that the principal portion increases over time (e.g., from $60{,}000$ to $80{,}000$ ), illustrating amortization progress.
Key characteristics of an amortizing loan (to verify correctness):
- By maturity, the loan is fully paid off: final balance $B_N = 0$
- Principal portion is increasing over time: $ext{Pr}t < ext{Pr}{t+1} ext{ for early to mid periods}$ (principal repayments grow as interest declines)
- For a fixed-rate mortgage, the total payment (principal + interest) remains constant over the life of the loan: $P_t = P ext{ (constant)}$ for all periods
- The payment frequency and rate determine the per-period rate and number of payments:
- Per-period rate: $i{per} = \frac{i{annual}}{m}$ where $m$ is the payments per year
- Number of total payments: $N = y \times m$ where $y$ is the total term in years
Frequency changes and the importance of the number of payments: a common error is to set the rate for monthly payments but not adjust the total number of payments.
- If frequency is monthly for a 5-year loan: $N = 5 \times 12 = 60$ payments
- If the 60th payment is the last, the table should have 60 rows; otherwise, you’ll see residual balance or incorrect end behavior.
- Converting the rate to monthly: the annual rate must be divided by the frequency to get the per-period rate: $i{per} = \frac{i{annual}}{m}$
Practical improvement: conditional reporting in spreadsheets
- Idea: report the payment only if still within the loan term; otherwise leave the cell blank (or a period).
- Example logical/test structure (conceptual):
- If time t is less than the total number of payments N, report $P$ ; else report blank.
- In Excel-like syntax: =IF(t < N, P, "")
- Result: when you drag the formula down, the per-period payment appears for all periods within the term and blanks afterward.
Longer-term mortgage example and validation
- Typical mortgage length: 30 years
- Total payments for a 30-year loan with monthly payments: $N = 30 \times 12 = 360$
- With a properly set up amortization table and fixed rate, you should end with 360 rows for a 30-year loan.
- If you change parameters (e.g., rate, term, or frequency), the amortization table updates to reflect the new schedule.
Why this matters in real life (cost analysis and decision making)
- When evaluating where to live and how long you’ll stay, you can estimate interest costs for a given horizon (e.g., two years).
- Example comparison: at 7% the two-year interest cost is about $69{,}000$ , at 8% about $79{,}000$ (rough illustration from the transcript). Small rate differentials (e.g., 1%) can mean substantial dollars over a couple of years.
- This aids rent-vs-own analyses and performance comparisons of deals.
Mortgage costs and the importance of shopping for a mortgage
- Buying a house vs. borrowing money: you buy two products— the house and the money used to buy it (the loan).
- The cost of money includes the interest rate and all loan-related fees.
- Advice: shop for a mortgage just as aggressively as you shop for the house itself.
- Costs vary by lender and can be substantial; research shows significant differences in closing costs depending on how many mortgage brokers you speak with.
- Example distributions mentioned: speaking to two brokers ~ low end around $3{,}000; speaking to one more broker could raise total closing costs to around $22{,}200; speaking to four brokers could keep costs around $2{,}000. (Point is: more shopping can save money.)
- Financial sophistication and the questions you ask your loan officer matter; those with more finance education tend to navigate costs more effectively.
Key mortgage cost components beyond the interest rate
- Interest rate: primary driver of annual cost; lenders compete on rate but may add fees.
- Closing costs and prepaid items: include origination fees, processing fees, and other lender charges.
- Points (buying down the rate):
- A point = "one point" = 1% of the loan amount (not a tip; it’s prepaid interest to reduce the rate).
- Example scenario: If market rate is 6.50% and you pay one point to drop to 6.25%, you’re effectively paying 25 basis points to lower the rate.
- Trade-off varies: the amount of rate reduction per point depends on market conditions and lender offerings; sometimes a full 25 basis points, sometimes less (eighth of a point or 0.125).
- Calculation idea: determine whether paying points makes sense by comparing the upfront cost to the present value of the interest savings over the life of the loan.
- Truth in Lending Act (TILA): a regulatory framework that requires lenders to disclose all costs and provide an amortization schedule and estimates of total payments.
- Purpose: help borrowers understand the total cost of credit and compare offers across lenders.
APR (Annual Percentage Rate) and effective borrowing cost (EBC)
- APR is an important metric that reflects the true cost of borrowing by including interest and certain fees spread over the life of the loan.
- It assumes the borrower holds the loan to maturity, enabling cross-lender comparisons.
- APR can be used to assess whether paying for points up front yields a favorable long-run return when considering the cost of money.
Worked financial example from the transcript (illustrative figures)
- Example loan: a loan amount of $0.5\times 10^6 = 500{,}000$ at a market rate of 6.5%
- Total payments over 30 years: $1{,}130{,}000$
- Composition of total payments: principal repaid equals the original loan amount, $500{,}000$ ; interest paid over the life of the loan equals about $637{,}000$
- This illustrates the magnitude of interest cost relative to the principal over the long term.
Points example and cost-benefit
- Suppose you buy 1 point on a $500{,}000 loan for $5{,}000 to reduce the rate from 6.50% to 6.25% (a 25 basis point reduction).
- Resulting interest savings over the life of the loan could be around $63{,}000$ , making the upfront $5{,}000 cost worth it from a simple cost perspective.
- Decision criterion: compare the present value of the interest savings to the upfront cost (needs a time value of money analysis).
Real estate taxes, depreciation, and location considerations (practical context)
- Property taxes and predictable costs can be uncertain, and advice often varies (e.g., guidance can be to consult an attorney for pro forma tax estimates and depreciation planning).
- Tax depreciation: you cannot depreciate land, only the structure. Depreciation applies to the building, not to land value.
- Location matters: property values and taxes vary by location; proximity to amenities, job centers, and other factors influence cost and investment potential.
- Conceptual takeaway: when evaluating buy/own decisions, you’re effectively purchasing two things: the house and the money used to buy the house (the loan). Location and depreciation considerations influence both the asset’s value and the financing costs.
- Behavioral and strategic implications: location flexibility can affect rent-vs-own decisions; if people expect to move, rental flexibility may be valued higher.
Practical end goal
- After going through these notes, you should be able to construct an amortization schedule, adjust for different payment frequencies, and understand how to compare loan offers using rate, fees, points, and APR.
- You should also be able to articulate the practical implications of amortization on long-term costs and how to apply these principles to real-world mortgage decisions.
Summary of the new skill you now have
- You can build and validate an amortization schedule, adapt it to different loan terms, frequencies, and rates, and use it to inform mortgage decisions and cost comparisons.
Quick reference formulas (for your cheat sheet)
- Per-period interest: $It = B{t-1} \cdot i_{per}$
- Principal in period: $ext{Pr}t = Pt - I_t$
- Ending balance: $Bt = B{t-1} - ext{Pr}_t$
- Per-period rate from annual rate: $i{per} = \frac{i{annual}}{m}$
- Total payments: $N = y \times m$
- Conditional payment reporting (concept): if time t < N, show $P_t$ ; else show blank.
Notes on terminology from the transcript
- “Fixed rate mortgage”: a loan where the total payment remains constant over time due to a fixed interest rate and fixed payment frequency.
- “Truth in Lending Act” (TILA): regulation requiring disclosure of loan terms and costs; includes an amortization schedule and total cost estimates.
- “APR” / “EBC”: tools for comparing loan offers by incorporating interest and fees into a single annualized rate.