Real Estate Deal Underwriting Drill

Reviewed by Fallon Han· Updated 2026-06-01 21:30:02.161

This conversation was generated using Cook'd AI's career assistant and reviewed by Fallon Han from our editorial team for accuracy.

I am a second-year undergraduate in the UK on a dependent visa, and I am targeting real estate private equity. Can you walk me through a simple property deal example and explain which assumptions move the valuation most? I want to understand NOI, cap rates, leverage, and downside sensitivity in a practical way.

Absolutely. Let us use a straightforward office or multifamily deal example so the mechanics are clear. Imagine a property with: - Gross rental income: 1,000,000 - Operating expenses: 350,000 - So NOI: 650,000 If the market cap rate is 5.5 percent, the implied value is: - Value = NOI divided by cap rate - 650,000 divided by 0.055 = about 11.8 million That is the core relationship. The two biggest drivers are usually NOI and the cap rate. A higher NOI raises value, and a lower cap rate raises value because investors accept a lower yield. Leverage does not change the property value itself. It changes your equity return and downside risk. If you borrow 65 percent loan to value, your equity check is smaller, so gains can be magnified. But if NOI falls or rates rise, the debt can hurt quickly. A simple underwriting flow is: 1. Forecast rent and occupancy 2. Subtract operating costs to get NOI 3. Apply exit cap rate to estimate sale value 4. Compare that value to purchase price 5. Layer in debt to see equity IRR and downside risk If you want, I can next show you how a 5 percent NOI drop and a 50 basis point cap rate expansion change the valuation.

Yes, please. I think I get the formula, but I get confused about what actually moves value the most. If NOI goes down a bit, is that worse than the cap rate moving up? And how do I think about leverage in that context?

Great question. In real estate, small changes in cap rate can move value a lot because cap rate is the denominator. Let us use the same 650,000 NOI. - At a 5.5 percent cap rate, value is about 11.8 million - If cap rate expands to 6.0 percent, value becomes 10.8 million That is a drop of roughly 1.0 million, or about 8.3 percent, from just a 50 basis point move. Now compare that with NOI falling 5 percent: - New NOI = 617,500 - At a 5.5 percent cap rate, value is about 11.2 million That is a drop of about 0.7 million, or roughly 5 percent. So in this example, the 50 basis point cap rate move hurts more than a 5 percent NOI decline. But the impact depends on starting cap rate and how big the change is. Leverage amplifies both outcomes at the equity level. If you bought at 65 percent debt and value falls, your equity cushion shrinks faster than the property value. That is why lenders and investors focus on debt service coverage ratio, not just valuation. A good interview answer is: NOI drives intrinsic cash flow, cap rate drives the market's pricing of that cash flow, and leverage magnifies equity returns and losses.

That helps. Can you show me a full mini example with purchase price, debt, and an exit? I want to see how I would talk through downside sensitivity if rents underperform.

Sure. Let us build a mini case. Assume: - Purchase price: 11.8 million - NOI today: 650,000 - Exit cap rate: 5.5 percent - Debt: 7.7 million, or about 65 percent LTV - Interest-only debt at 6 percent for simplicity At entry: - Annual interest = 7.7 million x 6 percent = 462,000 - Debt service coverage ratio = 650,000 divided by 462,000 = 1.4x Now suppose by year 3, NOI grows to 700,000. Exit value at the same cap rate is: - 700,000 divided by 0.055 = 12.7 million Equity before repayment of debt would be about: - 12.7 million minus 7.7 million = 5.0 million Now the downside case. If NOI underperforms by 10 percent instead, it becomes 585,000. - Value at 5.5 percent cap rate = 10.6 million - Equity = 10.6 million minus 7.7 million = 2.9 million So equity drops much more than the property value because of leverage. If you want to sound sharp in an interview, say something like: - I would test downside from both the income side and the exit side - I would stress lower occupancy, slower rent growth, and cap rate expansion - I would check whether DSCR stays above lender thresholds - I would focus on whether the equity still has a cushion after debt paydown That shows you understand both valuation and credit risk.

When I explain this out loud, should I lead with NOI or cap rates? I worry I will sound too formulaic. Also, what are the main trade-offs if the sponsor uses more leverage to boost returns?

Lead with NOI. That is usually the cleaner story because it shows you understand the asset first. A strong structure is: 1. Start with the business plan and NOI drivers 2. Explain how the market capitalizes that NOI 3. Then discuss leverage as a financing overlay 4. Finish with downside protection That sounds more like an investor than someone reciting a formula. On leverage trade-offs: - Upside: more debt increases equity returns if the asset performs well - Downside: more debt increases refinance risk, weakens DSCR, and can wipe out equity faster if value falls - Flexibility: lower leverage gives more room to survive slower lease-up or rent softness In real estate PE, the key question is not just can we buy the asset, but can we hold it through the business plan and still exit safely. For your profile, a good answer could be: - I would underwrite the property off stabilized NOI, then test a downside case with lower income and higher exit cap rate - I would compare that to the debt burden to see if the equity is still protected - I would prefer a structure where leverage supports returns but does not force a sale if the market weakens That framing sounds practical and investor-oriented.

Can you give me a concise interview-style answer I could say in 30 seconds if they ask how I underwrite a deal and what sensitivity I care about most?

Yes. You could say: I start by underwriting stabilized NOI from rent, occupancy, and operating costs, then I value the property using an exit cap rate. From there, I layer in debt to see the effect on equity returns and DSCR. The sensitivities I care about most are NOI downside and cap rate expansion, because those have the biggest impact on value and exit proceeds. Leverage does not change the asset value, but it can magnify both upside and downside at the equity level, so I want to make sure the deal still works under a weaker rent and exit scenario. If you want, I can also help you make that answer sound more natural for a UK undergraduate interview.