Formula
For each term y in {1, 2, 3, 5, 7, 10} years: Rate_y = Interest rate + Rate increase per extra year × (y − 1)
Monthly payment_y = Loan amount × r_y ÷ (1 − (1 + r_y)^−(12y)), where r_y = Rate_y ÷ 12
Total interest_y = Monthly payment_y × 12y − Loan amount
DSCR_y = Annual cash available for debt service ÷ (Monthly payment_y × 12)
Shortest term with DSCR ≥ 1.25 = the first term in the ladder whose DSCR is at least 1.25; Extra interest for the longest term = Total interest at 10 years − Total interest at 1 year
Worked examples
Example 1: $200,000 at 10 percent, stepping 0.15 a year, with $60,000 of annual cash for debt service
Use the defaults: Loan amount $200,000, Interest rate 10 percent, Rate increase per extra year 0.15 percent, Annual cash available for debt service $60,000. One year: rate 10.00 percent; r = 0.0083333; payment = $200,000 × 0.0083333 ÷ (1 − 1.0083333^−12) = $17,583.18; interest = $17,583.18 × 12 − $200,000 = $10,998; DSCR = $60,000 ÷ $210,998 = 0.28. Two years: rate 10.15 percent; payment $9,242.84; interest $21,828; DSCR 0.54. Three years: 10.30 percent; $6,481.64; $33,339; 0.77. Five years: 10.60 percent; $4,308.69; $58,522; 1.16. Seven years: 10.90 percent; $3,413.98; $86,774; DSCR = $60,000 ÷ $40,968 = 1.46. Ten years: 11.35 percent; $2,794.77; $135,373; 1.79. The shortest term with DSCR of at least 1.25 is seven years at $3,413.98 a month. Interest at three years is $33,339, at ten years $135,373, and the extra interest for the longest term over the shortest is $135,373 − $10,998 = $124,375. Going from seven to ten years cuts the payment by $619 a month and adds $48,599 of interest.
Example 2: $500,000 at 8 percent, stepping 0.10 a year, with $110,000 of cash: only the longest term works
Enter Loan amount $500,000, Interest rate 8 percent, Rate increase per extra year 0.10 percent, Annual cash available $110,000. One year: 8.00 percent; payment $43,494.21; interest $21,931; DSCR 0.21. Two years: 8.10 percent; $22,636.46; $43,275; 0.40. Three years: 8.20 percent; $15,714.36; $65,717; 0.58. Five years: 8.40 percent; $10,234.18; $114,051; 0.90. Seven years: 8.60 percent; $7,943.41; $167,246; DSCR = $110,000 ÷ $95,321 = 1.15, short of 1.25. Ten years: 8.90 percent; $6,306.76; $256,811; DSCR = $110,000 ÷ $75,681 = 1.45. The shortest term with DSCR of at least 1.25 is ten years at $6,306.76 a month. Interest at three years is $65,717; at ten years $256,811; extra interest for the longest term $234,881. The seven-year term fails by a small margin; a lender with a 1.15 floor would accept it and save the borrower about $89,000 of interest, which is why the DSCR floor is worth asking about before accepting the longest term.
Example 3: $100,000 at 12 percent, stepping 0.25 a year, with $22,000 of cash: no term qualifies
Enter Loan amount $100,000, Interest rate 12 percent, Rate increase per extra year 0.25 percent, Annual cash available $22,000. One year: 12.00 percent; $8,884.88; interest $6,619; DSCR 0.21. Two years: 12.25 percent; $4,719.03; $13,257; 0.39. Three years: 12.50 percent; $3,345.36; $20,433; 0.55. Five years: 13.00 percent; $2,275.31; $36,518; 0.81. Seven years: 13.50 percent; $1,846.49; $55,105; 0.99. Ten years: 14.25 percent; $1,567.73; $88,128; DSCR = $22,000 ÷ $18,813 = 1.17. No term reaches 1.25, so the headline reads None at this cash flow. Even at ten years the business covers the payment with only 17 percent to spare, and the rate step-up has pushed the ten-year rate to 14.25 percent. The request is too large for the cash flow: a loan of about $85,000 at ten years would clear 1.25, or the business needs more cash available, or a lender with a lower floor and no step-up. The max loan from payment calculator finds the amount directly.