Spreadsheet: 721282d1614623435-excel-index-match-retrieving-multiple-columns-of-data-excel-question-00237440xc6a08-
Sheet: By Investor

Investor [NAME] (Closed) |  |  |  |  |  | Total Weighted Average Investor Yield =
Investor | Investment | Date | Status | Principal Payment Amount | Total Payment Amount | IRR | Weight Factor
[NAME] | GF | 2019-01-24 00:00:00 | Closed | 125000 | 133831 | 0.145
[NAME] | GF | 2020-02-24 00:00:00 | Closed | 250000 | 295173 | 0.1503
[NAME] | GF | 2019-01-10 00:00:00 | Closed | 200000 | 217000.31 | 0.177
[NAME] | GF | 2019-11-11 00:00:00 | Closed | 250000 | 275000 | 0.1301
Greg | DF | 2018-06-14 00:00:00 | Closed | 145000 | 155100 | 0.09924
Mark | GF | 2020-02-24 00:00:00 | Closed | 250000 | 295173 | 0.1503
Mark | DF | 2018-03-08 00:00:00 | Closed | 200000 | 219000 | 0.10753
Mark | DF | 2019-06-19 00:00:00 | Closed | 150000 | 195000 | 0.1484
Mark | DF | 2019-09-01 00:00:00 | Closed | 150000 | 195000 | 0.1431
[NAME] | GF | 2019-01-25 00:00:00 | Closed | 225000 | 240250 | 0.14
[NAME] | DF | 2017-09-15 00:00:00 | Closed | 224000 | 240000 | 0.2644
[NAME] | GF | 2020-02-24 00:00:00 | Closed | 250000 | 295173 | 0.1503
[NAME] | DF | 2018-04-01 00:00:00 | Closed | 200000 | 207500 | 0.11076
[NAME] | DF | 2018-06-20 00:00:00 | Closed | 300000 | 300723.29 | 0.08
[NAME] | DF | 2017-06-06 00:00:00 | Closed | 150000 | 159650 | 0.10035
[NAME] | DF | 2020-06-26 00:00:00 | Closed | 250000 | 310890 | 0.1598
Chad | GF | 2020-09-20 00:00:00 | Closed | 500000 | 581561.09 | 0.1336
Kam | GF | 2020-02-24 00:00:00 | Closed | 250000 | 295173 | 0.1503
T&K | GF | 2018-12-18 00:00:00 | Closed | 1000000 | 1088500 | 0.1615
T&K | GF | 2019-01-11 00:00:00 | Closed | 250000 | 270000 | 0.169
T&K | GF | 2019-03-19 00:00:00 | Closed | 150000 | 165000 | 0.1524
T&K | GF | 2019-06-04 00:00:00 | Closed | 600000 | 680000 | 0.1525
T&K | GF | 2019-11-21 00:00:00 | Closed | 200000 | 229700 | 0.1466
T&K | GF | 2020-02-27 00:00:00 | Closed | 800000 | 858000 | 0.1403
T&K | DF | 2017-05-15 00:00:00 | Closed | 200000 | 237000 | 0.1075
T&K | DF | 2017-10-25 00:00:00 | Closed | 150000 | 166635 | 0.1356
T&K | DF | 2018-01-25 00:00:00 | Closed | 150000 | 171250 | 0.1332
T&K | DF | 2019-09-19 00:00:00 | Closed | 260000 | 313261.76 | 0.13
T&K | DF | 2019-10-07 00:00:00 | Closed | 240000 | 326150 | 0.1483
EA | GF | 2019-07-26 00:00:00 | Closed | 100000 | 107000 | 0.0974
EA | GF | 2019-06-01 00:00:00 | Closed | 200000 | 230000 | 0.162
EA | GF | 2019-07-26 00:00:00 | Closed | 100000 | 112700 | 0.1453
EA | GF | 2019-11-11 00:00:00 | Closed | 350000 | 387000 | 0.1338
EA | DF | 2018-07-12 00:00:00 | Closed | 299232.06 | 392224.45 | 0.08
EA | DF | 2018-12-24 00:00:00 | Closed | 469474.48 | 496951.02 | 0.08
EA | DF | 2019-01-07 00:00:00 | Closed | 290293.46 | 291184.22 | 0.08
EA | DF | 2020-07-23 00:00:00 | Closed | 127080 | 127080 | 0.12
[NAME] | GF | 2020-02-24 00:00:00 | Closed | 250000 | 295173 | 0.1503
[NAME] | GF | 2020-02-24 00:00:00 | Closed | 250000 | 295173 | 0.1503
Saher | DF | 2017-09-15 00:00:00 | Closed | 100000 | 108000 | 0.3
[NAME] | DF | 2019-09-26 00:00:00 | Closed | 265000 | 325074.82 | 0.1339
[NAME] | DF | 2019-11-11 00:00:00 | Closed | 200000 | 261280 | 0.14779
[NAME] | DF | 2019-11-11 00:00:00 | Closed | 135000 | 189200 | 0.14643