Debt Fund Modeling / Argus

Calling all debt fund analysts/associates... I work at a mortgage REIT as an analyst and we are a typical bridge lender. I am curious to see how detailed other shops underwriting/modeling is.

  • Besides the typical DCF, market research (comps), etc. that goes into your origination models, what else do you guys/girls usually put together.
    -When you get an Argus from a broker/sponsor how often are you going through their MLAs and changing their assumptions? Generally, are you guys trending rents?

Thanks y'all

 

I work at a well capitalized debt shop that buys b-pieces. The UW on our acquisitions are pretty detailed. In particular, analyst are expected to have a thorough presentation of market level risks, understand the loan type and structure, and being very comfortable with the number you provide as a valuation of the debt and collateral. Management level positions/ IR teams will know how the trust waterfalls and how each securitization will effect the bond holders.

 

Our trust waterfall would be how the BB's, B/NR, XE-G positions flow through to our bondholders. I work on the Asset Management side, so unfortunately I don't have access into how we price the issuance or model our returns. I find B-Piece debt acquisition very interesting based on the competitive nature in pricing your bid correctly since their is so much inherent risk within the issuance. We generally take a pretty steep discount below par on these purchase.

 

We look at the numbers as much as anyone but we focus a lot on the borrowers. REO, PFS, management team selection, etc. To your third point regarding figures put together from the potential borrower or broker, we might make note of a proforma budget illustrated in the OM but as you know, these always paint the picture a little too bright.

Not too high, not too low
 
Most Helpful
  1. Usually an investment committee memo walking through the deal structure, sponsor background & PFS, valuation, property, market, risks & mitigants, etc.

  2. I always run a model w/ 100% my own MLAs. I never want to be in the position of having to say "the Sponsor/broker were assuming 5% rent growth." when a deal becomes non-performing and I'm asked why my valuation/CF projections were what they were.

  3. Whether or not we UW rents trended or untrended is property/market specific.

I come from down in the valley, where mister when you're young, they bring you up to do like your daddy done
 

We're not property type or region specific, but we do have markets that we tend to do more deals in, which makes things somewhat easier. If it's a market that I'm not familiar w/, I'll reach out to brokers. Admittedly, some properties' assumptions are more bullet-proof than others.

I come from down in the valley, where mister when you're young, they bring you up to do like your daddy done
 

We always tweak Argus MLAs based on the appraisal and calls to market participants. In addition to the typical analyses you listed, we put together: Take-out analysis, Real Estate Tax Analysis, Rollover Analysis and Funding Schedule. I assume most shops are doing the same...

Space and place.
 

How much do your firms rely on conversations with market participants?

I feel like sometimes we get very strong comments from brokers and with some markets, it gets tricky because they all know one another and you have to account for some bias when talking about your deal since they likely know the people on the other side which can have an impact based on their relationship...

 

Vel qui illo culpa aperiam est doloribus minima. Nam deleniti doloremque unde est error dignissimos ullam. Commodi voluptas architecto illo est. Magnam rem sint molestiae eos. Soluta officiis qui sint et accusantium. Magnam voluptatibus laudantium id corrupti. Reprehenderit quis debitis corporis enim dicta.

Asperiores adipisci sunt quae odit omnis atque debitis. Ducimus rem repellat quos ipsum facilis eius. Saepe voluptatem aut eligendi doloremque.

Sit quia perferendis accusantium delectus eaque porro. Ea ab unde natus ut. Blanditiis quia accusamus minus blanditiis atque. In rem ullam cumque. Repellat aut tenetur facere quas magni aut.

Space and place.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
kanon's picture
kanon
98.9
6
GameTheory's picture
GameTheory
98.9
7
dosk17's picture
dosk17
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
98.8
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”