Mortgage Amortization and Payments

This video tutorial explains how to create an amortization schedule using Excel. It covers calculating monthly mortgage payments, setting up a payment schedule, and determining interest and principal for each payment. The tutorial also addresses troubleshooting common errors and finalizing the schedule. Additionally, it demonstrates how to summarize total payments and interest over 30 years and adjust loan parameters like principal, interest rate, and loan term.

What is the principal amount used in the example for creating an amortization schedule?

• $300,000

• $500,000

• $400,000

• $200,000

How many years is the term of the mortgage in the example?

• 30 years

• 25 years

• 15 years

• 20 years

What is the formula used to calculate the number of monthly payments for a 30-year mortgage?

• 30 / 12

• 30 - 12

• 30 x 12

• 30 + 12

Which Excel function is used to calculate the monthly mortgage payment?

• PMT

• VLOOKUP

• AVERAGE

• SUM

What is the first step in setting up the initial rows of the amortization schedule?

• List the first few payments

• Determine the monthly payment

• Calculate total interest

• Adjust the principal

How is the interest for each month calculated in the amortization schedule?

• Beginning Balance x Monthly Rate

• Ending Balance x Monthly Rate

• Principal x Annual Rate

• Payment - Principal

What issue might arise when extending the rows in the amortization schedule?

• Missing payments

• Incorrect principal value

• Wrong interest rate

• Formula errors

How can you fix the formula error related to the interest calculation?

• Change the principal

• Adjust the payment

• Recalculate the term

• Lock the cell reference

What is the total amount paid over the course of the 30-year mortgage?

• $300,000

• $579,000

• $600,000

• $279,767

What happens to the monthly payment if the loan term is reduced from 30 years to 20 years?

• It remains the same

• It becomes zero

• It decreases

• It increases