Spreadsheet: 163211d1340222552-data-label-filter-out-zero-in-bar-graph-value-score
Sheet: Prop Scores & Appraisal Cap (2

Loan # | Property Name | Loan/Property | Value | [NAME] |  |  |  |  |  | Count | Balance | % of visited assets | % of total pool
1 |  | Loan | 3.5 | 141500000 |  |  |  |  | 1
2 |  | Loan | 3.5 | 95000000 |  |  |  |  | 1.25
3 |  | Loan | 3 | 85000000 |  |  |  |  | 1.5
4 |  | Loan | 2.5 | 78750000 |  |  |  |  | 1.75
5 |  | Loan | 3.25 | 75911186.73666666 |  |  |  |  | 2
6 |  | Portfolio | 2.75 | 73411686.11 |  |  |  |  | 2.25
6.01 |  | Property | 2.75 | 42648693.83533334 |  |  |  |  | 2.5
6.02 |  | Property | 2.75 | 30762992.27466667 |  |  |  |  | 2.75
7 |  | Loan | 3 | 54000000 |  |  |  |  | 3
8 |  | Loan | 3.25 | 48388590.90908169 |  |  |  |  | 3.25
 |  |  |  |  |  |  |  |  | 3.5
10 |  | Loan | 3 | 41951824.45 |  |  |  |  | 3.75
11 |  | Loan | 3 | 40000000 |  |  |  |  | 4
12 |  | Loan | 3.75 | 38633447 |  |  |  |  | 4.25
13 |  | Loan | 3 | 37000000 |  |  |  |  | 4.5
14 |  | Portfolio | 3.25 | 28023228.11412405 |  |  |  |  | 4.75
14.01 |  | Property | 3.25 | 16129445.6992991 |  |  |  |  | 5
14.02 |  | Property | 3.25 | 11893782.41482495
15 |  | Loan | 3.75 | 26445911.07
16 |  | Portfolio | 3.246713385484572 | 26000000
16.01 |  | Property | 3.5 | 9083000 |  | What it looks like
16.02 |  | Property | 3 | 9325000
16.03 |  | Property |  | 1592000
16.04000000000001 |  | Property |  | 3150000
16.05000000000001 |  | Property |  | 2850000
 |  |  |  | 44500000
17 |  | Portfolio | 3 | 25020000
17.01 |  | Property | 3 | 5560000
17.02 |  | Property | 3 | 3650000
17.03 |  | Property |  | 3660000
17.04000000000001 |  | Property |  | 3000000
17.05000000000001 |  | Property | 3 | 3000000
17.06000000000001 |  | Property | 3 | 2780000
17.07000000000001 |  | Property |  | 1830000 |  | What I want it to look like
17.08000000000001 |  | Property |  | 1540000
18 |  | Loan | 3 | 13920000
19 |  | Loan |  | 5560000
20 |  | Loan | 3 | 23107742.22
21 |  | Loan | 2.75 | 18779375.84
22 |  | Loan | 3.25 | 17578852.72
23 |  | Loan |  | 17428642.35666667
25 |  | Loan |  | 14982794.44
26 |  | Loan | 3 | 14981742.25
27 |  | Loan |  | 12958050.17
28 |  | Loan |  | 12735538.21
29 |  | Portfolio |  | 12728831.62
29.02 |  | Property |  | 1269357.026056326
29.03 |  | Property |  | 3138133.202383548
29.04000000000001 |  | Property |  | 2538714.052112652
29.05000000000001 |  | Property |  | 1657216.006424678
29.06000000000001 |  | Property |  | 952018.7678819796
31 |  | Portfolio |  | 12135669.1
31.01 |  | Property |  | 9738499.895061728
32 |  | Loan |  | 12067018.51
33 |  | Loan |  | 11925552.29
34 |  | Loan |  | 11325000
35 |  | Loan |  | 11300000
36 |  | Loan |  | 11186831.25
37 |  | Portfolio |  | 11186165.18666667
37.01 |  | Property |  | 1087240.894099295
37.02 |  | Property |  | 1075496.007897605
37.02999999999999 |  | Property |  | 2285219.286671667
37.03999999999999 |  | Property |  | 390936.9264276786
37.04999999999999 |  | Property |  | 879188.624240788
37.05999999999999 |  | Property |  | 1932872.700620969
37.06999999999999 |  | Property |  | 1859047.701638918
37.07999999999998 |  | Property |  | 595633.5145142744
37.08999999999998 |  | Property |  | 1080529.530555472
38 |  | Loan |  | 10878482.49
40 |  | Loan |  | 9488452.739999998
42 |  | Loan |  | 8980912.200000001
44 |  | Loan |  | 8066553.109999999
45 |  | Portfolio |  | 7684848.78
45.01 |  | Property |  | 4316489.736818182
45.02 |  | Property |  | 3368359.043181818
46 |  | Loan |  | 7337657.63
47 |  | Loan |  | 7192482.75
48 |  | Loan |  | 6927318.209999999
49 |  | Loan |  | 6686315.840000001
50 |  | Loan |  | 5986472.995612223
51 |  | Loan |  | 5743404.54
52 |  | Loan |  | 5631560.840000001
54 |  | Loan |  | 4295021.560000001
56 |  | Loan |  | 3950247.87
57 |  | Portfolio |  | 3594252.04
57.01 |  | Property |  | 1787062.114288
57.02 |  | Property |  | 1807189.925712
58 |  | Loan |  | 3496015.24
59 |  | Loan |  | 3294932.18
60 |  | Loan |  | 3221335.17
61 |  | Loan |  | 3094073.68
62 |  | Loan |  | 2975000
63 |  | Loan |  | 2659388.61
64 |  | Loan |  | 2537059.25
65 |  | Loan |  | 2394905.58
64 |  | Loan |  | 3950247.87
66 |  | Portfolio |  | 3594252.04
66.01 |  | Property |  | 1787062.114288
66.02000000000001 |  | Property |  | 1807189.925712
67 |  | Loan |  | 3496015.24
68 |  | Loan |  | 3294932.18
69 |  | Loan |  | 3221335.17
70 |  | Loan |  | 3094073.68
71 |  | Loan |  | 2975000
72 |  | Loan |  | 2659388.61
73 |  | Loan |  | 2537059.25
74 |  | Loan |  | 2394905.58
62 |  | Loan |  | 6927318.209999999
63 |  | Loan |  | 6686315.840000001
65 |  | Loan |  | 5986472.995612223
67 |  | Loan |  | 5743404.54
68 |  | Loan |  | 5631560.840000001
78 |  | Loan |  | 4295021.560000001
79 |  | Loan |  | 3950247.87
81 |  | Portfolio |  | 3594252.04
81.01 |  | Property |  | 1787062.114288
81.02000000000001 |  | Property |  | 1807189.925712
82 |  | Loan |  | 3496015.24
83 |  | Loan |  | 3294932.18
84 |  | Loan |  | 3221335.17
85 |  | Loan |  | 3094073.68
86 |  | Loan |  | 2975000
87 |  | Loan |  | 2659388.61
88 |  | Loan |  | 2394905.58
89 |  | Loan |  | 2537059.25