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.

 
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

 

Laboriosam placeat consequatur est necessitatibus reprehenderit ipsam. Deleniti sapiente praesentium aspernatur placeat reprehenderit labore. Quasi itaque ea esse vero accusamus.

Eum accusantium aliquid eveniet animi optio ut ea maiores. Molestiae dicta odio exercitationem accusamus temporibus. Officiis minima quisquam officia laudantium fugiat occaecati voluptas adipisci. Qui nostrum velit dolores dolore vel.

Career Advancement Opportunities

May 2024 Investment Banking

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

Overall Employee Satisfaction

May 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

May 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

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (20) $385
  • Associates (90) $259
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (67) $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
Betsy Massar's picture
Betsy Massar
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
GameTheory's picture
GameTheory
98.9
6
kanon's picture
kanon
98.9
7
CompBanker's picture
CompBanker
98.9
8
dosk17's picture
dosk17
98.9
9
DrApeman's picture
DrApeman
98.8
10
Linda Abraham's picture
Linda Abraham
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...”