Loan Sizing
Loan sizing is working out the largest loan a property supports by applying each of the lender’s limits, such as loan to value, DSCR, debt yield and a stress test, and taking the lowest result.
What are the loan sizing formulas?
Loan to value: maximum loan = value x maximum LTV
DSCR: maximum loan = (NOI / minimum DSCR) / annual loan constant
Debt yield: maximum loan = NOI / minimum debt yield
Stress test: maximum loan = (NOI / stressed minimum DSCR) / annual loan constant at the stressed rate
Maximum supportable loan = the lowest of the results
- Value: the appraised value.
- NOI: the lender's underwritten net operating income, not the borrower's pro forma.
- Annual loan constant: twelve monthly payments on a $1 loan at the rate and amortization; multiplied by the loan, it gives annual debt service.
- Maximum LTV, minimum DSCR, minimum debt yield and stressed minimum DSCR: the policy limits for the property type.
Construction and bridge loans add loan to cost and loan to as-stabilized value.
How is the sample deal sized?
Illustrative figures for the 96-unit community, with NOI of $871,000 and a $12,500,000 appraised value, under the sample policy limits (LTV 75 percent, DSCR 1.25x, debt yield 9 percent, stress coverage 1.15x with the rate one point higher). The loan is 6.25 percent on a 30-year amortization, an annual constant of 7.39 percent; at 7.25 percent the constant is 8.19 percent.
| Constraint | Calculation | Maximum loan |
|---|---|---|
| LTV 75% | $12,500,000 x 75% | $9,375,000 |
| DSCR 1.25x | $871,000 / 1.25 = $696,800 of debt service, / 7.39% | $9,430,736 |
| Debt yield 9% | $871,000 / 9% | $9,677,778 |
| Stress 1.15x at 7.25% | $871,000 / 1.15 = $757,391 of debt service, / 8.19% | $9,252,146 |
The constants are shown rounded; the loan amounts use the unrounded constants. The stress test binds at $9,252,146. The $9,000,000 request is $252,146 below it, and it produces the file's figures: 72.0 percent LTV, 1.31x coverage on $665,000 of debt service, 9.7 percent debt yield, and 1.18x when the rate rises one point.
How do lenders use loan sizing?
Each limit protects against a different failure. LTV relies on the appraisal and the market's cap rate. DSCR relies on today's rate. Debt yield ignores rate and amortization altogether. A stress test asks whether coverage survives a rate move. Taking the lowest result means no single assumption decides the loan. Which constraint binds also tells a credit officer where the risk sits; on this deal, it is rate sensitivity.
Typical policy treatment (illustrative): the sample policy sets LTV 75 percent, DSCR 1.25x, debt yield 9 percent and stress coverage of 1.15x with the rate one point higher. A request above the lowest result needs a policy exception and a mitigant.
What are common loan sizing mistakes?
- Sizing on the borrower's pro forma NOI instead of the lender's underwritten NOI.
- Using interest-only payments in the DSCR constraint on a loan that will amortize.
- Stopping at the first constraint that clears the request, so the binding one never appears.
- Sizing a floating-rate or short-term loan at today's rate with no stress constraint.
Where does loan sizing appear in the credit memo?
The sizing table sits in the loan structure section, with every constraint, its policy source and the result, and the binding constraint named. A request above any limit is shown with the policy exception and its mitigant.
Related terms
DSCR, loan to value, debt yield, stress testing, amortization.
Where LenderBox does this work
With loan sizing and deal structuring, LenderBox shows the maximum supportable loan at today's rate and under stress, with each constraint tested against your credit box, so your team sets the amount knowing the ceiling and your underwriter approves.