Underwriting worksheet — No. 14
Loan amortization calculator
Every payment on a loan set down in order: what goes to interest, what goes to principal, and how much sooner the balance clears when you pay extra.
Monthly payment
----
Principal and interest on the scheduled loan, before taxes, insurance, and escrow. Everything below is the arithmetic behind that one number.
Paying extra saves in interest and clears the loan sooner.
Loan terms
Adjust any line; every figure on this page restates immediately.
Principal and rate
Structure
Interest only pays nothing at principal until the final payment. ARM steps the rate up after the fixed period, to the caps you set.
Adjustable rate terms
Most the rate can move at any single adjustment.
Extra payments
Anything above the scheduled payment goes straight at principal.
Applied to principal
One lump each year, paid in the month named below.
Presets
Cost of the loan
All figures rounded to the dollar.
Key milestones
Where this loan crosses over.
Schedule and comparison
Four views of the same amortization.
Add a monthly, annual, or one-time extra payment above to see the base loan and the accelerated loan stated side by side.
Principal against interest, per payment
Remaining balance over time
Annual principal against interest
Amortization schedule
| No. | Date | Payment | Principal | Interest | Extra | Balance |
|---|
Annual totals
| Year | Principal | Interest | Extra | End balance |
|---|
Compare two loans
Enable comparison to see two loan structures side by side: 30 year against 15 year, different rates, or different loan types.
This worksheet gives estimates for planning. Real payoff numbers depend on your lender's day-count method, servicing rules, and how extra payments are actually applied, so confirm anything material against your loan documents. It is not tax, legal, or investment advice.
← All tools