Trending Content - Real Estate Forum
Career Resources
WSO Free Modeling Series - Now Open Through
June 30, 2026
9 Free Financial Modeling Lessons
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
High Finance Applications
Guaranteed
Get at least one offer GUARANTEED
- 1:1 support
- 92% success rate
- 2,000+ mentor network
- Unlimited Live bootcamps
- AI for resume + LinkedIn
- Networking automation tools
- HireVue simulation tool
- Full course library
- Private Slack community
- 20hrs of mocks
- + much more...
You didnt provide enough information to answer the question lol. Divide the relevant NOI by 1.15x then the loan amount and you'll get the max rate they want.
thank you; in round numbers-the NOI is $70,000,000 per annum. For the loan amount, I assume I should be using the remaining loan amount today?
In that case, the loan amount would be $675,000,000.
(((NOI/DSCR)/Loan Amount)*360/365) - Spread
You calculate the DS required to get to a 1.15x based on your in place NOI, then subtract the spread from said %. This would be the SOFR/Index rate you need to be at to reach a 1.15x.
To calculate that DS, you do in-place NOI\1.15. Then goal seek (principal balance * (x-1%)) = DS you just solved for.
Let me know if this helped!
Thank you very helpful. Just to confirm-the loan amount used in that case is the remaining principal at the time the hedge has to be purchased or the original loan amount. I'd assume it's the remaining principal loan amount at time of hedge but please let me know if some shops do this differently
Yep it’s whatever the current balance is at the time. I’ve seen lenders require caps on the fully funded amounts if there are holdbacks, but usually it’s just based on the current notional.
thank you!! can you explain the goal seek part (not the formula). After calculating the minimum NOI needed to be at 1.15x DSCR, what inputs am I using in goal seek?
Excepturi voluptatem impedit soluta qui id dolorem. Quia eaque et pariatur. Corporis optio et necessitatibus sunt enim.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...