Calculate Cost, Annual Total, and Total Due

You are ready to calculate the requested information in columns $J$ through $M.$

a$.$ Insert a lookup function in cell J$6$ to display the down payment requirement for the first client.

b$.$ Format this value using the appropriate style with no decimal places.

c$.$ Use an IF function in cell $K6$ that reflects the down payment is waived for existing customers. For clients who are not existing customers, the amount shown is the value of the proposed loan times the answer from the previous step.

d$.$ Insert a lookup function in cell L$6$ that displays the length of the loan based on the type of loan.