Chapter 10 Excel Assignment instructions & template.xlsx G ACC 213 Lab P3 for Chapter 10 - Installment Notes & Amortization Tables Instruction for complete the amortization table in Part using information provided Once the table is completed. The record the two ouma entre in Part 2 information Your car loan has monthly payments, the first payment occurring 1 month after ioan starts $20,000 principal 24 months 2 years 0.3750000000 Monthly interest per your 24 total payments 5872.90 monthly payment Part 1: Complete the mortation table below to formules for calculation call references Accounting Principal balance Monthly Interest Principal Period beginning of month Cash Payment Expense Repayment Principal balance end of month Previous Next Dashboard Calendar To Do Notifications Inbox Chapter 10 Excel Assignment instructions & template.xlsx G . 10 12 13 14 15 16 17 18 19 20 21 Previous Next Dashboard SRE Calendar To Do Notifications Inbox Chapter 10 Excel Assignment instructions & template.xlsx . Part 2 Record the journal entry for payments and 2 after you have completed the amortization table Remember to use Excel efficiently! (That is dont forget to use cell references for the dollar amount Dell Month 1 Crede Account Debat Month 2 entry Previous Next Dashboard BH Calendar To Do Notifications Inbox