Best Response

There are nuances between the different asset classes but in general underwriting looks at the cash flows that an asset or building if you will pays out to the owner/lender/fund/shareholder.

OPERATING CASH FLOW For real estate purposes you do not use the terms EBITDA, EBIT or P/E Multiple. While you can and some funds do look at these for the most parts since you are dealing with an individual asset. A real estate underwriter would look at the total amount of revenue that a building takes in, or gross rents. Next you look at the vacancy factor, or how much of a buildings square feet, or apartments are unused. You then subtract the vacancy amount from the gross revenue to get to the effective income. Which is exactly what it sounds like, the actual rent and revenue that the building brings in, not just the potential gross income which would be if the building is 100% occupied, which is never(exception is retail but a static vacancy factor is used).

EXPENSES Next you get to expenses, fixed and variable expenses which are paid from the cash flow to operate the building. Since real estate is the most labor intensive asset class of structured finance expect these to be a lot in the 30%-40% of the gross revenue. Depending on the building and product type(e.g. Multi-family"apartment buildings", Office, Retail, and Hospitality"hotels") these will be different. But, again, generally you will always have to pay real estate taxes on the building you own or plan to own, heat/gas/oil, water and sewer, payroll, lawyer fees, janitorial/custodial services, property/Asset Management services, electricity. Now there can be many more and you can break down these expenses into sub categories(e.g. hallway lighting, elevator lighting, bathroom lighting), they would all go under electricity. Now before I get into the metrics or how to value and use the income and expense information you would gather, I will state that most expenses are looked at as a dollar amount per square foot, that is how you are able to compare two similar buildings. Now if you take the effective revenue and subtract the total expenses that will give you the Net Operating Income or N.O.I.. This is the most important number in real estate that people will talk about, NOI.

METRICS Now how do you make sense of all those numbers you came up with, Potential Gross Income(PGI), Effective Gross Income(EGI), Net Operating Income(NOI)? The next step is to see how those returns are if you or, if you are a lender your borrower stack up. Basically should I buy or should I lend on this property. This is the most important part of underwriting, the first part above was gathering the data now you must understand what it means. You probably remember the great recession of '07 and '08..and '09,'10,'11 etc... what you might remember from this or watching the Big Short is that people buy real estate with loans(debt). Very few people buy commercial real estate without any type of loan so most owners/potential buyers and banks want to know how much is the biggest amount of debt they could take out/loan. From here on I will write this like you were an analyst for an owner group. Most banks will have a minimum amount of cash flow that you must have to take out a loan. The most simplistic of underwriting will look at the 1st year a property is run, the most complicated will look at 5,7,or 10 years out and have a discounted cash flow. Let's just look at the simplistic "model". So for that first year banks will want to know what a specific property's cash flow can accommodate. I will assume you know how to get a present value in finance for the next part. So banks will take a look at the D.S.C.R.(Debt Service Coverage Ratio). This is given as an example of 1.20x cash flow(NOI), so you look at the monthly payment of the biggest mortgage you can accommodate on the property. You take your NOI divide it by the DSCR, in this case 1.20x, and you get your monthly payment. Then search for the Present Value by inputting the Future Value: 0, PMT: Yearly NOI/DSCR, Interest Rate: use 4.50% for sizing purposes, Number of Periods: 30 years. Then search for PV and the number that gets spit out is the maximum loan amount that you can get based on the cash flows of that particular building. Now this is just an example, the interest rates are different depending on property types and who the buyer is and the the occupancy is of the building, but for your purposes it is a good rule of thumb. In practice you will most likely have to convert all those inputs into monthly numbers. The other metric that you will look at is LTV or Loan to Value, it is the % of your mortgage versus the market value of the property. Now when I mentioned that banks will have a minimum of 1.20 DSCR they will also have a maximum LTV that they will lend to and the loan amount if the lesser of DSCR and LTV.

Summary

This is very long winded and very simplistic for a nuanced practice. IF you have any questions feel free to reply as I know there must be some things to clarify.

 

To clarify 1.20x is a fixed value. It is an underwriting metric that most banks use for multifamily to "size" a potential loan. I didn't give the monthly payment value that would go into the PV formula. So for an example let us say the building in question has an NOI of $100,00 and the bank's DSCR is 1.20x. Then the highest yearly payment on your mortgage that the bank will let you borrow is aprox $83,333. The number $83,333 is your payment in the PV function.

1.20x is an example, some banks use 1.25x as their minimum, some 1.30x. For riskier assets this number will go higher but not by much. After doing this a while you will just know or ballpark a loan based on product type by knowing what the aprox rate the bank will lend at and the min DSCR the bank will lend at.

This is all assuming that you are not LTV constrained...you won't be in major metro markets. This is where the property's loan to value is much lower in relation to the cash flow the property produces.

 

Vel quam provident ex consequatur laborum eveniet vitae. Occaecati corporis odio et est aut eius. Sed eum ad ea esse. Ut accusantium iste praesentium. Sunt commodi magni dolorem ut quibusdam omnis occaecati magni.

Rerum provident laboriosam voluptas cum dolorem omnis. Necessitatibus neque aut hic et. Velit accusamus architecto provident pariatur occaecati nisi et. Quia eos nesciunt minus est. Perspiciatis quasi sunt pariatur in quidem sit autem esse. Quia dignissimos aliquid dolorum animi deleniti et voluptas.

Aliquam quaerat at ab maiores. Id accusantium eius sint officiis non. Voluptates asperiores ducimus quos laboriosam. Harum libero laudantium sint qui voluptas quos et.

Quos quae voluptatum aut autem excepturi. Ut reiciendis dolore velit et. Odit et sapiente maiores illo nulla et impedit. Et aspernatur cupiditate dolor. Quia iusto esse repellendus sunt.

Array

Career Advancement Opportunities

April 2024 Investment Banking

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

Overall Employee Satisfaction

April 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

April 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

April 2024 Investment Banking

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