In cell F4, enter a Lookup function to display the interest rate of the loan. The function should reference the borrowers credit rating and the table array in range A15:C18. Include the range_lookup argument to ensure an exact match.

In cell F5, insert a lookup function that uses the credit rating to determine the minimum down payment based on the table array A15:C18. Include the range_lookup argument to ensure an exact match. Multiply the function result by the negotiated cost of the vehicle.

F4 Auto Loan Calculator iate Calculations Based on Credit Rating 4 Negotiated Cost of Vehicle 35,000.00 S Additional Down Payment 5,000.00 6 Date of First Payment 7 Credit Ratin Min Down Payment 10/16/2017 Excellent Tax 9 Constants 10 Sales Tax Rate 11 Term of Loan in Years 12 # of Payments Per Year 13 14 Credit Down Payment 15 Excellent 16 Good 17 Fair 18 Poor 19 puts Total Down Payment Amount of the Loan Monthly Payment (P&I Monthly Sales Tax 12 APR Total Monthly Payment 3.25% 3.50% 4.25% 5.25% 23 25 30 32 35 EI -+ 100%