- Next Level Financial Modeling
- Posts
- 📈Floating Interest Rates 101
📈Floating Interest Rates 101
Next Level Financial Modeling: Helping you become an expert commercial real estate underwriter every Saturday!
Depending on the market and business plan, many sponsors utilize floating interest rate loans for their projects. A floating interest rate refers to a variable interest rate that changes over the duration of the debt obligation.
The total interest rate moves up and down, or "floats," reflecting economic or financial market conditions. Often, it moves in tandem with a particular index or benchmark, or with general market conditions.
Let’s take a look at how to accurately underwrite a floating interest rate loan.
What is SOFR?
SOFR Forward Curve
The Secured Overnight Financing Rate (SOFR) is an influential interest rate that banks use to price U.S. dollar-denominated derivatives and loans.
SOFR took the place of LIBOR in June 2023, offering fewer opportunities for market manipulation and current rates rather than forward-looking rates and terms.
SOFR is a common benchmark used in commercial real estate financing for floating interest rate debt. A lender will quote the borrower’s interest rate comprised of:
Lender Spread + SOFR = Total Interest Rate
SOFR & Underwriting
To underwrite a floating interest rate loan, you will need to incorporate the latest SOFR forward curve into your underwriting model. This can be downloaded for free on Chatham Financial.
Keep in mind, the SOFR projections are constantly changing!
SOFR Index
Download the latest SOFR Curve Excel file
Copy & paste values into underwriting model
Input the Lender Spread
Now your projected interest rate in the underwriting model will accurately reflect the SOFR Curve + the Lender Spread input. As SOFR moves up or down, the required debt service will change.
Floating Interest Rate
Best Practices
As noted, the SOFR Curve (and all benchmarks) are constantly changing. Lenders, economists, and experienced investors do not have a crystal ball to predict what will happen in the market. Nobody knows how accurate the projected forward curves will be.
The purpose of creating an underwriting model, with floating interest rate capability, was to provide as much flexibility as possible to the user.
If you choose to model a floating interest rate loan, be sure to understand the risks involved. Best practices would include adding a buffer of 100 - 200bps to your interest rate, so hopefully the rate shown is higher than what you actually receive.
The Next Level Value-Add Model allows for fixed and floating interest rate loans on the senior loan and refinance loan.
📈 CRE & Market News
📈 Stay Up-To-Date on Rates
US Ten Year Treasury Yield: 4.21%
30 Day Term SOFR: 5.34%
30 Day Average SOFR: 5.33%
Fannie Mae (1.35x DSC / 65% LTV / 10Y): 5.55% - 6.30%
Freddie Mac (1.35x DSC / 65% LTV / 10Y): 5.85% - 6.05%
5 Year FHLB: 4.45%
WSJ Prime Rate: 8.50%
📈 Chart of The Week
More than 66,000 Build-to-Rent Units Underway in Sun Belt
While the U.S. overall has seen moderate occupancy decline in the past five years, some small apartment markets are logging significantly worse performances.
As of early November, some 113,308 BTR units were under construction (including at properties in lease-up where construction is ongoing), according to RealPage Market Analytics.
📈 Modeling Your Success,
👋 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
👉 Do you want to take your underwriting to the next level?
We are now offering 1-on-1 underwriting sessions. Schedule a call today and we will underwrite your next deal on a group call.