In: Finance
You get a car loan for $16,000 at an annual interest rate of 7%, which requires 5 annual payments. Draw a loan amortization chart, which details the payment, interest and principle each year of the loan. Replicate the chart in Excel using monthly payments.