Question

In: Finance

OQ3.13. What is the purpose of a loan amortization schedule? Explain briefly and give examples.

OQ3.13. What is the purpose of a loan amortization schedule? Explain briefly and give examples.

Solutions

Expert Solution

Amortization schedule is a table that is used to present the periodic loans payments which is the principal amount and the amount of interest that is comprised in each payment till the loan is completely paid off by the end of its term. Lenders can keep a track on the amounts they owe as well as when they become due. They are also used to forecast the outstanding balance of the loan or interest at any point of time in the life of the loan. Mostly, such tables are used in the case of instalment loans that have payoff dates that are known when the loan is take such as a car loan or a mortgage loan.

In the initial portion of amortization table, the payments include the interest portion of the loan. Later on, the payments apply to the principal portion of the loan This means that, with each payment, the percentage of interest in the payment portion continually decreases whereas the percentage of princiapal amount in the payment portion increases continually with each payment. This means the balance of the principal of your loan will not decrease much in the earlier part of your repayment schedule.

Though the amount of principal and interest amount varies with each month, the total payment of every month remains the same.

Eg: The first few lines of an amortization schedule for a $250,000, 30-year fixed-rate mortgage with a 4.5% interest rate looks like this:

Month Month 1 Month 2 Month 3
Total Payment $1,266.71 $1,266.71 $1,266.71
Principal $329.21 $330.45 $331.69
Interest $937.50 $936.27 $935.03
Total Interest $937.50 $1,873.77 $2,808.79
Loan Balance $249,670.79 $249,340.34 $249,008.65

Related Solutions

AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $25,000 loan to be repaid in equal...
AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $25,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 8% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $ $ $ $ $ 2 3 b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all...
What is a loan amortization schedule, and what are some ways these schedules are used?
What is a loan amortization schedule, and what are some ways these schedules are used?
Finance- Amortization Schedule Create the amortization schedule for a loan of $5,000, paid monthly over two...
Finance- Amortization Schedule Create the amortization schedule for a loan of $5,000, paid monthly over two years using an 8 percent APR.
Problem 5-50 Amortization Schedule (LG9) Create the amortization schedule for a loan of $4,300, paid monthly...
Problem 5-50 Amortization Schedule (LG9) Create the amortization schedule for a loan of $4,300, paid monthly over two years using an 9 percent APR. (Round your answers to 2 decimal places.)       Month   Beginning Balance   Total Payment   Interest Paid   Principal Paid   Ending Balance 1                               2                               3                               4                               5                               6                               7  ...
Problem 5-49 Amortization Schedule (LG9) Create the amortization schedule for a loan of $14,000, paid monthly...
Problem 5-49 Amortization Schedule (LG9) Create the amortization schedule for a loan of $14,000, paid monthly over three years using a 9 percent APR. (Round your answers to 2 decimal places.)    Month Beginning Balance Total Payment Interest Paid Principal Paid Ending Balance 1                2                3                4                5                6                7...
Create a loan amortization schedule in excell for a $27,000 car loan that will be repaid...
Create a loan amortization schedule in excell for a $27,000 car loan that will be repaid over 48 months at an annual interest rate of 6%. What is your monthly payment? _$_ What is the total dollar amount of payments made over the life of this loan? $____ What is the total dollar amount of interest paid over the life of this loan? $___________ How many months will it take to pay off the loan if you pay an extra...
Prepare an amortization schedule for a three-year loan of $24,000.
Prepare an amortization schedule for a three-year loan of $24,000. The interest rate is 16 percent per year, and the loan calls for equal principal payments.
1A) Construct a loan amortization schedule for a 15 year, 7.75% loan of $10,000,000. The loan...
1A) Construct a loan amortization schedule for a 15 year, 7.75% loan of $10,000,000. The loan requires equal, end-of-year paymens, and interest compounded monthly. b) what is the total amount of interest paid over the life of the loan? c) Assume that there is a balloon payment requirment after 10 years. What is the balloon payment in section a?
A- 1. Construct a loan amortization schedule for a 15-year, 7.75% loan of $10,000,000. The loan...
A- 1. Construct a loan amortization schedule for a 15-year, 7.75% loan of $10,000,000. The loan requires equal, end-of-year payments, and interest is compounded monthly. - What is the total amount of interest paid over the life of the loan? 2. Re-construct this amortization schedule assuming that interest is compounded annually. - What total amount of interest is paid over the life of the loan? - What is the difference between those total interest amounts? 3. Assume that in sections...
What is a loan amortization schedule?  How would you use it to determine your loan interest rate?...
What is a loan amortization schedule?  How would you use it to determine your loan interest rate? In which months is most of the interest paid?  Why? What is the percentage difference of interest paid with a 30-yr. loan vs. a 15-yr. loan as a percentage of the 15-yr. loan interest amount?  What factors would affect your choice between two loans?  Would making payments two weeks early each month make much difference in the total amount paid?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT