{ "cells": [ { "attachments": {}, "cell_type": "markdown", "id": "41b4ea8e", "metadata": {}, "source": [ "#
\n", " | accountno | \n", "year | \n", "make | \n", "model | \n", "vin | \n", "odometer | \n", "saledate | \n", "typedeal | \n", "apr | \n", "currentbalance | \n", "amttofinance | \n", "firstpayduedate | \n", "paymentamount | \n", "lastpayamount | \n", "down | \n", "nextpaymentdate | \n", "lastpaymentdate | \n", "numberofpayments | \n", "paymentterms | \n", "paymentperiod | \n", "numbertradins | \n", "openbalance | \n", "totalsaleprice | \n", "totalofpayments | \n", "tradein | \n", "tradeacv | \n", "tradepayoff | \n", "financecharge | \n", "princollected | \n", "intcollected | \n", "saleno | \n", "address | \n", "city | \n", "state | \n", "zip | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1014 | \n", "11504 | \n", "2003-01-01 | \n", "HONDA | \n", "ODYSSEY EX WAGO | \n", "5FNRL18613B027243 | \n", "107188 | \n", "2012-02-11 | \n", "BP | \n", "9.9 | \n", "0.00 | \n", "8309.58 | \n", "2012-03-01 | \n", "146.16 | \n", "0.0 | \n", "1000.0 | \n", "2014-08-01 | \n", "2014-12-31 | \n", "65 | \n", "65 SEMI-MONTHLY | \n", "SEMI-MONTHLY | \n", "1 | \n", "10500.40 | \n", "13000.40 | \n", "10500.40 | \n", "1500.0 | \n", "0 | \n", "0.0 | \n", "1190.82 | \n", "7334.16 | \n", "1176.26 | \n", "539 | \n", "512 SPRINGWATER DR | \n", "NORCROSS | \n", "GA | \n", "30093 | \n", "
1758 | \n", "14259 | \n", "2008-01-01 | \n", "Nissan | \n", "Rogue | \n", "JN8AS58V38W412146 | \n", "131041 | \n", "2016-09-26 | \n", "BP | \n", "29.8 | \n", "4936.78 | \n", "11115.75 | \n", "2016-10-08 | \n", "206.46 | \n", "0.0 | \n", "600.0 | \n", "2017-07-01 | \n", "2017-05-08 | \n", "84 | \n", "84 BI-WEEKLY | \n", "BI-WEEKLY | \n", "1 | \n", "17342.64 | \n", "18942.64 | \n", "17342.64 | \n", "1000.0 | \n", "0 | \n", "0.0 | \n", "6226.89 | \n", "1186.86 | \n", "2160.14 | \n", "1539 | \n", "4493 LAWRENCEVILLE HWY | \n", "Tucker | \n", "GA | \n", "30084- | \n", "
3880 | \n", "16904 | \n", "2014-01-01 | \n", "Dodge | \n", "Avenger | \n", "1C3CDZCB5EN117364 | \n", "0 | \n", "2021-05-17 | \n", "BS | \n", "29.8 | \n", "5148.54 | \n", "11363.38 | \n", "2021-06-03 | \n", "221.70 | \n", "0.0 | \n", "2000.0 | \n", "2021-09-09 | \n", "2021-08-31 | \n", "78 | \n", "78 BI-WEEKLY | \n", "BI-WEEKLY | \n", "0 | \n", "11363.38 | \n", "19292.60 | \n", "17292.60 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "5929.22 | \n", "552.34 | \n", "966.86 | \n", "5117 | \n", "97 TREEVIEW LN | \n", "Lithonia | \n", "GA | \n", "30038- | \n", "