The loan constant is the annual debt service as a percent of the loan. The loan constant calculator gives the constant, the monthly payment, the DSCR, the debt yield and the largest loan that the income of a property supports at the lender’s minimum DSCR.
How the calculation works
- Enter the loan amount, the annual interest rate and the amortization period in years.
- The calculator computes the monthly payment of a fully amortizing loan, the annual debt service, and the loan constant: annual debt service / loan amount.
- Enter the net operating income of the property and the minimum DSCR that the lender asks for.
- It gives the DSCR, the debt yield, and the largest loan that the income can support at that minimum DSCR.
Example
A loan of $2,000,000 at 6.75 % amortized over 25 years has a monthly payment of $13,818.23 and an annual debt service of $165,819. The loan constant is 165,819 / 2,000,000 = 8.291 %. With a NOI of $190,000 the DSCR is 1.15 and the debt yield is 9.50 %. For a minimum DSCR of 1.25, the largest loan is 190,000 / 1.25 / 0.08291 = $1,833,327.
Why it matters
The calculator helps commercial real estate investors, brokers and borrowers to compare loan offers, to see how much a property can borrow and to understand why a small change in the rate or in the amortization period changes the loan size. It is a quick check before the formal underwriting by a lender.
Good to know
The calculator uses a fixed rate, fully amortizing loan with monthly payments. It does not include fees, a balloon payment, an interest-only period, a variable rate or taxes. Lenders also set limits on the loan-to-value ratio and the debt yield, and the largest loan is only the limit given by the DSCR. The NOI should be a realistic figure after vacancy and operating expenses.
Related tools
The DSCR calculator is the coverage test, the cap rate calculator values a property from its NOI, the LTV calculator measures the loan against the value, and the amortization calculator shows the full schedule of payments.