Consider an 8.5% loan amortizing at a 25-year rate with monthly payments. What is the maximum amount that can be loaned on a property where net operating income (NOI) is $500,000 per year, if the underwriting criteria specify a debt service coverage ratio (DSCR) no less than 1.25X?

Question

Business

Ezekiel Guerra

25 February, 10:45

Consider an 8.5% loan amortizing at a 25-year rate with monthly payments. What is the maximum amount that can be loaned on a property where net operating income (NOI) is $500,000 per year, if the underwriting criteria specify a debt service coverage ratio (DSCR) no less than 1.25X?

+4

Answers (1)

Know the Answer?

Lucille Brooks · Answer 1

Maximum Amount that can be loanded = $4139619

Explanation:

DSCR = NOI / Debt Service

Debt Service = Principal + Interest

NOI = $ 500000

Debt Service = 500000 / 125 % = $ 400,000

The loan would be ammortized monthly over a period of 25 years.

Monthly Payment or EMI

E = P*r * (1 + r) n / ((1 + r) n - 1)

12E = 400,000 = [P*r * (1 + r) n / ((1 + r) n - 1) ] * 12

or, P = 400000 / 0.0966272500154557 = $4139619

Maximum Amount that can be loanded = $4139619