Formula
Amortizing monthly payment = Loan amount × r ÷ (1 − (1 + r)^−N), where r = Interest rate ÷ 12 and N = Amortization (years) × 12
Interest-only payment = Loan amount × Interest rate ÷ 12, paid for the number of Interest-only months at the start (capped at the term)
Balloon due at maturity = Loan amount × (1 + r)^k − Payment × ((1 + r)^k − 1) ÷ r, where k = Term to maturity × 12 − Interest-only months (the number of amortizing payments made)
Interest paid through maturity = Interest-only payment × IO months + Amortizing payment × k − (Loan amount − Balloon)
Origination fee = Loan amount × Origination fee percent; Annual debt service = Amortizing monthly payment × 12
Worked examples
Example 1: $1,000,000 at 7.75 percent, 25-year amortization, 10-year term
Use the defaults: Loan amount $1,000,000, Interest rate 7.75 percent, Amortization 25 years, Term to maturity 10 years, Interest-only months 0, Origination fee 1 percent. Monthly rate r = 0.0775 ÷ 12 = 0.0064583. N = 25 × 12 = 300 payments. (1 + r)^−300 = 1.0064583^−300 ≈ 0.1450, so 1 − 0.1450 = 0.8550. Payment = $1,000,000 × 0.0064583 ÷ 0.8550 = $7,553.29. Interest-only payment = $1,000,000 × 0.0775 ÷ 12 = $6,458.33 (shown for reference even though no IO months are used). Amortizing payments made before maturity k = 120. Balloon = $1,000,000 × 1.0064583^120 − $7,553.29 × (1.0064583^120 − 1) ÷ 0.0064583 = $802,452. Principal repaid in ten years = $1,000,000 − $802,452 = $197,548. Interest through maturity = $7,553.29 × 120 − $197,548 = $906,395 − $197,548 = $708,847. Origination fee = $10,000. Annual debt service = $7,553.29 × 12 = $90,639. After ten years of payments totalling $906,395, more than 80 percent of the principal is still owed.
Example 2: $750,000 at 8.5 percent with 12 interest-only months, 20-year amortization, 5-year term
Enter Loan amount $750,000, Interest rate 8.5 percent, Amortization 20 years, Term 5 years, Interest-only months 12, Origination fee 1.5 percent. r = 0.085 ÷ 12 = 0.0070833; N = 240. Amortizing payment = $750,000 × 0.0070833 ÷ (1 − 1.0070833^−240) = $6,508.67. Interest-only payment = $750,000 × 0.085 ÷ 12 = $5,312.50 for the first 12 months, during which the balance does not fall. Amortizing payments made k = 60 − 12 = 48. Balloon after 48 amortizing payments = $681,900. Principal repaid = $750,000 − $681,900 = $68,100. Interest = $5,312.50 × 12 + $6,508.67 × 48 − $68,100 = $63,750 + $312,416 − $68,100 = $308,066. Origination fee = $750,000 × 0.015 = $11,250. Annual debt service = $78,104. The IO year lowers the first-year outlay by about $14,350 but leaves the borrower with a larger balloon than a fully amortizing structure would, because the schedule only ran for 48 of the 60 months.
Example 3: $2,000,000 at 7 percent, fully amortizing over 25 years
Enter Loan amount $2,000,000, Interest rate 7 percent, Amortization 25 years, Term 25 years, Interest-only months 0, Origination fee 0.5 percent. r = 0.07 ÷ 12 = 0.0058333; N = 300. Payment = $2,000,000 × 0.0058333 ÷ (1 − 1.0058333^−300) = $14,135.58. Because the term equals the amortization, k = 300 and the balloon formula returns zero: Balloon = $0. Interest through maturity = $14,135.58 × 300 − $2,000,000 = $4,240,674 − $2,000,000 = $2,240,675 (the tool's figure differs by a dollar from hand arithmetic because it carries unrounded cents). Origination fee = $10,000. Annual debt service = $169,627. This is the structure a 504 debenture or a long-term SBA 7(a) real estate loan provides: no refinancing event, at the price of a rate that is locked for a very long time and, on SBA loans, a prepayment fee in the early years.