Spreadsheet: 31298d1227110150-automatic-page-break-example-lead-template-w-formulas-
Sheet: November 2008 Example Leads

 | XYZ Company
Application # | Agreement # | Customer Name | CUST NUMBER | IL CUST | CUST ADDRESS | CUST CITY | CUST STATE | CUST ZIP | Customer phone | CUST FAX | SIC CODE | Lease signor | FIRST LEASE GUARANTOR | SECOND LEASE GUARANTOR | EQUIP DESC | ASSET SUPPLIER # | Vendor | DISC FLAG | BROKER OPT FLAG | End of lease option | Fund date | MATURITY DATE | Pymt Frequency | Original term | Agreement cost without tax | ORIGINAL COST | AMOUNT FINANCED | Pymts made | Pymt amount | LATE | 30 | 60 | 90 | SOURCE ID | PRIVATE LABEL | SOURCE | SOURCE ADDRESS | SOURCE CITY | SOURCE STATE | SOURCE ZIP CODE | SOURCE PHONE | SOURCE FAX | SUB SOURCE NAME | TERR | [NAME] | WrapProgram buyout quote | Amt that can be added with out changing pmt | Rates used | New term | New lease pymt when Wrapping $20K | Payment increase when Wrapping $20K | Pymt on new $20K lease | Total pymts with out Wrapping | Monthly cash flow saving when Wrapping $20K vs new lease
679285 | [PHONE]-000 | Customer 1 | 596309 | 784618 | STONY HILL GOLF 48 STONY HILL | BETHEL | CT | 06801 | [PHONE] |  | 8999 | [NAME] |  |  | MISC. INTANGIBLE | 523174 | ABC Company 1 | N | Y | SOURCE OWNED $101 | 2006-12-01 00:00:00 | 2009-03-01 00:00:00 | I |  | 3012 | 3012 | 860.64 |  |  | 0 | 0 | 0 | 0 | 562926 | N | XYZ Company | 710 ANY STREET | ANY CITY | FL | 99999 | [PHONE] | [PHONE] |  | FLORIDA | FL |  | No payment info. contract set-up with Irregular Pymts
703570 | [PHONE]-001 | Customer 2 | 631784 | 789537 | 142 CLUBHOUSE DRIVE | BRANSON | MO | 65616 | [PHONE] |  | 8999 | [NAME] |  |  | MISC. INTANGIBLE | 591105 | ABC Company 2 | N | N | EFA | 2006-12-22 00:00:00 | 2011-12-22 00:00:00 | I |  | 33781.36 | 33781.36 | 11705.84 |  |  | 0 | 0 | 0 | 0 | 562926 | N | XYZ Company | 711 ANY STREET | ANY CITY | FL | 99999 | [PHONE] | [PHONE] |  | FLORIDA | FL |  | No payment info. contract set-up with Irregular Pymts
601368 | [PHONE]-002 | Customer 3 | 488320 | 715057 | 9741 SW 168 TERRACE | MIAMI | FL | 33157 | [PHONE] |  | 5261 | [NAME] |  |  | MISC. LICENSE VEHICLES | 72827 | ABC Company 3 | N | N | EFA | 2006-03-17 00:00:00 | 2011-04-17 00:00:00 | M | 60 | 20456 | 20456 | 7457.8 | 30.14 | $465.23 | 8 | 0 | 0 | 0 | 478185 | N | JKL COMPANY | 1200 ANY STREET | ANY CITY | FL | 89999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 12480.69 | 6941.280626789905 | 1 | 60 | 778.035952122 | 312.805952122 | 479.076 | 944.306 | 166.270047878
760092 | [PHONE]-003 | Customer 4 | 701442 | 821625 | 2521 US HIGHWAY 27 | SEBRING | FL | 33870 | [PHONE] |  | 5812 | [NAME] |  |  | COMPUTER | 672534 | ABC Company 4 | N | N | $101 | 2007-05-02 00:00:00 | 2012-05-25 00:00:00 | M | 60 | 46880.63 | 46880.63 | 15434.77 | 16.00 | $1,038.59 | 19 | 2 | 0 | 0 | 478185 | N | JKL COMPANY | 1201 ANY STREET | ANY CITY | FL | 89999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 41746.36 | <$5,000 | 1 | 60 | 1471.520727612 | 432.9307276120001 | 479.076 | 1517.666 | 46.14527238799997
767943 | [PHONE]-004 | Customer 5 | 712979 | 827858 | 33 N GARDEN AVENUE | CLEARWATER | FL | 33755 | [PHONE] |  | 8111 | [NAME] |  |  | COMPUTER | 672534 | ABC Company 5 | N | N | $101 | 2007-05-30 00:00:00 | 2012-06-30 00:00:00 | M | 60 | 31213.95 | 31213.95 | 9825.45 | 16.00 | $683.99 | 0 | 0 | 0 | 0 | 478185 | N | JKL COMPANY | 1202 ANY STREET | ANY CITY | FL | 89999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 26967.18 | <$5,000 | 1 | 60 | 1125.042436284 | 441.0524362840001 | 479.076 | 1163.066 | 38.0235637159999
710426 | [PHONE]-005 | Customer 6 | 642286 | 794367 | 6690 NW 66 WAY | PARKLAND | FL | 33067 | [PHONE] |  | 5191 | [NAME] |  |  | FORKLIFTS | 644598 | ABC Company 6 | N | N | EFA | 2007-01-12 00:00:00 | 2012-03-12 00:00:00 | I |  | 41354 | 41354 | 12662.4 |  |  | 0 | 0 | 0 | 0 | 478185 | N | JKL COMPANY | 1203 ANY STREET | ANY CITY | FL | 89999 | [PHONE] | [PHONE] |  | FLORIDA | FL |  | No payment info. contract set-up with Irregular Pymts
722467 | [PHONE]-006 | Customer 7 | 659370 | 804972 | 4897 NO H UNIVERSITY DR | LAUDERHILL | FL | 33351 | [PHONE] |  | 7538 | [NAME] |  |  | INDUSTRIAL EQUIPMENT | 665450 | ABC Company 7 | N | N | PUT | 2007-02-28 00:00:00 | 2012-07-28 00:00:00 | I |  | 62509.47 | 67116.75 | 19476.45 |  |  | 0 | 0 | 0 | 0 | 478185 | N | JKL COMPANY | 1204 ANY STREET | ANY CITY | FL | 89999 | [PHONE] | [PHONE] |  | FLORIDA | FL |  | No payment info. contract set-up with Irregular Pymts
661609 | [PHONE]-007 | Customer 8 | 570968 | 765970 | 470 [NAME] BAY J | HALLANDALE | FL | 33009 | [PHONE] |  | 1731 | [NAME] |  |  | COMPUTER | 586378 | ABC Company 8 | N | N | PUT | 2006-09-15 00:00:00 | 2010-10-15 00:00:00 | M | 48 | 50075 | 53424.28 | 8409.32 | 25.00 | $1,288.20 | 0 | 0 | 0 | 0 | 546000 | N | EFG COMPANY | 14707 ANY STREET | ANY CITY | FL | 79999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 35433.15 | 18345.37365804173 | 1 | 60 | 1321.066200855 | 32.86620085499999 | 479.076 | 1767.276 | 446.209799145
677969 | [PHONE]-008 | Customer 9 | 503888 | 724952 | 8787 SOUTHSIDE BLVD STE 510 | JACKSONVILLE | FL | 32256 | [PHONE] |  | 5199 | [NAME] |  |  | EMBROIDERY | 991071107 | ABC Company 9 | N | N | $101 | 2006-10-06 00:00:00 | 2011-10-15 00:00:00 | M | 60 | 48000 | 48000 | 18240 | 24.00 | $1,104.00 | 0 | 0 | 0 | 0 | 546000 | N | EFG COMPANY | 14708 ANY STREET | ANY CITY | FL | 79999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 34985.9 | 11102.82078751596 | 1 | 60 | 1310.40747303 | 206.4074730300001 | 479.076 | 1583.076 | 272.6685269699999
703374 | [PHONE]-009 | Customer 10 | 627558 | 800416 | 476 LOWELL ST | METHUEN | MA | 01844 | [PHONE] |  | 7231 | [NAME] |  |  | TANNING BEDS | 991102433 | ABC Company 10 | N | N | EFA | 2007-02-08 00:00:00 | 2010-02-25 00:00:00 | M | 36 | 31499.9 | 31499.9 | 7629.94 | 20.00 | $1,086.94 | 0 | 0 | 0 | 0 | 546000 | N | EFG COMPANY | 14709 ANY STREET | ANY CITY | FL | 79999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 16420.83 | 28955.68646085381 | 1 | 60 | 872.417277654 | -214.522722346 | 479.076 | 1566.016 | 693.598722346
721813 | [PHONE]-010 | Customer 11 | 658430 | 804846 | 308 MAIN ST | OXFORD | MA | 01540 | [PHONE] |  | 7299 | [NAME] | JILL NAPIERALSKI |  | TANNING BEDS | 991102433 | ABC Company 11 | N | N | $1 | 2007-02-28 00:00:00 | 2010-03-28 00:00:00 | M | 36 | 15000 | 15948.91 | 4229.81 | 19.00 | $560.52 | 0 | 0 | 0 | 0 | 546000 | N | EFG COMPANY | 14710 ANY STREET | ANY CITY | FL | 79999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 8990.24 | 14409.80508679207 | 1 | 60 | 694.4264109119999 | 133.906410912 | 479.076 | 1039.596 | 345.1695890880001
725776 | [PHONE]-011 | Customer 12 | 664014 | 806625 | 17575 SW 142 PL | MIAMI | FL | 33177 | [PHONE] |  | 2395 | [NAME] | MARIA ARROYO |  | PRINTERS | 177026 | ABC Company 12 | N | N | % OPTION | 2007-03-07 00:00:00 | 2010-03-25 00:00:00 | M | 36 | 9895 | 9895 | 2385.2 | 19.00 | $389.34 | 0 | 0 | 0 | 0 | 546000 | N | EFG COMPANY | 14711 ANY STREET | ANY CITY | FL | 79999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 7853.41 | 8400.378542945167 | 1 | 60 | 667.1950124580001 | 277.8550124580001 | 479.076 | 868.4159999999999 | 201.2209875419999
733876 | [PHONE]-012 | Customer 13 | 629268 | 795014 | 917 HIGHMEADOW CT | LANCASTER | PA | 17601 | [PHONE] |  | 7999 | [NAME] |  |  | INDUSTRIAL EQUIPMENT | 991102433 | ABC Company 13 | N | N | $1 | 2007-03-29 00:00:00 | 2010-03-29 00:00:00 | M | 36 | 36955 | 36955 | 8481.68 | 19.00 | $1,262.13 | 0 | 0 | 0 | 0 | 546000 | N | EFG COMPANY | 14712 ANY STREET | ANY CITY | FL | 79999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 20107.6 | 32582.57859379306 | 1 | 60 | 960.72942888 | -301.4005711200001 | 479.076 | 1741.206 | 780.4765711200001
785043 | [PHONE]-013 | Customer 14 | 503888 | 724952 | 8787 SOUTHSIDE BLVD STE 510 | JACKSONVILLE | FL | 32256 | [PHONE] |  | 5199 | [NAME] |  |  | EMBROIDERY | 613164 | ABC Company 14 | N | N | $101 | 2007-08-07 00:00:00 | 2012-08-15 00:00:00 | M | 60 | 48000 | 48000 | 18240 | 14.00 | $1,104.00 | 0 | 0 | 0 | 0 | 546000 | N | EFG COMPANY | 14713 ANY STREET | ANY CITY | FL | 79999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 43255.16 | <$5,000 | 1 | 60 | 1507.477996572 | 403.4779965720002 | 479.076 | 1583.076 | 75.59800342799986
803801 | [PHONE]-014 | Customer 15 | 762347 | 853407 | 206 E MAIN STREET | CENTREVILLE | MI | 49032 | [PHONE] |  | 7231 | [NAME] | JILL ANDERSON |  | TANNING BEDS | 991102433 | ABC Company 15 | N | N | PUT | 2007-09-13 00:00:00 | 2012-11-10 00:00:00 | I |  | 17409 | 19069.97 | 8180.83 |  |  | 7 | 0 | 0 | 0 | 546000 | N | EFG COMPANY | 14714 ANY STREET | ANY CITY | FL | 79999 | [PHONE] | [PHONE] |  | FLORIDA | FL |  | No payment info. contract set-up with Irregular Pymts
656382 | [PHONE]-015 | Customer 16 | CL392744 | 37876709 | 6255 COLLEGE DRIVE SUITE D2 | SUFFOLK | VA | 23321 | [PHONE] |  | 7299 | [NAME] | JEAN SCHLEGEL |  | MISC. INTANGIBLE | 991102433 | ABC Company 16 | N | N | $1 | 2006-11-08 00:00:00 | 2012-01-08 00:00:00 | I |  | 63989.9 | 63989.9 | 30210.1 |  |  | 0 | 0 | 0 | 0 | 546000 | N | EFG COMPANY | 14715 ANY STREET | ANY CITY | FL | 79999 | [PHONE] | [PHONE] |  | FLORIDA | FL |  | No payment info. contract set-up with Irregular Pymts
656562 | [PHONE]-016 | Customer 17 | 563391 | 759042 | 2807 SW 187 AVE | MIRAMAR | FL | 33029 | [PHONE] |  | 8999 | [NAME] |  |  | EMBROIDERY | 564158 | ABC Company 17 | N | N | PUT | 2006-08-17 00:00:00 | 2011-09-17 00:00:00 | I |  | 15000 | 16261.44 | 6530.76 |  |  | 0 | 1 | 0 | 0 | 546000 | N | EFG COMPANY | 14716 ANY STREET | ANY CITY | FL | 79999 | [PHONE] | [PHONE] |  | FLORIDA | FL |  | No payment info. contract set-up with Irregular Pymts
664966 | [PHONE]-017 | Customer 18 | 575627 | 766874 | 1835 NW 112TH AVE STE 184 | MIAMI BEACH | FL | 33172 | [PHONE] |  | 8999 | [NAME] |  |  | PRINTERS | 991060125 | ABC Company 18 | N | N | PUT | 2006-09-20 00:00:00 | 2009-10-20 00:00:00 | I |  | 45399 | 48704.47 | 9503.93 |  |  | 0 | 2 | 0 | 0 | 546000 | N | EFG COMPANY | 14717 ANY STREET | ANY CITY | FL | 79999 | [PHONE] | [PHONE] |  | FLORIDA | FL |  | No payment info. contract set-up with Irregular Pymts
702459 | [PHONE]-018 | Customer 19 | 630274 | 788422 | 13023 2200 N AVE | WALNUT | IL | 61376 | [PHONE] |  | 0115 | [NAME] | RICHARD ECKBERG |  | HEAVY EQUIPMENT | 634895 | ABC Company 19 | N | N | $1 | 2006-12-19 00:00:00 | 2012-01-19 00:00:00 | M | 60 | 34195 | 34195 | 16910.6 | 22.00 | $851.76 | 0 | 0 | 0 | 0 | 524015 | N | QRS COMPANY | 545 ANY STREET | ANY CITY | FL | 69999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 27450.7 | 8107.750016281341 | 1 | 60 | 1136.62457766 | 284.8645776599999 | 479.076 | 1330.836 | 194.2114223400001
708578 | [PHONE]-019 | Customer 20 | 639347 | 793493 | 6436 BASIL LANE | NEW PORT RICHEY | FL | 34653 | [PHONE] |  | 8741 | [NAME] | JANINE HORN |  | HEAVY EQUIPMENT | 991066875 | ABC Company 20 | N | N | $101 | 2007-01-09 00:00:00 | 2012-01-26 00:00:00 | M | 60 | 29300.5 | 29300.5 | 12395.3 | 20.00 | $694.93 | 18 | 0 | 0 | 0 | 524015 | N | QRS COMPANY | 546 ANY STREET | ANY CITY | FL | 69999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 25479.27 | <$5,000 | 1 | 60 | 1089.401337726 | 394.4713377260001 | 479.076 | 1174.006 | 84.60466227399979
725526 | [PHONE]-020 | Customer 21 | 663677 | 804590 | 9715 W BROADWAY BLVD | PLANTATION | FL | 33324 | [PHONE] |  | 2879 | [NAME] | [NAME] |  | BUSINESS EQUIPMENT | 666976 | ABC Company 21 | N | N | $101 | 2007-02-28 00:00:00 | 2012-03-28 00:00:00 | M | 60 | 17391.98 | 17391.98 | 7244.62 | 19.00 | $410.61 | 0 | 1 | 0 | 0 | 524015 | N | QRS COMPANY | 547 ANY STREET | ANY CITY | FL | 69999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 15186.48 | <$5,000 | 1 | 60 | 842.8499046239999 | 432.2399046239999 | 479.076 | 889.686 | 46.83609537600012
374574 | [PHONE]-021 | Customer 22 | 62058 | 534478 | 160 WIXON POND RD | MAHOPAC | NY | 10541 | [PHONE] |  | 8299 | [NAME] | [NAME] | [NAME] | TRAILERS | 991073803 | ABC Company 22 | N | N | EFA | 2004-04-01 00:00:00 | 2009-04-20 00:00:00 | M | 60 | 20670 | 20670 | 7530 | 54.00 | $470.00 | 0 | 0 | 0 | 0 | 991018848 | N | TUV COMPANY | 710 ANY STREET | ANY CITY | FL | 59999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 2764.46 | 16856.64395845335 | 1 | 60 | 545.295321948 | 75.29532194800004 | 479.076 | 949.076 | 403.780678052
359022 | [PHONE]-022 | Customer 23 | 27046 | 535308 | 6140 94TH AVE | PINELLAS PARK | FL | 33782 | [PHONE] | [PHONE] | 5411 | [NAME] |  |  | MISC. INTANGABLE | 81498 | ABC Company 23 | N | N | EFA | 2004-04-06 00:00:00 | 2009-04-30 00:00:00 | M | 60 | 19260 | 19260 | 6090 | 54.00 | $422.50 | 0 | 0 | 0 | 0 | 991018848 | N | TUV COMPANY | 711 ANY STREET | ANY CITY | FL | 59999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 2487.27 | 15150.8500477586 | 1 | 60 | 538.655568126 | 116.155568126 | 479.076 | 901.576 | 362.920431874
386433 | [PHONE]-023 | Customer 24 | 87550 | 537628 | 217 E FRONT ST | TRAVERSE CITY | MI | 49684 | [PHONE] |  | 5944 | [NAME] |  |  | COMPUTER | 991020160 | ABC Company 24 | N | N | EFA | 2004-04-16 00:00:00 | 2009-05-16 00:00:00 | M | 60 | 27033 | 27033 | 9207 | 55.00 | $604.00 | 0 | 0 | 0 | 0 | 991018848 | N | TUV COMPANY | 712 ANY STREET | ANY CITY | FL | 59999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 2922.5 | 22292.7059380975 | 1 | 60 | 549.0809805 | -54.91901949999999 | 479.076 | 1083.076 | 533.9950195
396624 | [PHONE]-024 | Customer 25 | 109367 | 546014 | 2043 CAMERON ST | RALEIGH | NC | 27605 | [PHONE] |  | 5621 | [NAME] | [NAME] |  | MACHINE TOOLS | 991023969 | ABC Company 25 | N | N | EFA | 2004-05-19 00:00:00 | 2009-06-19 00:00:00 | M | 60 | 12492 | 12492 | 4410 | 53.00 | $281.70 | 0 | 0 | 0 | 0 | 991018848 | N | TUV COMPANY | 713 ANY STREET | ANY CITY | FL | 59999 | [PHONE] | [PHONE] |  | FLORIDA | FL | 1911.45 | 9848.68826616236 | 1 | 60 | 524.86249101 | 243.16249101 | 479.076 | 760.7760000000001 | 235.9135089900001