Amortization Table for Notes Receivable

An amortization table for a note receivable shows how each scheduled payment is divided between interest income and repayment of principal, along with the remaining balance. Enter the note’s principal, annual interest rate, and term to calculate a level monthly payment, total interest, and a sample schedule basis.

Formula

This calculator uses the standard fixed-payment, fully amortizing loan formula. It calculates the payment, rather than displaying every row of a dated schedule.

• Monthly payment: M = P × r ÷ [1 − (1 + r)⁻ⁿ]
• Total interest: I = M × n − P
• Monthly rate: r = APR ÷ 1,200
• Number of payments: n = years × 12

P is the note’s original principal in dollars; APR is the annual interest rate entered as a percentage; r is the monthly rate as a decimal; n is the number of monthly payments; M is the monthly payment in dollars; and I is total interest in dollars. The payment is rounded to cents by ordinary display rounding; the calculator’s total-interest result uses that displayed payment multiplied by the number of payments, less principal.

Worked Example

Using the default inputs—$20,000 principal, 8% APR, and a five-year term:

1. Convert the annual rate to a monthly decimal: r = 8 ÷ 1,200 = 0.0066667.
2. Find the number of payments: n = 5 × 12 = 60.
3. Substitute: M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰].
4. The unrounded payment is about $405.53, so the monthly payment is $405.53.
5. Total interest using the rounded payment is $405.53 × 60 − $20,000 = $4,331.80.

The actual final payment on a real note may differ by a few cents because payments and interest are rounded at each posting, and because payment dates may not align exactly with monthly periods.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are equal monthly payments made at the end of each monthly period.
• Interest accrues monthly at APR divided by 12.
• The calculation excludes fees, taxes, insurance, escrow, late charges, and any separate servicing costs.
• It assumes no missed, early, irregular, or extra payments and no balloon amount.

What an Amortization Table Shows

A note receivable is a written promise by a borrower to pay a specified amount, often with interest, to the holder of the note. For the holder, it is an asset: the borrower owes money. An amortization table turns the promised payment pattern into a period-by-period view of that asset’s principal balance and interest component.

A full schedule commonly has columns for payment number or date, beginning balance, cash payment, interest, principal reduction, and ending balance. For a standard fixed-rate note, the payment can remain constant while the interest and principal portions change. Early in the schedule, the balance is larger, so the interest portion is usually larger. As principal is repaid, less interest accrues and more of each payment reduces principal.

For example, at the first monthly period in the example, interest is approximately $20,000 × 0.0066667, or $133.33. Subtracting that from the $405.53 payment leaves about $272.20 for principal. The approximate ending balance is therefore $19,727.80. A complete accounting schedule may vary slightly because of rounding and the note’s exact dates.

How the Noteholder Records Payments

In basic bookkeeping, receipt of a payment is divided between interest revenue and reduction of the note receivable. Using the first-period illustration, the holder would generally recognize about $133.33 as interest income and reduce the note receivable by about $272.20. The total cash received is $405.53. The borrower’s records generally reflect the corresponding interest expense and reduction of the liability, subject to the applicable accounting framework and transaction details.

The schedule is not itself a journal entry, and the calculator does not determine the correct accounting treatment for every note. A note may have a different payment frequency, irregular dates, a discount or premium, transaction fees, an interest-free or below-market stated rate, or a balloon payment. Those features can require a different effective-interest calculation or a schedule tailored to the contract and accounting requirements.

Building and Checking a Full Schedule

To create each row for a conventional monthly note, calculate interest on the opening balance, subtract that interest from the payment to get principal repaid, then subtract principal repaid from the opening balance. Repeat for the next period.

• Interest for a period = opening balance × monthly rate.
• Principal repaid = payment − period interest.
• Closing balance = opening balance − principal repaid.

Check that each payment equals its interest and principal components, that the balance falls over time when the payment covers interest, and that the balance reaches approximately zero after the final payment. Small residuals can arise from rounding. Do not force a schedule to balance by changing intermediate figures without checking the note’s terms; a final payment may need an adjustment if the contract calls for it.

Common Differences From a Simple Calculator

This calculator assumes equal monthly periods and a rate that converts cleanly to APR divided by 12. A real note may calculate interest using actual days elapsed, a 360-day convention, a different compounding frequency, or another contractual method. If the payment date is irregular or the rate changes, the simple level-payment formula may not reproduce the statement balance.

It also does not show a dated table or account for skipped payments, prepayments, fees added to principal, or a final balloon. A balloon note may have regular payments that do not fully repay principal by maturity; it is not fully amortizing, so the formula’s zero-balance assumption would not describe its final amount due. For a contractual schedule, use the note’s stated payment dates, day-count convention, rate terms, and rounding method.

Frequently Asked Questions

What does amortization mean for a note receivable?
It means allocating scheduled payments between interest and repayment of the note’s principal over time. The remaining balance declines as principal is repaid.

Is a note receivable an asset?
Generally, it represents an amount owed to the noteholder and is recorded as a receivable asset. The precise classification and measurement depend on the transaction and applicable accounting requirements.

Why does the interest portion decrease?
With a fixed rate and a declining principal balance, interest calculated for each period declines. If the total payment stays level, the portion applied to principal consequently grows.

Does this calculator create a complete amortization table?
No. It estimates the level monthly payment and total interest under the stated assumptions. A full table requires calculating each period’s interest, principal reduction, and ending balance, ideally using the note’s actual dates and terms.

What if the note has a balloon payment or irregular payments?
This formula does not model those features. Use a schedule designed for the contract’s payment pattern, rate method, and maturity amount rather than treating the note as a standard fully amortizing loan.

This result is an estimate; the lender’s disclosure gives the exact figures.

Related

• Qualifying Income Calculator: Estimate Loan Income
• Qualifying Income Calculator for Loan Applications
• Roth IRA Earned Income: What Qualifies?

in p | Note principal | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Note term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2