Can you please help me to find the answers for all the things that i posted ASAP.

Home D DE 2 WES f c D You Have Decided to use a 20 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.75% You must also determine the amount of INTEREST, PRINCIPAL and BALANCE owing for the mortgage after 2 years and 7 Month. Input all the TVM variables and answers into the fields below. M $354574 20 Years ID 11 -P/Y -C/ FI Your man DO NOT TRY other considered cheating and w the Each Pro Volan 354376 12 31 of Period 13 14 15 16 IT 16 BALANCE OWING IBALI May Payment (PMD) 20969 240 51 sa MURO ANSWERS AND ANSWERED UNASHED LIMWERED UNASWERED LINAWERED PEINOPALPAD PN Mortgage Rate As)- 3.75 Vue Albed of loan 0 21 Sedia Va INTERESTPAD IN sa Submit Answers 30 OPEN CASE MERE ove Mortgage Case1125-2020.xam Saving... divyesh Draw Page Layout Formulas Data Review View Developer Help Search 11 A General W U A $ . % Conditional Format as Formatting Table Styles Format - F Font Section 5. Mortgage Calculation X E fx Instructions C D 2 Find the MONTHLY mortgage PAYMENT of stress tested(+2%) on your rate of 3.75% with a 25 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 2 Years and 7 Months. Input all the TVM variables and answers into the fields below. Amortization Mortgage Amount From Previous Question $354574 25 Years .P/Y c/y- Present Value of Loan (PV P1 Months P2 Months se will be deliver use another stud ting and both ste enment. Each ass Number of Periods (N) Monthly Payment (PMT) BALANCE OWING (BAL) Mortgage Rate As % (1/Y) Value At End of Loan (FV) VERED VERED VERED VERED SWERED SWERED SWERED SWERED PRINCIPAL PAID (PRN) Section Value: 7 INTEREST PAID (INT) Submit Answers Autosave on lome Insert Draw dues patal DP Share Calibri Mortgage Case 1125-2020.xlsm Saving Page Lammas Ban View DAR Mortgage Calculators . 11 Instructions Please determine the amortization for the following two payment frequencies using the mortgage amount: $354574. Section Value: 13 SoFind Select- Font Submit Answers lo B D (HINT: Solve for N and adjust your mortgage payment from section 4.MAKE SURE YOUR PMT IS NEGATIVE.) Monthly PMT from Section 4 2096.89 O R S Mortgage Rate As % (/) Present Value of Loan (PV Value At End of Loan (FV) 3.75 Question 1: Your mortage case will be de DO NOT TRY to use another considered cheating and bott zero on the assignment. Each Payment Frequency 1 Weekly Formulas for covering payment frequencies are in Chapter 7 of your textbook. Question 2: Payment Frequency 2 Accel. Bi-Weekly P/Y 51 52 C/Y P/Y C/Y 53 ANSWERED ANSWERED ANSWERED ANSWERED UNASWERED UNASWERED UNASWERED UNASWERED Number of Periods (N) 54 SS S6 S7 58 Number of Periods (N) Payment (PMT) Payment (PMT) Amortization in Yeon 12 Decimal Amortization in Year 2 Demol OPEN CASE HERE DIL go 3 Prtsen Home Ervd Pgup PgDn 74 9 111 Section 7 - Property Tax F Instructions The City of Edmonton has assessed your property at a value of $373531.31 and the Mill Rate is 8.6869. What are the Annual and Monthly property tax amounts? Annual Property Tax Amount Monthly Property Tax Amount this excel file. e. This will be will be given a at is unique. Instructions You will be getting possession of the home on July 1 st. What will the property tax adjustment be? Who will have to pay? Adjustment Amount Who Pays Adjustment? Section Value: 6 Submit Answers >save On Mortgage Case 1125-2020.xlsm. Saving divyosh patel Draw Page Layout Formulas Data Review View Developer Help Search Section 8. Qualification 11 Wed 27 Sort & Fi Filter som Font Editing fx Part 1 With your Annual Income of: $135444.71 and the figures you already determined for a Stress Tested Monthly Mortgage Payment, and Property Tax of $, calculate Gross Debt Service Ratio. Assume the cost of 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? C D P o Total Monthly GDS Expenses GDS Ratio as a % le: 3.45% Do they Qualify on GOS? Part 2 be delivered other students Id both studer t. Each assign If you have consumer debt servicing in the amount of $1032.63 per month. 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? ANSWERED ANSWERED ANSWERED ANSWERED UNASWERED UNASWERED UNASWERED UNASWERED Total Monthly TDS Expenses TDS Ratio as a % le: 3.45% Do they Qualify on TDS Section Value: 9 Submit Answers HERE Prtson Home End Poup F11 FB 9 Home D DE 2 WES f c D You Have Decided to use a 20 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.75% You must also determine the amount of INTEREST, PRINCIPAL and BALANCE owing for the mortgage after 2 years and 7 Month. Input all the TVM variables and answers into the fields below. M $354574 20 Years ID 11 -P/Y -C/ FI Your man DO NOT TRY other considered cheating and w the Each Pro Volan 354376 12 31 of Period 13 14 15 16 IT 16 BALANCE OWING IBALI May Payment (PMD) 20969 240 51 sa MURO ANSWERS AND ANSWERED UNASHED LIMWERED UNASWERED LINAWERED PEINOPALPAD PN Mortgage Rate As)- 3.75 Vue Albed of loan 0 21 Sedia Va INTERESTPAD IN sa Submit Answers 30 OPEN CASE MERE ove Mortgage Case1125-2020.xam Saving... divyesh Draw Page Layout Formulas Data Review View Developer Help Search 11 A General W U A $ . % Conditional Format as Formatting Table Styles Format - F Font Section 5. Mortgage Calculation X E fx Instructions C D 2 Find the MONTHLY mortgage PAYMENT of stress tested(+2%) on your rate of 3.75% with a 25 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 2 Years and 7 Months. Input all the TVM variables and answers into the fields below. Amortization Mortgage Amount From Previous Question $354574 25 Years .P/Y c/y- Present Value of Loan (PV P1 Months P2 Months se will be deliver use another stud ting and both ste enment. Each ass Number of Periods (N) Monthly Payment (PMT) BALANCE OWING (BAL) Mortgage Rate As % (1/Y) Value At End of Loan (FV) VERED VERED VERED VERED SWERED SWERED SWERED SWERED PRINCIPAL PAID (PRN) Section Value: 7 INTEREST PAID (INT) Submit Answers Autosave on lome Insert Draw dues patal DP Share Calibri Mortgage Case 1125-2020.xlsm Saving Page Lammas Ban View DAR Mortgage Calculators . 11 Instructions Please determine the amortization for the following two payment frequencies using the mortgage amount: $354574. Section Value: 13 SoFind Select- Font Submit Answers lo B D (HINT: Solve for N and adjust your mortgage payment from section 4.MAKE SURE YOUR PMT IS NEGATIVE.) Monthly PMT from Section 4 2096.89 O R S Mortgage Rate As % (/) Present Value of Loan (PV Value At End of Loan (FV) 3.75 Question 1: Your mortage case will be de DO NOT TRY to use another considered cheating and bott zero on the assignment. Each Payment Frequency 1 Weekly Formulas for covering payment frequencies are in Chapter 7 of your textbook. Question 2: Payment Frequency 2 Accel. Bi-Weekly P/Y 51 52 C/Y P/Y C/Y 53 ANSWERED ANSWERED ANSWERED ANSWERED UNASWERED UNASWERED UNASWERED UNASWERED Number of Periods (N) 54 SS S6 S7 58 Number of Periods (N) Payment (PMT) Payment (PMT) Amortization in Yeon 12 Decimal Amortization in Year 2 Demol OPEN CASE HERE DIL go 3 Prtsen Home Ervd Pgup PgDn 74 9 111 Section 7 - Property Tax F Instructions The City of Edmonton has assessed your property at a value of $373531.31 and the Mill Rate is 8.6869. What are the Annual and Monthly property tax amounts? Annual Property Tax Amount Monthly Property Tax Amount this excel file. e. This will be will be given a at is unique. Instructions You will be getting possession of the home on July 1 st. What will the property tax adjustment be? Who will have to pay? Adjustment Amount Who Pays Adjustment? Section Value: 6 Submit Answers >save On Mortgage Case 1125-2020.xlsm. Saving divyosh patel Draw Page Layout Formulas Data Review View Developer Help Search Section 8. Qualification 11 Wed 27 Sort & Fi Filter som Font Editing fx Part 1 With your Annual Income of: $135444.71 and the figures you already determined for a Stress Tested Monthly Mortgage Payment, and Property Tax of $, calculate Gross Debt Service Ratio. Assume the cost of 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? C D P o Total Monthly GDS Expenses GDS Ratio as a % le: 3.45% Do they Qualify on GOS? Part 2 be delivered other students Id both studer t. Each assign If you have consumer debt servicing in the amount of $1032.63 per month. 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? ANSWERED ANSWERED ANSWERED ANSWERED UNASWERED UNASWERED UNASWERED UNASWERED Total Monthly TDS Expenses TDS Ratio as a % le: 3.45% Do they Qualify on TDS Section Value: 9 Submit Answers HERE Prtson Home End Poup F11 FB 9