Formula
Loan amount = Purchase price or value × Loan to value ÷ 100
Monthly payment = Loan amount × r ÷ (1 − (1 + r)^−N), where r = Interest rate ÷ 12 and N = Amortization (years) × 12; Annual debt service = Monthly payment × 12
DSCR = Annual net operating income ÷ Annual debt service; Maximum loan by DSCR = present value, at r over N, of a monthly payment equal to (NOI ÷ Lender minimum DSCR) ÷ 12
Cash needed to close = Purchase price − Loan amount + Purchase price × Closing costs ÷ 100
Cap rate = NOI ÷ Purchase price; Debt yield = NOI ÷ Loan amount
Worked examples
Example 1: $1,800,000 property at 75 percent LTV, 7.25 percent, NOI $170,000
Use the defaults: Purchase price $1,800,000, Loan to value 75 percent, Interest rate 7.25 percent, Amortization 25 years, Annual net operating income $170,000, Closing costs 2.5 percent, Lender minimum DSCR 1.25. Loan amount = $1,800,000 × 0.75 = $1,350,000. r = 0.0725 ÷ 12 = 0.0060417; N = 300. Payment = $1,350,000 × 0.0060417 ÷ (1 − 1.0060417^−300) = $9,757.89. Annual debt service = $9,757.89 × 12 = $117,095. DSCR = $170,000 ÷ $117,095 = 1.45, above the 1.25 minimum. Maximum debt service the lender allows = $170,000 ÷ 1.25 = $136,000 a year, or $11,333.33 a month; the loan that payment supports at 7.25 percent over 300 months = $1,567,961, which is above the LTV loan, so LTV is the binding constraint. Cash needed to close = $1,800,000 − $1,350,000 + $1,800,000 × 0.025 = $450,000 + $45,000 = $495,000. Cap rate = $170,000 ÷ $1,800,000 = 9.44 percent. Debt yield = $170,000 ÷ $1,350,000 = 12.6 percent. Both ratios are comfortable; the lender will fund at 75 percent.
Example 2: $950,000 property at 80 percent LTV where DSCR binds
Enter Purchase price $950,000, Loan to value 80 percent, Interest rate 7.75 percent, Amortization 25 years, NOI $72,000, Closing costs 3 percent, Lender minimum DSCR 1.25. Loan amount = $950,000 × 0.80 = $760,000. r = 0.0775 ÷ 12 = 0.0064583. Payment = $760,000 × 0.0064583 ÷ (1 − 1.0064583^−300) = $5,740.50. Annual debt service = $68,886. DSCR = $72,000 ÷ $68,886 = 1.05, below 1.25, so the DSCR output turns to a warning. Maximum debt service = $72,000 ÷ 1.25 = $57,600 a year = $4,800 a month; the loan that supports = $635,485. The lender will offer about $635,000, not $760,000. Cash needed to close at the requested LTV would be $190,000 + $28,500 = $218,500, but at the DSCR-sized loan it rises to $950,000 − $635,485 + $28,500 = $343,015. Cap rate = 7.58 percent, debt yield = 9.5 percent. The buyer is paying a price whose yield is close to the cost of debt, which is exactly when DSCR, not LTV, sizes the loan.
Example 3: owner-occupied $2,400,000 building at 90 percent with an SBA-style structure
Enter Purchase price $2,400,000, Loan to value 90 percent, Interest rate 7 percent, Amortization 25 years, NOI $260,000 (the operating company's cash flow available for occupancy cost plus the rent it would otherwise pay), Closing costs 2 percent, Lender minimum DSCR 1.2. Loan amount = $2,160,000. r = 0.0058333. Payment = $2,160,000 × 0.0058333 ÷ (1 − 1.0058333^−300) = $15,266.43. Annual debt service = $183,197. DSCR = $260,000 ÷ $183,197 = 1.42. Maximum debt service = $260,000 ÷ 1.2 = $216,667 = $18,055.56 a month; maximum loan = $2,554,625, above the LTV loan, so the 90 percent structure holds. Cash needed to close = $240,000 + $48,000 = $288,000. Cap rate = 10.83 percent; debt yield = 12.0 percent. A conventional lender would rarely go to 90 percent; the structure is what a 504 loan achieves by pairing a 50 percent bank first lien with a 40 percent SBA debenture and a 10 percent injection, which this calculator approximates with a single blended rate.