Accounting 2120 Spring 2019 Extra Computer Project (D)-Chapter 14 10 points Due Thursday, April 4, 2019, Classtime Prepare an amortization table for the following car loan: Amount Financed Time period: Interest rate: $15,000 4.5 years 5.0% 1- Determine the monthly payment using the "pmt" function on Excel. 2 - Prepare a monthly amortization table for the payoff of the loan. (Round to cents.) Answer the following questions: a) b) c) How much interest expense will they incur in month 12? What is the remaining principal balance in month 15? What is the remaining principal balance in month 24? 3 - Prepare a second amortization table assuming that you round up the payment to the nearest $100. (Example: payment is $233.19, Roundup would be $300.00.) Answer the following questions: a) b) c) How much interest expense will they incur in month 12? What is the remaining principal balance in month 15? What is the remaining principal balance in month 24? 4- In what month would you pay off the rest of the loan if they round up the payment to the nearest $100