88 50 Arial 10 B v Currency 10 .00 .00 +0 1 Amortization schedule 2 Loan amount to be repaid (PV) $36,000.00 4 Interest rate (r) S Length of loan (in years) 12.00% 3 6 7 a. Setting up amortization table 8 Calculation of loan payment Formula #N/A 9 10 Year Beginning Balance Payment Interest Repayment of Principal Remaining Balance 11 1 12 13 14 2 3 15 b. Calculating % of Payment Representing Interest and Principal for Each Year 16 17 Year 1 Payment % Representing Interest Payment% Representing Principal Check: Total= 100% 18 2 19 3 20 21 Formulas 22 23 24 25 3723 Year Beginning Balance Payment Interest 1 #N/A #N/A #N/A Repayment of Principal #N/A Remaining Balance #N/A #N/A #N/A T #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 26 27 b. Calculating % of Payment Representing Interest and Principal for Each Year G