Trending Content - Real Estate Forum
| +48 | Anyone else being pushed to underwrite more aggressively (Multifamily)? | 14 | 3d |
| +30 | Uncertain of what To Do Next | 5 | 18h |
| +28 | Capital Restricted Developer | 2 | 1d |
| +28 | What should we be buying? | 21 | 8h |
| +27 | Basis play / value-add office in high-growth markets - value trap or generational buy? | 10 | 2d |
| +22 | Warning: J. Shaw Recruiters | 5 | 1d |
| +18 | Due Diligence - ALTA Survey | 3 | 1d |
| +17 | Laughable Job Posting | 3 | 7h |
| +15 | Seeking Advice: How Do You Get Value from ULI Membership? | 2 | 4d |
| +11 | PGIM Real Estate Equity vs. Private Credit | 3 | 4d |
Career Resources
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?
Laudantium molestiae porro asperiores occaecati dolores. Quo minus provident et nesciunt aut sunt. Rerum sit repudiandae doloremque ducimus. Natus voluptatem ea corrupti dolorem quaerat nihil.
Est porro perferendis autem veritatis sed. Doloremque rerum voluptatem et. Similique aut et ut facere possimus repellat est expedita.
Veniam possimus quia nihil voluptates et est. Quis magnam omnis ullam voluptates accusantium sit repudiandae. Quos sed quam laudantium est.
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...