Modeling Question - Combining Condo Sales & Rental Space

I'm trying to model a mixed-use complex that has ground floor retail with a grocery anchor and second and third floor condos. I have construction debt currently at 75% LTC, but whenever I go to roll it over to permanent debt in year 3 there's no way 75% LTV will come close to covering since the NOI is so low in comparison to the cost. I have little to no experience with condos - so what is the right way to tackle this beast?

I currently am not sure:

  1. Whether to include the condo sales in NOI or as a below the line capital event
  2. Whether to use the condo sale money toward investor/sponsor distribution or against the construction loan
  3. If the construction loan on cost to permanent loan on value strategy is even done with condos
  4. How the pref is handled with condo sales - my cash available for distribution is going to start not covering it at some point because the NOI from the retail + grocery is low in comparison to the initial contribution.
  5. If I'm way overthinking this

If anyone has a condo model or mixed use model out there or even just knows the right approach, I'd really appreciate it.

9 Comments
 
Best Response

1) Condo sales should be treated as a capital event.

2) Sale proceeds need to go towards paying down the loan. This something that is explicitly spelled out with the lender. Usually it is not for the full selling price per unit- developer still gets to keep some CF, but the acceleration is pretty substantial. If loan basis is $200K/unit, paydown on unit sales will be greater than $200K. On a side note, this is one of the reasons lenders hate condo loans- you rarely ever have money out on the darn things!

Sorry if this doesn't make sense. It's been a long week.

 

Re: your second point. I recently did a deal where we had a similar issue: if they sized the loan based on LTC, we would only be truly levered up for a few months and they would never put that much money to work. We managed to work out a revolving structure where we could re-lever after every takedown (this was an LD deal, so longer sales period than a condo and more cost/sales overlap). The lender still wanted to be paid of with a certain % of revenue left in the deal but it was pretty cool to come to a creative compromise

 

1) Capital event

2) The loan agreement typically states the waterfall goes as follows: i) pay down commissions/non-lender sales costs, ii) exit fee, iii) pays down loan. There is no way that today you can get away with leakage towards paying down yourself, or a pref for your investors.

3) No. If there's a lot of units then the bridge lender construction lender will have set your initial maturity accordingly so the market can absorb these units. Otherwise, no. There obviously can't be any debt yield and dscr tests for extensions, but there very well may be a maximum LTV covenant depending on the value of the unsold inventory at maturity. Condos that go through trouble in not being able to extend their loan typically try to procure condo inventory loans.

4) Are you talking about preferred equity? If so, interest typically accrues for condo deals with this type of capital. If you're talking about preferred returns for an LP in the equity then it's the same as any other deal, cash available after paying down debt is available to pay down pref. The pref accrues until that happens, which is why condo deals need a high sellout relative to the construction basis to make the economics work.

5) Yes. Think of this high-level and it won't be confusing. Lenders protect their money and are not concerned if the equity/pref gets paid down, and will certainly not allow it to happen before their outstanding loan is paid down.

 

Hey guys, I was recently tasked with modelling a mobile home property, whereby the company would sell off some of the homes on the site whilst still renting out the lot on a monthly basis to the tenant, and I was wondering where this income should show up in the pro-forma? I modeled it above the line as "other income" - is this incorrect? Thanks!

"Average people have great ideas. Legends have great execution"
 

I've never done a condo/retail mix myself, but I have seen similar loan and waterfall issues come up in condo projects in Cabo. From what I saw, the condo sale income is usually handled as a capital event below the line, not in the operating NOI, and the lenders are quite strict on using proceeds to pay down principal before any cash goes to equity or investors. There are always nuances with construction and takeout financing and sometimes people get tripped up thinking condo sales work like rental deals for modeling, totally different beast when it comes to cash flow timing and getting any pref handled if sales take longer than expected.

If you want to see how returns and sales flows look on the ground, there are a lot of good case studies for a condo for sale cabo san lucasand how the process works with local lenders and foreign buyers. Might shed some light, especially if you're thinking about the way absorption and loan paydown play out in practice.

 

Sed perferendis non non blanditiis qui. Ut placeat esse qui quo. Eaque doloremque omnis velit. Quo aliquam eum dolorem non et dolorum rerum.

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 01 98.3%
  • BMO Capital Markets 13 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan 01 97.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $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
kanon's picture
kanon
99.0
4
Secyh62's picture
Secyh62
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
98.9
10
Mimbs's picture
Mimbs
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...”