Understanding Mortgage Payments and Amortization

This video tutorial explains how to calculate monthly mortgage payments and break down the payment into interest and principal components. It demonstrates the use of a formula to determine the monthly payment and shows how to create an amortization schedule manually. The tutorial also covers using online tools and Excel to verify calculations and create amortization schedules efficiently.

What is the primary focus of a mortgage payment?

• Paying interest and reducing the principal

• Paying off the entire loan balance

• Paying only the interest

• Paying only the principal

Which formula component represents the number of payments made in a year?

• T

• N

• Principal

• Annual interest rate

How is the monthly interest calculated for the first payment?

• By adding the principal and interest

• By subtracting the principal from the total payment

• By multiplying the remaining balance by the annual interest rate and dividing by 12

• By dividing the principal by the number of years

What is the purpose of creating an amortization schedule?

• To determine the monthly payment

• To track how much of each payment goes to interest and principal

• To calculate the total loan amount

• To find the annual interest rate

How does the portion of the payment going towards interest change over time?

• It fluctuates randomly

• It decreases

• It remains constant

• It increases

What is the total interest paid after the first two months?

• $3,331.33

• $2,147.29

• $4,993.98

• $1,666.67

What happens to the principal portion of the payment over time?

• It decreases

• It remains constant

• It increases

• It fluctuates

What tool can be used to verify the amortization schedule calculations?

• A financial advisor

• An online loan calculator

• A spreadsheet software

• A scientific calculator

Why might there be a slight difference in the calculated balance after the third payment?

• Due to a change in interest rate

• Because of a rounding error

• Because of a change in principal

• Due to a calculation mistake

What is the effect of rounding on the monthly payment calculation?

• It can cause a significant error

• It has no effect

• It can cause a minor discrepancy

• It makes the calculation easier