USE THE BORROW $50,000 FOR 4 YEARS AT 9%(MONTHLY PAYMENTS)!!!!!

A B D E Full Name QBA Time 1 2 3 GIVENS: 4 PV i PAYMENT (PMT) Using fx HINT: You must make the PV in the arguments box negative - example -80,000) 5 6 n r 7 8 9 10 11 PMT PMTAMT PMT to INT PMT to PRIN 0.00 1 2 3 0.00 0.00 0.00 0.00 0.00 0.00 12 13 14 15 16 17 18 19 20 21 22 5 6 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8 Outstanding Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 9 10 11 23 24 12 0.00 0.00 25 13 14 0.00 0.00 0.00 0.00 26 15 0.00 27 28 0.00 16 17 0.00 0.00 0.00 0.00 0.00 29 0.00 0.00 18 0.00 0.00 0.00 30 31 0.00 0.00 0.00 0.00 32 33 19 20 21 22 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 34 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 35 36 23 24 36 37 38 39 0.00 0.00 0.00 0.00 40 41 42 43 44 45 46 47 48 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 49 50 51 52 53 54 55 56 57 58 45 46 47 48 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 59 60 0.00 0.00 0.00 Calculate means to force the cell to make the calculation-this means you must use the sign first (12/12 or=512) Input means to type the appropriate amount or number YOU WILL USE MY PRE-PROGRAMMED AMORTIZATION TABLE PROVIDED HERE. DIRECTIONS / INSTRUCTIONS 1. Input Full name in cell A1. 2. Input QBA and time (if online type online) in E1. 3. Input the PV or Principle-in B4 4. Input the stated rate-in B7 5. Calculate i (interest per payment) - in B5 6. Input the time (years) - in B8 7. Calculaten (number of payments) - in B6 8. Using fx (function wizard) calculate the monthly payment in D4. 9. Table should automatically reduce to zero. 10. Submit through Blackboard by "DUE DATE" - Sunday November 29th 10pm. Replace King with your LAST NAME 1/2 pt. 1/2 pt. 1/2 pt. 1/2 pt. 2 pts. 1/2 pt. 2 pts. 3 pts. O pts. 1/2 pt. 10 pts. Your Criteria: Based on the first letter of your last name You will use the information provided If your Last Name begins with A-/ Borrow $50,000 for 4 years at 9% (monthly payments) If your Last name begins with J-R Borrow $25,000 for 4 years at 6% (monthly payments) A B D E Full Name QBA Time 1 2 3 GIVENS: 4 PV i PAYMENT (PMT) Using fx HINT: You must make the PV in the arguments box negative - example -80,000) 5 6 n r 7 8 9 10 11 PMT PMTAMT PMT to INT PMT to PRIN 0.00 1 2 3 0.00 0.00 0.00 0.00 0.00 0.00 12 13 14 15 16 17 18 19 20 21 22 5 6 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8 Outstanding Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 9 10 11 23 24 12 0.00 0.00 25 13 14 0.00 0.00 0.00 0.00 26 15 0.00 27 28 0.00 16 17 0.00 0.00 0.00 0.00 0.00 29 0.00 0.00 18 0.00 0.00 0.00 30 31 0.00 0.00 0.00 0.00 32 33 19 20 21 22 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 34 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 35 36 23 24 36 37 38 39 0.00 0.00 0.00 0.00 40 41 42 43 44 45 46 47 48 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 49 50 51 52 53 54 55 56 57 58 45 46 47 48 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 59 60 0.00 0.00 0.00 Calculate means to force the cell to make the calculation-this means you must use the sign first (12/12 or=512) Input means to type the appropriate amount or number YOU WILL USE MY PRE-PROGRAMMED AMORTIZATION TABLE PROVIDED HERE. DIRECTIONS / INSTRUCTIONS 1. Input Full name in cell A1. 2. Input QBA and time (if online type online) in E1. 3. Input the PV or Principle-in B4 4. Input the stated rate-in B7 5. Calculate i (interest per payment) - in B5 6. Input the time (years) - in B8 7. Calculaten (number of payments) - in B6 8. Using fx (function wizard) calculate the monthly payment in D4. 9. Table should automatically reduce to zero. 10. Submit through Blackboard by "DUE DATE" - Sunday November 29th 10pm. Replace King with your LAST NAME 1/2 pt. 1/2 pt. 1/2 pt. 1/2 pt. 2 pts. 1/2 pt. 2 pts. 3 pts. O pts. 1/2 pt. 10 pts. Your Criteria: Based on the first letter of your last name You will use the information provided If your Last Name begins with A-/ Borrow $50,000 for 4 years at 9% (monthly payments) If your Last name begins with J-R Borrow $25,000 for 4 years at 6% (monthly payments)