How Does an Amortization Schedule Work? Principal, Interest, and Remaining Balance

The quick answer

For the fixed-rate monthly model used by Mycelgrid Amortization Calculator, every schedule row starts with the current loan balance. The calculator determines that month’s interest from the opening balance, subtracts the interest from the scheduled payment to find scheduled principal, applies any optional extra principal, and then carries the smaller balance into the next month.

With a positive fixed rate and a declining balance, the interest portion generally becomes smaller over time while more of the scheduled payment goes toward principal. At 0% interest, there is no interest portion: the balance is divided across the scheduled monthly payments.

What each amortization row means

Opening balance

The opening balance is the amount still owed at the start of that modeled payment period. The first row begins with the loan amount entered in the calculator. Later rows begin with the previous row’s remaining balance.

Interest

In this Tool’s fixed-rate monthly model, interest for the row is calculated from the opening balance and the monthly rate. The monthly rate is the entered annual rate divided by 12.

Principal

Principal is the part of the payment that reduces the balance. For the scheduled payment, it is what remains after that month’s interest is subtracted.

Extra principal

If you enter an extra monthly payment, the current Tool applies that amount directly to principal after the scheduled principal for the month. It does not treat the extra amount as interest.

Remaining balance

The remaining balance is what carries forward after scheduled principal and any modeled extra principal are applied. The next row calculates interest from this new balance.

Worked example: the first payments of a 30-year loan

Use a $250,000 loan at 6.5% annual interest for 30 years with no extra monthly principal. Under the current Tool model, the scheduled principal-and-interest payment is about $1,580.17 per month.

The first rows look like this after display rounding:

The scheduled payment is essentially level, but its composition changes. Because the balance is a little smaller after each payment, the next month’s modeled interest is also a little smaller. That leaves a little more of the scheduled payment available to reduce principal.

What an extra principal payment changes

Extra principal reduces the balance sooner in this calculator’s model. A smaller balance means later interest is calculated from a smaller amount, which can shorten the modeled payoff time and reduce modeled total interest.

Using the same $250,000, 6.5%, 30-year example:

Those figures describe this calculator’s deterministic assumptions. A real loan can use different payment timing, principal-application rules, fees, or prepayment terms, so the actual loan documents remain the controlling source for a real account.

Why can the final payment be smaller?

A level-payment formula can leave a final remaining balance smaller than the normal scheduled payment. The current calculator caps the last payment at the balance still owed plus that month’s modeled interest instead of overpaying the schedule.

What total interest means

In this Tool, total interest is the sum of the modeled interest amounts across the generated schedule. It changes when the starting balance, fixed rate, term, or extra-principal assumption changes.

It is not the same as every possible cost of borrowing. The calculator does not add taxes, insurance, escrow, lender fees, or other charges to the amortization model.

What this amortization schedule does not model

The current Mycelgrid calculator is intentionally bounded. It models a fixed annual rate, monthly payment periods, and an optional fixed extra principal amount. It does not model:

• taxes or insurance;
• escrow;
• lender fees;
• variable interest rates;
• prepayment penalties;
• lender-specific daily-interest or payment-allocation rules.

An amortization schedule is therefore useful for understanding the represented principal-and-interest model, but it is not a lender quote, underwriting decision, or substitute for reviewing the actual loan documents.

A simple way to read any row

When you inspect a schedule, read each row in this order:

1. Start with the opening balance.
2. See how much interest the model charges for that period.
3. See how much of the scheduled payment reduces principal.
4. Check whether extra principal was applied.
5. Carry the remaining balance into the next row.

That sequence explains how the schedule connects one payment to the next and why total interest and payoff time change when the inputs change.