Monthly payment, total interest, the balance at an optional balloon year, and every year of the amortization laid out one row at a time.
| Year | Paid | Principal | Interest | Balance |
|---|---|---|---|---|
| 1 | $25,120 | $6,423 | $18,697 | $263,577 |
| 2 | $25,120 | $6,887 | $18,232 | $256,689 |
| 3 | $25,120 | $7,385 | $17,734 | $249,304 |
| 4 | $25,120 | $7,919 | $17,200 | $241,385 |
| 5 | $25,120 | $8,492 | $16,628 | $232,893 |
| 6 | $25,120 | $9,106 | $16,014 | $223,787 |
| 7 | $25,120 | $9,764 | $15,356 | $214,023 |
| 8 | $25,120 | $10,470 | $14,650 | $203,554 |
| 9 | $25,120 | $11,227 | $13,893 | $192,327 |
| 10 | $25,120 | $12,038 | $13,082 | $180,289 |
| 11 | $25,120 | $12,908 | $12,211 | $167,381 |
| 12 | $25,120 | $13,842 | $11,278 | $153,539 |
| 13 | $25,120 | $14,842 | $10,278 | $138,697 |
| 14 | $25,120 | $15,915 | $9,205 | $122,782 |
| 15 | $25,120 | $17,066 | $8,054 | $105,716 |
| 16 | $25,120 | $18,299 | $6,820 | $87,417 |
| 17 | $25,120 | $19,622 | $5,498 | $67,795 |
| 18 | $25,120 | $21,041 | $4,079 | $46,754 |
| 19 | $25,120 | $22,562 | $2,558 | $24,193 |
| 20 | $25,120 | $24,193 | $927 | $0 |
Standard monthly amortization, before tax. Interest income is taxed differently from a lump sum, which is worth an hour with your accountant before you decide. If a balloon year is set, the schedule stops there because the remaining balance is due in full rather than continuing to amortize.
A balloon does not change the monthly payment. It sets a year when the remaining balance comes due in full instead of continuing to amortize, which is why the table stops there rather than running the loan out to zero.
The owner financing overview shows one monthly figure and a total. This page is the schedule behind that figure: the principal and interest split for every single year of the note.