CALCULATING AN AMORTIZATION SCHEDULE

¾ Enter into the spreadsheet (Table 2) the original loan amount, the number of payment periods and the nominal monthly interest rate: PV = 100 N = 3 i = 2 ¾ The amortized monthly payment is 34.68. ¾ If 34.68 were paid each month, then the total paid would be $104.04 (34.68 x 3), of which $100 is principal. So the balance of $4.04 is interest ... ................
................