Question
You have just taken a car loan of $15,000. The loan is for 48 months at an annual interest rate of 15% (which the bank
You have just taken a car loan of $15,000. The loan is for 48 months at an annual interest rate of 15% (which the bank translates to a monthly rate of 15%/12 = 1.25%). The 48 payments (to be made at the end of each of the next 48 months) are all equal.
a. Calculate the monthly payment on the loan.
b. In a loan table calculate, for each month: the principal remaining on the loan at the beginning of the month and the split of that month's payment between interest and repayment of principal.
c. Show that the principal at the beginning of each month is the present value of the remaining loan payments at the loan interest rate (use either NPV or the PV functions).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started