Hi I need to calculate the maximum loan based on the following assumptions. I appreciate your help! would also appreciate a calculation walk through. Thanks!
Max LTV: 65%
Min DSCR in stabilized year: 1.5
Min stabilized DY %: 9%
NOI: 525,361
NOI in stabilized year: 692,434
Cap Rate: 5.25%
Interest Rate: 5.00%
Am-Yrs: 30
| +23 | SWF/Pension Funds in RE | 3 | 6d |
| +20 | Probability of S2 recap returning equity | 9 | 14h |
| +20 | To the veterans: What was institutional dev actually like during the last bull run? | 8 | 1d |
| +16 | Development vs. REPE pay gap | 8 | 1d |
| +14 | PGIM Real Estate Equity Opinions? | 9 | 3d |
| +11 | Reneging - What should I do? | 5 | 2d |
| +11 | PRE MBA IB back to IB | 5 | 2d |
| +10 | JD/LLM career path to REPE advice | 4 | 1d |
| +10 | Going into RE Entrepreneurship before FT REPE experience. | 1 | 1d |
| +9 | How do I break into a family office role | 1 | 13h |
Career Resources
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.
Depends on if it's being UW to a stabilized or in-place NOI, but assuming stabilized for no particular reason:
1) LTV = .65 * 692,434/.0525 = $8.57MM (LTV Req * Property Value) 2) DSCR = 692,434 / 1.5 = 461,622 / .05 * ((1-(1/(1 + .05 / 12) ^ 360 (just a PV of min NOI over the loan term) = $7.165MM 3) DY = 692,434 / .09 = $7.693MM (NOI / DY req)
Max Loan Size = $7.165MM
2) is slightly off. I did it in excel using the PMT calc. Don't want to share cause I don't want this forum to turn into Chegg
Rerum enim sit possimus cumque. Consectetur dolorem deserunt voluptatum repellendus quia est in. Recusandae ut odit nemo dignissimos inventore et. Quo sit voluptatem ut ut.
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...