Note: the cells go to 360, but could not fit in picture.

- 0.00 Mortgage Amortization Complete the loan amortization schedule for a Mortgage that will be repaid over 360 months and answer the following questions (The details about the loan are shown below) Correct Answers 1. What is your monthly payment? 2. What is the total $ amount of payments made over the life of the loan Enter Answers Here. 3. How many months will it take to pay off the loan if you pay an extra $175.88 per month? Note: Enter the month when the whole principal is paid off. Also, remember to show the amortization table for the original payment before you submit Payment Payment Beginning Balance Interest Paid Principle Paid Ending Balance No. Amount Loan Input Data Amount 1 Principal Amount $470,000.00 2 Annual Interest Rate 3.50% 3 Periods Per Year 12 4 Total Number of Payments 360 5 Percentage Rate Per Period 6 Extra Payment per month $175.88 7 8 Grade Mortgage 9 10 Mortgage Score 11 Total Score 12 13 13 14 15 15 10 16 - 17 FEEDBACK: 18 19 20 21 - 22 23 24 - 25 - 26 271 28 29 30 31 32 33 34 35 36 37 38 39 40 - 41 42 43 44 45 46 47 48 49 50 51 52 53 ex 54 55 ed 56 57 58 so 59 60 a 61 62 63 64 cs 63 ac 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 1) Round your answers to the nearest cent. 2) You may have a small amount of payment left over in the amortization table due to rounding errors. This is normal