Define the note terms before building the schedule
Record the original principal, interest rate, payment frequency, first payment date, amortization term, and legal maturity date. If the amortization period is longer than the time until maturity, the note will have a balloon balance.
Example: $150,000 at 7% amortized over 20 years
A $150,000 balance at 7.00% with monthly payments amortized over 20 years has a scheduled payment of about $1,162.95. If the note matures after five years, the estimated balance after 60 scheduled payments is about $129,384.94.
That amount illustrates why “20-year amortization with a 5-year balloon” is not a five-year payoff schedule.
Track actual payment dates and changes
Private notes can involve late payments, partial payments, additional principal, temporary changes, or negotiated extensions. Preserve the original schedule and then document each actual change. If interest accrues by actual days, the date of each payment can affect the calculation.
Keep payment history separate from legal documents
An amortization schedule is a useful accounting aid, but it does not replace the promissory note, mortgage, land contract, deed of trust, or other legal documents. Changes to the payment arrangement may require formal documentation. Consult qualified legal and tax professionals for those issues.
Reconcile the balloon before maturity
Several months before a balloon date, calculate the expected balance and compare it with the payment history. That gives both parties time to identify any discrepancy before refinancing, extension, or payoff.
A payment ledger makes private-note servicing easier
For a privately serviced note, keep a payment ledger beside the amortization schedule. Record the date received, amount received, interest applied, principal applied, ending balance, and any note explaining an irregular event. This creates an audit trail that is easier to review than a schedule that is repeatedly overwritten.
If a payment is late or partial, do not simply type the originally scheduled amount and move on. Enter the actual transaction according to the note’s rules, then recalculate the later balance. If the parties formally modify the note, retain a copy of the original schedule and start a revised schedule from the agreed modification date.
At tax time or before a balloon payoff, the ledger can also help summarize interest and principal received. Tax treatment is outside the scope of an amortization program, so those totals should be reviewed with the appropriate tax professional.
Build the numbers instead of estimating them
Use the free online schedule calculator for a complete amortization table. If you need to edit individual payment dates, amounts, rates, or notes and save the revised loan, use Amortization Pro for Windows.