CarMax Interview Question

Using the table, how would you create a formula for loan approvals