Commercial loan sizing calculator
This calculator sizes a commercial real estate loan three ways, by loan-to-value, by DSCR, and by debt yield, and shows the smallest of the three, because commercial lenders size the loan to that test.
Max loan$1,584,653
- By loan-to-value
- $1,680,000
- By DSCR
- $1,584,653
- By debt yield
- $1,866,667
- Resulting LTV, DSCR, debt yield
- 66.0% LTV, 1.25 DSCR, 10.6% debt yield
- Equity needed at this price
- $815,347
The DSCR test sets the loan here. More NOI, a lower rate, or longer amortization raises it.
For planning only. Not a loan offer or commitment to lend.
The test that binds is the one to work on.
The three tests
| Test | What it asks | Formula |
|---|---|---|
| Loan-to-value (LTV) | How much can be lent against the value? | Value x maximum LTV |
| DSCR | How big a payment can the NOI carry? | The loan whose yearly payment equals NOI / minimum DSCR |
| Debt yield | How much NOI is there per dollar of loan? | NOI / minimum debt yield |
Max loan = the smallest of the three.
In plain words:
- LTV is the loan as a percent of the price or appraised value.
- DSCR on a commercial loan is NOI divided by annual debt service. A 1.25 minimum means the yearly payment can be at most NOI divided by 1.25. The calculator turns that payment into a loan at your rate and amortization.
- Debt yield is NOI divided by the loan amount. A 9 percent minimum means the loan can be at most NOI divided by 0.09. The rate and amortization are not in this formula.
The DSCR test uses the standard loan formula:
Max monthly payment = NOI / minimum DSCR / 12 Max loan by DSCR = payment x (1 - (1 + r)^-n) / r r = yearly rate / 12, n = amortization in years x 12
Worked example with the default numbers
| Input | Default |
|---|---|
| NOI, per year | $168,000 |
| Price or appraised value | $2,400,000 |
| Max loan-to-value | 70% |
| Minimum DSCR | 1.25 |
| Minimum debt yield | 9% |
| Interest rate | 7% |
| Amortization | 25 years |
- By loan-to-value: $2,400,000 x 70% = $1,680,000.
- By DSCR: $168,000 / 1.25 = $134,400 a year of debt service, or $11,200 a month. At 7% over 25 years, $11,200 a month carries $1,584,653.
- By debt yield: $168,000 / 9% = $1,866,667.
- The smallest is the DSCR result, so the max loan is $1,584,653.
- At that loan: $1,584,653 / $2,400,000 = 66.0% LTV; DSCR 1.25; $168,000 / $1,584,653 = 10.6% debt yield.
- Equity needed at this price: $2,400,000 - $1,584,653 = $815,347.
| Result | Default output |
|---|---|
| Max loan | $1,584,653 |
| By loan-to-value | $1,680,000 |
| By DSCR | $1,584,653 |
| By debt yield | $1,866,667 |
| Resulting LTV, DSCR, debt yield | 66.0% LTV, 1.25 DSCR, 10.6% debt yield |
| Equity needed at this price | $815,347 |
| Verdict | The DSCR test sets the loan here. More NOI, a lower rate, or longer amortization raises it. |
What raises the loan
The calculator names the test that binds and what moves it:
| Test that binds | What raises the loan |
|---|---|
| Loan-to-value | More value, or a higher LTV program |
| DSCR | More NOI, a lower rate, or longer amortization |
| Debt yield | More NOI |
In the default example, LTV and debt yield have room to spare. Only the DSCR result would rise with a lower rate or a longer amortization, and it can rise until the LTV result, $1,680,000, takes over.
The default limits are examples, not our terms
The 70% LTV, 1.25 DSCR, 9% debt yield, 7% rate, and 25-year amortization are the calculator's example inputs. Enter the limits from your term sheet, or send us the deal and we will tell you which loan programs fit and what the terms look like today.
Equity needed is the down payment only
"Equity needed at this price" is the price or value minus the max loan. Closing costs and reserves are extra, so plan for more cash than this line shows.
Start with a clean NOI
Every test starts from NOI, so a wrong NOI moves all three. Build it in the NOI and cap rate calculator, or from a T-12 operating statement and a rent roll in the format lenders ask for. A personal financial statement covers assets, liabilities, liquidity, and net worth for commercial loans.
The Commercial loan sizing tab in the deal analyzer workbook runs the same three tests, and it can value the property from NOI and a market cap rate instead of the price.
What we finance
We arrange commercial purchase and refinance loans for five-plus unit multifamily, mixed-use, retail, office, industrial, and self-storage, sized on the property's NOI, DSCR, and debt yield. DSCR and commercial loans close in your LLC or other entity; most of them still ask for a personal guarantee.
Frequently asked questions
How do commercial lenders size a loan?
Commercial lenders size the loan to the smallest of three tests: loan-to-value, DSCR, and debt yield. With the default numbers, LTV allows $1,680,000, DSCR allows $1,584,653, and debt yield allows $1,866,667. DSCR gives the smallest result, so it sets the loan. The test that binds is the one to work on.
What is debt yield?
Debt yield is the property's NOI divided by the loan amount. A 9 percent minimum on $168,000 of NOI caps the loan at $1,866,667. Because the rate and amortization are not in the formula, a lower rate does not raise a debt-yield limit. Only more NOI raises it.
What is DSCR on a commercial loan?
It is NOI divided by annual debt service. A 1.25 minimum means the yearly payment can be at most NOI divided by 1.25. On $168,000 of NOI that is $134,400 a year, which supports $1,584,653 at 7 percent over 25 years. Rental DSCR loans use rent over PITIA instead.
Are the default limits Alura's loan terms?
No. The 70 percent LTV, 1.25 DSCR, 9 percent debt yield, 7 percent rate, and 25-year amortization are example inputs only. Enter the limits from your term sheet, or ask us for current ones. Programs and terms change, and we confirm terms in writing before you commit.
How do I raise my max loan?
Work on the test that binds. If DSCR binds, more NOI, a lower rate, or longer amortization raises it. If loan-to-value binds, more value or a higher LTV program raises it. If debt yield binds, only more NOI raises it. The calculator names the binding test for you.
Does "equity needed" include closing costs?
No. It is the price or value minus the max loan, $815,347 with the default numbers, so it covers the down payment only. Closing costs and reserves are extra, so plan for more cash than this line shows. The deal analyzer workbook shows the same line on its Commercial loan sizing tab.
Templates and guides
- Deal analyzer workbookRental analysis, 5-year pro forma with IRR, flip and BRRRR, commercial loan sizing.Excel · 243 KB
- T-12 operating statementTrailing twelve months of income and expenses, NOI, and expense ratio.Excel · 54 KB
- Rent rollUnits, leases, rents, and occupancy in the format lenders ask for.Excel · 54 KB
- Personal financial statementAssets, liabilities, liquidity, and net worth for commercial loans.Excel · 52 KB
- Investor loan document checklistWhat to gather for DSCR, commercial, bridge, construction, 1031, IRA, and VA.PDF · 114 KB
Run your scenario by us
Two minutes. No credit pull, no SSN, no fee to talk. A licensed loan officer calls you back the same business day.
(813) 356-9448info@aluracapital.com
Ready to apply? The application opens on NEXA Mortgage's site, the licensed mortgage company our loans run through. Same team, same file.
Apply now on NEXA Mortgage's site, opens in a new tabGot it.
A licensed loan officer will call you the same business day. Want to skip the wait? Call or text (813) 356-9448.
Ready to start your application now? It opens on NEXA Mortgage's site.
Apply now on NEXA Mortgage's site, opens in a new tab