- Next Level Financial Modeling
- Posts
- π 3 Things to Verify in Your Underwriting Model
π 3 Things to Verify in Your Underwriting Model
Numbers Don't Lie: The only newsletter helping you become an expert commercial real estate underwriter every Saturday 11am EST/10am CST.
After underwriting hundreds of deals, Iβve discovered there are a few key items that have substantial impacts on your returns.
Here are 3 key items you need to verify in your underwriting model.
Financing
Leverage in real estate is using debt to increase the potential return on investment.
Real estate is a highly levered asset. Therefore, debt has huge impacts on your returns! Minor changes in your debt assumptions can greatly change the dynamics of the deal.
In your underwriting model, verify this:
Loan amount matches term sheet
Rate cap expiration is modeled correctly
Correct amount of capex is financed
Amortization matches term sheet
Tax & insurance escrow amounts are accounted for
Months of interest only is correct
Projected Rents
Projected rents populate your income income numbers and have a direct impact on your net operating income.
We all know that NOI is the driving factor to determine value in commercial real estate.
Look at this example:
All else equal, by lowering projected rents by only $100, you can see how dramatically returns can change.
Rents are critical to get right in your underwriting model. To make sure you get this right, do this:
Confirm you projected rents with a local property management company.
Compare your rents to properties with similar vintage, amenities, and nearby to subject.
Verify market rents with market reports and third party data sources.
Organic Rent Growth
This is the manual input in your underwriting model that reflects the percentage increase your rents will grow each year. Organic rent growth is the expected rent increase you will receive to keep up with inflation.
Unusually high organic rent growth inputs can be dangerous because it has a compounding effect. Meaning, every year builds off of the previous.
This can make or break a deal on paper. Sponsors sometimes use this to juice the returns in their underwriting model.
There is no correct answer of what to use as it is highly dependent on the market and your assumptions on the future projected growth of the area.
However, Iβve seen most underwriters stick to 2% to 4% annual organic growth.
Related: Why Organic Rent Growth is Dangerous
π CRE & Market News
π Stay Up-To-Date on Rates
US Ten Year Treasury Yield: 3.83%
30 Day Term SOFR: 5.29%
30 Day Average SOFR: 5.06%
Fannie Mae (1.35x DSC / 65% LTV / 10Y): 5.25% - 5.90%
Freddie Mac (1.35x DSC / 65% LTV / 10Y): 5.25% - 5.55%
5 Year FHLB: 4.38%
WSJ Prime Rate: 8.25%
π Chart of The Week
Apartment Demand Finally Matching Up with Job and Income Growth
New lease traffic has been strong, indicating renters are shopping around as record volumes of supply have expanded their options. Thus, rent growth is faltering as supply does what itβs supposed to do β slow down intense price increases.
π Did you enjoy this newsletter? The best compliment would be for you to share this on social media or with a friend.
1-on-1 Underwriting Coaching
π Schedule a 1-on-1 underwriting session with me today!
We will underwrite a deal of your choice together on Google Meet. I guarantee you will feel more confident underwriting your deals after we work together!
Areas of expertise:
Multifamily Value-Add
Multifamily Acquisitions
Multifamily Development
Debt & Financing Structures
Mixed Use
π Modeling Your Success,
Analyze Your Next Deal in 10 Minutes or Less (July Sale ends 7/31/23)
Miss Last Week's Newsletter? Read Here