AutoSave OFF Insert Draw Chapter 10 Excel Assignm View Home S US Page Layout Formulas 10 AA I - a. Au Data = Review = = 2 General D $ % ) LO Paste & 047 A Arial B IU x fx B C D ACC 213 Lab 9 for Chapter 10 - Installment Notes & Amortization Tables Instructions: First, complete the amortization table in Part 1 using the information provided. Once the table is completed, then record the two loumal entries in Part 2 Information: Your car loan has monthly payments, the first payment occurring 1 month after loan starts $27.000 principal months monthly interest total payments 0.4166666667% years per year 5% 24 $1,184.53 monthly payment Part 1: Complete the amortization table below. Use formulas for calculations/cell references. Accounting Principal balance Monthly interest Principal Period beginning of month Cash Payment Expense Repayment Principal balance end of month GOOOOON Sheet1 + Page Layout Formulas View Data = Review = = General U Home Insert Draw of Arial Paste 8 BI U 047 x vfx A B 10 Dva A v bu $ -% 9 to C D E F 17 Part 1: Complete the amortization table below. Use formulas for calculations cell references Accounting Principal balance Monthly interest Principal Period beginning of month Cash Payment Expense Repayment Principal balance and of month 48 Part 2: Record the Journal entry for payments 1 and 2 after you have completed the amortization table. 49 Remember to use Excel efficiently! (That is, don't forget to use cell references for the dollar amounta) Accounts Debit Credit Sheet1 + Data = Arial = = General Tomas ~ 10 A A BI I-a. Av 047 x V fx AB Paste $ % F 46 471 48 Part 2: Record the journal entry for payments 1 and 2 after you have completed the amortization table. 49 Remember to use Excel efficiently! (That is, don't forget to use cell references for the dollar amounts) Month 1 entry Month 2 entry Sheet1