Please help

File Edit View Insert Format Debug Run Tools Window 0 51% Thu 9:18 PM Q DE AutoSave ( OFF ~ ~ 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 Conditional Format Cell Formatting as Table Styles [Format X v Sort & Find & Ideas Sensitivity Filter Select Office Update To keep up-to-date with security updates, fixes, and improvements. choose Check for Updates. Check for Updates Section 8 - Qualification C17 + X V fx B Part 1 With your Annual Income of: $135444.71 and the figures you already F G H K L STUDENT INFORMATION determined for a Stress Tested Monthly Mortgage Payment, and Property Tax of $3142.63, calculate Gross Debt Service Ratio. Assume the cost of 2 FIRST NAME heating the home will be $201.85. Do you qualify to purchase this home based on GDS Ratio? If not, what is the income that you would require? LAST NAME A STUDENT ID Total Monthly GDS Expenses - GDS Ratio as a % | ie: 3.45% - -Do they Qualify on GDS?- Yes Section | 6 Question 1: MI 8 Section Il . Part 2 9 Question 2: DOWN PAYM If you have consumer debt servicing in the amount of $1032.63 per month. 10 Question 3 TOTAL MORTG. What is the the TDS ratio? Do you qualify for the purchase based on this number? If no, what is the income required to qualify? 11 Section Ill 12 Question 4: CMHC PF 13 NEW MORT - Total Monthly TDS Expenses - TDS Ratio as a % | ie: 3.45% Do they Qualify on TDS? 14 SECTION IV Yes 15 Question 5: 16 FILL OUT COMPLETELY 17 18 19 20 Section Value: 9 Submit Answers 21 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