Commercial Loan to Value Calculator: Max Loan by LTV, DSCR, and Debt Yield

This commercial loan to value calculator shows the biggest loan a lender is likely to give you, sized three ways at once. Loan to value (LTV) is one test. Most commercial lenders also test debt service coverage ratio (DSCR) and debt yield, and the lowest of the three sets your loan.

Commercial loan to value and max loan calculator

Example defaults, not lender quotes. Replace the lender terms with the ones on your term sheet.

Maximum loan: $0

Binding constraint: n/a

Max loan as LTV: 0%. Equity needed at that loan: $0

The loan you want: LTV n/a, DSCR n/a, debt yield n/a.

Lender testMax loanImplied LTV

Max loan under each test (red = the one that sets your loan)

Why a commercial loan has three limits

On a house, the lender mostly cares about your income and the loan to value. On a commercial property, the building is supposed to pay the loan back. So the lender sizes the loan off the property's net operating income (NOI) as much as its value.

That's the single biggest thing I see investors coming from residential get wrong. They hear "75% LTV" and assume they're putting 25% down. Then the term sheet comes back at 66% because the NOI only covers so much debt, and they're scrambling for another $150,000.

If you only need the basic ratio, the simple loan to value calculator does that. This one adds the other two tests and shows which one binds.

The three formulas

  • LTV test. Max loan = property value x maximum LTV. A $2,000,000 property at 75% LTV supports up to $1,500,000.
  • DSCR test. The lender divides NOI by its minimum DSCR to get the most debt service it will allow, then works backward to the loan that payment supports at the quoted rate and amortization. More on that ratio in the DSCR calculator.
  • Debt yield test. Max loan = NOI / minimum debt yield. Debt yield ignores the rate and amortization entirely, which is why some lenders like it.

Your loan is the smallest of the three. Not every lender uses all three tests. Many community banks use LTV and DSCR only, so set the debt yield to 0 if your lender doesn't use it, and the calculator will ignore that test.

How to use the calculator

  1. Enter the value. Use the purchase price or the appraised value, whichever is lower, because that's what most lenders do.
  2. Enter the NOI. Use the NOI the lender will underwrite, which is often lower than the seller's number (lenders add vacancy, management, and reserves).
  3. Enter the lender's terms. Maximum LTV, minimum DSCR, minimum debt yield, rate, and amortization. Use 0 for amortization if the loan is interest only.
  4. Enter the loan you want. The calculator shows its LTV, DSCR, and debt yield and tells you whether it fits.
  5. Move the rate. Watch the DSCR bar move while the other two stay put. That's rate risk on your loan size.

Worked example

These are example numbers (the calculator's defaults), not a lender quote.

A $2,000,000 property with $140,000 of NOI. The lender offers 75% max LTV, a 1.25x minimum DSCR, a 9% minimum debt yield, a 7.00% rate, and 25 year amortization.

  • LTV test: $2,000,000 x 75% = $1,500,000.
  • DSCR test: $140,000 / 1.25 = $112,000 of allowed annual debt service, or $9,333 per month. At 7.00% over 25 years, that payment supports about $1,320,544.
  • Debt yield test: $140,000 / 9% = about $1,555,556.

The DSCR test binds, so the max loan is about $1,320,544, or about 66.0% LTV. You'd need about $679,456 of equity instead of the $500,000 you'd expect from "75% LTV."

The $1,500,000 loan the buyer wanted would have a payment of about $127,220 per year, for a DSCR of about 1.10x. Its LTV is 75% and its debt yield is about 9.33%, so it passes two tests and fails the one that counts. Drop the rate to 6.00% in the calculator and the DSCR limit rises, but it's still below $1,500,000. That's the conversation to have before you sign a letter of intent.

The NOI the lender uses is not always yours

Every one of these tests starts with NOI, so the NOI you enter matters more than any other input. Lenders underwrite their own version. They usually take in place rents (not pro forma rents), apply a vacancy factor even if the building is full, add a management fee even if you plan to self manage, and set aside replacement reserves for roofs, parking lots, and HVAC.

That can knock a meaningful amount off the seller's NOI. On the DSCR and debt yield tests, every dollar of NOI you lose cuts the loan by a multiple of that dollar. So before you run this calculator for a real offer, rebuild the NOI the way a lender would. Ask the lender for their underwriting assumptions if they'll share them. Most will tell you their vacancy, management, and reserve figures on the first call.

The same goes for value. If the appraisal comes in below your price, the LTV test drops with it, and sometimes that's the one that binds.

What to do when the loan comes up short

  • Negotiate amortization. A longer amortization lowers the payment, which raises the DSCR limit. Sometimes a lender will give a year or two of interest only during lease up.
  • Bring a second layer. A seller carry back or a second lien can fill the gap if the lender allows it and the combined payments still cover. Model it with the blended rate calculator.
  • Raise the NOI first. If the rents are below market, a value add plan and a refinance later may beat over leveraging today.
  • Renegotiate the price. If the NOI only supports a certain loan, that's useful information for the seller, too.

I've walked away from deals because the debt didn't work, and I've never regretted one of those calls. The loan sizing tells you what the property can really carry.

Frequently asked questions

How do you calculate loan to value on a commercial property?

Divide the loan amount by the property value (usually the lower of the price or the appraisal). A $1,500,000 loan on a $2,000,000 property is 75% LTV.

What is a typical LTV for a commercial loan?

It depends on the lender, the property type, and the loan program, so check the term sheet. Remember that the DSCR or debt yield test often limits the loan below the stated maximum LTV.

What does binding constraint mean in loan sizing?

It is the lender test that produces the smallest loan. Your loan is capped at that amount even if the other tests would allow more.

Why does my max loan drop when rates rise?

A higher rate raises the payment on every dollar borrowed. Since NOI and the minimum DSCR do not change, the property can support fewer dollars of debt.

Do all lenders use debt yield?

No. Debt yield is more common with larger and securitized loans. Many local banks size on LTV and DSCR only. Set the debt yield input to 0 to leave it out.

Want to walk into your next lender meeting knowing exactly how big a loan the deal supports? Loan sizing is part of the underwriting we do together in the CRE Central Accelerator.

Learn About the Accelerator