finance

89 Step 3 In G77 enter EZZ.SKS79 90 check numbers: 12 yrs pmt-$263. Int+Prin $37.826 91 Step 4. Copy down cells in table 92 33 What is your choice of loan rates and terms? Siyrat 6% 34 35 96 Problem 3: 37 You are planning to purchase a car for $20,000. You decide to get the loan from the credit union. It is for 6% annually but you decide to pay it off in 3 years. You want to see the loan amortization table for your loan to see how the 28 interest and principal are being paid off Fill in the inputs and the table will automatically calculate for you. 99 00 Loan Enter the loan as 20000 01 Monthly PMT You must calculate PMT = (rate/12, term*12, principal) 02 Rate Kannual rate (0.06) 03 Term years of loan (3) 051 06 Loan Amortization Table Constant PMT $0.00 Principal 0 07 Beg Principal Balance Total Monthly PMT Monthly Loan Principal Reduction Ending Principal Balance Interest OB Month 09 10 0 ooo 0 0 0 0. 0.00 0.00 0 0 0