Formula
Monthly payment = loan amount × r ÷ (1 − (1 + r)^−months), where r = annual interest rate ÷ 12.
For each payment k: interest = balance before the payment × r; principal = monthly payment − interest; new balance = previous balance − principal.
Total interest = monthly payment × months − loan amount. Interest paid in year one = the sum of the interest column over the first 12 rows.
The schedule shows up to 360 rows; the download contains the same rows without currency formatting.
Worked examples
Example 1: $75,000 at 10 percent over 36 months (the defaults)
r = 0.10 ÷ 12 = 0.0083333. Payment = $75,000 × 0.0083333 ÷ (1 − 1.0083333^−36) = $625 ÷ 0.2583 = $2,420.04. Row 1: interest = $75,000 × 0.0083333 = $625.00; principal = $2,420.04 − $625.00 = $1,795.04; balance = $75,000 − $1,795.04 = $73,204.96. Row 2: interest = $73,204.96 × 0.0083333 = $610.04; principal = $1,810.00; balance = $71,394.96. Each month the interest falls by about $15 and the principal rises by the same amount. Row 36: interest = $20.00; principal = $2,400.04; balance = $0.00. Totals: $2,420.04 × 36 = $87,121, so total interest = $12,121. Interest in year one = the first 12 interest figures summed = $6,485, more than half the total, and the balance after 12 payments is $52,444.31. The tool shows $2,420.04, $12,121, $6,485 and $52,444.31 above the schedule.
Example 2: $200,000 at 8 percent over 120 months
r = 0.08 ÷ 12 = 0.0066667. Payment = $200,000 × 0.0066667 ÷ (1 − 1.0066667^−120) = $1,333.33 ÷ 0.5495 = $2,426.55. Row 1: interest = $200,000 × 0.0066667 = $1,333.33; principal = $2,426.55 − $1,333.33 = $1,093.22; balance = $198,906.78. More than half of the first payment is interest. Row 2: interest = $1,326.05; principal = $1,100.51; balance = $197,806.27. After 12 payments the balance is $186,389.51, so a year of payments totalling $29,119 has reduced the debt by only $13,610; year-one interest is $15,508. Row 120: interest = $16.07; principal = $2,410.48; balance = $0. Total interest = $2,426.55 × 120 − $200,000 = $91,186. Ten-year money at a single-digit rate still costs almost half the principal, and nearly all of that cost sits in the first five years, which is the argument for prepaying a long loan early rather than late.
Example 3: $30,000 at 15 percent over 12 months
r = 0.15 ÷ 12 = 0.0125. Payment = $30,000 × 0.0125 ÷ (1 − 1.0125^−12) = $375 ÷ 0.1385 = $2,707.75. Row 1: interest = $375.00; principal = $2,332.75; balance = $27,667.25. Row 2: interest = $345.84; principal = $2,361.91; balance = $25,305.34. Row 12: interest = $33.43; principal = $2,674.32; balance = $0. Total interest = $2,707.75 × 12 − $30,000 = $2,493, which is also the year-one interest since the loan ends in a year. The interest share of the first payment is 14 percent, against 26 percent in Example 1 and 55 percent in Example 2. Short loans at high rates can carry less interest in dollars than long loans at low rates: this 15 percent loan costs $2,493; the 8 percent loan in Example 2 costs $91,186. Rate is a price per year; total interest is price times years times balance.