11 Create an amortization schedule of the monthly payments using the formulas and information covered 12 in class. Use cell references or formulas in green boxes. 10 13 14 15 Name: 16 17 18 19 *** ***Format these 7 cells representing dollars as Accounting, rates as % with 2 decimal places.* 20 21 Loan Amount $ 5,800.00 Total Interest 22 Loan Term 3 23 Rate 6.50% Total Principal Total Cost 24 Payment $ 178.00 25 26 27 28 29 Pmt # 30 1 31 Type here to search II X < > 59F