I need help with creating a formula for Strata 3 and Strata 4 on the excel spreasheet.

YouDriveOut: The conversation The scene: Executives at YouDriveOut, a chain of used car lots, are brainstorming about how to ensure consistent financial performance. Alicia is the CFO, and Manuel is the Controller. Alicia Manuel, I'm thinking about switching our minimum credit score cutoff from 430 to 450 to improve our overall loan performance, that is, to increase the proportion of payments that our customers make on loans. Manuel You want me to compare the loan default rates for these? Alicia Yes, that's the idea. Manuel Any particular format? Alicia No, but whatever you create should show the difference in overall loan performance with the sales impact for the two cutoff numbers. And be sure to do the analysis by dealer with the dealer street address. Pivot tables could be useful. It would also be helpful to see the analysis by vehicle category. YouDriveOut: Credit score cutoff analysis Required: 1 Download the data file (creditScore.xlsx) and this Web page (creditScore.htm). 2 Launch Word and open the creditScore.htm file in Word. Save the file as a Word document with the name creditScoreLastnameFirstname where LastnameFirstname identifies you. 3 Plan the analysis by responding to the following steps and questions based on the conversation. Put responses in the Response column. Response a State the overall objective of the analysis. b Identify assumptions embedded in the conversation. c Verify that attributes required for the analysis are available in creditScore.xlsx. Data definitions for the attributes are available in Table 1. -Loan performances a function of credit scores -Eliminating loans below 450 words not appreciably decreases sales -Lowest credit score is 430 d Based on credit score values, which set of loans should be compared to which other set of loans? e Decide the use of each attribute in the analysis. That is, how is each attribute relevant to the analysis? f Scan the data values to find outliers or other situations at odds with assumptions embedded in the conversation. g Specify formulas (spreadsheet) for new variables to be constructed from the attributes supplied in the file creditScore.xlsx. To find Web-hosted explanations of specific functions and operations, search the Web. In each search, include the version number of the program, e.g.: Excel 2013 pivot tables. h If you had your choice of spreadsheet modeling or database querying, which would you choose and why? 4 Use your responses in the first requirement to guide an analysis in a spreadsheet that compares the loan performance for the two cutoff points for the loans in the file (creditScore.xlsx). Use 9/1/2013 as the reporting date. 5 Answer practice questions about the spreadsheet operations, which may give clues about specific operations. 6 Upload this file (creditScoreLastnameFirstname) with your responses to the drop box in Brightspace. The quiz will not be available to you until you upload the file to the drop box. 7 Answer quiz questions about the credit score analysis at the scheduled time. 8 After learning to query databases in Microsoft Access, create the analysis in Access: a Import the data (loan, dealer, sales, and acquisitions sheets) into a database manager. For information about data types, see the note at the bottom of Table 1. b Perform the analysis. c Compare results from the spreadsheet and querying. Copyright 2011-2015 A. Faye Borthick, Gary P. Schneider, and Terese R. Viscelli. Atlanta, Georgia, USA. All rights reserved. February 4, 2016 Cut Off Dat 9/1/2013 loanID dealerID loanAmountdownPaymentloanDate monthlyPaymentnumberPaymentspaymentsMadecreditScore Strata3 Strata4 pymtsforCu 1536 2 5000 5000 4/15/2012 250 36 16 500 16 1539 1 7000 3000 4/17/2012 280 36 15 435 16 1542 2 7000 3000 4/19/2012 280 36 15 430 16 1545 1 5000 5000 4/20/2012 250 36 17 500 16 1548 2 7000 500 4/23/2012 275 36 17 450 16 1551 1 3000 500 4/25/2012 205 24 11 440 16 1554 2 5000 5000 4/28/2012 250 36 15 455 16 1557 3 3000 500 4/30/2012 205 24 14 460 16 1560 2 4000 500 5/3/2012 230 30 15 550 15 1563 2 7000 500 5/4/2012 275 36 15 450 15 1566 1 6000 3000 5/8/2012 250 36 16 445 15 1569 2 6000 3000 5/9/2012 250 36 17 495 15 1572 1 3000 500 5/11/2012 200 24 11 435 15 1575 2 7000 500 5/14/2012 275 36 15 450 15 1578 3 6000 3000 5/18/2012 250 36 14 445 15 1581 2 4000 2000 5/19/2012 250 24 15 430 15 1584 1 4000 2000 5/22/2012 250 24 15 430 15 1587 2 5000 2000 5/23/2012 310 24 15 480 15 1590 3 3000 3000 5/26/2012 180 30 16 425 15 1593 2 5000 2000 5/28/2012 310 24 14 450 15 1596 3 3000 3000 5/31/2012 175 30 15 425 15 1599 1 5000 2000 5/31/2012 310 24 13 465 15 1602 3 4000 2000 6/2/2012 250 24 14 425 14 1605 2 6500 500 6/4/2012 375 30 14 450 14 1608 3 3000 3000 6/8/2012 170 30 15 425 14 1611 1 4000 500 6/10/2012 225 30 13 480 14 1614 2 4000 500 6/11/2012 220 30 12 550 14 1617 1 6500 500 6/14/2012 375 30 15 475 14 1620 2 6000 500 6/17/2012 340 30 14 460 14 1621 3 7000 3000 6/19/2012 280 36 9 435 14 1623 2 7000 3000 6/20/2012 280 36 14 435 14 1626 3 5000 5000 6/21/2012 250 36 14 500 14 1629 2 7000 3000 6/25/2012 280 36 9 435 14 1632 1 7000 3000 6/28/2012 280 36 14 430 14 1635 2 5000 5000 6/29/2012 250 36 14 500 14 1638 2 7000 500 6/30/2012 275 36 13 450 14 1641 3 3000 500 7/2/2012 190 24 12 440 13 1644 1 5000 5000 7/2/2012 250 36 12 500 13 1647 2 3000 500 7/3/2012 195 24 11 440 13 1650 1 4000 500 7/5/2012 230 30 12 550 13 1653 3 7000 500 7/7/2012 275 36 11 465 13 1656 2 6000 3000 7/10/2012 250 36 11 445 13 1659 2 6000 3000 7/13/2012 250 36 14 445 13 1662 1 3000 500 7/14/2012 200 24 9 435 13 1665 2 7000 500 7/17/2012 275 36 12 470 13 1668 2 6000 3000 7/18/2012 250 36 13 445 13 1671 3 4000 2000 7/20/2012 250 24 12 430 13 1674 2 4000 2000 7/22/2012 250 24 12 430 13 1677 3 5000 2000 7/24/2012 310 24 12 450 13 1680 2 3000 3000 7/27/2012 170 30 10 425 13 1683 3 5000 2000 7/30/2012 310 24 13 485 13 1686 1 3000 3000 7/31/2012 165 30 11 425 13 1689 3 5000 2000 8/2/2012 310 24 11 450 12 1692 2 4000 2000 8/4/2012 250 24 11 425 12 1695 3 6500 500 8/5/2012 375 30 11 450 12 1698 2 3000 3000 8/7/2012 170 30 11 425 12 1701 1 4000 500 8/10/2012 230 30 12 550 12 1704 2 4000 500 8/12/2012 240 30 12 495 12 1707 1710 1713 1716 1719 1722 1725 1728 1731 1734 1737 1740 1743 1746 1749 1752 1755 1758 1761 1764 1767 1770 1773 1776 1779 1782 1785 1788 1791 1794 1797 1800 1803 1806 1809 1812 1815 1818 1821 1824 1827 1830 1833 1836 1839 1842 1845 1848 1851 1854 1857 1860 1863 1866 1869 1872 1875 1878 1881 1884 3 3 2 3 3 1 2 1 2 1 2 3 1 2 1 3 2 2 1 3 3 2 3 2 3 1 3 2 1 2 1 3 2 3 3 2 1 2 1 1 2 3 1 2 3 3 1 3 3 2 3 1 3 3 3 2 3 1 2 1 6500 6000 7000 5000 7000 7000 5000 7000 3000 5000 3000 4000 7000 6000 6000 3000 7000 6000 4000 4000 5000 3000 5000 3000 5000 4000 6500 3000 4000 4000 6500 6000 7000 5000 7000 7000 5000 7000 3000 5000 3000 4000 7000 6000 6000 3000 7000 6000 4000 4000 5000 3000 5000 3000 5000 4000 6500 3000 4000 4000 500 500 3000 5000 3000 3000 5000 500 500 5000 500 500 500 3000 3000 500 500 3000 2000 2000 2000 3000 2000 3000 2000 2000 500 3000 500 500 500 500 3000 5000 3000 3000 5000 500 500 5000 500 500 500 3000 3000 500 500 3000 2000 2000 2000 3000 2000 3000 2000 2000 500 3000 500 500 8/13/2012 8/16/2012 8/19/2012 8/21/2012 8/25/2012 8/26/2012 8/30/2012 9/3/2012 9/5/2012 9/6/2012 9/7/2012 9/9/2012 9/11/2012 9/12/2012 9/13/2012 9/14/2012 9/15/2012 9/18/2012 9/20/2012 9/23/2012 9/26/2012 9/28/2012 9/30/2012 10/2/2012 10/3/2012 10/4/2012 10/6/2012 10/7/2012 10/9/2012 10/11/2012 10/12/2012 10/14/2012 10/16/2012 10/18/2012 10/19/2012 10/21/2012 10/23/2012 10/26/2012 10/28/2012 10/31/2012 11/2/2012 11/5/2012 11/6/2012 11/7/2012 11/9/2012 11/12/2012 11/15/2012 11/16/2012 11/17/2012 11/20/2012 11/22/2012 11/25/2012 11/29/2012 11/30/2012 12/2/2012 12/4/2012 12/7/2012 12/8/2012 12/9/2012 12/12/2012 375 330 280 250 280 280 250 275 190 250 185 225 275 250 250 180 275 250 250 250 310 175 310 170 310 250 375 165 205 200 375 320 280 250 280 280 250 275 180 250 175 205 275 250 250 175 275 250 250 250 310 165 310 170 310 250 375 165 210 215 30 30 36 36 36 36 36 36 24 36 24 30 36 36 36 24 36 36 24 24 24 30 24 30 24 24 30 30 30 30 30 30 36 36 36 36 36 36 24 36 24 30 36 36 36 24 36 36 24 24 24 30 24 30 24 24 30 30 30 30 12 12 9 12 12 9 11 12 11 10 8 10 8 11 11 9 9 12 11 11 11 10 10 10 9 9 10 8 9 9 10 10 7 10 10 9 9 10 9 10 9 9 9 6 9 7 9 8 8 5 8 8 9 9 7 6 8 6 8 8 460 450 435 500 435 430 500 450 440 455 440 550 450 445 495 435 450 445 430 430 470 425 450 425 465 425 450 425 480 550 475 450 435 500 435 430 500 450 440 455 460 550 450 445 495 435 450 445 430 430 470 425 450 425 465 425 450 425 480 550 12 12 12 12 12 12 12 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 9 9 9 9 9 9 9 9 9 9 9 9 9 9 8 8 8 8 8 8 1887 1890 1893 1896 1899 1902 1905 1908 1911 1914 1917 1920 1923 1926 1929 1932 1935 1938 1941 1944 1947 1950 1953 1956 1959 1962 1965 1968 1971 1974 1977 1980 2 3 2 1 2 1 2 1 2 3 2 2 1 2 1 2 3 2 1 2 3 2 3 1 3 2 3 1 2 1 2 2 6500 6000 7000 5000 7000 7000 5000 7000 3000 5000 3000 4000 7000 6000 6000 3000 7000 6000 4000 4000 5000 3000 5000 3000 5000 4000 6500 3000 4000 4000 6500 6000 500 500 3000 5000 3000 3000 5000 500 500 5000 500 500 500 3000 3000 500 500 3000 2000 2000 2000 3000 2000 3000 2000 2000 500 3000 500 500 500 500 12/13/2012 12/14/2012 12/15/2012 12/16/2012 12/19/2012 12/20/2012 12/26/2012 12/27/2012 12/31/2012 1/2/2013 1/3/2013 1/5/2013 1/6/2013 1/8/2013 1/10/2013 1/13/2013 1/14/2013 1/16/2013 1/18/2013 1/21/2013 1/25/2013 1/28/2013 1/30/2013 2/2/2013 2/3/2013 2/5/2013 2/8/2013 2/9/2013 2/10/2013 2/12/2013 2/13/2013 2/13/2013 375 325 280 250 280 280 250 275 195 250 165 200 275 250 250 195 275 250 250 250 310 160 310 180 310 250 375 170 195 200 375 325 30 30 36 36 36 36 36 36 24 36 24 30 36 36 36 24 36 36 24 24 24 30 24 30 24 24 30 30 30 30 30 30 8 7 7 8 6 6 8 7 5 7 7 7 7 7 6 3 7 8 5 5 6 6 7 5 5 5 6 5 6 6 6 6 475 450 435 500 435 430 500 450 440 455 460 550 450 445 495 435 450 445 430 430 480 425 450 425 465 425 450 425 480 550 475 460 8 8 8 8 8 8 8 8 8 7 7 7 7 7 7 7 7 7 7 7 7 7 7 6 6 6 6 6 6 6 6 6 loanCurencvehiclePricProportionDown 1 10000 0.5 0.9375 10000 0.3 0.9375 10000 0.3 1 10000 0.5 1 7500 0.066667 0.6875 3500 0.142857 0.9375 10000 0.5 0.875 3500 0.142857 1 4500 0.111111 1 7500 0.066667 1 9000 0.333333 1 9000 0.333333 0.733333 3500 0.142857 1 7500 0.066667 0.933333 9000 0.333333 1 6000 0.333333 1 6000 0.333333 1 7000 0.285714 1 6000 0.5 0.933333 7000 0.285714 1 6000 0.5 0.866667 7000 0.285714 1 6000 0.333333 1 7000 0.071429 1 6000 0.5 0.928571 4500 0.111111 0.857143 4500 0.111111 1 7000 0.071429 1 6500 0.076923 0.642857 10000 0.3 1 10000 0.3 1 10000 0.5 0.642857 10000 0.3 1 10000 0.3 1 10000 0.5 0.928571 7500 0.066667 0.923077 3500 0.142857 0.923077 10000 0.5 0.846154 3500 0.142857 0.923077 4500 0.111111 0.846154 7500 0.066667 0.846154 9000 0.333333 1 9000 0.333333 0.692308 3500 0.142857 0.923077 7500 0.066667 1 9000 0.333333 0.923077 6000 0.333333 0.923077 6000 0.333333 0.923077 7000 0.285714 0.769231 6000 0.5 1 7000 0.285714 0.846154 6000 0.5 0.916667 7000 0.285714 0.916667 6000 0.333333 0.916667 7000 0.071429 0.916667 6000 0.5 1 4500 0.111111 1 4500 0.111111 1 1 0.75 1 1 0.75 0.916667 1 1 0.909091 0.727273 0.909091 0.727273 1 1 0.818182 0.818182 1 1 1 1 0.909091 0.909091 1 0.9 0.9 1 0.8 0.9 0.9 1 1 0.7 1 1 0.9 0.9 1 0.9 1 1 1 1 0.666667 1 0.777778 1 0.888889 0.888889 0.555556 0.888889 0.888889 1 1 0.875 0.75 1 0.75 1 1 7000 6500 10000 10000 10000 10000 10000 7500 3500 10000 3500 4500 7500 9000 9000 3500 7500 9000 6000 6000 7000 6000 7000 6000 7000 6000 7000 6000 4500 4500 7000 6500 10000 10000 10000 10000 10000 7500 3500 10000 3500 4500 7500 9000 9000 3500 7500 9000 6000 6000 7000 6000 7000 6000 7000 6000 7000 6000 4500 4500 0.071429 0.076923 0.3 0.5 0.3 0.3 0.5 0.066667 0.142857 0.5 0.142857 0.111111 0.066667 0.333333 0.333333 0.142857 0.066667 0.333333 0.333333 0.333333 0.285714 0.5 0.285714 0.5 0.285714 0.333333 0.071429 0.5 0.111111 0.111111 0.071429 0.076923 0.3 0.5 0.3 0.3 0.5 0.066667 0.142857 0.5 0.142857 0.111111 0.066667 0.333333 0.333333 0.142857 0.066667 0.333333 0.333333 0.333333 0.285714 0.5 0.285714 0.5 0.285714 0.333333 0.071429 0.5 0.111111 0.111111 1 0.875 0.875 1 0.75 0.75 1 0.875 0.625 1 1 1 1 1 0.857143 0.428571 1 1 0.714286 0.714286 0.857143 0.857143 1 0.833333 0.833333 0.833333 1 0.833333 1 1 1 1 7000 6500 10000 10000 10000 10000 10000 7500 3500 10000 3500 4500 7500 9000 9000 3500 7500 9000 6000 6000 7000 6000 7000 6000 7000 6000 7000 6000 4500 4500 7000 6500 0.071429 0.076923 0.3 0.5 0.3 0.3 0.5 0.066667 0.142857 0.5 0.142857 0.111111 0.066667 0.333333 0.333333 0.142857 0.066667 0.333333 0.333333 0.333333 0.285714 0.5 0.285714 0.5 0.285714 0.333333 0.071429 0.5 0.111111 0.111111 0.071429 0.076923 dealerID name 1 YouDriveOut1 2 YouDriveOut2 3 YouDriveOut3 street 2500 Camino Way 2390 Sassafras Blvd 6700 Oriental Pky vehicleID saleDate saleDealerID loanID 54123 4/20/2012 1 1545 54130 4/28/2012 2 1554 54137 5/26/2012 3 1590 54144 6/1/2012 1 1599 54151 7/5/2012 1 1650 54158 7/18/2012 2 1668 54165 7/20/2012 3 1671 54172 6/20/2012 2 1623 54179 7/24/2012 3 1677 54186 7/1/2012 3 1641 54193 6/2/2012 3 1602 54200 5/11/2012 1 1572 54207 7/27/2012 2 1680 54214 5/28/2012 2 1593 54221 4/30/2012 3 1557 54228 5/3/2012 2 1560 54235 7/2/2012 1 1644 54242 6/21/2012 3 1626 54249 5/14/2012 2 1575 54256 7/22/2012 2 1674 54263 7/3/2012 2 1647 54270 6/25/2012 2 1629 54277 4/23/2012 2 1548 54284 4/25/2012 1 1551 54291 7/7/2012 3 1653 54298 7/30/2012 3 1683 54305 7/10/2012 2 1656 54312 5/31/2012 3 1596 54319 5/18/2012 3 1578 54326 8/5/2012 3 1695 54333 8/7/2012 2 1698 54340 8/10/2012 1 1701 54347 8/26/2012 1 1722 54354 7/13/2012 2 1659 54361 6/28/2012 1 1632 54368 10/1/2012 2 1776 54375 8/19/2012 2 1713 54382 8/30/2012 2 1725 54389 7/14/2012 1 1662 54396 7/31/2012 1 1686 54403 7/17/2012 2 1665 54410 6/4/2012 2 1605 54417 5/4/2012 2 1563 54424 5/19/2012 2 1581 54431 1/1/1900 3 1689 54438 6/29/2012 2 1635 54445 6/8/2012 3 1608 54452 8/21/2012 3 1716 54459 8/12/2012 2 1704 54466 10/3/2012 3 1779 54473 5/8/2012 1 1566 54480 5/22/2012 1 1584 54487 6/10/2012 1 1611 54494 8/13/2012 3 1707 54501 9/3/2012 1 1728 54508 8/25/2012 3 1719 54515 5/23/2012 2 1587 54522 6/11/2012 2 1614 54529 5/9/2012 2 1569 54536 54543 54550 54557 54564 54571 54578 54585 54592 54599 54606 54613 54620 54627 54634 54641 54648 54655 54662 54669 54676 54683 54690 54697 54704 54711 54718 54725 54732 54739 54746 54753 54760 54767 54774 54781 54788 54795 54802 54809 54816 54823 54830 54837 54844 54851 54858 54865 54872 54879 54893 54900 54907 54914 54921 54928 54935 54949 54956 54963 6/14/2012 10/4/2012 8/16/2012 6/30/2012 6/17/2012 10/6/2012 9/18/2012 10/7/2012 9/13/2012 10/16/2012 10/18/2012 9/26/2012 9/5/2012 9/28/2012 9/6/2012 9/30/2012 9/14/2012 10/19/2012 9/9/2012 9/7/2012 8/4/2012 10/9/2012 9/11/2012 9/12/2012 9/15/2012 10/28/2012 9/20/2012 10/31/2012 9/23/2012 11/2/2012 12/8/2012 10/11/2012 12/9/2012 1/25/2013 11/5/2012 1/28/2013 11/6/2012 1/13/2013 11/12/2012 11/7/2012 11/15/2012 4/15/2012 4/17/2012 6/19/2012 10/21/2012 11/16/2012 12/12/2012 10/12/2012 1/14/2013 1/30/2013 10/23/2012 6/19/2012 11/9/2012 11/22/2012 10/26/2012 1/16/2013 10/14/2012 11/25/2012 2/8/2013 1/6/2013 1 1 3 2 2 3 2 2 1 2 3 3 2 2 1 3 3 3 3 2 2 1 1 2 2 1 1 1 3 2 1 2 2 3 3 2 1 2 3 2 1 2 1 3 2 3 1 1 3 3 1 2 3 3 2 2 3 1 3 1 1617 1782 1710 1638 1620 1785 1758 1788 1749 1803 1806 1767 1731 1770 1734 1773 1752 1809 1740 1737 1692 1791 1743 1746 1755 1821 1761 1824 1764 1827 1878 1794 1881 1947 1830 1950 1833 1932 1842 1836 1845 1536 1539 1621 1812 1848 1884 1797 1935 1953 1815 1542 1839 1857 1818 1938 1800 1860 1965 1923 54977 54984 54991 54998 55005 55019 55026 55033 55040 55047 55061 55068 55075 55089 55096 55103 55117 55124 55138 55152 55159 55257 55306 55320 55334 55341 55390 55397 55418 55432 55439 11/30/2012 12/2/2012 1/8/2013 2/2/2013 12/4/2012 12/7/2012 12/16/2012 2/3/2013 1/10/2013 2/5/2013 12/19/2012 1/18/2013 12/20/2012 12/13/2012 2/9/2013 12/14/2012 1/21/2013 11/17/2012 12/15/2012 11/29/2012 11/20/2012 1/2/2013 1/3/2013 12/26/2012 1/5/2013 2/10/2013 12/27/2012 2/12/2013 12/31/2012 2/13/2013 2/13/2013 3 3 2 1 2 3 1 3 1 2 2 1 1 2 1 3 2 3 2 3 2 3 2 2 2 2 1 1 2 2 2 1866 1869 1926 1956 1872 1875 1896 1959 1929 1962 1899 1941 1902 1887 1968 1890 1944 1851 1893 1863 1854 1914 1917 1905 1920 1971 1908 1974 1911 1977 1980 vehicleID acquireDate category cost make 54123 4/11/2012 SUV $1,500 GMC 54130 4/11/2012 truck $3,000 Chevrolet 54137 4/11/2012 truck $3,000 Chevrolet 54144 4/11/2012 hybrid $4,000 Honda 54151 4/11/2012 truck $3,000 Chevrolet 54158 4/11/2012 sedan $6,000 Honda 54165 4/11/2012 sedan $5,500 Chrysler 54172 4/11/2012 SUV $6,500 Mercury 54179 4/11/2012 sedan $5,000 Chrysler 54186 4/11/2012 hybrid $4,000 Honda 54193 4/11/2012 sedan $6,000 Honda 54200 4/11/2012 SUV $5,000 Ford 54207 4/11/2012 sedan $6,500 VW 54214 4/11/2012 truck $4,500 GMC 54221 4/11/2012 SUV $3,000 Chevrolet 54228 4/11/2012 truck $5,000 Chevrolet 54235 4/11/2012 sedan $5,500 Honda 54242 4/11/2012 sedan $5,000 Chrysler 54249 4/11/2012 SUV $1,500 GMC 54256 4/11/2012 sedan $7,000 Chevrolet 54263 4/11/2012 hybrid $8,500 Honda 54270 4/11/2012 sedan $3,500 Cadillac 54277 4/11/2012 SUV $7,500 Honda 54284 4/11/2012 sedan $6,000 Honda 54291 4/11/2012 truck $2,000 Ford 54298 4/11/2012 sedan $2,500 Cadillac 54305 4/11/2012 SUV $2,000 GMC 54312 4/11/2012 truck $1,500 Chevrolet 54319 4/11/2012 SUV $6,500 Mercury 54326 4/25/2012 sedan $3,000 Mercury 54333 4/25/2012 hybrid $4,000 Honda 54340 4/25/2012 sedan $6,500 VW 54347 4/25/2012 sedan $5,500 Chrysler 54354 4/25/2012 sedan $4,000 Ford 54361 4/25/2012 truck $3,000 Chevrolet 54368 4/25/2012 truck $5,000 Chevrolet 54375 4/25/2012 sedan $1,500 Chevrolet 54382 4/25/2012 sedan $6,000 Honda 54389 4/25/2012 sedan $7,500 VW 54396 4/25/2012 truck $4,000 GMC 54403 4/25/2012 sedan $3,500 Cadillac 54410 4/25/2012 truck $2,500 Ford 54417 4/25/2012 SUV $6,500 Cadillac 54424 4/25/2012 SUV $9,000 Chevrolet 54431 4/25/2012 truck $2,000 Chevrolet 54438 4/25/2012 SUV $6,500 Cadillac 54445 4/25/2012 SUV $5,000 Ford 54452 4/25/2012 sedan $3,500 Acura 54459 4/25/2012 sedan $7,000 Chevrolet 54466 4/25/2012 truck $2,000 Chevrolet 54473 4/25/2012 SUV $2,500 Chevrolet 54480 4/25/2012 sedan $1,000 Chevrolet 54487 4/25/2012 truck $4,000 GMC 54494 4/25/2012 sedan $7,000 Acura 54501 4/25/2012 hybrid $8,500 Honda 54508 4/25/2012 sedan $5,500 Honda 54515 4/25/2012 sedan $4,000 Acura 54522 4/25/2012 sedan $3,500 Ford 54529 4/25/2012 SUV $4,000 GMC model Jimmy S-10 S-10 Civic S-10 Accord 300 Mountaineer 300 Civic Civic Explorer Jetta Sierra 1500 Blazer Silverado Accord 300 Jimmy Impala Accord Catera CR-V Accord F150 DeVille Jimmy C/K 1500 Mountaineer Grand Marquis Civic Jetta 300 Taurus S-10 Silverado Caprice Civic Jetta Sierra 1500 Catera F150 Escalade Equinox C/K 1500 Escalade Explorer Integra Impala C/K 1500 Blazer Caprice Sierra 1500 RL Accord Civic Integra Taurus Envoy year 2000 2003 2003 2001 2003 2006 2005 2005 2004 2001 2007 2005 2007 2005 2004 2007 2005 2004 2000 2007 2006 2002 2006 2006 2000 2000 2002 1998 2005 2003 2001 2007 2005 2005 2003 2007 1999 2007 2008 2004 2002 2001 2002 2007 2000 2002 2005 2000 2007 2000 2003 1996 2004 2004 2006 2006 2001 2004 2002 54536 54543 54550 54557 54564 54571 54578 54585 54592 54599 54606 54613 54620 54627 54634 54641 54648 54655 54662 54669 54676 54683 54690 54697 54704 54711 54718 54725 54732 54739 54746 54753 54760 54767 54774 54781 54788 54795 54802 54809 54816 54823 54830 54837 54844 54851 54858 54865 54872 54879 54886 54893 54900 54907 54914 54921 54928 54935 54942 54949 4/25/2012 sedan 4/25/2012 SUV 4/25/2012 sedan 4/25/2012 SUV 4/25/2012 SUV 5/10/2012 sedan 5/10/2012 SUV 5/10/2012 sedan 5/10/2012 sedan 5/10/2012 truck 5/10/2012 truck 5/10/2012 SUV 5/10/2012 sedan 5/10/2012 SUV 5/10/2012 sedan 5/10/2012 SUV 5/10/2012 sedan 5/10/2012 SUV 5/10/2012 sedan 5/10/2012 sedan 5/10/2012 hybrid 5/10/2012 hybrid 5/10/2012 sedan 5/10/2012 sedan 5/10/2012 hybrid 5/10/2012 truck 5/10/2012 sedan 5/10/2012 truck 5/10/2012 sedan 5/10/2012 SUV 5/26/2012 SUV 5/26/2012 SUV 5/26/2012 SUV 5/26/2012 SUV 5/26/2012 sedan 5/26/2012 SUV 5/26/2012 sedan 5/26/2012 sedan 5/26/2012 truck 5/26/2012 truck 5/26/2012 truck 5/26/2012 SUV 5/26/2012 SUV 5/26/2012 sedan 5/26/2012 SUV 5/26/2012 truck 5/26/2012 sedan 5/26/2012 SUV 5/26/2012 sedan 5/26/2012 sedan 5/26/2012 hybrid 5/26/2012 SUV 5/26/2012 sedan 5/26/2012 SUV 5/26/2012 sedan 5/26/2012 sedan 5/26/2012 hybrid 5/26/2012 SUV 5/26/2012 SUV 5/26/2012 sedan $7,000 Acura $5,500 Cadillac $7,000 Ford $6,500 Cadillac $5,000 Chevrolet $3,500 Chevrolet $5,500 Cadillac $3,500 Acura $7,000 Chrysler $4,500 GMC $1,500 Chevrolet $4,500 Chevrolet $6,500 VW $11,000 Chevrolet $7,000 Ford $2,000 GMC $6,000 Ford $7,500 Mercury $3,000 Cadillac $4,000 Ford $9,000 Ford $5,000 Honda $1,000 Chevrolet $5,000 Chevrolet $9,000 Ford $2,000 Ford $3,500 Acura $2,000 Ford $5,500 Honda $4,500 Ford $2,000 GMC $5,000 Chevrolet $4,000 GMC $7,500 Honda $3,500 Cadillac $5,000 Chevrolet $5,000 Chrysler $7,500 VW $2,500 Ford $4,000 GMC $6,000 Chevrolet $7,000 Honda $3,000 Chevrolet $1,000 Chevrolet $6,500 Mercury $2,500 Ford $7,000 Chrysler $11,000 Chevrolet $5,000 Chevrolet $6,000 Ford $8,000 Honda $7,000 Honda $2,500 Mercury $7,500 Mercury $3,000 Cadillac $3,000 Cadillac $6,500 Ford $5,500 Cadillac $7,500 Honda $7,000 Chevrolet RL Escalade Focus Escalade Suburban Aveo Escalade Integra Sebring Sierra 1500 C/K 1500 Suburban Jetta Equinox Focus Jimmy Focus Mountaineer Catera Taurus Escape Civic Caprice Impala Escape F150 Integra F150 Civic Explorer Jimmy Suburban Envoy CR-V Catera Suburban 300 Jetta F150 Sierra 1500 Silverado CR-V Blazer Caprice Mountaineer F150 Sebring Equinox Impala Focus Accord CR-V Grand Marquis Mountaineer DeVille DeVille Escape Escalade CR-V Impala 2004 2000 2008 2002 2003 2005 2000 2000 2008 2005 1998 2002 2007 2009 2008 2002 2007 2006 2001 2005 2005 2003 1996 2004 2005 2000 2000 2000 2006 2004 2002 2003 2002 2006 2002 2003 2004 2008 2001 2004 2008 2005 2004 1996 2005 2001 2008 2009 2004 2007 2005 2005 2002 2006 2001 2001 2002 2000 2006 2007 54956 54963 54970 54977 54984 54991 54998 55005 55012 55019 55026 55033 55040 55047 55054 55061 55068 55075 55082 55089 55096 55103 55110 55117 55124 55131 55138 55145 55152 55159 55166 55173 55180 55187 55194 55201 55208 55215 55222 55229 55236 55243 55250 55257 55264 55271 55278 55285 55292 55299 55306 55313 55320 55327 55334 55341 55348 55355 55362 55369 6/9/2012 truck 6/9/2012 sedan 6/9/2012 SUV 6/9/2012 SUV 6/9/2012 sedan 6/9/2012 hybrid 6/9/2012 SUV 6/9/2012 SUV 6/9/2012 truck 6/9/2012 sedan 6/9/2012 sedan 6/9/2012 SUV 6/9/2012 hybrid 6/9/2012 SUV 6/9/2012 sedan 6/9/2012 sedan 6/9/2012 sedan 6/9/2012 sedan 6/9/2012 sedan 6/9/2012 sedan 6/9/2012 truck 6/9/2012 sedan 6/9/2012 truck 6/9/2012 sedan 6/9/2012 SUV 6/9/2012 SUV 6/9/2012 sedan 6/9/2012 SUV 6/9/2012 SUV 6/9/2012 SUV 6/21/2012 sedan 6/21/2012 sedan 6/21/2012 sedan 6/21/2012 sedan 6/21/2012 sedan 6/21/2012 hybrid 6/21/2012 sedan 6/21/2012 sedan 6/21/2012 truck 6/21/2012 sedan 6/21/2012 sedan 6/21/2012 sedan 6/21/2012 sedan 6/21/2012 hybrid 6/21/2012 truck 6/21/2012 sedan 6/21/2012 sedan 6/21/2012 sedan 6/21/2012 sedan 6/21/2012 sedan 6/21/2012 sedan 6/21/2012 sedan 6/21/2012 hybrid 6/21/2012 SUV 6/21/2012 sedan 6/21/2012 hybrid 6/21/2012 truck 6/21/2012 SUV 6/21/2012 sedan 6/21/2012 SUV $6,000 Chevrolet $4,000 Ford $4,000 GMC $3,500 GMC $3,000 Mercury $5,000 Honda $9,000 Chevrolet $3,000 Chevrolet $5,000 Chevrolet $3,500 Ford $1,500 Chevrolet $4,500 Chevrolet $8,500 Ford $5,000 Ford $5,500 Chrysler $6,000 Ford $5,500 Honda $5,500 Honda $7,500 Acura $7,500 Acura $3,000 Chevrolet $5,500 Honda $6,000 Chevrolet $4,500 Chevrolet $4,500 Chevrolet $4,500 Ford $7,500 Acura $2,500 Chevrolet $11,000 Chevrolet $3,500 GMC $5,000 Chevrolet $2,500 Mercury $3,500 Ford $3,500 Chevrolet $4,500 Chevrolet $5,000 Honda $4,000 Acura $6,500 Chrysler $1,500 Chevrolet $3,500 Chevrolet $7,000 Chrysler $2,500 Cadillac $2,500 Cadillac $8,000 Honda $2,000 Chevrolet $6,000 Honda $7,000 Acura $4,500 Chevrolet $7,500 VW $7,000 Ford $3,000 Cadillac $6,000 Honda $8,500 Ford $7,000 Honda $3,000 Cadillac $8,500 Ford $4,500 GMC $3,500 GMC $3,000 Mercury $2,500 Chevrolet Silverado Taurus Envoy Envoy Grand Marquis Civic Equinox Blazer Silverado Taurus Caprice Suburban Escape Explorer 300 Focus Accord Civic RL RL S-10 Accord Silverado Aveo Suburban Explorer RL Blazer Equinox Envoy Impala Grand Marquis Taurus Aveo Aveo Civic Integra Sebring C/K 1500 Aveo Sebring DeVille DeVille Accord C/K 1500 Civic RL Aveo Jetta Focus Catera Accord Escape CR-V Catera Escape Sierra 1500 Envoy Grand Marquis Blazer 2008 2005 2002 2001 2003 2003 2007 2004 2007 2004 1999 2002 2004 2005 2005 2007 2005 2006 2005 2005 2003 2005 2008 2007 2002 2004 2005 2003 2009 2001 2004 2002 2004 2005 2007 2003 2001 2007 1998 2005 2008 2000 2000 2005 2000 2007 2004 2007 2008 2008 2001 2006 2004 2005 2001 2004 2005 2001 2003 2003 55376 55383 55390 55397 55404 55411 55418 55425 55432 55439 55446 55453 55460 6/21/2012 SUV 6/21/2012 sedan 6/21/2012 sedan 6/21/2012 SUV 6/21/2012 truck 6/21/2012 SUV 6/21/2012 sedan 6/21/2012 hybrid 6/21/2012 sedan 6/21/2012 sedan 6/21/2012 SUV 6/21/2012 sedan 6/21/2012 hybrid $4,500 Ford $1,500 Chevrolet $4,000 Acura $1,500 GMC $3,000 Chevrolet $7,500 Mercury $2,500 Mercury $8,500 Honda $6,500 Chrysler $3,000 Cadillac $9,000 Chevrolet $6,500 Chrysler $8,000 Honda Explorer Caprice Integra Jimmy S-10 Mountaineer Grand Marquis Accord Sebring DeVille Equinox Sebring Accord 2004 1999 2001 2000 2003 2006 2002 2006 2007 2001 2007 2007 2005