Is it possible to bundle data together based on certain criteria? For example, I have 32 properties (average value of $718k) as a starting point. I need to make four bundles of 5 properties, and two bundles of 6 properties based on the following criteria:
I'm not sure if this is possible but any help would be appreciated. Thanks!
<tbody>
</tbody>
- want the most optimal bundles based on proforma DSC - don't want all the strong DSC properties in one bundle, vice versa. Basically want everything to be of equal value and strength
- bundles should be similar in value ($718k x 5 = $3,590k) - except for the two bundles of 6 properties which can be higher ($4,308k)
I'm not sure if this is possible but any help would be appreciated. Thanks!
| Property Analysis | |||||||||||||||||||||||||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | ||||
| Proforma DSC | 1.80 | 1.50 | 3.39 | 1.26 | 1.04 | 2.55 | 1.25 | 2.28 | 2.47 | 1.45 | 0.92 | 2.73 | 1.81 | 1.37 | 2.09 | 2.11 | 1.11 | 0.91 | 2.80 | 1.06 | 0.70 | 2.33 | 0.71 | 1.48 | 0.72 | 0.76 | 1.09 | 1.03 | 0.73 | 0.83 | 0.63 | 1.01 | |||
| Collateral Analysis | TOTAL | ||||||||||||||||||||||||||||||||||
| Property Stated Value | 1,800,000.00 | 900,000.00 | 1,800,000.00 | 850,000.00 | 880,000.00 | 1,500,000.00 | 880,000.00 | 1,200,000.00 | 1,300,000.00 | 1,300,000.00 | 680,000.00 | 1,200,000.00 | 950,000.00 | 950,000.00 | 1,300,000.00 | 1,300,000.00 | 1,800,000.00 | 700,000.00 | 900,000.00 | 740,000.00 | 625,000.00 | 900,000.00 | 700,000.00 | 960,000.00 | 690,000.00 | 690,000.00 | 950,000.00 | 680,000.00 | 680,000.00 | 1,400,000.00 | 900,000.00 | 650,000.00 | 32,755,000 | ||
| Discount to 80% | 1,440,000.00 | 720,000.00 | 1,440,000.00 | 680,000.00 | 704,000.00 | 1,200,000.00 | 704,000.00 | 960,000.00 | 1,040,000.00 | 1,040,000.00 | 544,000.00 | 960,000.00 | 760,000.00 | 760,000.00 | 1,040,000.00 | 1,040,000.00 | 1,440,000.00 | 560,000.00 | 720,000.00 | 592,000.00 | 500,000.00 | 720,000.00 | 560,000.00 | 768,000.00 | 552,000.00 | 552,000.00 | 760,000.00 | 544,000.00 | 544,000.00 | 1,120,000.00 | 720,000.00 | 520,000.00 | 26,204,000 | ||
| O/S Mortgage Balance | 295,327.61 | 145,244.57 | 650,000.00 | 0.00 | 87,522.97 | 481,000.00 | 76,049.12 | 95,283.83 | 93,066.93 | 80,652.43 | 0.00 | 0.00 | 82,299.49 | 78,160.94 | 373,448.49 | 367,292.64 | 106,582.81 | 0.00 | 221,473.34 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3,233,405 | ||
| Net Equity | 1,144,672 | 574,755 | 790,000 | 680,000 | 616,477 | 719,000 | 627,951 | 864,716 | 946,933 | 959,348 | 544,000 | 960,000 | 677,701 | 681,839 | 666,552 | 672,707 | 1,333,417 | 560,000 | 498,527 | 592,000 | 500,000 | 720,000 | 560,000 | 768,000 | 552,000 | 552,000 | 760,000 | 544,000 | 544,000 | 1,120,000 | 720,000 | 520,000 | 22,970,595 | ||
| Average value of property | 717,831 |
<tbody>
</tbody>
