Prepare an amortization schedule based on the following information:
You are purchasing a car for $19,500 and you are getting a loan for the entire amount. The interest rate from Honda Motor Finance Corporation is 9.9% per year. Your loan in a unique one in that you only have to pay twice per year (at the end of every 6 months). The loan has a 3-year term, but you plan to make a lump sum payment after 2 years in order to pay off the loan. Find out what the ending balance on the loan will be after 2 years and complete an amortization table with the following columns filled in for periods 1-4: Beginning Balance, Payment, Interest, Principal, Ending Balance.