I need step by step instructions on how to complete this excel table.

Review View Tell me 101 Page Layout Formulas Data Calibri (Body 18-AA BIV O -A F x Mortgage Calculator General Paste A1 Conditions Forening Formats Tube Celties 5 -% 9 - 29.0 De 0. 2 7 Format - Stand 1 4 X de Sant Mortgage Calculator Additional Down Payment Payment Range Names DUTTUwers pay .5% private mortgage insurance (PMI) of the loan amount if they do not make at least a 20% down payment. A borrower's credit rating determines the required down payment percentage and APR. For example, a person with an excellent credit rating may make only a 5% down payment with a 3.25% APR loan. A per-son with a fair credit rating will make a 15% down payment and have a higher APR at 5.25%. Your worksheet needs to perform various calculations. The filled cells in column F indicate cells containing formulas, not values. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible Start Excel. Download and open the file named co2 grader_h3.xlsx 0.000 On the Payment worksheet, assign the range name Table to the range A17:C20. 0.000 In cell F4, enter a lookup function to calculate the APR Based on Credit Rating. Include the range_lookup argument to ensure an exact match. Use range names for the first two arguments in the function. 10.000 In cell F5, enter a lookup function and formula to calculate the Minimum Down Payment Required amount. Indude the range_lookup argument to ensure an exact match. Use range names for the first two arguments in the function and for calculation after the closing parenthesis. For example, a borrower who has an Excellent rating is required to pay a minimum of 5% down payment of the negotiated purchase price. Multiply the function results by the negotiated cost of the house 10.000 In cell F6, enter a formula to calculate the Annual Property Tax based on the negotiated cost of the house and the annual property tax rate. Use range names in the formula 6.000 In cell F10, enter a formula to calculate the Total Down Payment, which is sum of the required minimum down payment (calculated previously) and any additional down payment entered in the Inputs section. Use range names in the formula 4.000 5.000 In cell F11, enter a formula to calculate the Amount of the Loan, which is the difference between the negotiated cost of the house and the total down payment. Use range names in the formula In cell F7, enter an IF function to calculate the Annual PMI. If the borrower's total down payment (required and additional) is 20% or more of the negotiated purchase price (multiply the cost by the PMI avoidance percentage), PMI is zero. If the total down payment is less than 20%, the borrower has to pay PMI calculated by multiplying the amount of the loan by the PMI rate. Use range names whenever possible in the function 10.000 Review View Tell me 101 Page Layout Formulas Data Calibri (Body 18-AA BIV O -A F x Mortgage Calculator General Paste A1 Conditions Forening Formats Tube Celties 5 -% 9 - 29.0 De 0. 2 7 Format - Stand 1 4 X de Sant Mortgage Calculator Additional Down Payment Payment Range Names DUTTUwers pay .5% private mortgage insurance (PMI) of the loan amount if they do not make at least a 20% down payment. A borrower's credit rating determines the required down payment percentage and APR. For example, a person with an excellent credit rating may make only a 5% down payment with a 3.25% APR loan. A per-son with a fair credit rating will make a 15% down payment and have a higher APR at 5.25%. Your worksheet needs to perform various calculations. The filled cells in column F indicate cells containing formulas, not values. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible Start Excel. Download and open the file named co2 grader_h3.xlsx 0.000 On the Payment worksheet, assign the range name Table to the range A17:C20. 0.000 In cell F4, enter a lookup function to calculate the APR Based on Credit Rating. Include the range_lookup argument to ensure an exact match. Use range names for the first two arguments in the function. 10.000 In cell F5, enter a lookup function and formula to calculate the Minimum Down Payment Required amount. Indude the range_lookup argument to ensure an exact match. Use range names for the first two arguments in the function and for calculation after the closing parenthesis. For example, a borrower who has an Excellent rating is required to pay a minimum of 5% down payment of the negotiated purchase price. Multiply the function results by the negotiated cost of the house 10.000 In cell F6, enter a formula to calculate the Annual Property Tax based on the negotiated cost of the house and the annual property tax rate. Use range names in the formula 6.000 In cell F10, enter a formula to calculate the Total Down Payment, which is sum of the required minimum down payment (calculated previously) and any additional down payment entered in the Inputs section. Use range names in the formula 4.000 5.000 In cell F11, enter a formula to calculate the Amount of the Loan, which is the difference between the negotiated cost of the house and the total down payment. Use range names in the formula In cell F7, enter an IF function to calculate the Annual PMI. If the borrower's total down payment (required and additional) is 20% or more of the negotiated purchase price (multiply the cost by the PMI avoidance percentage), PMI is zero. If the total down payment is less than 20%, the borrower has to pay PMI calculated by multiplying the amount of the loan by the PMI rate. Use range names whenever possible in the function 10.000