Impact-Site-Verification: 1fce05f2-a6cf-4f31-8ca1-aaddc332516c

How Mortgage, Loan, and Amortization Worksheets Work

Same payment algebra, three jobs—clean loan, home framing, and the schedule

Free Calculator Hub Editorial Team
9 min read
How Mortgage, Loan, and Amortization Worksheets Work

How Mortgage, Loan, and Amortization Worksheets Work

Searchers often want “the monthly number” without seeing how interest and principal trade places over time. Our finance worksheets keep that math transparent: you enter the rate, we show the formula, and we never pretend a scenario is a lender quote.

Educational only
No live mortgage rates, no approval odds, and no substitute for CFPB Loan Estimate / Closing Disclosure review or licensed advice.

Start with a clean amortizing payment

The loan calculator takes principal, a fixed annual rate, and term. It converts the annual rate to a monthly rate, applies the standard level-payment formula (or equal principal splits at 0%), and reports the scheduled payment. That matches the installment structure the CFPB describes when explaining amortization on consumer loans.

Run a loan payment

Principal, rate, and term only:

Loan Calculator

Mortgage worksheets start from price and down payment

The mortgage page sets principal as home price minus down payment, computes principal and interest the same way, then adds monthly property tax, homeowners insurance, and HOA dues you supply. Currency selection changes formatting only. PMI, points, and closing costs stay out unless you model them separately—so the total is a housing-cost sketch, not a cash-to-close figure.

Sketch a housing payment

Purchase inputs plus optional recurring costs:

Mortgage Calculator

Schedules show the interest–principal swap

An amortization schedule applies interest to the opening balance each month, subtracts that interest from the payment to find principal, and carries the new balance forward. Rounding follows the calculator’s documented rules; the final payment may be adjusted so the balance reaches zero. Use this view when you care about total interest or early payoff experiments—not when you only need a single payment estimate.

Open the schedule

Month-by-month interest, principal, and balance:

Amortization Schedule Calculator

Refi comparisons need two labeled scenarios

Refinancing worksheets only help if both the current loan and the proposed loan use the same cash and fee assumptions you believe. Closing costs, remaining term, and any cash-out change the story; the tool will not decide whether refinancing is “worth it.”

Compare refinance assumptions

Side-by-side educational scenarios:

Refinancing Calculator

Checklist before you trust a scenario

  1. Rate and term match a written quote or a clearly labeled hypothetical
  2. Fees and prepaid items listed separately from principal and interest
  3. Total interest compared across terms, not payment alone
  4. Official disclosures reviewed when a real application is in play

For growth math on savings and investments—not loan paydown—see the compound interest calculator and the simple vs compound interest guide. Investor.gov and SEC investor publications remain the neutral public references for compounding education.

Free Calculator Hub Editorial Team