You Have Decided to use a 15 year Amortization for your Mortgage. Use this information to find the MONTHLY mortgage PAYMENT using the mortgage amount from previous section and a rate of 3.17%. You must also determine the amount of INTEREST, PRINCIPAL and BALANCE owing for the mortgage after 4 Years and 1 Months. Input all the TVM variables and answers into the fields below. Amortization Mortgage Amount From Previous Question $281143 15 Years P/Y Present Value of Loan (PV- P1 Months P2 Months Number of Periods (N) - - Monthly Payment (PMT) - BALANCE OWING (BAL) - - Value At End of Loan (FV) - PRINCIPAL PAID (PRN) - Mortgage Rate As % (1/Y) 3.17 Section Value: 7 INTEREST PAID (INT) Submit Answers Instructions Find the MONTHLY mortgage PAYMENT of stress tested(+2%) on your rate of 3.17% with a 20 year amortization mortgage. You will use the mortgage amount from previous sections. You must also determine the amount of INTEREST, PRINCIPAL and BALANCE owing for the mortgage after 3 Years and 1 Months. Input all the TVM variables and answers into the fields below. Amortization Mortgage Amount From Previous Question $281143 20 Years P1 Months P2 Months PY Present Value of Loan (PV7 BALANCE OWING (BAL) Number of Periods (N) Monthly Payment (PMT) Mortgage Rate As % (1/Y) PRINCIPAL PAID (PRN) Value At End of Loan (FV) Section Value: 7 INTEREST PAID (INT) Submit Answers Instructions Please determine the amortization for the following two payment frequencies using the mortgage amount: $281143. Submit Answers Monthly PMT from Section 4 (HINT: Solve for N and adjust your mortgage payment from section 4.MAKE SURE YOUR PMT IS NEGATIVE.) Value At End of Loan (FV) Present Value of Loan (PV Mortgage Rate As % (1/Y) 3.17 Question 2: Question 1: - Payment Frequency 1 Accel. Bi-Weekly Formulas for coverting payment frequencies are in Chapter 7 of your textbook Payment Frequency 2 Weekly TC/Y PY C/Y Number of Periods (N) Number of Periods (N) Payment (PMT) Payment (PMT) Amortization in Years (2 Decimals) - Amortization in Years (2 Decimals) - You Have Decided to use a 15 year Amortization for your Mortgage. Use this information to find the MONTHLY mortgage PAYMENT using the mortgage amount from previous section and a rate of 3.17%. You must also determine the amount of INTEREST, PRINCIPAL and BALANCE owing for the mortgage after 4 Years and 1 Months. Input all the TVM variables and answers into the fields below. Amortization Mortgage Amount From Previous Question $281143 15 Years P/Y Present Value of Loan (PV- P1 Months P2 Months Number of Periods (N) - - Monthly Payment (PMT) - BALANCE OWING (BAL) - - Value At End of Loan (FV) - PRINCIPAL PAID (PRN) - Mortgage Rate As % (1/Y) 3.17 Section Value: 7 INTEREST PAID (INT) Submit Answers Instructions Find the MONTHLY mortgage PAYMENT of stress tested(+2%) on your rate of 3.17% with a 20 year amortization mortgage. You will use the mortgage amount from previous sections. You must also determine the amount of INTEREST, PRINCIPAL and BALANCE owing for the mortgage after 3 Years and 1 Months. Input all the TVM variables and answers into the fields below. Amortization Mortgage Amount From Previous Question $281143 20 Years P1 Months P2 Months PY Present Value of Loan (PV7 BALANCE OWING (BAL) Number of Periods (N) Monthly Payment (PMT) Mortgage Rate As % (1/Y) PRINCIPAL PAID (PRN) Value At End of Loan (FV) Section Value: 7 INTEREST PAID (INT) Submit Answers Instructions Please determine the amortization for the following two payment frequencies using the mortgage amount: $281143. Submit Answers Monthly PMT from Section 4 (HINT: Solve for N and adjust your mortgage payment from section 4.MAKE SURE YOUR PMT IS NEGATIVE.) Value At End of Loan (FV) Present Value of Loan (PV Mortgage Rate As % (1/Y) 3.17 Question 2: Question 1: - Payment Frequency 1 Accel. Bi-Weekly Formulas for coverting payment frequencies are in Chapter 7 of your textbook Payment Frequency 2 Weekly TC/Y PY C/Y Number of Periods (N) Number of Periods (N) Payment (PMT) Payment (PMT) Amortization in Years (2 Decimals) - Amortization in Years (2 Decimals)