Question:Complete the Chapter 2 Mid-Level Exercise 2, "Mortgage Calculator," on pages Excel 207-208. Complete all Steps: A-L.

I need help fixing an assignment. The assignment is mostly done, but I have included the email from my instructor where she says I have to fix certain parts that I do not know how to fix.

\fThank you for submitting the Lesson 5 assignment. Unfortunately, it does not meet the minimum requirements. Per the syllabus, all assignments must be completed in order to qualify to complete the course. Therefore, this assignment must be resubmitted. You will not be penalized for the resubmission. Reason - The assignment is missing some required functions. Per step g, the APR and Minimum Down Payment should both be calculated using a VLookup function. Also, the Annual PMI needs an If function since there are 2 options. Additionally, almost all of the results in column F were incorrect and need to be recalculated. Please complete the assignment and resubmit both files. If you have any questions, please let me know. Alissa Tenorio Adjunct Faculty Mortgage Calculator Inputs Negotiated Cost of House Additional Down Payment Date of First Payment Credit Rating Constants Property Tax Rate Down Payment to Avoid PMI PMI Rate Term of Loan in Years # of Payments Per Year Credit Exellent Good Fair Poor Down Payment 5% 10% 15% 20% DOU2128397, Doug Kurzinski, 36512 $ 375,000.00 $ 5,000.00 11/1/2016 Fair 0.75% 20.00% 0.50% 30 12 APR 3.25% 3.50% 4.25% 5.25% Intermediate Calculations APR Based on Credit Rating 4.25% Min Down Payment Required $ 56,250.00 Annual Property Tax $ 2,812.50 Annual PMI $ Outputs Total Down Payment Amount of the Loan Monthly Payment (P&I) Monthly Property Tax Monthly PMI Total Monthly Payment Date of Last Payment $ 61,250.00 $ 313,750.00 $1,543.46 $ 234.38 $ $1,777.84 10/1/2046 qattachments_47c76174eb73abf0abe0d117dc2ba0cb1f86fd19.xlsx Payment List Type Negotiated Cost of House NCH Additional Down Payment ADP Date of First Payment DFP Credit Rating CR Property Tax Rate PTR Down Payment to Avoid PMI DPAP PMI Rate PMIR Term of Loan in Years TLY # of Payments Per Year PPY Exellent Credit Down PaymentEDP Good Credit Down Payment GDP Fair Credit Down Payment FDP Poor Credit Down Payment PDP Exellent Credit APR EAPR Good Credit APR GAPR Fair Credit APR FAPR Poor Credit APR PAPR APR Based on Credit Rating APRBCR Min Down Payment Required MDPR Annual Property Tax APT Annual PMI AP Total Down Payment TDP Amount of the Loan AL Monthly Payment (P&I) MP Monthly Property Tax MPT Monthly PMI MPMI DOU2128397, Doug Kurzinski, 36512 qattachments_47c76174eb73abf0abe0d117dc2ba0cb1f86fd19.xlsx Range Names