Please Help.

File Edit View Insert Format Debug Run Tools Window 52% Thu 9:15 PM Q DE . . . AutoSave ( OF ~ ~ 6 . MCase study 2020 Home Insert Draw Page Layout Formulas Data Review View Share Comments A A" 29 Wrap Text v Insert v Delete v Paste BIUV V |av AV Merge & Center v $ ~ % 9 78 40 Conditional Format Cell X v Sort & Find & Ideas Sensitivity Formatting as Table Styles [Format Filter Select * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates C17 + X V fx B C D E F G H K L STUDENT INFORMATION Section 5 - Mortgage Calculation 2 FIRST NAME Instructions- Find the MONTHLY mortgage PAYMENT of stress tested(+2%) on your rate of 3.75% LAST NAME with a 25 year amortization mortgage. You will use the mortgage amount from A STUDENT ID previous sections. You must also determine the amount of INTEREST, PRINCIPAL and BALANCE owing for the mortgage after 2 Years and 7 Months. Input all the TVM Section | variables and answers into the fields below. 6 Question 1: - Mortgage Amount From Previous Question- -Amortization $412088.4 25 Years 8 Section Il C/Y Present Value of Loan (PV - P1 Months - P2 Months 9 Question 2: DOWN PA 10 Question 3 TOTAL MOR 11 Section Ill Number of Periods (N) Monthly Payment (PMT) - BALANCE OWING (BAL) 12 Question 4: CMHC 13 NEW MO Mortgage Rate As % (1/Y)- Value At End of Loan (FV] - - PRINCIPAL PAID (PRN) - 14 SECTION IV 15 Question 5: Section Value: 7 16 FILL OUT COMPLETELY INTEREST PAID (INT) 17 Submit Answers 18 19 PV 412088.4 20 PMT 2443.22 21 FV 871371.54 22 P1 23 P2 43 24 BAL OUTSTANDING 374538.66 25 TOTAL PRN 37549.74 26 TOTAL INT 38190.21 A OPEN CASE HERE + + 100% 5