• Determine the Mortgage Rate to be applied to each client based on their Credit Score using the V-Lookup function.

Determine the Mortgage Rate to be applied to each client based on their Credit Score using the V-Lookup function. Format the rate to the percentage format with 2 digits to the right of the decimal. Save the file and submit assignment through the drop box. Save OFF Mortg Home Insert Draw Page Layout Formulas Data Review Calibri (Body) V 11 V AP V Paste U V D3 fx | B D E F G Mortgage Rate Credit Score Loan Amount 420 550 380 750 800 775 680 480 $ $ 350,000 $ 800,000 $ 1,000,000 $ 650,000 $ 300,000 $ 425,000 $ 250,000 1 Client 2 3 Avery Adams 4 Billy Borrower 5 Dee Denver 6 Jane Jackson 7 Gonzalo Juarez 8 Lisa Lenkov 9 Jen Li 10 Lizzie Windsor 11 12 13 Lookup Table 14 850+ 15 800-849 16 750-799 17 700-749 18 650-699 19 600-649 20 550-599 21 500-549 22 450-499 23 400-449 24 350-399 25 300-349 26 0-299 27 28 29 30 31 32 33 2.50% 2.75% 3.00% 3.25% 3.50% 3.75% 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50%