Car Loan-Solution | Verified Solutions
Car Loan Problem: The 48 installments (to be made at the end of each of the next 48 months) are all equal. Create your own spreadsheet to address the following questions: 1). Calculate the monthly payment on the loan (hint: formula pmt() or solver). You have just taken a car loan of $15,000. The loan term is for 48 months at an annual interest rate of 15% (which the bank translates to a monthly rate of 15%/12=1.25%). 2). Creat a loan table. For each month to track: the principle remaining on the loan at the beginning of the month and the split of that month's payment between interest and repayment of principal. 3). 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 function)
Document information
- Uploaded on
- August 25, 2023
- Number of pages
- 5
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
