Spreadsheet: 805149d1668548542-weighted-average-with-multiple-criteria-wavg
Sheet: Breakdown

 | Loan Type | A | B | C |  |  | A | 1 | 2 | 11 | 12 | 13 | 90 | 200
 |  | WAVG | WAVG | WAVG |  |  | B | 4 | 80 | 132 | 134 | 210
 | 1 |  |  |  |  |  | C | 3
 | 2
 | 3
 | 4 |  |  |  |  |  | 1 | 10 | 11
 | 5 |  |  |  |  |  | 2 | 20
 | Total by Sector |  |  |  |  |  | 3 | 50
 |  |  |  |  |  |  | 4 | 65 | 63 | 67 | 68
 |  |  |  |  |  |  | 5 | 80
 |  |  |  |  |  |  | 6 | 76 | 77
 | BR# | OFFCR | TYPE | GROUP | QRYBAL | ORGAMT | ACCINT | YTDINT | DATOP6 | ORGDT6 | MATDT6 | TERM | RATE | PRATE#
Loan 1 | 3 | 223 | 17 | 10 | 0 | 2000000 | 0 | 0 | 2022-10-31 00:00:00 | 2022-10-31 00:00:00 | 2023-10-31 00:00:00 | 12 | 0.08 | 500
Loan 2 | 2 | 060 | 17 | 10 | 95000 | 95000 | 138.54165 | 0 | 2022-10-24 00:00:00 | 2022-10-19 00:00:00 | 1989-10-19 00:00:00 | 998 | 0.025 | 508
Loan 3 | 11 | 081 | 17 | 10 | 461526.58 | 2500000 | 2689.03337 | 0 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 1989-10-14 00:00:00 | 998 | 0.0725 | 500
Loan 4 | 90 | 208 | 17 | 10 | 1692142.67 | 14460000 | 4970.67716 | 2820.23 | 2022-10-25 00:00:00 | 2022-10-24 00:00:00 | 1932-10-24 00:00:00 | 120 | 0.0825 | 500
Loan 5 | 90 | 208 | 19 | 10 | 1800000 | 1800000 | 3802.5 | 2340 | 2022-10-25 00:00:00 | 2022-10-24 00:00:00 | 1932-10-24 00:00:00 | 60 | 0.0585 | 0
Loan 6 | 90 | 198 | 19 | 10 | 5000000 | 5000000 | 17013.88895 | 0 | 2022-10-20 00:00:00 | 2022-10-19 00:00:00 | 2023-10-19 00:00:00 | 12 | 0.049 | 411
Loan 7 | 90 | 199 | 47 | 11 | 0 | 1200000 | 0 | 0 | 2022-10-11 00:00:00 | 2022-10-07 00:00:00 | 2025-10-07 00:00:00 | 36 | 0.0610666 | 566
Loan 8 | 90 | 199 | 47 | 11 | 0 | 5000000 | 0 | 0 | 2022-10-11 00:00:00 | 2022-10-07 00:00:00 | 2025-10-07 00:00:00 | 36 | 0.0610666 | 566
Loan 9 | 210 | 226 | 07 | 50 | 450000 | 450000 | 843.795 | 1335.89 | 2022-10-14 00:00:00 | 2022-10-13 00:00:00 | 1952-11-01 00:00:00 | 360 | 0.05625 | 570
Loan 10 | 134 | 004 | 54 | 50 | 500000 | 500000 | 2898.32266 | 0 | 2022-10-17 00:00:00 | 2022-09-22 00:00:00 | 1952-10-01 00:00:00 | 360 | 0.04875 | 570
Loan 11 | 210 | 206 | 07 | 50 | 546000 | 546000 | 1023.765 | 511.86 | 2022-10-26 00:00:00 | 2022-10-26 00:00:00 | 1952-11-01 00:00:00 | 360 | 0.05625 | 570
Loan 12 | 134 | 004 | 54 | 50 | 650000 | 650000 | 1284.23247 | 0 | 2022-10-17 00:00:00 | 2022-10-03 00:00:00 | 1952-11-01 00:00:00 | 360 | 0.05375 | 570
Loan 13 | 210 | 206 | 08 | 50 | 682500 | 682500 | 1222.8312 | 1834.2 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 1952-11-01 00:00:00 | 360 | 0.05375 | 570
Loan 14 | 210 | 174 | 08 | 50 | 875000 | 875000 | 1421.87161 | 1303.39 | 2022-10-24 00:00:00 | 2022-10-21 00:00:00 | 1952-11-01 00:00:00 | 360 | 0.04875 | 570
Loan 15 | 132 | 004 | 06 | 50 | 789780.4 | 791250 | 6013.84661 | 0 | 2022-10-20 00:00:00 | 2022-07-29 00:00:00 | 1952-08-01 00:00:00 | 360 | 0.06375 | 0
Loan 16 | 134 | 004 | 07 | 50 | 976000 | 976000 | 1748.77736 | 0 | 2022-10-17 00:00:00 | 2022-10-03 00:00:00 | 1952-11-01 00:00:00 | 360 | 0.04875 | 570
Loan 17 | 210 | 206 | 08 | 50 | 1162500 | 1162500 | 1889.09616 | 2833.56 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 1952-11-01 00:00:00 | 360 | 0.04875 | 570
Loan 18 | 132 | 004 | 06 | 50 | 891742.55 | 893750 | 5725.11069 | 0 | 2022-10-20 00:00:00 | 2022-07-22 00:00:00 | 1952-08-01 00:00:00 | 360 | 0.05375 | 0
Loan 19 | 210 | 206 | 60 | 50 | 954887.8 | 955959 | 1862.61825 | 4424.63 | 2022-10-03 00:00:00 | 2022-09-30 00:00:00 | 1952-10-01 00:00:00 | 360 | 0.05375 | 570
Loan 20 | 210 | 206 | 08 | 50 | 1350000 | 1350000 | 2025 | 1350 | 2022-10-25 00:00:00 | 2022-10-24 00:00:00 | 1952-11-01 00:00:00 | 360 | 0.045 | 570
Loan 21 | 132 | 004 | 06 | 50 | 1152694.63 | 1155000 | 8260.97848 | 0 | 2022-10-20 00:00:00 | 2022-07-08 00:00:00 | 1952-08-01 00:00:00 | 358 | 0.06 | 0
Loan 22 | 210 | 174 | 09 | 50 | 1480000 | 1480000 | 2220 | 1110 | 2022-10-26 00:00:00 | 2022-10-26 00:00:00 | 1952-11-01 00:00:00 | 360 | 0.045 | 570
Loan 23 | 90 | 208 | 23 | 65 | 0 | -11424000 | 54347.82563 | 0 | 2022-10-17 00:00:00 | 2022-10-14 00:00:00 | 2027-10-14 00:00:00 | 60 | 0.0652 | 0
Loan 24 | 3 | 098 | 23 | 65 | 580000 | 580000 | 1703.75 | 0 | 2022-10-31 00:00:00 | 2022-10-28 00:00:00 | 2027-10-28 00:00:00 | 60 | 0.0675 | 0
Loan 25 | 90 | 167 | 23 | 65 | 1500000 | 1500000 | 2906.25 | 23637.5 | 2022-10-20 00:00:00 | 2022-06-30 00:00:00 | 2026-03-31 00:00:00 | 18 | 0.0465 | 0
Loan 26 | 1 | 196 | 23 | 65 | 830000 | 830000 | 1540.36697 | 1171.22 | 2022-10-26 00:00:00 | 2022-10-24 00:00:00 | 1932-10-01 00:00:00 | 120 | 0.06186 | 595
Loan 27 | 3 | 205 | 23 | 65 | 2625000 | 2625000 | 13449.47672 | 0 | 2022-10-17 00:00:00 | 2022-10-14 00:00:00 | 2027-10-14 00:00:00 | 60 | 0.0595 | 0
Loan 28 | 134 | 004 | 54 | 50 | 2531250 | 2531250 | 15425.44692 | 0 | 2022-10-14 00:00:00 | 2022-09-29 00:00:00 | 1952-10-01 00:00:00 | 360 | 0.05125 | 570
Loan 29 | 3 | 096 | 23 | 65 | 10736333.33 | 10750000 | 13047.63002 | 57855.9 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2027-10-07 00:00:00 | 60 | 0.0625 | 0
Loan 30 | 210 | 206 | 60 | 50 | 3051243.63 | 3055000 | -7319.7307 | 21098.6 | 2022-10-12 00:00:00 | 2022-09-22 00:00:00 | 1952-10-01 00:00:00 | 360 | 0.04875 | 570
Loan 31 | 90 | 208 | 23 | 65 | 24200000 | 28560000 | 135869.55559 | 0 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2027-10-14 00:00:00 | 60 | 0.0652 | 0
Loan 32 | 90 | 199 | 43 | 67 | 9910000 | 9910000 | 9864.01321 | 45381.74 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2025-10-07 00:00:00 | 60 | 0.0511899 | 563
Loan 33 | 90 | 208 | 95 | 68 | 7040000 | 7040000 | 14236.4422 | 8760.89 | 2022-10-25 00:00:00 | 2022-10-24 00:00:00 | 1932-10-24 00:00:00 | 60 | 0.056 | 0
Loan 34 | 90 | 037 | 70 | 76 | 191948 | 250000 | 640.34554 | 287.99 | 2022-10-05 00:00:00 | 2022-10-04 00:00:00 | 2024-10-04 00:00:00 | 24 | 0.09 | 500
Loan 35 | 80 | 210 | 27 | 80 | 250000 | 250000 | 947.92052 | 0 | 2022-10-18 00:00:00 | 2022-10-17 00:00:00 | 2023-10-17 00:00:00 | 12 | 0.055 | 500