Please help with questions #3,4,5

3) Click in cell E3 and enter the formula to compute the required down payment amount, which is found by multiplying the percentage rate for the down payment times the selling price of the home. The percentage rate for the down payment depends on the term of the loan, so you will need to use the VLOOKUP function to determine the correct percentage. 4) Complete the formulas in row 3. The amount to be financed is the selling price minus the down payment. The monthly payment is computed using the PMT function. Copy the row 3 formulas to the rows for the other customers. 5) Enter the appropriate functions to compute the summary statistics at the bottom of the worksheet in cells C19 through C23