How Mortgage, Loan, and Amortization Worksheets Work
Same payment algebra, three jobs—clean loan, home framing, and the schedule

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.
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.
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.
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.
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.”
Checklist before you trust a scenario
- Rate and term match a written quote or a clearly labeled hypothetical
- Fees and prepaid items listed separately from principal and interest
- Total interest compared across terms, not payment alone
- 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.