Loan Sizing
Loan sizing is the process of determining the maximum loan a property can support, based on the most restrictive of several tests, typically LTV, LTC, DSCR, and debt yield. Lenders size to the lowest result among these tests, not the highest.
Example
A property tests at $7,000,000 on LTV, $7,175,000 on LTC, $6,500,000 on DSCR, and $6,500,000 on debt yield. The loan sizes to $6,500,000, the lowest of the four, not the average and not the highest.
Formula
Max Loan = the lowest result among the LTV, LTC, DSCR, and debt yield tests
Excel Formula:
=MIN(B20:B23)
B20= Max Loan on LTVB21= Max Loan on LTCB22= Max Loan on DSCRB23= Max Loan on Debt Yield
Related article
How Lenders Size a CRE Loan: DSCR, LTV, LTC, and Debt YieldRelated terms
New CRE tools and templates, once a week.
Subscribed. Good things coming.