Problem:
On a spreadsheet, set up a monthly amortization schedule for a 3-year car note of $20,000. The annual interest rate on this loan is 7%. Calculate the monthly payment.
Required:
Question: What is the beginning loan balance on the 24th month?
Question: What is the ending loan balance on the 30th month?
Note: Provide support for your rationale.