Question

In: Finance

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?

Solutions

Expert Solution

The loan amortization schedule shows us how the interest and the principal are paid off during the term of the loan. The interest rate can be determined by adding the entire interest column and then compared it against the principal.

The interest is paid of most during the initial few months and the composition of interest in the monthly payments reduces as the term increases. Hence you pay most of the interest in the initial months and most of the principal in the furthest months.

We pay lower interest in the 15 year loan than a 30 year loan because the interest compounded for a shorter period than a 30 -year loan. We cannot calculate the exact difference in percentage since we do not know for how much is the loan.

The factors that would affect the choice are:

1. The monthly or annual salary or cash inflow to an individual or a business - 15 years loans require higher monthly or annual payment than 30 year loans

2. Are there any bonus points available for a 15 or a 30 year loan

3. Are there any interest rate difference between the two loans?

No. Making payments two weeks early will not serve any purpose and there may be some pre-payment penalty in some loans. It make sense to pay off the lump sum may be at the end of the 5th year if you plan to resell the property or home.


Related Solutions

a)Prepare an amortization schedule for a 10-year loan of $300,000. The interest rate is 12% and...
a)Prepare an amortization schedule for a 10-year loan of $300,000. The interest rate is 12% and the loan calls for equal payments. How much interest is paid in the fifth year? How much interest is paid over the life of the loan? b)What is the present value of $2,625 per year at a discount rate of 8%, if the first payment is received six years from now and the last payment is received 20 years from now?
Develop an amortization schedule for a 5-year loan of $25,000 at an interest rate of 7.5%,...
Develop an amortization schedule for a 5-year loan of $25,000 at an interest rate of 7.5%, assuming equal annual installments at the end of each year. Use the same format that we used in class. Please show work in Excel
Prepare an amortization schedule for a three-year loan of $111,000. The interest rate is 10 percent...
Prepare an amortization schedule for a three-year loan of $111,000. The interest rate is 10 percent per year, and the loan calls for equal annual payments. How much total interest is paid over the life of the loan? (Leave no cells blank. Enter '0' where necessary. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Year Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance 1 $ 111000 $ $ $ $ 2...
Prepare an amortization schedule for a five-year loan of $84,000. The interest rate is 8% per...
Prepare an amortization schedule for a five-year loan of $84,000. The interest rate is 8% per year and the loan calls for equal annual payments. How much interest is paid in the third year? How much total interest is paid over the life of the loan? Provide another amortization schedule if you must pay $8,400 toward the principle each year instead of equal annual payments. How much interest is paid in the third year? Explain why the third year interest...
Prepare an amortization schedule for a five-year loan of $55,000. The interest rate is 8 percent...
Prepare an amortization schedule for a five-year loan of $55,000. The interest rate is 8 percent per year, and the loan calls for equal annual payments. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Leave no cells blank - be certain to enter "0" wherever required.)    Year Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance 1 $ $ $ $ $    2    3    4    5    How...
Loan amortization schedule    Joan Messineo borrowed ​$40,000 at a 4​% annual rate of interest to be...
Loan amortization schedule    Joan Messineo borrowed ​$40,000 at a 4​% annual rate of interest to be repaid over 3 years. The loan is amortized into three​ equal, annual,​ end-of-year payments a. Calculate the​ annual, end-of-year loan payment. b.  Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. a.  The amount of the​ equal, annual,​ end-of-year loan...
A loan amortization schedule allows you to see the amount you are paying towards interest and...
A loan amortization schedule allows you to see the amount you are paying towards interest and the outstanding balance of the loan. Since the amount of interest is based on the outstanding principal, you can compute the interest portion directly by multiplying the interest rate by the beginning of the period outstanding balance. When you subtract interest from the overall payment, you see the portion being applied towards the principal, which reduces the ending period outstanding balance, which hence becomes...
complete an amortization schedule for the following loan. the loan is $100,000 at 3.5% interest, amortized...
complete an amortization schedule for the following loan. the loan is $100,000 at 3.5% interest, amortized on a YEARLY basis over five (5) years.
Prepare amortization schedule for a five-year loan of $167,500. The interest rate is 17 percent per...
Prepare amortization schedule for a five-year loan of $167,500. The interest rate is 17 percent per year and the loan calls for equal annual payments. How much interest is paid in the third year? How much total interest is paid over the life of the loan? (No excel sheet)
Amortization with Equal Payments. Prepare an amortization schedule for a three-year loan of $57,000. The interest...
Amortization with Equal Payments. Prepare an amortization schedule for a three-year loan of $57,000. The interest rate is 8 percent per year, and the loan calls for equal annual payments. How much interest is paid in the third year? How much total interest is paid over the life of the loan?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT