Scored 182 loans by hand and walked from the fund I liked. Right call so far.
Posting this because the process was more useful than the outcome and I'd have wanted to read it two years ago.
I had $60k that wasn't going into a property. Looked at four residential bridge debt funds. Two sent loan-level tapes when I asked, one sent a bucketed chart, one told me the tape was available after subscription, which is a strange order of operations.
Of the two tapes I got, one was 182 loans and one was 61. I scored every loan on five things: origination year, current extension count, whether interest was cash-pay or accruing, LTV as a percentage of the fund's own most recent value opinion rather than the original appraisal, and metro. Spreadsheet, three evenings, nothing clever.
The 182-loan fund was the one I liked going in. Coupon 11.2% weighted, net target 9%, sharp people. Scoring it, 31% of outstanding balance sat in one metro and 24 loans were 2022 vintage carrying a second extension. Their reported default rate was 1.1%. Once I counted second extensions as impaired it was closer to 9% of balance at risk, and I don't know that those loans go bad, I just couldn't get comfortable that the 1.1% meant what I'd assumed.
The 61-loan fund: coupon 9.6%, net target 7.5%, top metro 14%, three loans with any extension at all, all first extensions, all cash-pay. I put the $60k there in month one of last year.
14 months in, 14 monthly distributions, all at or slightly above the stated rate. One loan went to foreclosure in month nine on a small single family rehab and recovered at about 96 cents on the balance including accrued. That's the number I actually cared about, because it told me the LTV was real.
What nearly broke it: the subscription package required accreditation verification through a third party and my letter came back wrong twice, which pushed me out of a closing window by six weeks. Second thing, the tax reporting arrived late enough that I filed an extension, and I'd talk to your own accountant about how this kind of income lands for you because mine had opinions I hadn't expected.
What I'd keep: refusing to score the fund that sent a chart. I never found out whether it was fine. It might be great. I just couldn't do the work on it.