This exercise requires the ability to create Amortization Schedules Using a Spreadsheet program. Based on the information given about the Amortization of the loan, the principal payable per month became greater than the interest payable per month on the 159th month (given that the loan amount is $500,000.
The amount of principal in a monthly payment first exceeds the interest payment In 159th Month. The interest on this month is $1, 248.39 while the principal on this month is $1, 205.46.
It is to be noted that when a loan is taken, the constituents of the amounts being paid back is the Principal and part of the interest on the loan.
The yearly interest rate must be divided by 12.
Your monthly interest rate, for instance, will be 0.3525 percent if your annual interest rate is 4.23 percent (0.0423 annual interest rate x 12 months).
Additionally, you'll add 12 to the number of years remaining on your loan term.
The total amount of interest that is paid for the term loan is $383,385.54
Yes it would change. It would change to the 165th month. In this month, the interest paid is $1, 834.00 while the principal paid back is $1,846.77. See the attached image for answer C.
Learn more about Amortization at;
https://brainly.com/question/10561878
#SPJ1
