Loan Repayment and Interest Concepts

The video tutorial explains how to set up a spreadsheet for loan repayment calculations. It covers the differences between repayment and payment, the impact of interest rates, and how to use recursive calculations in spreadsheets. The tutorial also discusses strategies for managing loans and investments, emphasizing the importance of understanding interest rates and repayment terms.

What is the main difference between a repayment and a payment in the context of loans?

• Payment is always larger than repayment.

• Payment is only for interest.

• Repayment is a one-time payment.

• Repayment involves paying off borrowed money over time.

What is the interest rate mentioned for the loan in the video?

• 7% per annum

• 8% per annum

• 6% per annum

• 5% per annum

How often is the interest compounded according to the video?

• Annually

• Semi-annually

• Quarterly

• Monthly

In the video, when does the bank charge interest on the loan?

• Only after the loan is fully repaid

• After the first repayment

• Before any repayments are made

• Only at the end of the year

What is the initial loan amount mentioned in the video?

• $10,000

• $15,000

• $12,000

• $20,000

What formula is used to calculate the new loan balance after interest is added?

• Loan amount - 0.07

• Loan amount / 1.07

• Loan amount + 0.07

• Loan amount x 1.07

How many years is the loan repayment scheduled for?

• 15 years

• 20 years

• 10 years

• 12 years

What is the repayment amount mentioned in the video?

• $1,646.92

• $1,500.00

• $1,700.00

• $1,800.00

Why might it be beneficial to pay off a high-interest debt quickly?

• To decrease the loan term

• To increase the loan term

• To reduce the total interest paid

• To increase the total interest paid

What is a potential advantage of keeping a low-interest debt?

• It reduces your monthly expenses.

• It decreases your overall debt.

• It allows you to invest money elsewhere for higher returns.

• It increases your credit score.