Affordable Housing Loan Origination Analyst

tryingtofinance's picture
Rank: Baboon | 107

Anyone have any info on exit opps/career path starting in this kind of role? Had a phone interview today that went really well and was pretty much told on the spot I would get an in person interview. Also was told there would be an Excel test. What can I expect for that? Thank yall.

edit - any good online resources to learn about affordable housing?

Comments (7)

Aug 3, 2019

Bump

Aug 3, 2019

I presume it would be like any other debt modeling as in you're protecting downside risk as a senior lender. You want to read the QAPs and affordable housing guidelines in the states your company would lend in. Practice amortization schedules, scenario analyses, etc.

Aug 3, 2019

I believe they lend to multiple states, possibly nationwide. Anywhere specific to learn more about amortization schedules and scenario analyses modeling? I'm pretty intermediate with modeling. I have REFM and BIWS but haven't looked at them in awhile or practiced much Excel at all in awhile since I've been studying and practicing ARGUS. Thank you

Aug 8, 2019
tryingtomakefukyoumoney:

I believe they lend to multiple states, possibly nationwide. Anywhere specific to learn more about amortization schedules and scenario analyses modeling? I'm pretty intermediate with modeling. I have REFM and BIWS but haven't looked at them in awhile or practiced much Excel at all in awhile since I've been studying and practicing ARGUS. Thank you

ARGUS is going to be a total waste of your time (as it relates to this interview). As others have said, understanding a little bit about how tax credit financing works is worth the effort. Ditto Section 8. You're not going to be expected to build a flawless underwriting model in an interview, but understanding the hows and whys of the industry will certainly help you understand that model later on

Aug 3, 2019

You can learn amortization schedules and scenario analyses with basic Google searches. Just make sure you can build one and understand the concepts. Read materials on LIHTC, Section 8, and other HUD programs as well. Novogradac is a good resource.

Also, if you're doing affordable housing I don't think learning Argus makes sense. Real estate modeling is pretty simple, but affordable housing gets entangled with legal and regulatory guidelines.

    • 1
Learn More

Side-by-side comparison of top modeling training courses + exclusive discount through WSO here.

Aug 3, 2019

Gotcha. Looks like some review from the REFM course actually so shouldn't be too hard to pick back up on. Will take a look at Novogradac, thanks again!

Aug 8, 2019
Comment