Spreadsheet: CharReport_Demo
Sheet: 2013 projections

 | Goal Sheet |  |  |  |  |  |  |  | Measure
 | Month | # contracts | Actual | avg size | actual | total $ | actual | # empl | avg ltv ln 3 | avg ltv ln 5 | avg pti | avg dti | avg score | [NAME] 30+ | loss % | avg disc | avg be yld | # [NAME]  [NAME] | # of funding dlrs | LTB | BTA
 | Jan | 55 |  | 15000 |  | 825000 | 769888.2 | 5 | 1.05 | 1.15 | 0.12 | 0.4 | 570 | 0 | 0 | 495 | 0.155 | 10 | 5 | 0.05 | 0.5
 | Feb | 60 |  | 15500 |  | 930000 | 753624.44 | 5 | 1.05 | 1.15 | 0.12 | 0.4 | 570 | 0 | 0 | 495 | 0.155 | 25 | 20 | 0.05 | 0.5
 | Mar | 75 |  | 15700 |  | 1177500 | 1358170.66 | 5 | 1.05 | 1.15 | 0.12 | 0.4 | 570 | 0.005 | 0 | 495 | 0.155 | 30 | 25 | 0.05 | 0.5
 | Apr | 70 |  | 15700 |  | 1099000 | 1222587.87 | 5 | 1.05 | 1.15 | 0.12 | 0.4 | 570 | 0.0075 | 0 | 495 | 0.155 | 60 | 30 | 0.05 | 0.5
 | May | 65 |  | 15700 |  | 1020500 | 1130767.13 | 5 | 1.05 | 1.15 | 0.12 | 0.4 | 570 | 0.01 | 0.002 | 495 | 0.155 | 80 | 35 | 0.05 | 0.5
 | June | 65 |  | 15700 |  | 1020500 | 1026143.87 | 6 | 1.05 | 1.15 | 0.12 | 0.4 | 570 | 0.0125 | 0.003 | 495 | 0.155 | 90 | 40 | 0.05 | 0.5
 | July | 60 |  | 15700 |  | 942000 | 826127.23 | 6 | 1.05 | 1.15 | 0.12 | 0.4 | 570 | 0.015 | 0.004 | 495 | 0.155 | 100 | 45 | 0.05 | 0.5
 | Aug | 60 |  | 15700 |  | 942000 | 912092.98 | 6 | 1.05 | 1.15 | 0.12 | 0.4 | 570 | 0.0175 | 0.005 | 495 | 0.155 | 100 | 50 | 0.05 | 0.5
 | Sept | 55 |  | 15700 |  | 863500 | 790278.94 | 7 | 1.05 | 1.15 | 0.12 | 0.4 | 570 | 0.02 | 0.006 | 495 | 0.155 | 100 | 55 | 0.05 | 0.5
 | Oct | 55 |  | 15700 |  | 863500 | 840012.42 | 7 | 1.05 | 1.15 | 0.12 | 0.4 | 570 | 0.0225 | 0.007 | 495 | 0.155 | 100 | 60 | 0.05 | 0.5
 | Nov | 50 |  | 15700 |  | 785000 | 896904.37 | 7 | 1.05 | 1.15 | 0.12 | 0.4 | 570 | 0.025 | 0.0085 | 495 | 0.155 | 100 | 60 | 0.05 | 0.5
 | Dec | 50 |  | 15700 |  | 785000 | 911660.39 | 7 | 1.05 | 1.15 | 0.12 | 0.4 | 570 | 0.0299 | 0.01 | 495 | 0.155 | 100 | 60 | 0.05 | 0.5
 |  | 720 | 0 | 15700 | #N/A | 11253500 | 11438258.5
 |  |  |  |  |  |  |  |  |  |  |  |  | Loss Summary
 | Targets |  |  | YTD AVG May | YTD June | YTD July | YTD Aug | YTD Sept | YTD Oct | YTD Nov | YTD Dec |  | Customer | Tier | Make | Model | Year | Amt Fin | Loss | Type | Dealer
 | LTV | >115% |  | 106.09 | 105.64 | 105.02 | 105.01 | 104.86 | 104.66 | 104.86
 | PTI | >15% |  | 10.32 | 10.35 | 10.31 | 10.21 | 10.23 | 10.23 | 10.23
 | FICO | <570 |  | 592.44 | 593.23 | 592.63 | 591.62 | 592.28 | 593.26 | 594.26
 | Discount | 495 |  | 461.11 | 459.27 | 454.32 | 450.44 | 445.35 | 439.11 | 433.45
 | [NAME] | 0.155 |  | 17.19 | 17.18 | 17.29 | 17.41 | 17.42 | 17.44 | 17.45
 | Losses | >1% |  | 0 | 0 | 0.09 | 0.1 | 0.1 | 0.2 | 0.2
 | [NAME] % | >3% |  | 0 | 0.38 | 0 | 0.33 | 0.5 | 0.4 | 0.4
 | Repo % | >5% |  | 1 @ 0.04% | 2 @ 0.11% | 3@ 0.09 | 5@ 0.13 | 7@0.17 | 7 @ 0.17 | 7 @ 0.14
 | Expenses | month | year |  |  |  | Month | MTD | YTD | Profit
 | Rent/utilities | 2000 | 24000 |  |  |  | Jan
 | Furn/file cabn | 389 | 4668 | 3 yr depr |  |  | Feb
 | Supplies | 292 | 3500 | initial start first month 2000 |  |  | March
 | Phone/T1 | 580 | 6960 |  |  |  | April |  |  |  |  |  |  |  |  |  |  |  |  |  | *dealer cut off
 | Computers/fax/copiers | 674 | 8088 | 3 yr depr |  |  | May
 | Promotions | 1667 | 20000 | initial hit 6000 |  |  | June | 9898.92 | -63981.32
 | [NAME]/mileage | 1500 | 18000 |  |  |  | July | 11519.73 | -52461.59
 | Interest | 0.05 |  |  |  |  | August | 19442.25 | -33019.34
 | Legal | 100 | 1200 |  |  |  | September | 27046.74 | -6972.6
 | Servicing | 0.02 |  |  |  |  | October | 53737.79 | 47765.19 | 7.77%/0.69
 | Postage | 350 | 4200 |  |  |  | Nov
 | Salaries | 38750 | 465000 |  |  |  | Dec
 | Losses | 8333 | 100000 |  |  |  | *over charged 12K on corporate expenses that need to be adjusted.