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
| +59 | Development Fees > Sponsor Equity Contribution | 18 | 20h |
| +57 | What's an Undergrad to Do? | 21 | 2d |
| +43 | Advice to Job Seekers: Don't Sleep on Asset Management | 13 | 1d |
| +24 | Mid Sized REPE firm for first job in RE | 10 | 17m |
| +10 | Full-Time RE Acquisitions Analyst Recruiting - Class of 2028 | 4 | 1d |
| +3 | Tishman Speyer Debt Fund | 0 | 4d |
| +3 | Debt fund jobs | 1 | 4d |
| +3 | Thoughts on CIM Group today? | 11 | 1d |
| +3 | LDG Development wins $36.3M Lawsuit | 1 | 17h |
| +1 | Equity Waterfall - Market Standard | 2 | 2d |
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
Magni magnam perspiciatis doloribus quam. Quis et maxime ut officia sit et. Harum sit pariatur rerum veniam qui deleniti. Aut similique ea dolor impedit voluptatum ut nemo.
Eos repellat iusto omnis sint maxime maiores at. Voluptate tempora atque est autem dolor consequatur laudantium. Repellendus ipsum cum temporibus ipsam sit. Saepe distinctio at sint eos sequi modi. Quo at eos beatae commodi inventore doloremque laudantium.
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...