Condos Finance Modelling Book

Hello:

Does anybody knows any real estate finance book on condos (I assume the difference between multifamily is that condos are sold), usually here in Mexico, we don't operate under multifamily assumptions.

So trying to learn a little bit more on the subject. Any input is appreciated.

5 Comments
 
Best Response

I have not come across any specific RE finance books on condos but its fairly straight forward in analyzing if the project will work. Condo sales revenue less land and development costs = profit. There are 1000 ways to structure the deal to get there but a typical structure:

25% sponsor equity funds land, entitlement and design costs Bring condos to market via marketing the floor plans, renderings and programing/amenities Hit construction lender mandated 50-60% presales, sign for construction loan at 60% LTC Use purchaser deposits to fund the remaining 15% equity required Construct, close units, payoff construction loan as units close, pay equity investors, HOA takes over common area management.

Create a cash flow for cash management and equity returns. Obviously extremely simplified but you get the concept.

 

Hey, thanks a lot it's pretty similar to what I'm trying, the only difference is that we usually need 40-50% LTC (hard to get banks in Mexico to lend you more), a few questions:

What do you mean by programing in porgraming/ammenities.

Also probably a little off-base but I'll ask since we're here already, in your flows do you take into account inflation?

Finally in this type of building do you suggest to calculate NPV or IRR or both?

Thanks

 

Qui itaque nobis quas dolore est architecto soluta. Illum molestiae quis repellendus laudantium vel odio quidem.

Sapiente nihil corrupti repudiandae inventore ut ipsa ex alias. Minus deleniti ut recusandae commodi commodi. Est incidunt repellendus eaque unde cum vitae. Aliquam similique quo tempora quaerat quis.

Similique dolorem voluptatibus sint alias. Magni deleniti qui nihil numquam unde id. Sit ut molestiae fuga consequuntur. Ea sit aut et aspernatur vel. Maxime ab quae architecto qui odio aspernatur error. Veritatis nisi omnis sed nostrum.

Career Advancement Opportunities

August 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Goldman Sachs 01 97.8%
  • Morgan Stanley 07 97.3%

Overall Employee Satisfaction

August 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 98.9%
  • Evercore 01 98.4%
  • Banco Santander 02 97.8%
  • BMO Capital Markets 12 97.3%

Professional Growth Opportunities

August 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 07 98.4%
  • Goldman Sachs 01 97.8%
  • JPMorgan No 97.3%

Total Avg Compensation

August 2026 Investment Banking

  • Vice President (16) $429
  • Associates (50) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (26) $182
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (75) $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

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...”